News for hackers. Stuff that matters.
Re:SQL as an API language by jondumbau on Friday October 05, 2018 @05:15AM (#18146756)
How did the data get there.
Re:SQL as an API language by qwerty456127 on Friday October 05, 2018 @11:22AM (#18148843)
The page by the link says it's about the immutable mode and INSERT and UPDATE errors raise errors. As about me it's a very usual use case: I pre-populate a database with a huge data set (some GiBs) in a single batch and work with the data (data science stuff) in read-only mode then, some time after, add another batch of data (usually much smaller than the initial one) to it but database writing and reading never happens simultaneously in this scenario. In fact Datasette seems a thing I've always wanted as it is probably going to let me access my SQLite databases over a network this way.