Blog: Shaun Thomas


210 blogs updated: 46 min. ago
Politically Bankrupt
It's incredibly sad this appears to be the level of discourse we've sunk to. Regardless of how I personally feel about Trump, who is quite l...
3
20-05-2018 00:29:07 Shaun Thomas PostgreSQL
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...
6
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...
14
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...
13
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...
12
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...
15
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]...
13
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...
16
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...
16
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 ...
12
24-02-2017 21:17:46 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.