Debra Cerda Blog Posts

 

As part of the countdown to Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Relevant Logic President/CEO Guyren Howe is a web developer, trainer, database expert, technical writer, and more specializing in PostgreSQL, Flutter, and Rails. Guyren will present “Postgres’s Type System” at Postgres Conference 2024. Read what Guyren has to say about Postgres and why to attend his session:

Why should attendees come to your talk at Postgres Conference 2024?

What would you like for them to take away from your session? Learn the important details of Postgres's type system: the built-in types, extension types, domains, arrays and custom types.

What is your favorite aspect of Postgres Conference?

My talk :)

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?

Follow the pgsql-general list. Learn relational theory. Don't listen to the database haters.

How do you see the use of open source technologies evolving over the next five years?

I foresee an open source boom as AI technologies can work with open source much better than closed.

 

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

As part of the countdown to Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Robert Bernier is senior PostgreSQL consultant at Percona.

Robert will present Working With The Citus Extension. Read what Robert has to say about Postgres and why to attend their session:

Why should attendees come to your talk at Postgres Conference 2024? What would you like for them to take away from your session?
For people who have heard about Citus but know nothing about it.
What is your favorite aspect of Postgres Conference?
Meeting my peers
What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?
Data eats the world. Focus on learning about your data and how it's used.
How do you see the use of open source technologies evolving over the next five years?
PostgreSQL is a General Purpose Management System. It will come to dominate the DBMS world.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Three talents:
- know your SQL
- know your OS (linux)
- know a programming language

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

Debra Cerda     April 18, 2024     speaker spotlight

The Postgres Conference 2025 is set to take place in Orlando, Florida, from March 18 to 21, 2025. This year's conference features an expanded lineup of tracks, including the Dev Track, which is tailored for developers seeking to deepen their expertise in PostgreSQL. This track offers sessions to enhance your development skills, explore new tools, and provide practical insights into PostgreSQL's capabilities.

What to Expect

The Dev Track is curated to address the diverse needs of developers working with PostgreSQL. Attendees can look forward to:

  • In-Depth Tutorials: Hands-on sessions that delve into advanced PostgreSQL features and development practices.
  • Expert-Led Workshops: Opportunities to learn from seasoned professionals about optimizing performance, implementing machine learning, and more.
  • Cutting-Edge Topics: Discussions on the latest tools, extensions, and methodologies in the PostgreSQL ecosystem.

Session Highlights

Here are some standout sessions in the Dev Track:

  • A Practical Guide to Set-Based Queries (paid training)

    • Speaker: Aaron Cutshall
    • Date & Time: March 18, 2025, 9:00 AM – 12:00 PM
    • Description: This workshop addresses performance issues arising from procedural code in PostgreSQL. Aaron will guide participants through transforming procedural logic into efficient set-based queries, enhancing database performance.

  • Machine Learning using PostgreSQL (paid training)

    • Speaker: Abbas Butt
    • Date & Time: March 18, 2025, 1:00 PM – 4:00 PM
    • Description: Abbas will introduce participants to implementing machine learning algorithms directly within PostgreSQL 15.x using Apache MADlib 2.1.0 installed on Ubuntu 22.04. The session covers practical applications of predictive analytics, enabling developers to harness the power of ML in their databases.

  • From MongoDB to Postgres: Building an Open Source Standard for Document Databases
    • Speaker: Peter Farkas
    • Date & Time: March 19, 2025, 4:00 - 4:20 PM
    • Description: This session reviews the current state of document databases, and demonstrates how Postgres handles MongoDB workloads with ease.

For a comprehensive view of all sessions and to plan your itinerary, visit the official conference schedule.

Why Attend?

Participating in the Dev Track at Postgres Conference 2025 offers numerous benefits:

  • Skill Enhancement: Gain practical knowledge and hands-on experience with PostgreSQL's advanced features.
  • Networking Opportunities: Connect with fellow developers, industry experts, and thought leaders.
  • Stay Current: Keep abreast of the latest developments, tools, and best practices in the PostgreSQL community.

Don't miss this opportunity to elevate your PostgreSQL development skills. Register now and join us in Orlando for an enriching experience.

Debra Cerda     March 06, 2025

<

 

As part of the countdown to Postgres Conference 2024 learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

NEXTGRES founder Jonah Harris is a developer with expertise in database internals, high-performance systems, and near-real-time machine learning optimizations. Recognized for contributions to Oracle Database and PostgreSQL, with leadership roles at MariaDB, The Meet Group, and EnterpriseDB.

