3 ms·
SQLite does not work smoothly in many languages (like python) in regards to concurrent access. Without a controlling process (or thread) it's synchronisation po
by akvadrako 9y ago
SQLite does not work smoothly in many languages (like python) in regards to concurrent access. Without a controlling process (or thread) it's synchronisation possibilities are limited, so it can never scale too far.
Nonetheless I think it's a great idea to build your own single-threaded layer over SQLite and scale that, using a message bus or whatever.
But it's _not_ a drop-in replacement for MySQL based apps.
- ageofwant 9y agoSQLAlchemy with transactions on SQLite should get you very close, probably close enough.
- infecto 9y agoWhy get very close when I can just spin up a single micro RDS instance of MySQL or Postgres and not have to worry about it?
- marktangotango 9y agoWhoa! That's nearly $20 a month, if you're past the free tier, which you will be if you're not already. Edit that's t1.micro, t2 is $13.
- infecto 9y agoNot sure how other people do it but 1 micro RDS serves many projects for me. Well worth the money for me.
- hasenj 9y agoYea my hunch/hypothesis does not apply to slow languages like python. That's why I said a fast language that's compiled to native binaries. For example, D, Swift, or Go.