Christophe Pettus

Language is a Virus: Locales and PostgreSQL

This is a pragmatic look at PostgreSQL's support for locales, in particular around character encoding and collations. This is intended for DBAs and developers who want to make use of PostgreSQL's extensive locale features with a minimum number of gotchas. Among the topics are:

* A quick overview of locales, character encodings, and collations.

* What a "locale provider," and how do you use it?

* How do various collations perform?

* What are the use cases for various locales?

* And what is this horrible thing about index corruption I hear ab

Various PostgreSQL community members attend SCaLE and are willing to meet with attendees and answer any questions. Many aspects of the community are covered: User groups, conference organization, core development, exhibitions, advocates and more! Please come and ask any questions!

When building an application on top of a relational database, it's very easy to fall into antipatterns that can cause the application to perform poorly as it scales… or when you first turn it on! The scope of this talk is talking about the most common ways in which applications abuse databases, and how to address them early in development so you are not struggling later.

When building an application on top of a relational database, it's very easy to fall into antipatterns that can cause the application to perform poorly as it scales… or when you first turn it on! The scope of this talk is talking about the most common ways in which applications abuse databases, and how to address them early in development so you are not struggling later.

PostgreSQL has added in-core logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication… We'll discuss what the options are, their limitations and pitfalls, and what the best use-case for each one is. We'll show what it takes to set each one up, monitor it, and get it working again on failures.

Keeping data secure is a vital part of the operations of any enterprise. Customer expectations, regulatory requirements, contractual obligations, and competitive needs all demand that the data in the database only be sent out to those who actually have a need and right to it.

PostgreSQL has the most advanced JSON features of any relational database... but what do you do with them? We'll talk about various ways you can use JSON to make your data life much easier, while still retaining all of the relational functionality in PostgreSQL you have come to know and love.

Part of any database administrator's job is planning for disasters... but what does that actually mean? We'll discuss disaster scenarios, how to make sure you minimize data loss and downtime, and how to handle the recovery gracefully in your PostgreSQL database.