Re:We Can Do Better Than SQL
by simonw on Tuesday August 11, 2020 @02:34AM
(#24117724)
I've been experimenting with SQL as an API language - including client-side SQL constructed in JavaScript - fir a couple of years with my Datasette project.
I'm using similar security tricks to you: read-only queries with a time limit, against SQLite rather than PostgreSQL.
I'm using similar security tricks to you: read-only queries with a time limit, against SQLite rather than PostgreSQL.
More here: https://simonwillison.net/2018/Oct/4/datasette-ideas/ and https://github.com/simonw/datasette