Alexis Hope ENGINEERING & DESIGN NOTES

SQL

Chronological Archive
LATEST

SQLite in 2026

#SQL#SQLite#WASM#Cloudflare#Vectors

I wrote my first SQLite article in 2011 while debugging an Adobe AIR app. The problem was a quoting edge case; the solution was a one-liner. SQLite was a curiosity — a file-based database you used when you didn’t want to run a server. Fifteen years later, SQLite is having a …

READ MORE →

Data Sources for R — EDA Across a Heterogeneous Stack

#R#Elasticsearch#SQLite#Postgres#Redis

R has a reputation as a statistics tool — the thing you reach for when you need a regression or a publication-quality plot. That framing undersells it. The part of R that earns its place in a practical engineering workflow is its I/O story: the breadth of data sources it can …

READ MORE →

Percona Toolkit for Managing MySQL Clusters

#MySQL#Percona#Database#Replication#Infrastructure

Running a MySQL cluster in production eventually teaches you that MySQL’s built-in tooling is optimised for the happy path. Replication works, until it doesn’t. Schema changes are fast, until the table has 80 million rows. SHOW SLAVE STATUS reports lag, but the number isn’t …

READ MORE →

Cassandra CQL

#SQL

So apart from needing to redesign/rebuild my site, I really need to start writing more about my experiments. More for my own record than a public one. Recently started playing with the whole Nutch family (Hadoop, MapReduce, Hbase, Pig, Solr, Nutch,… etc). I finally got Nutch 2.1 …

READ MORE →

Adobe AIR SQLite ORM

#AS3#SQL

A note from a series of posts on AIR and SQLite. At the time, I needed to put together an analytics tracking library for an AIR application — Google Analytics only supported Flex apps with DOM access, so it wasn’t available in AIR. That constraint pushed me toward building a …

READ MORE →

Insert Or Update if row exists AIR SQLite

#SQL

Following on from the previous post, here’s a solution for INSERT or UPDATE if the row exists — a fairly desirable behaviour that saves the usual SELECT if exists, then UPDATE else INSERT routine. This sounds like it would be a straightforward fix, but I couldn’t find a single …

READ MORE →

3115 Error with SQLite

#SQL#AIR

Spoiler: Double quote string values in SQLite statements (Possible solution this error is raised by many misconfigurations). With SQLite in Adobe AIR, I was running some initial tests to figure out a clever TRIGGER to UPDATE or INSERT appropriately. So far I’ve been writing all …

READ MORE →