3 ms·
sqlite is fantastic piece of software. I am using it in every single side projects of mine. I can not describe how I satisfied with results even in relatively h
by bbayer 9y ago
sqlite is fantastic piece of software. I am using it in every single side projects of mine. I can not describe how I satisfied with results even in relatively high load (300K pages/day on $5 Linode VPS). I found that most of time using a full featured RDBMS is not necessary depending on use case.(I am doing mostly reads)
- majewsky 9y ago> 300K pages/day Does that qualify as "high load"? That's just below 4 pages/second. Given how beefy server CPUs and SSDs are, I would consider something like 100+ requests/second "high load".
- bbayer 9y agoYou are right. That is why I said "relatively". It is relatively high for my setup.($5 linode with 2gb ram that runs 4 instance gunicorn server.)
- cbluth 9y agoTry accounting for peak load times.
- monsieurbanana 9y agoIf only it worked like that, we would avoid so many problems. Sadly you cannot extrapolate at all the load of a server with their numbers of pages seen per day, depending on the use you can easily have peaks of more than 10x that.
- riku_iki 9y ago> using a full featured RDBMS is not necessary But what kind of overhead postgress adds comparing to sqlite? Advantages are clear: - more advanced functionality is available when you need it. - pgsql likely has better performance comparing to sqlite