Viewing profile — groue

Gentium is a very beautiful font: https://software.sil.org/gentium/

You are not your code.

Yes. GRDB encourages Codable because the user can profit from the code generated by the compiler, and this implies that database values are accessed by column name, on top of the C…

You're welcome :)

Thank you (GRDB author here). It is not mentioned in the README of the repository, but SQLiteData wraps GRDB to access the database and get notified of database changes (the meat a…

Out of curiosity, I asked on the SQLite forum how the query optimizer fits in this schema: https://sqlite.org/forum/forumpost/93f9bfcec0

I do, for JSON columns. I store UTF8 strings in SQLite, so that it is easy to see JSON values with a plain `SELECT *`). And I load blobs, because I code in Swift and the standard J…

Yes. Now, many short writes look exactly as one very long write from the point of view of an enqueued write that is waiting for its turn :-) I don't quite remember how fair is SQLi…

What's cool with WAL mode is that SQLITE_BUSY won't happen for readers (except very rare scenarios: https://www.sqlite.org/wal.html#sometimes_queries_return_sql... ) One should onl…

It is always safe, and by "safe" I mean "safe for data". You won't have to deal with data corruption. Precisely, see "How To Corrupt An SQLite Database File": https://www.sqlite.or…

The music is quite good! The covers of Freddie Freeloader and Flamenco Sketches are quite worth it, IMHO :-)

Library author here - SQLite concurrency needs a little care: don't miss the Concurrency Guide: https://github.com/groue/GRDB.swift/blob/master/Documentatio...

You can try https://github.com/groue/GRDB.swift It's a thin wrapper around SQLite, with convenience APIs for record types, robust support for concurrency, and a focus on GUI apps.

I often promise myself to have a look at SQLite virtual file system API, for this very purpose, but could not yet find the guts :-)

We start to see ORMs like Diesel ( https://diesel.rs ) or GRDB ( http://github.com/groue/GRDB.swift ) that radically simplify their domain by removing traditional ORM features like…

Related article: "Automatic Undo/Redo Using SQLite" https://www.sqlite.org/undoredo.html

There are ORMs that address partial records, multi-threading troubles brought by lazy loading, uniquing, auto-updating records, and, importantly, put raw SQL on the same level as t…

I agree. Sometimes, I explain that the feature request can be implemented, but not for free. I flag such issues with the "needs sponsoring" tag.

Unique to GRDB.swift, as far as I know, is the ability to perform database writes and then wait until snapshot isolation has been reached in another connection before releasing the…