News for hackers. Stuff that matters.
Re:We’re pretty happy with SQLite and not urgently intereste... by INTPenis on Monday June 20, 2016 @03:06AM (#11936532)
Not faster perhaps but with sqlite3 I had locking issues and after I switched to mysql I don't. It's really that simple. The app was used by a small office of 40 people at first, then started being used by close to a hundred people and that's when the locking errors began.
Re:We’re pretty happy with SQLite and not urgently intereste... by SwellJoe on Monday June 20, 2016 @04:30AM (#11936782)
That's a pretty big difference in scale. The app in the original article seems to be a desktop application, not a client/server system with many users. There's plenty of use cases where MySQL (or PostgreSQL) is a great choice. Yours is probably one of them.
Re:We’re pretty happy with SQLite and not urgently intereste... by leo_santagada on Monday June 20, 2016 @03:18AM (#11936575)
Were you using wal mode with sqlite? It helps a lot with locking.
Re:We’re pretty happy with SQLite and not urgently intereste... by INTPenis on Monday June 20, 2016 @03:32AM (#11936616)
I don't even know what it is so I wish I had looked it up first but now it's too late. Also mysql will aide in later replicating the application between different locations to ensure availability for each office.
Re:We’re pretty happy with SQLite and not urgently intereste... by lucaspiller on Monday June 20, 2016 @09:58AM (#11938038)
Yeah the WAL basically makes "concurrent processes reading/writing to the same database" work magically, where as without you'll get all sorts of issues and timeouts. I don't know why it isn't enabled by default, or at least more prominently advertised as an option.
Re:We’re pretty happy with SQLite and not urgently intereste... by SQLite on Monday June 20, 2016 @11:39AM (#11938693)
Initially, WAL mode was off by default because older versions of SQLite do not support it, and it is a property of the database file. Thus, a database created in WAL mode would be unreadable by older SQLites. But WAL has been available for 6 years now, so it might be reasonable to make it the default. We will take your suggestion under consideration. Thanks.