SQLite has some limitations and downsides in certain cases. However, what's interesting is that most of the negative responses to this tweet come from people who seem to be afraid of simplicity, rather than those pointing out these specific cases.
Shayan
 @ImSh4yy
16 Feb 2024
> How do you get around SQLite's write limits? Listen, SQLite can handle thousands of writes and a ton more reads per second. If you're hitting these limits, congratulations. You're probably very rich at this point and can hire someone, if not a team, to figure it out for you. If you're far from these limits, and thinking about workarounds, you're probably doing something wrong.

Feb 17, 2024 · 7:20 PM UTC

17
6
4
90
Replying to @ImSh4yy
I have absolutely nothing against SQLite but I must admit that I almost always use Postgres simply because I know it and it can do pretty much anything
2
16
Totally acceptable response!
1
6
more replies
Replying to @ImSh4yy
Yeah it's weird, I think @fractaledmind will need to do some more work educating folks on SQLite for web dev. I will be publishing six ways he mentioned to tune SQLite for web dev next week.
4
Replying to @ImSh4yy
Most people in that thread won't even hit the limits of SQLite. It's a pretty decent starter kit to get you off the ground. Personally, I always default to Postgres and TimescaleDB sometimes because I'm super comfortable with them & can get them up and running in no time.
3
Replying to @ImSh4yy
People who are afraid of simplicity, are the same people who explain simple things in complex manner
3
Replying to @ImSh4yy
People have self imposed restrictions like having 100% uptime, scaling to millions of users and other things. This is amplified by big companies releasing a new framework or library for their use case and everyone else blindly following that hype.
2
Replying to @ImSh4yy
Software engineering is plagued with people who seem to harbor a fetish for complexity
1
Replying to @ImSh4yy
It’s weird. I love using Postgres, and do for most server side work, but on mobile it’s always SQLite. Even swift data (or core data) is SQLite. And I love the simplicity of a single file that *just* works.
1
Replying to @ImSh4yy
i think cloudflare builds on sqlite for D1, and turso forked it. theres a couple other examples that are escaping me now, but sqlite seems to be growing a lot more beyond local
2
1
Replying to @ImSh4yy
Love to use it more with the sqlite db app you made
1
Replying to @ImSh4yy
People spend far too much time gold plating systems and pretending they know what their future needs are. Use SQLite till it doesn’t work. Assume you will need to move and use a ports/adaptor approach to integrating infra.
Replying to @ImSh4yy @kentcdodds
For me, db sequences are one thing I reach for with some frequency that I’d miss but be able to find alts for. I like pub/sub and row locks in Postgres for background jobs too which I don’t believe sql lite has. Not sure how well it handles json columns either 🤔
1
Replying to @ImSh4yy
Anyone worked with @SurrealDB
Replying to @ImSh4yy
How do you apply migrations for a huge number of db instances like this?
This tweet is unavailable
Replying to @ImSh4yy
SQLite is the 🐐
Load more