Jonah Harris will present The Future of MySQL is Postgres.  Read what Jonah has to say about Postgres and why to attend their session:

Why should attendees come to your talk at Postgres Conference 2024?  What would you like for them to take away from your session?

Attendees will leave this session understanding how PostgreSQL offers superior performance, reliability, and a richer set of features for modern application development over MySQL, and how this extension simplifies and accelerates the migration process, ensuring transparent compatibility. 

What is your favorite aspect of Postgres Conference?

My favorite aspect of Postgres conferences is the collaborative spirit, where developers, administrators, and enthusiasts come together to share their knowledge and solve real-world challenges.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?

I advise diving into hands-on projects and contributing to the OSS communities with an open mind; this offers invaluable experience and broad networking opportunities within open source communities, specifically PostgreSQL.

How do you see the use of open source technologies evolving over the next five years?

I see open source technologies becoming even more integral to innovation, driving collaboration and accessibility in emerging fields as well as traditional industries.

What considerations should be taken for the adoption and use of Postgres and related open source technologies? 

I always consider matching a technology's strengths to a project's needs. Whether it's Postgres or another OSS technology, evaluate it for its full capabilities and best fit first. Once those capabilities and fit are evaluated, assess the organization's ability to manage it.

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

Call for Speakers: Join Us at Postgres Conference Seattle 2024!

We are excited to announce that the Postgres Conference Seattle 2024 is accepting speaker submissions! This is your chance to share your knowledge, insights, and experiences with the global PostgreSQL community in one of the world’s most innovative tech hubs. Whether you're a seasoned PostgreSQL expert or have unique insights on emerging trends, this is the perfect stage to amplify your voice and make an impact.

Why Speak at Postgres Conference: Seattle

As the largest PostgreSQL gathering in the U.S., Postgres Conference: Seattle 2024 brings together users, developers, DBAs, and thought leaders from diverse industries including FinTech, HealthTech, EdTech, and more! Here’s why you should consider submitting a proposal:

  1. Expand Your Reach: Presenting at the conference will allow you to connect with hundreds of like-minded professionals, influencers, and companies shaping the future of data management.
  2. Share Your Expertise: Whether you're a PostgreSQL guru or a curious learner with unique insights, your contribution can help others grow in their own Postgres journey.
  3. Professional Recognition: Gain visibility and recognition within the Postgres community and broader tech industry. Being a speaker enhances your profile and can open doors for future collaborations, partnerships, or even job opportunities.
  4. Contribute to the PostgreSQL Ecosystem: PostgreSQL continues to evolve rapidly. By sharing your experiences, you contribute to the collective growth and innovation of this incredible open-source database system.

Tracks for Every Interest

We’re looking for speakers across various areas of expertise. If you work in development, operations, or the essential aspects of PostgreSQL usage, we want to hear from you! Here’s a quick overview of our three main tracks:

Development (Dev) Track

Do you have cutting-edge insights on PostgreSQL development? This track is for talks focused on building, optimizing, and scaling applications using PostgreSQL. Some of the topics you could cover include:

  • Query optimization and performance tuning
  • Building and deploying PostgreSQL-based applications
  • Best practices in database schema design
  • Case studies of innovative solutions using PostgreSQL

Whether you're diving into PL/pgSQL, extending Postgres with custom functions, or exploring advanced indexing techniques, this is the perfect platform to share your expertise with fellow developers.

Operations (Ops) Track

If you’re working behind the scenes, ensuring that PostgreSQL environments are secure, scalable, and high-performing, the Ops track is for you. This track seeks submissions from database administrators, SREs, DevOps engineers, and anyone involved in the operational side of PostgreSQL, such as:

  • Scaling PostgreSQL for high-traffic applications
  • Backup and recovery strategies
  • Monitoring and observability tools
  • Managing multi-region or cloud-based Postgres instances

Share your experience on how to keep PostgreSQL running smoothly, even under the most demanding conditions.

Essentials Track

The Essentials track is perfect for those who want to speak about the core foundational aspects of PostgreSQL. It’s an ideal opportunity to present content geared toward people who are new to PostgreSQL or seeking to deepen their understanding of its key concepts. Suggested topics might include:

  • Introduction to PostgreSQL for beginners
  • SQL best practices and optimization
  • Setting up a robust PostgreSQL environment
  • Security fundamentals for database management

This track encourages first-time speakers and practitioners who want to help others navigate the essentials of working with PostgreSQL.

