News for hackers. Stuff that matters.

A comment on SQLite Is Serverless. Parent comment

Re:SQLite Is Serverless by bshipp on Sunday January 26, 2020 @12:32PM (#22153347)
I disagree. CSVs don't have write-ahead logging and are not able to selectively lock portions file for writes.

And I'd say that not only is sqlite in the db marketplace (albeit for a specific subset of database application types) it's one of the largest players.

[ Parent | on HN ]
Re:SQLite Is Serverless by bane on Sunday January 26, 2020 @12:53PM (#22153467)
Why not? Just roll your own write-ahead log when you are writing to CSVs! That's all the SQLite code is doing.

SQLite does not selectively lock portions of the file for writes. It locks the entire file using the Operating System's own file handling services.

SQLite is a file format. CSVs, XML and JSON are also huge in the dB marketplace. That doesn't make them RDBMSs.

[ Parent | on HN ]
Re:SQLite Is Serverless by hartator on Sunday January 26, 2020 @01:23PM (#22153669)
A collection of CSVs can be used as a database.
[ Parent | on HN ]
Re:SQLite Is Serverless by bane on Sunday January 26, 2020 @01:31PM (#22153720)
Yes! If a database is defined as a place where I can read/write data, then any byte stream that I can read/write to is probably a database of a kind.
[ Parent | on HN ]