Debra Cerda Blog Posts

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

We are pleased to announce a partnership between Redgate and PgCentral Foundation, Inc., to return Postgres Conference to Seattle! We’ll be joining forces in their brand-new venue -- the Summit at the Seattle Convention Centre (SCC) -- during this year’s PASS Data Community Summit (PASS Summit).

The PASS Summit team has been working to create a more collaborative environment between professional data communities. The new venue for 2024 allows the perfect opportunity to host our People, Postgres, Data community for the Postgres Conference: Seattle 2024 on November 6 and 7.

About PASS Summit

The PASS Summit has earned its reputation as the premier event for data security and database professionals. Since Redgate took ownership in 2021, the event has continued to offer unmatched learning opportunities, covering a wide range of data platforms including SQL Server, PostgreSQL, AWS, Google Cloud, and more. This year’s summit will take place in Seattle, from November 4-8, 2024, welcoming thousands of attendees eager to sharpen their skills and stay on the cutting edge of data management.

PASS Summit is not just about lectures and sessions –  it offers hands-on learning experiences, a vibrant community space, and networking opportunities with industry leaders. The event is known for its comprehensive sessions, keynotes by industry experts, and access to the latest tools and technologies that empower organizations to manage their data effectively. Whether you're a beginner or a seasoned professional, there’s something for everyone.

For more details about the summit, visit the official website: PASS Data Community Summit 2024

Highlights from Postgres Conference Seattle 2024

Alongside PASS Summit, Postgres Conference: Seattle 2024 will also be taking place, making Seattle the hub of data learning in early November. Postgres Conference is the leading event dedicated to Postgres, an open-source database that has become essential for many modern organizations. This year’s event is powered by the joint efforts of Redgate and Command Prompt, Inc., and is priced at an affordable $599 through November 3rd.*

PostgresConf Seattle attendees will get exclusive access to certain elements of the PASS Data Community Summit, such as:

- PASS Summit Keynotes: Hear from influential figures shaping the future of data.

- PASS Ecosystem Sessions: Deep dives into data platforms and security.

- Community Zone: A space to collaborate with other professionals and expand your network.

- Exhibit Hall and Exhibitor Reception: Discover the latest tools and technologies from industry-leading vendors.

- Lunches, Refreshment Breaks, and Community Events: Plenty of opportunities to refuel and connect with peers.

 

This integration gives PostgreSQL enthusiasts a chance to engage in the broader data conversation while still enjoying tailored Postgres content.

Check out the event page here for more information on Postgres Conference Seattle 2024.

* Note: Postgres Conference: Seattle 2024 online registration closes November 3rd.  On-site registration will require the purchase of a PASS24 1-Day or 3-Day ticket, so don't delay!

Debra Cerda     October 11, 2024

 

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!

We are thrilled to invite you to partner with us for Postgres Conference 2025, taking place in sunny Orlando, Florida, from March 18th to 21st! 

For 2025, we have expanded our conference offerings to provide even greater value to our attendees and partners. We’ve added an extra day dedicated to Professional Training, introduced a Professional Development track, and are excited to offer a unique Wellness Sponsorship that supports attendee well-being. 

Why Sponsor Postgres Conference 2025? Our conference is renowned for its diverse programming, including Talks, Keynotes, Conference Keynotes, Half Day and Full Day Trainings, Tutorials, and Presentations. Each session fits into one of five specialized tracks: Dev, Ops, Essentials, Professional Development, and Cloud. This variety creates extensive opportunities for you to engage directly with your target audience, whether they're developers, operators, or leaders focused on professional growth.

A partnership with Postgres Conference 2025 offers:

  • Increased visibility within the PostgreSQL community
  • Direct networking with key decision-makers and influencers
  • Opportunities to showcase your brand through custom sponsorship packages

Whether you are interested in a general sponsorship or would like to discuss custom opportunities tailored to your brand, we would love to connect. Explore the best options for you on our Sponsorships page

If you would like to schedule a call or need further information, please don’t hesitate to reach out to 2025-sponsors@postgresconf.org. We look forward to discussing how we can make your sponsorship experience at Postgres Conference 2025 truly impactful.

Sincerely,

Postgres Conference 2025 Sponsorship Team

 

Debra Cerda     November 21, 2024

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 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 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!

 

Pavan Deolasse is a PostgreSQL consultant for 2ndQuadrant, one of our Platinum Sponsors for PostgresConf US 2018. Learn more about Pavan in this Community Profile:

Pavan Deolasee is a contributor to the development of PostgreSQL and related technologies. He holds a Masters of Technology in Computer Science from the Indian Institute of Technology, Bombay, and has several publications to his credit.

Pavan was introduced to PostgreSQL in the year 2006 when he started working for a PostgreSQL company. Hacking PostgreSQL was a completely new experience, but by accepting help from the community -- especially Simon Riggs, his mentor -- he began working through the code and was soon working on a very important project (Heap-Only-Tuple aka HOT). It was a very complicated piece of work, yet one of the landmark features in PostgreSQL and to this day remains one of his most important contributions to the project. Pavan has since contributed several patches to PostgreSQL. 