How to Submit Your Proposal

Submitting a proposal is easy! Simply prepare an abstract that describes your talk, its relevance to the conference tracks, and what attendees will take away from it. We encourage submissions from individuals of all backgrounds and levels of experience. Diversity of thought and experience enriches the conversation, and we welcome fresh perspectives.

Create a user account and submit your abstract, title, and description for review consideration.

Take this opportunity to shine as a thought leader in the Postgres world. Share your journey, inspire innovation, and connect with a vibrant community that’s as passionate about Postgres as you are. Submit your proposal today and join us in Seattle for an unforgettable experience!

Important Dates:

Submission Deadline: Monday, September 30th, midnight Pacific Time/ 3 am ET

Event Dates: November 6 - 7, 2024

Ready to Submit?

To submit your proposal and find more details, head to our submission page. Questions can be directed to organizers@postgresconf.org. We look forward to seeing you in Seattle!

We can’t wait to hear from you. Let’s shape the future of Postgres together!

Debra Cerda     September 26, 2024     seattle postgres open source conference

As part of the countdown to Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Baji Shaik is a Sr. Lead Consultant at AWS ProServe, GCC AMER, and is a seasoned expert in SQL/NoSQL databases, specializing in database migration and optimization. With a wealth of experience spanning various technologies, he's authored multiple books on PostgreSQL and actively contributes to the AWS blog community.

Baji will present “Beyond Boundaries: Mastering 2-Level Encryption Migration in PostgreSQL”. Read what Baji has to say about Postgres and why to attend his session:

Why should attendees come to your talk at Postgres Conference 2024? What would you like for them to take away from your session?
Learn about encryption in Oracle, its pros and cons. Discover PostgreSQL's encryption methods. Choose and migrate to the right encryption method without compromising security or performance.

What is your favorite aspect of Postgres Conference?
I actively participate in PostgreSQL Conferences to expand my knowledge base and forge valuable connections within the community.

What advice would you have for a Computer Science graduate or entry level developer who is interested in learning and engaging with Postgres and other open source technologies?
My advice would be to start by exploring online resources, joining community forums, and actively participating in relevant conferences and workshops to gain practical experience and network with industry professionals.

How do you see the use of open source technologies evolving over the next five years?

I envision open-source technologies playing an increasingly vital role across various industries, driving innovation, collaboration, and cost-efficiency while fostering a more inclusive and accessible digital ecosystem.

What considerations should be taken for the adoption and use of Postgres and related open source technologies?

Considerations for adopting and using Postgres and related open-source technologies include evaluating compatibility with existing systems, assessing scalability and performance requirements, ensuring adequate support and expertise, and considering factors like security, community support, and long-term sustainability.

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

 

Debra Cerda     April 10, 2024     speaker spotlight

As part of the countdown to PostgresConf Silicon Valley 2023, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Meet Dave Stokes, Technology Evangelist for Percona. Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide. He resides in Texas with the mandated pickup truck, hound dog, and guitars.

Read what Dave has to say about Postgres and why to attend his sessions which include "MERGE() - A Quick Introduction" and "PostgreSQL High Availability: The Considerations and the Candidates."

 

Why Postgres? Tell us about your involvement with the greater Postgres community. (How long have you been involved? How have you contributed? How else would you want to contribute?)

I have been mainly involved in the MySQL Community for a long time but am now exploring PostgreSQL. I have started a series on PostgreSQL for MySQL DBAs that is very popular

What new features of PostgreSQL 15 are you most excited about?

Merge()!

What features do you believe should be developed/improved and released in the next major upgrade?

JSON_TABLE()!! Please, please, pretty please!!

Why should attendees come to your talk at Postgres Conference Silicon Valley 2023? What would you like for them to take away from your session?

From the Merge() talk, I hope they will go away understanding how transaction log processing works. For the HA talk, I do not expect them to walk away as they will be so filled with brain energy that they sort of levitate away!

What is your favorite aspect of Postgres Conference?

The people.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?

Open source !- free. It provides a flexibility to innovate.

What's your top suggested readings for 2023?

Anything by Tim Dorsey.

What do you believe are the major achievements of open source and Postgres over the last decade?

Open-source software has proven that good code comes from more than just semi-benevolent corporations. And PostgreSQL has proven the power of the mailing list!

Check out the full schedule for Postgres Conference Silicon Valley 2023, and buy your tickets soon!

