Jumpstart with SQLite...

Patrick Langford
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!!!
Notifications
You’re not receiving notifications from this thread.
© 2022 GoRails, LLC