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.

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!

 

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

 

Henrietta "Hettie" Dombrovskaya is a database researcher and developer with over 30 years of academic and industrial experience. She holds a Ph.D. in Computer Science from University of Saint Petersburg, Russia, where she taugh Database and Transaction Theory, as well as multiple database tuning classes for both beginners and advanced professionals.

 

Her professional experience includes consulting for a number of government projects, and providing Data services in the financial sector, manufacturing, and distribution. She is a co-author, with B. Novikov, of the book “System Tuning." As Associate Director of DB at Braviant Holdings, she is happy to have an opportunity to implement the results of her research in practice.

 

Hettie will be presenting a breakout session on Wednesday, March 20, on "Using FDW Like Never Before." Read what she has to say about Postgres and why to attend her session:

 

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

I started to use Postgres by pure accident. I used to be a hard-core Oracle person, with 20 years of Oracle experience, and then I was offered a job at a company that was using Postgres. The year was 2010. I hadn't use Postgres since my student years and Stonebraker's version, so I reluctantly agreed -- thinking that it would be a very temporal job. But after a couple of months I found myself completely enchanted with Postgres, and decided to stay -- with Postgres as well as with the company.

 

 

For the past  several years I've being more active in promoting Postgres in different communities. My goal is to show the variety of ways Postgres can be used virtually anywhere, to promote Postgres among industries, developers and in academia. Since Dec 2016 I have led a Chicago PostgreSQL User Group, and I always make sure I have interesting speakers every month. Also, I am actively participating in the development and promotion of bitemporal framework in Postgres.

 

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

 

I hope that bitemporal framework will be eventually implemented as a real extension. 

 

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

 

I have two sessions at this conference. The first one, "Using FDW Like Never Before" is literally about "where there is a will, there is a way"! I am just showing a cool technique everyone can use, and hope somebody will build a Postgres feature on this idea.

 

The subject of the second session, ""Connecting Galaxies: Information Exchange Techniques for Java/PostgreSQL Applications" -- which I am co-presenting with Alyssa Ritchie -- is something I have been working on throughout my entire professional life. Most of the time when database people talk about optimization, they mean the SQL queries optimization. When we are talking about the real-life application -- not the abstract query -- the most performance gains can be achieved when optimizing the way an application interacts with a database.

 

This is one of the topics which "does not belong", and neither DB people, nor the application people want to claim it. So, once again, I am trying to profess and spread the word.

 

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

 

Revisit your freshman year math, calculus and algebra. You can't write good SQL without it.

 

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

 

 

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.

Tim Gorman is a technical consultant for Delphix who enable data virtualization and data masking to increase the agility of IT development and testing securely. Tim is co-author of six books about Oracle data warehousing and performance optimization, and has performed technical review for eight other published books. 

Tim will be presenting a breakout session on Wednesday, April 18 on "Reducing The Surface Area Of Risk In Data Security." 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?

30+ years in IT and databases, and PostgreSQL is the obvious heir apparent as every organization's default choice of data store.

Tell us about your involvement with the greater Postgres community. 

Just becoming involved.  I have been heavily involved in the Oracle user community for almost 25 years, and I have been getting involved in the Microsoft user community for the past 3 years.

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

pgPL/SQL

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

Creating environments for software development on PostgreSQL must include data masking to prevent confidential data from "bleeding" over from production to non-production environments.

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

Mastering PostgreSQL Administration

What is your favorite aspect of PostgresConf US?

Networking with my new technical community

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

What is learned when optimizing PostgreSQL is also applicable to other databases

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

Vladimir Putin, Michelle Obama, and Justin Trudeau.  Differing people with different accomplishments on the current world stage, and I would be fascinated to listen to how they react to one another (and to me) once the barriers and inhibitions are dropped.

 

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