Blog: theplateisbad (Ernst-Georg Schmid)


209 blogs updated: 4 min. ago
Using PostgreSQL to get things done: 1. Installation
Currently I'm doing a short series of videos about data analysis PostgreSQL. Since this is for people who usually do not directly deal with ...
0
29-03-2017 14:19:31 theplateisbad (Ernst-Georg Schmid) PostgreSQL
Windows, keep your dirty fingers of my files!
I spent the better part of the morning figuring out why a colleague could not import a PostgreSQL dump in plain format made on Linux on his ...
4
23-03-2017 15:55:59 theplateisbad (Ernst-Georg Schmid) PostgreSQL
Module Monday: safeupdate
A recent tweet pointed me to safeupdate which is a little extension that forbids unconditional UPDATE and DELETE statements, i.e. without WH...
3
06-02-2017 00:34:19 theplateisbad (Ernst-Georg Schmid) PostgreSQL
A new type for PostgreSQL
CREATE TYPE trumpean AS ENUM ('true', 'alternateTrue');
0
23-01-2017 19:11:37 theplateisbad (Ernst-Georg Schmid) PostgreSQL
What happened?
Deutschland3222Vereinigte Staaten3127Tschechische Republik2918Frankreich66V ereinigtes K nigreich49Belgien34Pole n23Slowakei12Brasilien11I r...
0
05-01-2017 00:44:24 theplateisbad (Ernst-Georg Schmid) PostgreSQL
One-time passwords with Google Authenticator PAM (and friends)
PostgreSQL allows for more than plain password authentication in pg_hba.conf. One of the most flexible is authenticating against a PAM. Let'...
3
30-12-2016 12:29:40 theplateisbad (Ernst-Georg Schmid) PostgreSQL
Stampede is out!
Stampede just got live! I'll try this for sure, when I have time, when I have time...
0
30-11-2016 17:56:51 theplateisbad (Ernst-Georg Schmid) PostgreSQL
pgchem::tigress 4.0 released
pgchem::tigress 4.0 is finally out! This builds against PostgreSQL >= 9.4.x and OpenBabel 4.2.x on Linux.It contains all fixes and contribut...
0
27-11-2016 15:48:02 theplateisbad (Ernst-Georg Schmid) PostgreSQL
tcn again
In the previous post, I suggested that contrib/tcn for example could be used to selectively update caches. OK, here is my try: By touching t...
0
19-11-2016 00:23:31 theplateisbad (Ernst-Georg Schmid) 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.