The architecture described in the article replicates the SQLite database on the page level.
Yeah but this thread became about "you need an API".
Technically you can create different users with very precise access permissions. Might not be the good idea to provide that kind of API to the general public, but if your clients are trustworthy, it might work.