Bookmarks (14) clear filters

Build PostgreSQL Applications Faster and Easier Than Ever with CYPEX — CYPEX is a user-friendly, low code tool to quickly build applications and forms with PostgreSQL at its core.

Calculating Differences Between Rows in SQL — If you have lots of rows that represent changing values (such as time series data, say) being able to calculate the differences between the values over time could be useful, here are some approaches.

How Network Latency Makes a Big Difference to Database Performance — Getting your queries as fast as possible is great, but network latency is important too. Hans-Jürgen demonstrates how to measure its impact in a situation with simulated latency.

Speeding Up count(*): Why Not Use max(id) - min(id)? — A warning tale in case you decide to take this shortcut. While you might be able to estimate or fudge a number that’s close, you can’t guarantee sequences will give you an exact, correct answer here.

Intersecting GPS Tracks to Identify Infected Individuals — I’m not a huge fan of COVID-19 related content, but this is a pretty interesting technique with numerous use cases. Essentially it uses PostGIS to identify overlapping paths.

A Look at Embedded SQL in C for Postgres with ecpg — A quick look at what is generously called a ‘vintage technology’ (i.e. old fashioned) where you write SQL directly inline within, say, a C program and compile it to handle all the database work behind the scenes. I’d never seen this style of programming before, so it’s interesting even if I’ll never use it.

Dealing with Casing When Migrating from SQL Server to PostgreSQL — SQL Server and Postgres have rather different approaches to the use of upper-case letters when naming things.

pg_timetable: Advanced Postgres Job Scheduling — Looking at a new job scheduler for Postgres implemented from scratch in Go that’s not just about running single queries at set times but that can also execute more complicated sequences of operations. GitHub repo.

PostgreSQL 12 Initial Query Performance Impressions — Postgres 12 came out just a month ago with a variety of features and performance improvements, but how does it really perform in a stress test? It’s a mixed bag with no obvious conclusions to draw.

Row Level Security, Views and a Lot of Magic in PostgreSQL — Row Level Security (RLS) is a key PostgreSQL feature that lets you define granular policies on which rows specific users can view or manipulate. Here’s a look at how they work and a problem Cybertec discovered with the feature.

Combined Indexes vs. Separate Indexes in PostgreSQL — A common question when it comes to designing relational databases relates to when composite indexes (indexes that involve multiple columns) make more sense than single column indexes. Hans-Jürgen looks at some scenarios in Postgres.

How To Improve The Performance of COUNT(*) — Using count(*) is often quite slow in Postgres. This article explores a variety of options to make counting rows faster using approximations and other tricks.

Speeding Up GROUP BY in PostgreSQL — SQL’s GROUP BY is used to group records in a result set together often for summary/aggregation purposes and there’s a way to speed them up and gain some ‘free’ extra perf, claims the author!

Looking at MySQL 8 with PostgreSQL Goggles On — If you’re a heavy Postgres user, you might not have taken a look at MySQL for many years. But if you’re curious what MySQL is like now, Kaarel has done the looking for you and even finds some features he’d welcome in Postgres.