5 ms·
Transactions, locks, queues, etc. No different than multiple app instances changing the same row in other databases. Any state mutation is ultimately ordered i
by manigandham 4y ago
Transactions, locks, queues, etc. No different than multiple app instances changing the same row in other databases.
Any state mutation is ultimately ordered in time and how that that ordering is accomplished depends on the abstractions you're using: in your app, network layer, database, etc.
- Thaxll 4y agoWhy would you use SQLlite once you start dealing with network, just use MySQl or PG. It's just re-inventing the wheel badly, I need to read the details but basically you're using a tool SQLLite that was not designed to be used outside of a single app use case.
- manigandham 4y agoWhat context are you talking about here? For Cloudflare, they're offering it because it's simple and lightweight, and they already have their Durable Objects product which serves as the transaction ordering mechanism and takes care of writes. If you're doing it yourself then sure it's probably not the best fit but that's up to you to decide.
- Thaxll 4y agoSQLLite was not meant to be used by multiple process so you have to build the missing parts yourself, 100% those have more limitations and issues than regular RDBMS that were built for it.