Blog: depesz (Hubert Lubaczewski)


208 blogs updated: 18 min. ago
New functions in versioning
Long time ago I wrote about my project Versioning. Since then nothing really changed. But recently I found a case where I could use some mor...
7
07-08-2017 17:15:56 depesz (Hubert Lubaczewski) PostgreSQL
How to make sure there is always at least one "sub" record?
This question appeared couple of times on irc, so I figured I can do a blogpost about it. First let's understand what we mean. Assuming we h...
16
03-07-2017 15:02:28 depesz (Hubert Lubaczewski) PostgreSQL
explain.depesz.com, paste.depesz.com – TOR announcement and some updates
I assume that you're familiar with explain.depesz.com and paste.depesz.com services. From today they are also available as services in TOR, ...
16
22-06-2017 19:40:36 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.
Another one missed, quite a long time ago, too..: On 4th of November 2016, Kevin Grittner committed patch: Implement syntax for transition t...
0
02-06-2017 12:47:13 depesz (Hubert Lubaczewski) PostgreSQL
New change on explain.depesz.com
Some (long) time ago, someone on irc suggested that I add option to keep track of optimizations of queries. Sorry, I forgot your name, and t...
10
19-05-2017 21:28:30 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Implement multivariate n-distinct coefficients
I missed it completely, but on 24th of March 2017, Alvaro Herrera committed patch: Implement multivariate n-distinct coefficients Add suppor...
10
19-05-2017 15:00:33 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Support SCRAM-SHA-256 authentication (RFC 5802 and 7677).
On 7th of March 2017, Heikki Linnakangas committed patch: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677). This introduces a new ge...
16
18-04-2017 16:42:29 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Identity columns
On 6th of April 2017, Peter Eisentraut committed patch: Identity columns This is the SQL standard-conforming variant of PostgreSQL's serial ...
16
11-04-2017 00:59:41 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Full Text Search support for json and jsonb
On 31st of March 2017, Andrew Dunstan committed patch: Full Text Search support for json and jsonb The new functions are ts_headline() and t...
18
04-04-2017 07:24:10 depesz (Hubert Lubaczewski) PostgreSQL
Waiting for PostgreSQL 10 – Support \if … \elif … \else … \endif in psql scripting.
On 30th of March 2017, Tom Lane committed patch: Support \if ... \elif ... \else ... \endif in psql scripting. This patch adds nestable cond...
19
03-04-2017 23:24:34 depesz (Hubert Lubaczewski) 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.