After struggling for years trying to figure out why people think [Cloudflare] Durable Objects are complicated, I'm increasingly convinced that it's just that they sound complicated. Feels like we can solve 90% of it by renaming DurableObject to StatefulWorker? It's just a worker that has state. And because it has state, it also has to have a name, so that you can route to the specific worker that has the state you care about. There may be a sqlite database attached, there may be a container a...| Simon Willison's Weblog
I just tried sqlite. It is ultra-light and support SQL commands. Just try this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter ".help" for usage hints. sqlite> create table t(x number); sqlite> insert into t values(1); sqlite> select * from t; 1 sqlite> $ du -h test.db 8.0K test.db I just created a database, […]| Laurent Schneider
rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. Recent versions—8.38.0 through 8.42.0—introduce several notable improvements, including Google Cloud Storage support, new HTTP APIs for cluster control, and improvements to Backup support. New Features and Enhancements Leader Stepdown API and CLI SupportVersions 8.40.0 through…| Vallified
Dumping a SQLite database to a text file can make it much smaller, which means you can download it faster.| alexwlchan
I tested four approaches, from `ORDER BY RANDOM()` to picking random `rowid` values in Python, and found one that's both fast and diverse. Here's what worked (and what didn't).| alexwlchan
This post is a guide for getting a Swift Vapor server-side app up and running on Fly.io with SQLite as the database provider. The target audience is Swift developers who are inexperienced with servers and deployment. I’m assuming you’ve already chosen Vapor, SQL, and Fly.io as your tools of choice and therefore will not discuss any of their tradeoffs. The below setup using SQLite avoids the operational complexity of maintaining a full Postgres server. Especially as a beginner that does no...| twocentstudios
Up to this point, we've been using simple test databases where the data for each row fits within a single page. However, in the wild, it is quite common for a row to be larger than a single page (typically 4096 bytes), especially when using variable-...| Geoffrey Copin's blog
In my ongoing hunting for new(ish) research to blog about I recently came across a database on iOS that I couldn't find much info on in the wider community. As briefly touched on from Mattia (read his blog here) the storeUser.db contains details on app installs and purchases from the app store. From the full file system extraction the database lives at path:| Stark 4N6
Chrome has evolved since its release. Use this interactive visualization to explore how!| dfir.blog
In my previous post, I wrote about exporting the postgres database for devlibrary from fly.io to a local file. Now, I want to convert that into a sqlite database, so I can get rid of the dependency on a separate database server.| Nithin Bekal
Last updated: March 18, 2024.| Clément Joly – Open-Source, Rust & SQLite
…even if none of my friends seem to think so. I’ve been off on a bit of a tangent recently. Its a slow burn tangent, that I am pretty sure was kicked off by this Geek Narrator podcast episode about the design of Turbo Puffer with Simon Eskildsen: The basic idea is that you can […]| Made by Mikal
In 2025, playing your own music on an iPhone is surprisingly hard, unless you pay Apple or navigate a maze of limitations. So I built my own player from scratch, with full text search, iCloud support, and a local-first experience. GitHub link Why I Built My Own Audio Player Like many people, I’ve picked up too many subscriptions, some through Apple (iCloud, Apple Music), others got lost in random platforms (like Netflix, which I forgot I was still paying for). I actually used Apple Music re...| nexo blog
How can you deploy a SQLite application on almost any cloud provider in a secure and reliable way!| Kalvad
Last updated: March 18, 2024.| Clément Joly – Open-Source, Rust & SQLite
When I'm reading a theory book, oftentimes I'm taking notes: it helps me remember the contents, make it easier to get back to it later on, and overall it helps me organize my thoughts. I was looking for an excuse to use LLM embeddings, to better understand what they are …| (not) my ideas
When I was pretty fresh in the field of digital forensics, I picked this new thing called Google Chrome to dig into. There weren't a lot of tools out there that could parse it and I thought learning about browser history would be a useful skill for me. I started| dfir.blog
SQLite claims to be one of the most popular pieces of software in the world, being integrated into every major operating system and browser. It...| tenthousandmeters.com
In this episode, when worked on the newly migrated JourneyInbox site and focused on the database. Since me moved from Postgres to SQLite, I needed to make sure that SQLite was ready for users. We examined common configuration to optimize the database and applied that config to JourneyInbox.| Matt Layman
After the initial launch of sqlite.directory, I have been working on a few updates to the site. Here are some of the updates:| Fractaled Mind
Rails continues to expand its lead as the single best platform for building web applications backed by SQLite! You can now load extensions directly from the database.yml file. This now means you have quick and easy access to the full range of SQLite extensions. This is a major step forward from the previous way, which required writing a custom initializer or using the enhanced adapter.| Fractaled Mind
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
In this episode, the third portion of the stream covers how I migrated my Heroku-backed Postgres database to SQLite. I finished the migration of my app from running on Heroku to running on DigitalOcean.| Matt Layman
Learn how to integrate SQLite with Go using the C API provided by the language, focusing on key operations like opening and closing the database, preparing statements, and binding parameters.| Happiness Machines
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
Standard components| The Grumpy Troll
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
Published: Thu 03 January 2019| www.pgcli.com
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
I've written a tool for creating a searchable archive of all your Reddit data.| xavd.id
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
↕️ Simple database schema migration library for rusqlite, written with performance in mind.| Clément Joly – Open-Source, Rust & SQLite
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.| fractaledmind.github.io
IntroductionLast weekend I decided to take a deeper look at the famous SQLite 35% Faster Than The Filesystem benchmark. I didn't want to do a shallow read of the post. I wanted to compile the kvtest tool and run the experiments myself and see what is going on. I recommend| Bruno Calza
