3 ms·
Not quite, I got bitten by weak type system more than once.
by isbvhodnvemrwvn 5y ago
Not quite, I got bitten by weak type system more than once.
- mekster 5y agoFunny in here, people praise SQLite but dismiss MySQL when it's tiny bit off the SQL standard and people complain how PHP converts values with best effort guess on different types but not when SQLite does that too. Don't know why anyone would use SQLite in production except for as some KV store embedded in an app.
- tptacek 5y agoBecause an SQL engine that defers control over connections, concurrency, storage, and process management to users is extremely valuable for multiple reasons, including simple cases like caches where you'd ordinarily just store things in flat files or BerkleyDB-style database, and complex cases like distributed statekeeping where existing SQL databases aren't going to do anything close to the right thing for your application, but you also don't want to reinvent SQL and query planning and write-ahead-logs to build your complex database. The vibe I get from this thread is that a lot of people have only experienced SQLite from the vantage point of something like Rails running in a "test" environment, and are used to explaining to people on some PHPbb somewhere that you can't really use SQLite to back a multiuser SAAS app. That's as may be, but when you're building infra components, you control who the "users" are; not everything is a web server taking requests from all comers.
- yawaramin 5y agoAdding to what tptacek said, it seems you're also out of date with SQLite, they added strict typing recently.
- dangoor 5y agoEnough people have had this complaint that sqlite has added STRICT tables: https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html
- isbvhodnvemrwvn 5y agoOh, finally! I haven't heard about it. Thank you!
- nooorofe 5y agothere is a strict mode https://sqlite.org/src/wiki?name=StrictMode https://sqlite.org/src/wiki?name=StrictMode