Skip to content

Standard Reader

Tag

Sql

Articles and publications tagged Sql across the Atmosphere.

46articles14publications

Articles

Publications

Redowan's Reflections

Redowan's ReflectionsAug 19, 2026

Postgres as an isolation reference model

Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.

Redowan's Reflections

Redowan's ReflectionsAug 19, 2026

A return to Postgres isolation

Use PostgreSQL's transaction isolation levels as a reference model for reasoning about the guarantees and tradeoffs of other relational and non-relational databases.

Redowan's Reflections

Redowan's ReflectionsJun 13, 2026

Reading your own writes with WAIT FOR LSN in Postgres 19

PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.

Redowan's Reflections

Redowan's ReflectionsJun 13, 2026

Reading your own writes with WAIT FOR LSN in Postgres 19

PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and mode options are actually for.

Google Open Source blogFeb 3, 2026

ZetaSQL is being renamed to GoogleSQL

We're excited to announce a small but significant change: the open-source project known as ZetaSQL has been officially renamed to...

Scott Spence

Scott SpenceJan 11, 2026

Migrating Off Of Fathom Analytics

This is the follow-up to Local Analytics with SQLite and SvelteKit. That post covered the infrastructure - batched writes, heartbeat-based live visitors, the production meltdown and rebuild. This one’s about actually removing the Fathom API...

Scott Spence

Scott SpenceDec 29, 2025

Local Analytics with SQLite and SvelteKit

I’ve been using Fathom Analytics for years and it’s great, but I wanted something more integrated. Something that could power live visitor counts and popular posts without external API calls. This is what I learned building self-hosted analytics...

oh hey, it's owais

oh hey, it's owaisDec 16, 2025

SQL, Math, and Baseball

Dev Log 37: 2025-12-16

Ryosuke's Sketchbook

Ryosuke's SketchbookNov 19, 2025

Offline Vector Database with Tauri

Ryosuke's Sketchbook

Ryosuke's SketchbookNov 11, 2025

Building an offline LLM research app

Scott Spence

Scott SpenceOct 6, 2025

SQLite Corruption with fs.copyFile() in WAL Mode

I was looking up something on my site for reference (as I usually do when trying to recall a detail) when I noticed the popular posts in the footer weren’t displaying. That’s odd. I’d been working with the database locally recently, so my immediate...

Scott Spence

Scott SpenceJul 13, 2025

Hunting Down 1.3 Billion Row Database Reads

I spent some time this weekend rolling the auth credentials for this site (again) after Claude Code doxed my variables! Anyways, whilst I was doing this I noticed my Turso dashboard had 1.3 BILLION row reads. My database was getting absolutely...

Tim DeschryverOct 10, 2024

Create a custom SQL expression with Entity Framework, or how to make EF interpret your Value Types

A deep-dive at the internals of Entity Framework to come up with a solution to make EF interpret your value types, in this particular case a strongly-typed ID (of the StronglyTypedId NuGet Package).

Devtools FM

Devtools FMSep 8, 2024

Predrag Gruevski - Trustfall, Cargo Semver Checks, and the Future of Query-Based Tools

Predrag Gruevski explores Trustfall, a revolutionary query tool that turns anything into queryable data, and cargo-semver-checks for Rust semantic versioning.

Scott Spence

Scott SpenceJan 20, 2024

Importing Large CSV Files into Turso DB

So, I’ve got these massive CSV files (some up to 233 thousand rows) that I exported from Fathom Analytics. I want to import them into the Turso DB I use for this site, so, eventually visitors will be able to view the data. I’m lot leaving Fathom, I...

Scott Spence

Scott SpenceDec 26, 2023

Use Common Table Expressions

I have the popular posts on this site which are stored in a Turso table, the table is generated from the Fathom Analytics API on this site and you can see them when you get to the bottom of a post or in the footer of the site. Here’s the sitch...

Tedium: The Dull Side of the Internet

Tedium: The Dull Side of the InternetOct 27, 2023

Spooky Database Relations

A discussion of the least-on-brand thing to ever happen on Halloween: The Halloween problem, a database querying issue with a long legacy.

Think and WriteApr 28, 2023

SQLでカテゴリごとに最大・最小の値を持つ行を取得する

Tim DeschryverMar 21, 2023

You can now return unmapped types from raw SQL select statements with Entity Framework 8

Entity Framework 8 brings a new feature allowing us to execute and return unmapped types from SQL select statements. In this blog post we'll take a quick look at how we can accomplish this, and why this is an important tool to have in your toolkit.

.NETEntity Framework

Think and WriteMar 14, 2023

メッセージの往復回数をカウントするSQLクエリの書き方

Tim DeschryverJan 9, 2023

Consuming SQL Functions with Entity Framework

Using DbFunctions is a method to use database-specific functions in your Entity Framework queries. They allow you to take advantage of features that are specific to a particular database provider, such as SQL Server and use them in your Entity Framework queries in a provider-agnostic way. As an example, let's use the SOUNDEX SQL function.

Think and WriteDec 7, 2022

BigQueryでJSONの配列から行に変換する

Philihp BusbyOct 4, 2022

Coerce a string into a uuid in Postgres

Redowan's Reflections

Redowan's ReflectionsSep 11, 2022

Recipes from Python SQLite docs

Practical SQLite recipes for Python: execute statements, batch operations, transactions, row factories, and context managers with sqlite3.