Tag: sql

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.

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...

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...

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...

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...

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).

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.

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...

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...

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.

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.

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.

Coerce a string into a uuid in Postgres

Recipes from Python SQLite docs

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

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.

New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

Exploring the new `ExecuteDelete` and `ExecuteUpdate` methods that were introduced in Entity Framework.

User Retention with Lness using PostgreSQL and Superset

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

I was digging into a performance issue at work recently and found THE WEIRDEST way of speeding up a query that uses ORDER BY. When testing against our replica database, I was getting results up to 100 times faster than before.

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

I was digging into a performance issue at work recently and found THE WEIRDEST way of speeding up a query that uses ORDER BY. When testing against our replica database, I was getting results up to 100 times faster than before.

Faster SQL Bulk Inserts With C#

Using SQL Bulk Copy to have a huge performance gain

Getting to know SQL Server Extended Events

How to convert your SQL Profiler template to an XEvent template.

SQL Server Profiler, underused and undervalued

How to use the SQL Server Profiler as a utility knife to get a better understanding of your system.

Concatenating MySQL Results with Group_concat and Concat_ws

Concatenating MySQL Results with Group_concat and Concat_ws

Stop abstracting early

Selecionar Um Intervalo de Linhas em MySQL

Utilizar MySQL é muito simples. Neste tutorial ensino a selecionar apenas um intervalo de linhas em MySQL.

Using a SAS LIBNAME's connection in Pass-through

SQL Optimization: Union vs. Union All

Counting distinct variables in SQL with SAS

Avoid Correlated Subqueries in SAS

Using a Materialized Path Model for Trees within OLTP Databases (part 1)