Karen (Karrie) Jex

Imagine the following, common scenario: Your database is configured for the needs of your day-to-day (OLTP) application activity; many concurrent user connections each performing multiple short select, insert and update statements. This OLTP activity constantly generates data, which has built up in your database over time, and is now seen as a valuable business resource.

Most developers have to interact with databases at some point, and therefore need to know at least a little bit about them, but probably don't have much training or experience in that area.

Lack of awareness around Mental Health issues has always been a problem in IT circles, leading to stress, burnout and difficulties in workplace and community relationships. This often results in employee turnover and strained dynamics within open source projects, and creates barriers for achieving a diverse contributor base.

In this session, we’ll look at when and why you might partition your database tables, and answer some of the common questions people have about table partitioning. You should come away with an understanding of whether partitioning is right for you and how you could go about putting it in place.

As an old-school DBA, maybe you still don’t like the idea of running mission-critical databases on Kubernetes. I can understand that – you’ve spent decades learning your trade, honing your database expertise and putting together your database administration toolbox. You’re confident in your ability...

Imagine the following, common scenario: Your database is configured for the needs of your day-to-day (OLTP) application activity; many concurrent user connections each performing multiple short select, insert and update statements. This OLTP activity constantly generates data, which has built up in your database over time, and is now seen as a valuable business resource.

A series of short talks, each a maximum of 5 minutes long: Don Goodman: A cognitive theory of community Floor Drees and Boriss Mejías: Using Postgres to find your next karaoke song Ants Aasma: Chasing tails Chris Ellis & Nick Bluth: Announcing: PostgreSQL Independent Network Chris Ellis: UUIDs Are...

Are you a systems admin or “infrastructure person” who suddenly had “looking after databases” added to your remit? This seems to happen a lot when everything’s running on Kubernetes and the databases are seen as just another part of the landscape. If so, what do you do? Quickly learn to be a...

In organisations where everything’s running on Kubernetes, the PostgreSQL databases are often seen as just another part of the landscape. The platform engineers or systems administrators find themselves charged with “looking after the databases” even if they don’t have database expertise.

To quote the baseball player Yogi Berra, "You can observe a lot just by watching." In this session, Stacey Haysler (not an engineer) will offer PostgreSQL tips learned from watching the email lists and attending conference sessions. Karen Jex (definitely an engineer) will then explain the technical reasons for the recommendations.

Data analytics can be used to glean all sorts of business insights from your historic application data. We'll look at some different techniques to make sure your database and code are optimised for analytics without slowing down your application.

Let’s talk about what it’s like for women in tech! Taking inspiration from the most popular movie of 2023, Barbie, we unravel the challenging journey of women navigating a male-dominated tech world.

Through the magic of OpenAI’s API and the pgVector Postgres extension, you can incorporate AI into your database and over-engineer a solution to a familiar problem; how to choose new food recipes that a pizza-loving picky eater will enjoy, and thereby avoid the whole family eating pizza all week.

Lots of people who have “looking after databases” as part of their remit aren't actually database administrators. The task seems to fall more and more often to people whose expertise lies in other areas, such as systems administrators.

Let’s talk about what it’s like for women in tech! Taking inspiration from the most popular movie of 2023, Barbie, we unravel the challenging journey of women navigating a male-dominated tech world.

You may have little or no training in database administration, yet you want your application to interact with databases in the best possible way. This workshop aims to answer all the questions you wanted to ask your DBA but didn't because he/she is too grumpy/busy. We focus on PostgreSQL.

The database forms the backbone of many applications so it’s essential, as a developer, to know how to interact with the database in an optimal way. Unfortunately, database administration doesn’t necessarily form part of a developer’s training so you may be a great developer, with a wealth of experience and talent in designing and coding applications, yet have little or no database knowledge.

An open discussion with Postgres community members around the topic of upgradability. We will be looking at the PostgreSQL development cycle (backward compatibility, addition of new features) and why it makes sense to upgrade Postgres regularly.

Could we use our favourite open source relational database to unlock the potential of open data? There is a vast array of open data made available by public sector bodies, charities and commercial organisations.