Comparing Encrypted SQLite Libraries for Electron — Why better-sqlite3-multiple-ciphers Is the Default Pick

A practical comparison of encrypted SQLite libraries for Electron desktop apps that need Data at Rest protection. It walks through better-sqlite3-multiple-ciphers, @journeyapps/sqlcipher, @signalapp/sqlcipher, SQLite SEE, and Realm across cipher choice, N-API prebuilds, licensing, and macOS signing / notarization, and explains why better-sqlite3-multiple-ciphers is the default recommendation.

Prototyping Electron encrypted SQLite libraries — running better-sqlite3-multiple-ciphers and @journeyapps/sqlcipher on macOS and Windows

I turned the desk-based comparison from the previous post into working Electron Todo recipes and ran them on both macOS and Windows. better-sqlite3-multiple-ciphers dropped in on both operating systems with only its N-API prebuilds, while @journeyapps/sqlcipher 6.0.0 built on macOS but officially dropped Windows and only comes back with a vcpkg-based OpenSSL workaround. This post walks through the three recipes and four pull requests in app-distribution-recipes and summarizes what the measurements confirmed.

Self-Hosting libSQL — A Reproducible Docker Compose Demo for Primary/Replica Replication and JWT Auth

I built a demo that reproduces, from a fresh clone, what you actually hit when self-hosting libSQL. It stands up a primary and a replica with Docker Compose, authenticates with Ed25519 JWTs, creates namespaces via the Admin API, and reads and writes from a TypeScript CLI. Here is what re-verifying against the current libsql-server turned up.

Steps to Build Ruby on Rails Development Environment on Mac [Ruby 1.8.7]

Setting up a Rails development environment on macOS with the system Ruby 1.8.7, RubyGems, Rails, and SQLite3.

[Ruby on Rails][SQLite3] SQLException: Cannot add a NOT NULL column with default value NULL

The cause of the SQLite3 NOT NULL column error in Rails migrations, and two ways to fix it.

[SQLite] Getting Current Time in Japan Standard Time (JST) with datetime

Getting the current time in JST with SQLite by passing 'localtime' to the datetime function.

[SQLite] Firefox Add-on 'SQLite Manager' is Convenient!

Recommending the Firefox add-on 'SQLite Manager' as a convenient GUI for SQLite.

[SQLite] SQLite Manager - Firefox Extension for Operating SQLite

Introducing the Firefox extension 'SQLite Manager' for operating SQLite via a GUI.

Prototyping on Vercel + Next.js Without an External DB: Comparing 6 Embedded Databases

A technical guide to selecting in-process databases for rapid prototyping under Vercel's ephemeral filesystem constraints.