Skip to content
Standard Reader
Log in
Tag

Sql

Articles and publications tagged Sql across the Atmosphere.

39articles12publications
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.
DatabaseSQL
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.
DatabaseSQL
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.
DatabaseSQL
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.
DatabaseSQL
Google Open Source blog
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...
GoogleSQLSQL
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...
sveltekitsql
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...
sveltekitsql
oh hey, it's owais
oh hey, it's owaisDec 16, 2025
SQL, Math, and Baseball
Dev Log 37: 2025-12-16
devlogsql
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...
sqldatabase
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...
tursodatabase
Tim Deschryver
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).
.NETSQL
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.
rustrustlang
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...
tursocli
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...
sqlturso
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.
databasessql
Think and Write
Think and WriteApr 28, 2023
SQLでカテゴリごとに最大・最小の値を持つ行を取得する
sqlbigquery
Tim Deschryver
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 Write
Think and WriteMar 14, 2023
メッセージの往復回数をカウントするSQLクエリの書き方
sqlbigquery
Tim Deschryver
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.
.NETSQL
Think and Write
Think and WriteDec 7, 2022
BigQueryでJSONの配列から行に変換する
SQLBigQuery
Philihp Busby
Philihp BusbyOct 4, 2022
Coerce a string into a uuid in Postgres
sqlpostgres
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.
DatabasePython
Redowan's Reflections
Redowan's ReflectionsSep 2, 2022
Pick random values from an array in SQL(ite)
Emulate Python's random.choice in SQLite using JSON arrays and the random() function. Populate tables with realistic test data efficiently.
DatabaseSQL
Tim Deschryver
Tim DeschryverAug 16, 2022
New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate
Exploring the new `ExecuteDelete` and `ExecuteUpdate` methods that were introduced in Entity Framework.
.NETentity framework