4 ms·
JSON just works, everywhere, all the time. Sometimes I'll use SQLite if there is a particular need.
by spottedmarley 1mo ago
JSON just works, everywhere, all the time. Sometimes I'll use SQLite if there is a particular need.
- Y-bar 1mo agoCan you show an example of how you use SQLite for _config_ files?
- LambdaComplex 1mo agoI think your emphasis might be in the wrong place...SQLite for config makes enough sense, but as a config _file_?
- deleted 1mo ago[deleted]
- Y-bar 1mo agoNot entirely. Because where would I configure the location of the SQLite location/connection then? Given what I know about it (single file, no auth, and such by default) I sort of understand the ”file” part I think. But not the ”config” part.
- spottedmarley 1mo agoSQLite is a tiny relational db that essentially runs right in the same folder as your application. No connection other than connecting from the app itself to the SQLite.db sitting next to it.
- gwbas1c 1mo agoYou're missing the point: Why are your config files so complicated that you need SQLite? I've shipped a product that used SQLite, and we actively removed configuration from SQLite. It was a lot easier to diagnose issues when configuration was in text files, because non-programmers could kinda-sorta understand them without needing to learn how to use SQL.
- spottedmarley 1mo ago"particular need". i also said json works everywhere. what was unclear?