News for hackers. Stuff that matters.
Re:SQLite Is Serverless by zzo38computer on Sunday January 26, 2020 @06:13PM (#22155526)
I don't know what is "ETL" meaning here, although SQLite does include a JSON extension to read/write JSON data too, so you can use SQL and JSON together if necessary.
Re:SQLite Is Serverless by elgenie on Sunday January 26, 2020 @06:21PM (#22155571)
It's an acronym for munging some data

ETL = extract, transform, load

Re:SQLite Is Serverless by zzo38computer on Sunday January 26, 2020 @06:30PM (#22155617)
Yes, if that is what you are trying to do, I think SQLite is good. SQLite command shell also has a .import command to read data from a file, and you can also import into a view and use triggers to process the data (this is something I have done). And there is also functions and virtual tables for JSON, and you can load extensions (written in C) to add additional functions, virtual tables, collations, etc. So for many cases, SQLite is useful.