5 ms·
"God forbid, SQLite"? It's honestly a great product and a wonderful stepping-stone. I wish more new projects used it rather than half-measures like Mongo.
by STRML 9y ago
"God forbid, SQLite"? It's honestly a great product and a wonderful stepping-stone. I wish more new projects used it rather than half-measures like Mongo.
- nerdwaller 9y ago100% agreed, it can hand a few hundred thousand hits a day. Obviously not okay for HN scale - but it's what my personal site and a bunch of side projects use.
- hdhzy 9y agoDo you have problems with locking if two requests are made in the same time?
- akx 9y agoAFAIU it's only locked for concurrent writes, so a largely read-only workload should be okay.
- hdhzy 9y agoReading notes at [0] it seems it takes a little bit of configuration to get good setup. [0]: https://secure.php.net/manual/en/sqlite3.exec.php#usernotes https://secure.php.net/manual/en/sqlite3.exec.php#usernotes
- bencollier49 9y ago"Few hundred thousand" ~= 300,000 /day = 3.47 hits / s "Insert time / record" = ~50 ms (according to the internet) = 50 ms / s locked time. So I'm guessing not. Even if at peak he was seeing 10x traffic, you'd only expect short delays from the database.
- deleted 9y ago[deleted]
- deleted 9y ago[deleted]
- deleted 9y ago[deleted]
- szatkus 9y agoI used SQLite in my side project few years ago. It was very simple (like 2 tables/collections), but a lot of updates every day. I eventually switched to MongoDB because SQLite was too slow (and also I wanted to play with NoSQL stuff).
- zamalek 9y ago> wonderful stepping-stone It's honestly a fantastic final solution in certain circumstances.