Blog: Shaun Thomas

210 blogs updated: 54 min. ago
Adventures in Server Sitting
To support more of my tinkering in an effort to test various Postgres cluster configurations, I decided it would be really nifty to have a v...
12-11-2017 02:41:43 Shaun Thomas PostgreSQL
PG Phriday: Community Edition
Postgres is one of those database engines that carves out a niche and garners adherents with various levels of religious zeal. The community...
28-04-2017 18:50:24 Shaun Thomas PostgreSQL
PG Phriday: Who Died and Made You Boss?! (The Investigatining!)
The Postgres system catalog is a voluminous tome of intriguing metadata both obvious and stupendously esoteric. When inheriting a Postgres d...
21-04-2017 19:12:30 Shaun Thomas PostgreSQL
PG Phriday: Design Pattern Workshop
Recently on the pgsql-performance mailing list, a question popped up regarding Postgres RAM usage. In this instance Pietro wondered why Post...
31-03-2017 20:19:21 Shaun Thomas PostgreSQL
PG Phriday: CONFLICT of Interests
MySQL has had a REPLACE INTO syntax to perform "UPSERT" logic since practically the very beginning. For the longest time, users who wanted t...
24-03-2017 19:33:15 Shaun Thomas PostgreSQL
PG Phriday: RESTing in the Corn
Last week we explored using Postgres as a [intlink id='pg-phriday-stuck-in-t he-middle-with-postgres'] central communication nexus[/intlink]...
17-03-2017 18:10:45 Shaun Thomas PostgreSQL
PG Phriday: Stuck in the Middle with Postgres
Earlier this year, I implied Postgres was some kind of [intlink id='pg-phriday-alien-incu rsion']super middleware[/intlink] for dragging dat...
10-03-2017 20:07:11 Shaun Thomas PostgreSQL
PG Phriday: Through the Window
Now that we know how Postgres [intlink id='pg-phriday-in-the-win dow']window functions work[/intlink], why not play with them a bit to get a...
03-03-2017 21:08:00 Shaun Thomas PostgreSQL
PG Phriday: In the Window
I'll be the first to admit that I found Postgres window functions fantastically confusing when I first encountered them. They're a powerful ...
24-02-2017 21:17:46 Shaun Thomas PostgreSQL
PG Phriday: Getting Assertive
There are a lot of languages available for authoring Postgres functions, but there's nothing quite like the the classic PL/pgSQL. It's SQL! ...
17-02-2017 20:27:35 Shaun Thomas PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.