#338 — January 15, 2020

Read on the Web

🏫 If you're in or around San Francisco or the Bay Area, consider attending PFDay SF 2020 next week. We're a sponsor and it's shaping up to be a great event :-)

Postgres Weekly

How to Create, Test and Debug an Extension Written in C for Postgres — Most of us aren’t ever going to build our own Postgres extensions, but it’s always good to know that we can.

David Zhang

PSQL_EDITOR: Fighting with Sublime Text under WindowsPSQL_EDITOR is a environment variable that psql uses to launch an external editor of your choice for certain input operations. On POSIX/Unix systems it’s pretty straight forward, but if you’re on Windows you might appreciate this article.

Pavlo Golub

Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Gain real-time performance insights and set intelligent alerts with Datadog. Try it free for 14-days.

Datadog sponsor

Two Edge Cases in Postgres's Full-Text Search — When using tsvectors and to_tsquery, there are some quirks that could trip you up.

Alexander Ivashkin and Igor Alexandrov

Installing PostGIS 3.0 and PostgreSQL 12 on CentOS 8

Devrim Gunduz

How to Build and Debug Postgres 12 using Latest Eclipse IDE on Ubuntu 18.04 — Another very specific guide, but if you need it, you need it :-)

David Zhang

▶  Innovations to Boost Productivity with Azure-Managed Postgres — One for anyone considering running Postgres (or MySQL or MariaDB) on Azure.

Sunil Kamath

▶  Why Developers Love Postgres — A just released, high level talk about why Postgres is a great database, including a section about how a department at Chevron migrated from Oracle to Postgres.

Craig Kerstiens

Logical Replication in PostgreSQL — Learn about the concept of logical replication and watch our demo on how to configure a logical replication in no time.

EnterpriseDB sponsor

🔧 Tools and Code

How To Simplify pgBouncer Monitoring with pgbouncer_fdw — In order to more easily monitor PgBouncer, the team at Crunchy Data developed an open source FDW for it.

Keith Fiske

tbls: A CI-Friendly Tool for Documenting Databases — Document a database automatically in GitHub Friendly Markdown format. By default you get documentation covering columns, indexes, relations, and other schema details. Written in Go.

Ken’ichiro Oyama

Q3C: Postgres Extension for Spatial Indexing on a Sphere — This is somewhat above my paygrade to understand, but it sounds like this may be particularly useful for datasets and use cases relating to sky indexing and astronomical cataloging.

Sergey Koposov

🗓 Upcoming Events

  • PgDay SF (January 21 in San Francisco) — A 1-day, single-track community Postgres event. Tickets are selling fast so get yours while you still can.
  • PgDay FOSDEM (January 31 in Brussels, Belgium) — Not only is there this Postgres event surrounding the popular open source event, but there's a Postgres room at FOSDEM itself on February 2 too.
  • PgConf.Russia (Febuary 3-5 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions.
  • PgConf India (Febuary 26-28 in Bengaluru, India) — A dedicated training day and a multi-track two-day conference.
  • Nordic PgDay 2020 (March 24 in Helsinki, Finland)
  • pgDay Paris 2020 (March 26 in Paris, France) — New! The schedule for the event has just been unveiled.
  • Swiss PGDay 2020 (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community.

If you are running a Postgres related event that's beyond the scale of a small local meetup or user group (so, say, 50+ people with people likely to travel to your event from afar), let us know and we can include it here in future issues.

🕰 ICYMI (Some older stuff that's worth checking out...)