Debra Cerda     April 17, 2023

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Hubert Zhang will co-present with Jack Wu at PostgresConf US 2018 on "Customize and Secure the Runtime and Dependencies of Your Procedural Languages using PL/Container." Hubert is a staff software engineer at Pivotal. He received his Master Degree at Peking University, with a major in artificial intelligence. He is most interested in database systems and distributed computing platform.

Tell us about your involvement with the greater Postgres community. (How long have you been involved? How have you contributed? How else would you want to contribute?)

I've been working on Postgres based MPP database Greenplum and HAWQ since 2014. I contributed on PLContainer in Greenplum, data locality, and Ranger module of HAWQ (a SQL-On-Hadoop system).

What features should be developed/improved and released in the next major upgrade?

Vectorize execution for OLAP queries.

Who should attend your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Data scientists and anyone who want to use Python and R in database to do data analysis and machine learning. You'll learn how to use PLContainer as well as how to build a customized docker image to setup your specialized Python or R environment.

Check out the full schedule for PostgresConf US 2018, and buy your tickets soon!

As part of the countdown to PostgresConf Silicon Valley 2023, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Meet Tatiana Krupenya, CEO of DBeaver. DBeaver provides a GUI interface that "connects to all data sources and stores, enables special extensions for big data databases, and includes supplemental features like a data viewer, an editor, mock data generator, metadata browsing and visual query builders, enabling users to dynamically access all of their databases while working within one environment."

Tatiana will present "Let robots help with queries" at this year's conference. Read more about Tatiana below:

 

Why Postgres? Tell us about your involvement with the greater Postgres community. 

DBeaver is one of the most popular UI tools for Postgres administration and data management. We support not only PostgreSQL itself but all popular forks and Postgres-based data sources, like Greenplum, Yugabyte, Redshift and others.

Why should attendees come to your talk at Postgres Conference Silicon Valley 2023? What would you like for them to take away from your session?

We have gotten used to thinking that working with databases is for database administrators and developers. However, thanks to modern technologies, people from other professional areas can also do this. It's data engineers, data architects, financial analysts, machine learning specialists, and others. The only thing that we need is to provide them with a safe and convenient infrastructure. In my talk, I would like to show how OpenAI can help with that.

What is your favorite aspect of Postgres Conference?

The best thing is the atmosphere. You can meet interesting people, learn about cutting-edge technologies, find new partners, and all of these in a friendly and positive environment.

Check out the full schedule for Postgres Conference Silicon Valley 2023. Walk-up registration is still available. Learn more here!

Debra Cerda     April 20, 2023     speaker spotlight

 

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Malcolm McLean of Apace Systems is a PostgreSQL DBA, Linux admin, Java/PHP developer and according to his bio "a bit of a pedantic perfectionist", with over 12 years of experience with PostgreSQL and somewhat more than that with Linux and development.

Malcolm is presenting "PostgreSQL in a Geographically Distributed Realtime Transactional System" on Thursday, April 19, at 11:20 am. Read what he has to say about Postgres and why to attend his session: 

Why PostgreSQL?

My very first job over 13 years ago introduced me to Postgres after having only worked with MySQL at university. Since then, I've been happier with its performance compared to other DB's I've benchmarked as well as with the features that are continuously introduced to keep the database on the forefront. Across 3 companies I have never looked back and never regretted my decision to always use Postgres.

Tell us about your involvement with the greater Postgres community.

I spoke at the first PgConf South Africa last year and I'm now one of the organisers of PostgresConf South Africa 2018.

What new features of PostgreSQL 10 are you most excited about?

Definitely the integrated logical replication without the need of an extension.

What features should be developed/improved and released in the next major upgrade?

It perhaps won't make Postgres 11, but at least by Postgres 12 we should have BDR integrated with the current logical replication capabilities rounded off.

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

We had an interesting replication problem to solve. Multi-master replication where data needed to be replicated betweens servers in multiple countries, some with data restrictions, but without replicating data where it didn't need to go. So a sort of conditional sharding with redundancy in each data center.

What sessions are you most excited about attending at PostgresConf US 2018?

 The talks on replication (anything to make our lives easier) and security. 

What is your favorite aspect of PostgresConf US?

Meeting like-minded people from different backgrounds. And of course, the trip itself. I've done quite a bit of travelling over the years, but I haven't yet been to the US.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Push yourself to learn. Sitting back doesn't get you very far. 

 

Check out the full schedule for PostgresConf US 2018, and buy your tickets soon!