by Robert Bernier | Nov 10, 2021 | Insight for DBAs, PostgreSQL
PostGIS is arguably the best GIS implementation in the world. There may be other database technologies with GIS but the value proposition of quality, performance, and sophistication, and, of course, cost, is nowhere near what PostgreSQL offers. So let me set the stage...
by Robert Bernier | Jul 19, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the table schema too. Operations such as adding, editing, and removing table columns are part of today’s life-cycle reality...
by Robert Bernier | Jun 28, 2021 | Insight for DBAs, Open Source, PostgreSQL, Security
PgBouncer is a great piece of technology! Over the years I’ve put it to good use in any number of situations requiring a particular type of control over application processes connecting to a postgres data cluster. However, sometimes it’s been a bit of a...
