Stopping Collations Going Wrong
Details
On 23 June we will be gathering at the Star of Kings for some Postgres and a pint. This time we'll have a talk by Andreas Karlsson from Percona on Stopping Collations Going Wrong, followed by a brief recap from Alastair Turner (Percona) and Valeria Kaplan (Data Egret) on this year's PGConf.DEV, where the PostgreSQL community celebrated its 30th birthday.
We are a very informal bunch, so hoping to see you and your colleagues there!
We do need to know the numbers, so please register if you are planning on coming.
WHERE
The Star of Kings on 23, June from 18:30.
PROGRAMME
18:30 Welcome
19:00 Stopping Collations Going Wrong (Andreas Karlsson, Percona) - More below!
19:45 Food and bar snacks
20:00 Celebrating 30 Years of Postgres at PGConf.DEV (Alastair Turner, Percona & Valeria Kaplan, Data Egret)
20:30 It's a pub, so we'll stay and hang out a bit longer — but feel free to leave whenever you prefer!
About The Talk
Stopping Collations Going Wrong
Outside of causing trouble for you when upgrading libc what are collations good for? PostgreSQL's collations have gotten a lot of bad press from the upgrade issues but they are also a powerful and important tool, especially for working with text in other languages than English.
This talk will give an introduction to collations in PostgreSQL, including how to use them, what they are useful for, how they work plus some common pitfalls and misunderstandings. You will learn, among other things, about the three collation providers (libc, icu, builtin), BCP 47, case insensitive collations, CTYPEs, what new features have been introduced in recent PostgreSQL versions and get a brief look into the future of collations in PostgreSQL.
About The Speaker
Andreas Karlsson is application developer and long time minor contributor to PostgreSQL who recently has started working with PostgreSQL full time. Right now working for Percona with PostgreSQL itself and extensions, including pg_tde.
***
THE OFFICIAL BITS
The meet-up abides by PostgreSQL Code of Conduct.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.