Any gotchas switching back to SQLite? PostgreSQL is great... but it seems like overkill until such time as I actually need a full RDBMS.
Chris Oliver•
You should never use SQLite for production because it locks the database when it writes, which means you can only have one user at a time accessing the database.
Patrick Langford•
In general I agree. For the app I'm writing SQLite is preferable. Small database. Heavy reads. Minimal writes. Low concurrent user writes. I'm just asking if jumpstart has anything postgreSQL specific. It doesn't look like it but I thought I'd ask.
Chris Oliver•
We use JSON columns several places. I know the SQLite json extension is not near as robust. That's probably the main thing.
Patrick Langford•
Ok, perfect. That is exactly what I needed to know. Thank you!!!
