home.social

Search

3 results for “twocentstudios”

  1. Chris Trott @[email protected] ·

    New blog post: Caveats Using Read-only SQLite Databases from the App Bundle

    twocentstudios.com/2025/06/07/

    A quick debugging story where I learnan some new things about SQLite's journal mode while building an database export/import feature for Eki Live.

    TLDR:

    - Journal mode is embedded in the sqlite database file itself.
    - The `backup` command changes the journal mode of the target database to match the source database.
    - Check the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode;"`.
    - Change the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode=DELETE;"`.

    #sqlite #grdb

    #sqlite #grdb
  2. Chris Trott @twocentstudios ·

    I’m wondering if this broken charging behavior on my iPhone is an iOS bug or my charger. It happens like once a fortnight. Pauses charging at 80% while plugged in, then in the middle of the night switches to charging while actually draining down to 30%.

  3. Chris Trott @[email protected] ·

    #appstoreconnect

    #appstoreconnect