---
title: "How extensions make Postgres much more powerful"
publication: "Postgres Weekly"
issue: 283
published_at: "2018-11-28"
canonical_url: "https://postgresweekly.com/issues/283"
---

The latest Postgres news, articles, tools, and projects.       

#283 — November 28, 2018 

[Read on the Web](https://postgresweekly.com/issues/283)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/prifalxnby5sv1kqyurx.jpg)](https://severalnines.com/blog/ten-ways-expand-functionality-postgresql)  

[Ten Ways to Expand the Functionality of Postgres](https://severalnines.com/blog/ten-ways-expand-functionality-postgresql) — There are many different extensions to adapt Postgres to your specific needs. This post looks at some of the most popular ones including PostGIS and pgAudit. 

Severalnines   

[Generating 'Sequential' UUIDs in Postgres](https://blog.2ndquadrant.com/sequential-uuid-generators/) — UUIDs (Universally Unique Identifiers) are a popular alternative to integers for row IDs and having them be _sequential_ can make them more useful than truly random UUIDs. [sequential-uuids](https://github.com/tvondra/sequential-uuids) is an extension that makes this possible. 

Tomas Vondra   [![\](https://copm.s3.amazonaws.com/c6bf77a9.jpg)](https://www.2ndquadrant.com/en/support/support-postgresql/?utm_source=cp&utm_medium=text&utm_campaign=cpsupport) 

[When It's Critical, You Can Count on Us](https://www.2ndquadrant.com/en/support/support-postgresql/?utm_source=cp&utm_medium=text&utm_campaign=cpsupport) — 2ndQuadrant support engineers have over 100 years of combined code contributions to the PostgreSQL project. We provide a guaranteed 15 minute response time and 24-hour bug fix - recovering your database quickly with minimal downtime. 

2ndQuadrant PostgreSQL Services sponsor   

[Implicit vs. Explicit SQL Joins](https://www.cybertec-postgresql.com/en/postgressql-implicit-vs-explicit-joins/) — A post that aims to shed some light on the difference between implicit (where you select multiple tables and use a condition to join them) and explicit joins (using SQL’s `JOIN` clause). 

Hans-Jürgen Schönig   

[How Postgres is More Than a Relational Database: Extensions](https://www.citusdata.com/blog/2018/11/27/postgres-more-than-a-relational-database/) — We’ve already mentioned extensions (above) but here we get a brief tour of extensions and how they can make Postgres into much more than a relational database. 

Craig Kerstiens   

[Best Practices for Migrating an Oracle Database to Postgres on AWS](https://aws.amazon.com/blogs/database/best-practices-for-migrating-an-oracle-database-to-amazon-rds-postgresql-or-amazon-aurora-postgresql-migration-process-and-infrastructure-considerations/) — An Oracle to Postgres migration can be a complex process with different technologies and skills involved so Amazon has put together a three part blog series in case you need to do this with RDS or Aurora. 

Amazon Web Services   

[Easy Running Totals with Windowing Functions in Postgres](http://denisgobo.blogspot.com/2018/11/easy-running-totals-with-windowing.html) 

Denis Gobo   

[Postgres's SSLMODE Explained](https://ankane.org/postgres-sslmode-explained) — When you connect to your database, Postgres uses the `sslmode` parameter to determine the security of the connection. 

Andrew Kane   

[The Best Postgres Feature You're Not Using: CTEs aka. WITH Clauses](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/) 

Craig Kerstiens   

[Five Cool Things Learned at the PostgreSQL Conference Europe 2018](https://severalnines.com/blog/five-cool-things-i-learned-postgresql-conference-europe-2018) — This blog provides some insights into the coolest things shared at the 2018 PostgreSQL Conference Europe. 

Achilleas Mantzios   

[7 Tips from Marco Slot for Dealing with Postgres Locks](https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog) — How to avoid common mistakes dealing with Postgres locks: 7 tips from building apps on top of Postgres and Citus. 

CITUS DATA sponsor   

[EnterpriseDB Unveils Its EDB Postgres Cloud Database Service](https://www.enterprisedb.com/blog/edb-postgres-cloud-database-service-released) — EnterpriseDB are offering a managed Postgres service on AWS. Compatibility with Oracle is a key feature. 

EnterpriseDB  

🗓 Events  

[Pg Down Under 2018](https://2018.pgdu.org/) — **December 7 (Melbourne, Australia)** PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.   

[PGConf.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **Decemeber 10-12 (Tokyo, Japan)** The largest PostgreSQL event in Asia.   

[PostgreSQL Conference Europe](https://2019.pgconf.eu/) — **October 15–18, 2019 (Milan, Italy)** The 11th Annual PostgreSQL Conference Europe, a day of instructor-led training followed by three days of world-class PostgreSQL presentations and a superb hallway track.         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom