4 ms·

I love postrgres, and obviously this is just a test, but for anything where I would use a pi sqlite is insanely good. I use sqlite for full fledged websites wi

• freedomben 8y ago
  Sqlite is amazing performant and scalable, as long as you don't need high availability or horizontal scaling. While I don't recommend using sqlite in production, I have done it before and had a similar experience. Millions of rows with excellent performance. Just hope you never have to scale beyond what a single machine can handle tho :-)
  • hobs 8y ago
    Agreed, I use SQL Server in my day job and always reached for PG when doing OSS stuff, was just blown away how well SQLite managed to hold up. Generally sharding/HA/DR are difficult problems with any db tech, so yeah, you are definitely right there.
  • Quarrelsome 8y ago
    production isn't the issue, multi-user is the issue.
• steve_adams_86 8y ago
  I worked at a company that used sqlite on a fairly data-intensive app until it had around 2500 paying customers, with something like 600 of those customers being active, heavy users. Scaling and availability started to kneecap our customers left and right so we migrated to postgres. It was a world of difference. When customers had specials and sent piles of traffic to their stores, they'd stay online the whole time. Everyone slept better. As much as I disliked that specific use of sqlite, I learned a ton about how awesome it is and came to really love the software behind it. It was also super impressive that it took the company so far, both in terms of the efforts the devs made and sqlite itself.