|
| ▲ | pythonaut_16 5 hours ago | parent | next [-] |
| If your language supports it, what is the overhead of working with SQLite? What's special about SQLite is that it already solves most of the things you need for data persistence without adding the same kind of overhead or trade offs as Postgres or other persistence layers, and that it saves you from solving those problems yourself in your json text files... Like by all means don't use SQLite in every project. I have projects where I just use files on the disk too. But it's kinda inane to pretend it's some kind of burdensome tool that adds so much overhead it's not worth it. |
|
| ▲ | cleversomething 4 hours ago | parent | prev | next [-] |
| > what's special about SQLite Battle-tested, extremely performant, easier to use than a homegrown alternative? By all means, hack around and make your own pseudo-database file system. Sounds like a fun weekend project. It doesn't sound easier or better or less costly than using SQLite in a production app though. |
|
| ▲ | ablob 4 hours ago | parent | prev | next [-] |
| So you trade the overhead of SQL with the overhead of JSON? |
|
| ▲ | locknitpicker 5 hours ago | parent | prev [-] |
| > You can avoid the overhead of working with the database. What overhead? SQLite is literally more performant than fread/fwrite. |
| |
| ▲ | cleversomething 4 hours ago | parent [-] | | That's exactly what I was going to say. This seems more like a neat "look Ma, no database!" hobby project than an actual production recommendation. |
|
