> On Jul 15, 2019, at 3:57 AM, Richard Hipp <d...@sqlite.org> wrote: > > Yeah there is. SQLite has a high-level query language (SQL) that can > radically simplify application development.
I guess it depends on your programming style. Most apps whose architecture I’m aware of* either wrap something like an ORM (e.g. Core Data) around the database to expose it as native objects, or they just hand-write a CRUD layer to persist their objects. Which is much more complexity than just the classes themselves with a bit of export/import code. I agree that SQL queries are powerful, but LINQ demonstrates that you can do the same kind of queries using functional-programming operations like `map`, `filter`, `fold`, etc. without having the impedance-mismatch of gluing two extremely different languages together. I love SQLite! And I have been using & evangelizing it since 2004. But the fact that it’s a very elegant and powerful hammer doesn’t mean that it’s the best tool for pushing thumbtacks into cork boards. :) (Even if you disagree with the above, I don’t see how one can think that it’s a good idea to read the entire database into memory, work with it there, and then write it all back out to disk. That’s a lot of unnecessary I/O and RAM usage. The only exception I can think of is if the storage medium can’t be counted on to remain online during operation.) —Jens * my background is in macOS and iOS, btw _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
