Ask HN: Have you used SQLite as a primary database?

Re:Ask HN: Have you used SQLite as a primary database? by jmstfv on Monday April 25, 2022 @06:50AM (#31152785)

I'm using SQLite in Notion Backups (most of the workload happens in background jobs; the web app itself doesn't get that many visits)

Except for some rare exceptions, it's been doing pretty great. I don't have any plans to migrate from SQLite any time soon.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by barryhennessy on Monday April 25, 2022 @07:42AM (#31153151)

Any chance I could convince you to share some of those 'rare exceptions'? I love a good exception ;)

Also they're where the real insights are.

[ Parent | on HN ]

Re:Ask HN: Have you used SQLite as a primary database? by jmstfv on Monday April 25, 2022 @08:10AM (#31153365)

Lately, Rails has been complaining about connection timeouts, stating that all connections in the pool were in use (this usually happens when Sidekiq, a background jobs framework, processes multiple long-running jobs).

By default, the connection pool in Rails contains 5 connections, and they time out within 5 seconds.

[ Parent | on HN ]