Skip to content
Standard
Reader
Log in
Tag
Sql
Articles and publications tagged Sql across the Atmosphere.
51
articles
17
publications
Articles
Publications
Recent
Recent
Trending
Most popular
bree’s blog
·
Nov 6, 2026
Recording a Run Once
alternate title: “a trace in time saves nine”
ewsim
·
programming
Thing a Week
·
Oct 21, 2026
Tweaks: Viewing SQL Queries in Vim/Neovim
vim
·
neovim
Redowan's Reflections
·
Aug 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.
Database
·
SQL
Redowan's Reflections
·
Aug 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.
Database
·
SQL
Redowan's Reflections
·
Jun 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.
Database
·
SQL
Redowan's Reflections
·
Jun 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.
Database
·
SQL
Google Open Source blog
·
Feb 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...
GoogleSQL
·
SQL
Scott Spence
·
Jan 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...
sveltekit
·
sql
Scott Spence
·
Dec 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...
sveltekit
·
sql
oh hey, it's owais
·
Dec 16, 2025
SQL, Math, and Baseball
Dev Log 37: 2025-12-16
devlog
·
sql
Ryosuke's Sketchbook
·
Nov 19, 2025
Offline Vector Database with Tauri
llm
·
ai
Ryosuke's Sketchbook
·
Nov 11, 2025
Building an offline LLM research app
llm
·
ai
Scott Spence
·
Oct 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...
1
·
sql
·
database
Scott Spence
·
Jul 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...
turso
·
database
stellz' blog
·
May 19, 2025
Smaller Hash BTrees
sql
·
dev
Tim Deschryver
·
Oct 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).
.NET
·
SQL
Devtools FM
·
Sep 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.
rust
·
rustlang
Scott Spence
·
Jan 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...
turso
·
cli
Scott Spence
·
Dec 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...
sql
·
turso
Tedium: The Dull Side of the Internet
·
Oct 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.
databases
·
sql
Google Open Source blog
·
Sep 26, 2023
Full support of PostgreSQL engine comes to Logica
Logica is a logic programming language designed for intuitive and efficient data manipulation, which we open sourced in 2020. It compiles to SQL, p...
Data analysis
·
Data Science
Think and Write
·
Apr 28, 2023
SQLでカテゴリごとに最大・最小の値を持つ行を取得する
sql
·
bigquery
Tim Deschryver
·
Mar 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.
.NET
·
Entity Framework
Think and Write
·
Mar 14, 2023
メッセージの往復回数をカウントするSQLクエリの書き方
sql
·
bigquery
Home
Latest
Discover
Search