HOT was committed to PostgreSQL in 2008 and Pavan has continued to stay fully engaged with the project. In 2009/2010, alongside other colleagues, Pavan started work on Postgres-XC, a distributed, shared-nothing, clustering solution based on PostgreSQL. He was involved in designing the high-level architecture of the solution, and later wrote many important pieces of the code such as the GTM, the GTM Proxy, the 2PC transaction controller at the coordinator, changes required to guarantee global consistency of the data, and many distributed planner and executor pieces.

When Postgres-XL, a fork of Postgres-XC, was released to the public in 2014, Pavan once again became involved with the project and has been leading the development of Postgres-XL ever since. 

Pavan joined 2ndQuadrant not long after in April 2015, and once again started working with long time colleagues and friends; he and 2ndQuadrant have continued to actively work on the development of Postgres-XL. The focus area of development has been stability and performance of the product while keeping the fork as close to open source PostgreSQL as possible. The most recent release (Postgres-XL 10) supports intra-datanode query parallelism, thus taking distributed query processing to the next level.

In 2013, Pavan and two of his colleagues started the India PostgreSQL User Group. They started conducting small meet-ups, in order to promote the technology in India and bring the local community together. These small gatherings have now expanded with a membership of over 600 members, and into a full scale conference: PGConf India, Asia's largest PostgreSQL conference with more than 250 people in attendance each day in 2018. 

As part of the 2ndQuadrant team of PostgreSQL developers, Pavan continues to work on many interesting new features. He is an active part of the production support team and also has the opportunity to investigate interesting customer problems, often leading to important and critical bug fixes to the open source project.

Pavan had this to say about his involvement with the project:

“I love PostgreSQL and the PostgreSQL community, so you will continue to see me around.”

 

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.

Dave Stokes is author of "MySQL & JSON - A Practical Programming Guide," and serves as a Technology Evangelist for Percona, advocating for MySQL innovation and best practices.

Dave will present “MERGE() - A Quick Introduction”. Read what Dave 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?
I like to show attendees new facets on old tools and help beginners master the very steep learning curves of today's world.

What is your favorite aspect of Postgres Conference?
The hallway track.

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?
You learn by breaking and repairing. After awhile you can learn to minimize the breakage but never the repairing.
And when you go to a show like Postgres Conference 2024 and have an open slot in the schedule, go attend a session on a subject you know absolutely nothing about. You will either learn that you do not like the subject and have only spent an hour of your life on something that does not interest you, or you will find another rabbit hole to explore.

How do you see the use of open source technologies evolving over the next five years?
PostgreSQL will be the dominant database. Sadly license changes may push us back to a pre-open source era when you had minimal or no choices in software.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
It needs to be more robust. Better replication that is easier to set up, no XID wrap-around, and easy upgrades.

Additional comments?
This is a great show - make the most of your opportunities.

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

Debra Cerda     April 17, 2024     speaker spotlight

Speaker Spotlight Baron Schwartz

 

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.

Baron Schwartz is the founder and CEO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software, and several books. He’s focused his career on learning and teaching about performance and observability of systems generally (including the view that teams are systems and culture influences their performance), and databases specifically.

Baron will be presenting a breakout session "How To Index Your Database" on Friday, April 20th at 12:50 pm. Read what he has to say about Postgres and why to attend his session: 

Why PostgreSQL? What got you into it, and made you stick with it?

The community has always been what’s drawn me to Postgres. From the very first I could immediately sense the deep commitment people had to the database and other people involved with the database. Each database community is special in its own way and has its own culture, and after being involved in many of them you sense it in a way you can’t explain. Postgres’s is loyal to freedom, independence, quality, and principles. All are dear to me as well.

Tell us about your involvement with the greater Postgres community.

I’ve participated since 2008 in various ways. I’ve blogged, written open source, written books, reviewed and tech-edited other people’s books, spoken, and attended. I hope to continue doing so!

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

Partitioning! Improved streaming replication! Parallel query execution! There are so many improvements. The pace of development is really impressive.

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

The database of the microservices-oriented future is only quasi-stateful. By this I mean that it acts almost like a read-through cache in front of “cold storage” like S3. Support for creating an empty database cluster, and having it fetch its data from cold storage on first query, would be game-changing for cloud-native apps. I realize that’s a lot of buzzwords, but it’s going to happen soon!

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

Indexing is at once the most important, simplest, and most complicated topic in designing a database; I hope to make it simpler and leave people with three big things they will never struggle to remember.

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

I'm really interested in hearing how others are using Postgres, both for creative purposes that showcase its flexibility and extensibility, as well as "use as designed." In my opinion, the best conference talks aren't "you should do this"; types of talks: they are "I did this and here's what happened"; I love stories!

What is your favorite aspect of PostgresConf US?

That’s an easy one to answer: seeing all my old friends again!

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

Computer Science seems to feel that algorithms, data structures, and so on are fundamental. Data persistence, especially relational, is equally important. Don’t neglect.

You can invite any three living people from anywhere in the world to dinner. Who do you invite and why?

I invite the three hungriest people in the world and eat mindfully with them, so I learn to appreciate what I have.

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