Archive for April 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.

Silas Marvin is a founding software engineer at PostgresML, writes software for fun and a better future.

Silas will present "RAG Masterclass: Simplify your data infrastructure with in-database NLP using pgml and pgvector for Retrieval Augmented Generation." Read what Silas 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?
Postgres developers should attend my talk to learn how to simplify their data infrastructure and build fast, powerful RAG applications using pgml and pgvector. Attendees will gain a solid understanding of RAG and its applications in Postgres, along with practical knowledge of pgml and pgvector to create efficient, scalable NLP solutions.

What is your favorite aspect of Postgres Conference?
My favorite aspect of Postgres Conference is the opportunity to connect with an incredible open-source community of like-minded developers who are passionate about pushing the boundaries of what Postgres can achieve. It's an awesome experience being surrounded by individuals who are committed to ensuring that Postgres remains the database powering the future.

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?
As a recent graduate myself, I recommend diving into the Postgres community and exploring open-source technology. Open-source projects provide an incredible opportunity for new developers to learn and grow as the development process is transparent and collaborative. In particular, I have found the Postgres community to be an exceptional group of intelligent, experienced developers who are not only building amazing projects but are also willing to guide and support newcomers on their journey.

How do you see the use of open source technologies evolving over the next five years?
Over the next 5 years, open source technologies are only going to keep growing and playing a bigger part in the software world. As software engineering grows, open source will grow right along with it. Solid, proven projects like Postgres will be the foundation that many new open source tools are built on top of.

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

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!

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!

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.

Manish Shah is founder and CEO of Datasparc, and brings expertise in product development, database security, and scalable cloud systems. His thought leadership and patent ownership in sensitive data discovery and protection underscore his ability to influence and innovate in the field.

Manish will present "Zero Trust database access with DBHawk". Read what Manish 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?

Join the session exploring critical database security and access challenges. Manish will dissect current issues and provide solutions for achieving precise zero-trust database access.

What is your favorite aspect of Postgres Conference?
Meeting face-to-face Postgres users.

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?
Learn SQL and other programming language. Install Postgres and start playing with it.

How do you see the use of open source technologies evolving over the next five years?
Businesses are recognizing the value of open source software, and its adoption in the enterprise is expected to grow.

What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Strong security and reliable support are crucial for wider adoption of Postgres. After all, data is an organization's most valuable asset.

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.

Shayon Sanyal is a Principal PostgreSQL Specialist at Amazon Aurora, with over 15 years experience, and crafts resilient applications, leveraging PostgreSQL's advanced features.

Shayon will present Enhancing OLTP Systems with pgvector: Best Practices in Database Design. Read what Shayon 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?
The integration of pgvector into existing Online Transaction Processing (OLTP) systems represents a significant advancement in leveraging vector search capabilities within traditional database environments. This presentation is designed to educate database professionals on the thoughtful integration of pgvector into OLTP applications powered by PostgreSQL, ensuring enhanced functionalities without compromising the core transactional integrity and performance. Attendees will learn how to adopt pgvector to unlock new application features while maintaining reliability, performance and scalability of their PostgreSQL databases. The presentation provides a roadmap for practical pgvector integration regardless of the hosting environment.

What is your favorite aspect of Postgres Conference?
For me, the most amazing aspect of the Postgres Conference is the opportunity to learn from and engage with some of the most brilliant minds in the PostgreSQL ecosystem. The lineup of speakers and contributors is always exceptional, offering invaluable insights and perspectives that can shape the future of this powerful database management system. The depth and breadth of technical discussions from advanced database internals and performance optimizations to cutting-edge features and real-world use cases, the conference provides a platform for exploring the full potential of PostgreSQL. It's a true feast for those who crave technical excellence.

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?
My advice would be to dive in headfirst and immerse yourself in the open source community. Start by exploring the official documentation and resources provided by the PostgreSQL project. Don't be afraid to ask questions on forums, mailing lists, or community channels – you'll be amazed at how welcoming and supportive the community is, especially towards those eager to learn. Attend local meetups or online events focused on PostgreSQL and open source technologies. These are excellent platforms for networking, learning from experienced professionals, and staying up-to-date with the latest trends and best practices.

How do you see the use of open source technologies evolving over the next five years?
Increased adoption across industries: Open source technologies have already gained widespread acceptance in the tech industry, but I expect their adoption to accelerate across various other sectors, such as finance, healthcare, manufacturing, and government. As organizations recognize the benefits of open source, including cost-effectiveness, flexibility, and community-driven innovation, they will be more inclined to embrace these technologies in their mission-critical systems.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
If I had to pick 2 then - 1/ Community Support and Documentation: Evaluate the size and activity level of the community surrounding the open source project. A vibrant and engaged community is often a good indicator of the project's long-term sustainability and the availability of support resources, such as documentation, forums, and mailing lists. and 2/ Scalability and Performance: Thoroughly assess the scalability and performance capabilities of the open source technologies you intend to use, especially if you anticipate handling large volumes of data or high-traffic workloads. Conduct performance testing and benchmarking to ensure that the technologies meet your specific requirements. Then there are other considerations such as security and compliance, integration and interoperability etc.

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.

Tatiana Krupenya is CEO of DBeaver Corp, an information technology company with many years of experience developing database management tools. DBeaver has created a full-featured data solution that easily adapts to users' needs, from open-source tools to all-in-one enterprise software. PostgreSQL is one of the most popular databases among DBeaver users.

Tatiana will present "Looking for the differences in your data". Read what Tatiana 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?
If you have ever tried to compare the data between tables, you know that it's not so obvious. It's not difficult if your table has a few tens of rows. You can easily do this visually. But what if you have thousands or millions of rows? Let's review the possible ways to compare this amount of data together.
What is your favorite aspect of Postgres Conference?
The best at any Postgres Conference is the Postgres Community. An opportunity to talk to people who are inspired by technology and ready to share their own experiences is invaluable. The conference is a place where you can feel what is the open-source culture.
How do you see the use of open source technologies evolving over the next five years?
There are no limits to open source. I am happy to see that big corporations invest more and more resources in open source. I believe that open source is not charity but a quality sign. Open source is always on the edge of technologies; it's flexible, and it's open to new. It's hard to predict how exactly these technologies will evolve over the next five years, but there are no doubts that open source will have an important place there.

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your ticket! Walk-up registration is available onsite.

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!

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.

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!