Cross-Database Queries in SQLite

Re:Cross-Database Queries in SQLite by nl on Monday February 22, 2021 @12:44AM (#26221271)

Flatfile means a plain text file, generally one you can process on a row-by-row basis. It sounds like you think there is some software called "flatfile", but it is a reasonably common term.

There are advantages over SQLite, eg: the ability to use unix command line tools against the file directly.

In my view SQLite has more advantages though.

[ Parent | on HN ]

Re:Cross-Database Queries in SQLite by HelloNurse on Monday February 22, 2021 @05:41AM (#26222966)

Altering data with text editors is more or less the opposite of the integrity afforded by a database.

Of course principled command-line tools for text (e.g. awk) and the possibility of running arbitrary SQL queries on a database blur the line, but the distinction between files that are read or written once as a step in a transformation pipeline or as something to load or save and databases that represent a persistent state, with transactions, remains sharp.

[ Parent | on HN ]