How/Why to Sweep Async Tasks Under a Postgres Table

from blog taylor.town, | ↗ original
I like slim and stupid servers, where each endpoint wraps a very dumb DB query. Dumb queries are fast. Fast queries make websites smooth and snappy. Keep those click/render loops sacred. Sweep complexity under a task table.
This is a short summary. ↗ Open original to view full content

Related

Performance benchmarks of PostgreSQL .NET with Npgsql, Dapper, and Entity Framework Core
Blog posts on .NET Software Development, C#, and Debugging on Michael's Coding Spot | original ↗
Parallelism, what next?
PostgreSQL and Databases in general | original ↗
Parallel Index Scans In PostgreSQL
PostgreSQL and Databases in general | original ↗
A shallow survey of OLAP and HTAP query engines
Scattered Thoughts | original ↗
Keep Your Data Raw at Rest
Lane's Blog | original ↗
Procrastinating on my side project by torturing databases
ntietz.com blog | original ↗
Let's build a distributed Postgres proof of concept
Notes on software development | original ↗
Postgres as a search engine
any blockers? | original ↗
I don't want to learn your garbage query language
Home on Erik Bernhardsson | original ↗
Disecting the Postgres Bulk Insert and Binary Format
nickb.dev | original ↗

More from taylor.town

Rob the Whole World; Give It Back
29 Oct 2024 | original ↗

Give a man a gun and he can rob a bank. Give a man a bank and he can rob the whole world.

How to build god and get away with it
17 Oct 2024 | original ↗

Humanity will inevitably build god in man's own image.

Town Hall #26: Rounding
13 Oct 2024 | original ↗

just smart enough to be happy

A History of Microwave Ovens
12 Oct 2024 | original ↗

Some humans put a ~2.4GHz magnetron on a ventilated metal box with a fancy door.

A Georgist's Guerilla Gardening Guide
9 Oct 2024 | original ↗

Every vacant plot could be a home, park, market, garden, farm...