Amsterdam Open Source Data Infrastructure Meetup - October 2023 🎃

• Are you interested in learning more about open-source data technologies? ✅
• Do you want to network with local and international tech professionals in a fun, relaxed environment? ✅

Then join us on October 31, at the Textkernel HQ, for an evening full of inspiring conversations and exciting talks. It is Halloween and you're encouraged (but certainly not required) to dress up 👻

Agenda:

• 18:30 - 19:00 Welcome: Networking & snacks
• 19:00 - 19:10 Kickoff: Welcome Aiven & Textkernel
• 19:10 - 19:40 Relational and Post-relational Postgres for Data Application Developers
• Speaker: Boriss Mejias, Solution Architect at EDB, accomplished air-guitarist.
• 19:40 - 20:10 The future of connection pooling: PGBouncer or something else?
• Speaker: Jelte Fennema-Nio (@JelteF), Principal software engineer at Microsoft working on Postgres, Citus and PgBouncer.
• 20:10 ~ 21:00 Food & networking

Relational and Post-relational Postgres for Data Application Developers
The essence of software development is to solve problems from the real world. We try to model the world with objects, functions, API, etc… The software receives tons of data as input, and generates tons of data as output… data becomes the gold of the application, and we store it in a database.

Despite our love for open source, where learning from the software is at the essence of it, many developers prefer to see their database as a black box where data is simply stored and retrieved without needing to know how it works under the hood.

But for your software to work better, faster and... louder, you will get into at least the basics of how to design your data schema, how data relate to each other in the database, what data types match your code better. You'll never need to know the relational and post-relational possibilities Postgres offers.

I will show you some fundamentals of Postgres, some tips and tricks for software design. I will show you developer’s friends and foes, giving you a power no one will withstand. In return, just say you’ll pay me after life… however high the price.

.... evil grin.

The future of connection pooling: PGBouncer or something else?
Postgres its connection pooler landscape is constantly changing: PgBouncer now supports named prepared statements in transaction pooling mode! New connection poolers with other fancy features like sharding and clustering are popping up too. So, now is a good time to reconsider your choice of connection pooler.

But do you really need to switch and if so which pooler do you choose?

• Simply the pooler already provided by the Postgres client library for your programming language of choice?
• The tried and tested PgBouncer?
• Or, one of the new kids on the block, like Odyssey, PgCat, or Supavisor?

In this talk you'll learn:

1. How some of the major new PgBouncer features work and how these features can be useful to you. The new named prepared statement functionality will be covered in detail.
2. What the differentiating factors are between PgBouncer, Odyssey, PgCat, and Supavisor. So you can decide for yourself which of these is best for you.

Please note that this is an alcohol-free event. Light bites will be provided.

By attending this event, you agree to abide by our Community Code of Conduct.