4 ms·
We are in the process of moving from Postgres to SQLite so these suggestions are very useful.
by datadeft 3y ago
We are in the process of moving from Postgres to SQLite so these suggestions are very useful.
- alberth 3y agoWould you mind elaborating on how you came to that decision and why? (Not suggesting it’s wrong, just interesting to hear from others as to why)
- criddell 3y agoI’m thinking about doing this as well. Sometimes SQLite is a better tool for the job. For example, there’s a lot of software that uses a database as their file format. SQLite is ideal for this. To answer the person’s question, there are easy ways and hard ways with all the trade offs you would expect. The easy way is to use an ODBC connector. That makes it easier to change the DB engine but it’s going to hurt performance. Chances are though that the performance will still be good enough for applications like database-as-file-format.