Debra Cerda Blog Posts

 

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 PostgresConf Silicon Valley 2023, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Bryn Llewellyn is a Technical Product Manager at Yugabyte, Inc., which offers an open source, cloud native distributed SQL database that looks like PostgreSQL to the developer. Bryn’s speciality is SQL and stored procedures in the context of distributed SQL.

Bryn has worked in the software field for more than forty years. He started working with SQL when he joined Oracle UK in 1990. He relocated to Oracle HQ (Redwood Shores, CA) in 1996 and his last role, before leaving, was as the Product Manager for PL/SQL. He left Oracle in April 2019 to join YugaByte, Inc.

Bryn started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN) and then worked in Oslo, first at the Norwegian Computing Center and then in a startup. In Norway, Bryn programmed in Simula—recognized as the first object-oriented programming language and as the inspiration for C++.

Bryn will be presenting a mini-tutorial on Friday, April 21st at 9:30am Pacific Time on "How to configure a PostgreSQL cluster for multitenancy." Read what he has to say about Postgres and why to attend his session:

 

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

I work for Yugabyte, Inc. (Learn more about Bryn's background). YugabyteDB uses the PostgreSQL query processing code “as is” on top of its own open source Spanner-like distributed storage system. I started at Yugabyte four years ago. And that’s when I first started to learn and to use PostgreSQL. My job is to document YugabyteDB’s SQL and PL/pgSQL functionality. This, by construction, has the same syntax and semantics as does vanilla PostgreSQL. I therefore ask lots of questions on the “pgsql-general” mailing list and, very occasionally, discover bugs in vanilla PostgreSQL.

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

Actually it’s a feature that’s new in Version 14: the new syntax for “language sql” functions that lets you define the body without making it a text literal so that it’s parsed at “create” time—allowing proper dependency tracking (and other benefits).

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

I would dearly like to see new functionality for "language plpgsql" subprograms that’s comparable to PL/SQL’s “package” construct (in Oracle Database).

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

I describe a practical solution to a genuine problem. And I make all the code easily available for download from the GitHub repo.

What is your favorite aspect of Postgres Conference?

Meeting real PostgreSQL practitioners and talking with them about their real-world use cases.

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

Get a job where you use the technology on a daily basis.

 What's your top suggested readings for 2023?  Books, blogs -- from fiction to non-fiction to technical, anything you enjoy?

Our Yugabyte blog!

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

How YugabyteDB has made the familiar PostgreSQL functionality available as an open source, cloud native, massively scalable and fault tolerant, distributed SQL database system. (Of course, I would say this!) 

Anything else to add?

I’m excited to be attending (again), and speaking (again) at the Postgres Conference Silicon Valley.

 

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

Debra Cerda     April 11, 2023     postgres speaker spotlight
Modern Webinar Business Linked In Post (Billboard Fina

Are you interested in learning about the latest developments and best practices in PostgreSQL? 

Then you won’t want to miss next week’s Postgres Conference Silicon Valley 2023! This annual conference brings together experts and enthusiasts from around the world to share their knowledge and experiences with the PostgreSQL community.

This year's conference will be held in San Jose April 20 and 21, 2023, at the San Jose Hilton, and promises to be another exciting and informative event. Attendees can expect a wide range of presentations, mini-tutorials, and networking opportunities, covering Postgres and open source related topics such as high availability, migration, security, machine learning, AI and much more.

Whether you're a seasoned PostgreSQL developer, a database administrator, or just curious about this powerful open-source database system, Postgres Conference Silicon Valley is the perfect place to learn and connect with like-minded individuals.

So why should you attend? For starters, you'll get to hear from some of the brightest minds in the PostgreSQL community. You'll learn about the latest trends and technologies, and gain valuable insights from real-world use cases and case studies. Check out our full program.

In addition, you'll have the opportunity to network with other PostgreSQL professionals and enthusiasts, and build relationships that can benefit you and your organization long after the conference is over. 

Be sure to stop by the exhibit area and chat with our incredible sponsors and partners, including our Conference sponsors CoreDB and Amazon Web Services (AWS) as well as our Cloud sponsor Google Cloud and Distributed SQL Summit (DSS) sponsor YugabyteDB. Our Conference Partners for this year include Airbyte, Command Prompt, Inc., DBeaver, Fujitsu, Neon, Nutanix, Percona, pgEdge and Community Partner OnGres.

Postgres Conference Silicon Valley is also a great chance to explore the local area, with plenty of opportunities for sightseeing, dining, and entertainment. A Welcome Reception will be hosted by YugabyteDB on Thursday evening for all registered attendees. 

So if you're looking to expand your knowledge of PostgreSQL, connect with other experts and enthusiasts, and have some fun along the way, be sure to register for Postgres Conference Silicon Valley today. We can't wait to see you there!

 

Debra Cerda     April 10, 2023

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.

Tracy Jenkins is a Database Solutions Architect with Amazon Web Services. She enjoys working with databases and helping customers architect performant, highly available, and scalable solutions while making recommendations on reliability, cost, and security.

Tracy Jenkins will present PostgreSQL Architecture Considerations for Application Developers. Read what Tracy 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?

It's a session to present and discuss beginning your journey into PostgreSQL and discussing some of the database-specific terms.

What is your favorite aspect of Postgres Conference?
The community getting together to network and help others working with the engine.

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?
If you have any questions, ask.

How do you see the use of open source technologies evolving over the next five years?
I see its use increasing more and more because for PostgreSQL to be an open source engine, it's very powerful and the world is noticing.

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

 

Debra Cerda     April 12, 2024     postgres speaker spotlight architecture

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 Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Peter Celentano is a Senior Specialist Solutions Architect, specializing in RDS PostgreSQL and Aurora PostgreSQL. Collaborating with AWS clients, he crafts scalable, secure, performant, and resilient cloud-based database architectures.

Peter will present "PostgreSQL Architecture Considerations for Application Developers". Read what Peter 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?
So much content in the PostgreSQL sphere focuses on the DBA best practices and how-to's, but not much exists by comparison for the database developer. In my talk, we'll discuss key PostgreSQL concepts and database architecture (and why app developers should care). I hope folks that attend my talk take away lessons learned from the field and some best practices which they may not be aware of yet.

What is your favorite aspect of Postgres Conference?
Meeting community experts and customers whom I've met virtually (but not yet in person).

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?
The documentation for PostgreSQL is excellent (by comparison to many other open source projects). Spin up an ec2 instance, install PostgreSQL, and start figuring out how it works! You'll always learn more by breaking something and figuring out how to fix it then by reading about it in a book! Don't forget to vacuum!!

How do you see the use of open source technologies evolving over the next five years?
I see the development of better open source LLMs and hardware to back them. And eventually, deeper integration with GenAI in the Postgres core.

What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Streamlining the patch review/approval process, allowing for faster innovation in Postgres core (without compromising on security and stability)

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here!

 

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 PostgresConf Silicon Valley 2023, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Meet Ry Walker, Founder and CEO of CoreDB, which is currently in private beta. CoreDB "provides provides a fully-managed, secure, scalable Postgres cluster with access to an ecosystem of extensions, expanding the capabilities of a database." Ry is a long-time coder, founder investor and champion of open source. He enjoys nature, science, art, tennis, platform tennis, golf, basketball, fishing and indie game development.

Read what he has to say about Postgres and why to attend his keynote session "The Growing Postgres Ecosystem" on Thursday, April 20th:

 

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

I've been a user since the beginning, recently started CoreDB which will provide a managed Postgres SaaS.

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

Learn about exciting Postgres extensions and what CoreDB is planning to contribute to the ecosystem

What is your favorite aspect of Postgres Conference?

I'm a first timer :)

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

Blog about your journey.

 What's your top suggested readings for 2023?  Books, blogs -- from fiction to non-fiction to technical, anything you enjoy?

The Hobbit :)

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

The rise of open source and open core companies is exciting!

 

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

Debra Cerda     April 12, 2023     postgres 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.

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

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.

Chandra Pathivada is is a Senior Database Specialist Solutions Architect with Amazon Web Services. He works with the AWS RDS team, focusing on Open Source database engines like RDS PostgreSQL, Aurora PostgreSQL, and Babelfish for Aurora PostgreSQL.

Chandra will present “Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues" and "Behind the Scenes: Demystifying Transaction Isolation in App Development". Read what Chandra 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?
This talk dives into the core concepts, shedding light on the real-world implications of different isolation levels on performance and integrity. Through interactive examples and case studies, attendees will learn how to navigate common pitfalls and optimize application performance, balancing concurrency with isolation effectively. Gain the knowledge and best practices necessary to implement error-free database-backed applications, making it an invaluable opportunity for anyone looking to enhance their expertise in database management and application development.

What is your favorite aspect of Postgres Conference?
Engage with the PostgreSQL community. This conference offers a rich tapestry of learning, sharing, and networking. It's where boundaries of knowledge expand through collaboration and where every attendee, regardless of expertise, finds value and inspiration.

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?
Start with fundamentals through hands-on practice, engage with the community through forums and meetups, and contribute to projects. Expand your knowledge through tutorials and start building your own projects. Have a mentor and network with professionals specializing in areas of interest.

How do you see the use of open source technologies evolving over the next five years?
In the next five years, open-source technologies are set to play a pivotal role in innovation, with a growing preference among developers and organizations to initiate their projects or migrate from commercial to open-source solutions. The community-driven nature of these technologies will fuel the addition of new features, enhancing their value and appeal.

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

Debra Cerda     May 07, 2024     speaker spotlight