Joshua D. Drake Blog Posts

In 2016 we started working with horizontal communities. We wanted to make sure that PgConf US was an inclusive community that advocated not only for the best database in the world but also all the external Open Source technologies that make the best database in the world the best platform in the world. 

This year we wanted to continue building a stronger community through relationships and our efforts are proving successful. We have joined forces with several horizontal communities to bring original and related content to PgConf US. The first is Big Apple Py. They are working with PgConf US to run a full track of Python content as well as a development workshop. 


The workshop is particularly interesting as it will focus on a code sprint to develop a mature and user friendly Python based conference software. I wonder if they know we already use a Ruby on Rails solution...

We also have a great workshop being presented by DockerNYC and Jesse White: Automating production ready databases in Docker
DockerNYC
PgConf US 2017 is less than two weeks away and we continue to work with communities to bring you even more new content! Stay tuned as we expect to announce more workshops in the next few days. If you haven't purchased your tickets, today would be a good day.
Joshua D. Drake     March 15, 2017

Adaptation Lizard

As Postgres Conference pushes forward in the brave new world, we evolve and increase the ability for the People, Postgres, Data community to succeed. As a part of our positive adaptation we have a new website that features upcoming events, professional content (written and video), and the best in our written community via “Community Content”.

Discord

In an effort to provide a modern, friendly, and inclusive community platform, we have launched a Discord server for all things Postgres. We are providing a helpful experience with rule #1 being: Be Nice. Our discussions will branch out beyond the core of PostgreSQL and provide a forum for success with Postgres and related technologies. Join us for what is guaranteed to be a refreshing experience for the community: https://discord.gg/tjxNBCz

2021

We are seeking feedback from our community on 2021 in-person events. We are currently considering the East Coast event for October 2021 and the West Coast event for December 2021. Please help us in determining the type of event you would like to participate in!

Upcoming live events

We currently have the following webinars scheduled through October:

Joshua D. Drake     August 25, 2020

The third PGConf US event of the year is happening July 13 - 14th! Tickets are now available!

This year the event is at Huntsman Hall located at The Wharton School. There will be two days of awesome Postgres content. On July 13th we are pleased to offer two great training sessions by two of the most veteran members of the PostgreSQL community, Bruce Momjian and Joshua Drake. Between them they have well over 40 years of hands-on experience with PostgreSQL. 

On July 14th we have eight first-rate sessions covering everything from Postgres performance to development. Check out the full schedule here:
Sponsorship opportunities for the conference are still available. If you use Postgres, support Postgres, or if you are looking to recruit a local Postgres expert, this is a great opportunity. Become a part of our dynamic and growing ecosystem! The prospectus is available at:

We would not be able to produce PGConf Local: Philly 2017 without the generous support from our sponsors:

For more information about PGConf US please visit: PGConf US


PGConf US: People, Postgres, Data



Joshua D. Drake     June 20, 2017

Invisible Disease Awareness

“According to the Disabled World website, an estimated 10% of the U.S. population has what could be considered an ‘invisible’ disease, defined as a health condition that causes significant impairment and undermines the overall quality of life but does not outwardly manifest itself in ways that are apparent to others.” [1]



While normally our focus is Postgres, we wanted to take a moment to bring attention to the People side of People, Postgres, Data. May is mental health and Ehlers-Danlos awareness month. Ehlers-Danlos Syndrome (EDS) is a rare condition that affects the collagen throughout the entire body, resulting in dislocations, subluxations, lack of joint stability and support, tendinosis, and debilitating pain. There is no cure and the symptoms are life long.

 

In 2020, PostgresWarrior (AKA Amanda Nystrom) was diagnosed with Hypermobile EDS and Fibromyalgia. She is an instrumental and invaluable member of the People, Postgres, Data community. She has driven us forward in ways that so many of us never see and yet require to succeed. Many of our community are affected by invisible diseases - let's take a moment to appreciate what they accomplish and fight for in Postgres/Open Source.

Upcoming webinars | RSVP here

  • May 25, 1pm ET: Creating a Resilient PostgreSQL Cluster with Kubegres

  • June 15, 1pm ET: When it All Goes Wrong - Incident Response in Large Postgres Databases

  • June 23, 1pm ET: Making Postgres Fly on Kubernetes

  • June 29, 1pm ET: Implementing Cluster File Encryption in Postgres

24x7x365 Postgres & Linux servicesCommand Prompt, Inc.The last of the original Postgres companies

Sponsored

Community Chat

Our Discord Channel has 2000 community members waiting to participate in your Postgres success. Join us today with a community that has rule #1 of: Be Nice.

Podcasts








  1. https://www.socialworktoday.com/archive/072417p32.shtml
Joshua D. Drake     May 19, 2021     eds postgresql




The presentation includes an introduction and setup for consul as the means of providing highly available PostgreSQL in local and geographically disparate data centers or cloud providers. The presentations includes:

*) Introduction to consul and its architecture
*) Setup of a single consul cluster
*) Setup for a few sample database instances (OLAP and OLTP)
*) Firewall requirements
*) Integration with bind, djbdns, and dnsmasq
*) Setup geographic failover to two different data centers and cloud providers
*) Various Best Practices tips and suggestions
*) Q&A

Joshua D. Drake     April 25, 2017


How do you use Postgres?

I work Fred Hutchinson Cancer Research Center and within Fred Hutch, I work for the largest group called SCHARP, Statistical Center for HIV/AIDS Research and Prevention. We use Postgres to monitor the AIDS drug trials real time to see if the trials are working or not. This means we collect the data from doctors and labs around the world, and analyzing the data. We also have servers where we receive data from other research institutes and share our randomized data, de-personalized, with other research institutes.


What community contributions have you provided?

In 2010 I started SeaPUG, Seattle Postgres Users Group, at the request of Josh Drake. I have at least have the presentations there every year. I have also discovered several PostgreSQL: bugs which have been fixed. Some of them affected every version of PostgreSQL. Bug numbers: 7553, 8173, 8257, 8291. I also found 8545, which has not been fixed but Core has acknowledge needs to be fixed but they are not sure where it should be fixed, pg_dump or pg_dumpall. I started the PostgreSQL track at LinuxFest Northwest in 2014 after my GIS presentation in 2013 was standing room only. This year I got a booth at the SeaGL, Seattle GNU Linux, conference with the idea of having a booth there next year along with also doing a PostgreSQL presentation next year at the conference.


You recently took a renewed interest in speaking at Postgres Conferences, why?

I have been giving presentations locally now for the last 7 years and so I am now ready to move on to the next step, doing presentations at the Local and National conferences around the United States.


What is the #1 barrier you see to Postgres adoption?

People not knowing about PostgreSQL, most people know about MYSQL, MSSQL and Oracle, but do not know about PostgreSQL. This is changing, some, with the Cloud providers now offering PostgreSQL, but I go to these conferences, LinuxFest Northwest and SeaGL, and people all the time are asking me, "What is Postgres and why should I use it over MYSQL, MSSQL or Oracle", because they have never heard of PostgreSQL.


What is something you feel the wider Postgres community could be better at?

We need to promote PostgreSQL so that new people starting personal projects and starting at companies, will think about PostgreSQL before other databases. This starts with getting the younger generation interested in PostgreSQL and that also means that we need to get the college professors willing to talk about PostgreSQL in their curriculums instead of ignoring PostgreSQL for all the other competing databases. Some of this means that at all the other conferences, we need to have a PostgreSQL presence, aka booth and presentations. We should also come up with a certification method for PostgreSQL DBA's, User's, Engineer's, etc so that prospective employers will have an idea of the prospective employees skill set.

Joshua D. Drake     December 12, 2017

We caught up with Alex Tatiyants after finding out about his Pev project. This is an awesome web based visual explain analyzer that is similar to the awesome explain.depesz . 

Tell us a little bit (one or two paragraphs) about your project or how you use Postgres: 

I created Pev (Postgres EXPLAIN Visualizer) to scratch my own itch. EXPLAIN generates a wealth of information, but isn’t easy to make sense of. I wanted to create a tool that helps me quickly diagnose problems with queries. Apparently, other people found it useful as well.


Pev plan


Why did you chose Postgres for your project? 


Postgres is a fantastic database: performant, mature, feature rich, and of course open source. And in addition to being a first rate relational database, it has very strong document store features as well.


Have you attended a PgConf US event or do you plan to? 

I haven't had a chance to attend PgConf.

Are you interested in contributing to the community further and if so, in what fashion? 

I don’t have any concrete plans at the moment.

Any closing comments? 

Thank you for your interest.
Joshua D. Drake     August 16, 2017

People, Postgres, Data,

Due to the health risks and travel restrictions created by the Coronavirus we unfortunately have to cancel Postgres Conference 2020 which was to be held at the Marriott Marquis on March 23rd, 2020 thru March 27th, 2020.

We want to thank all of our attendees, partners and volunteers for all the hard work we all put in to try and pull this event off. Sadly, the stars were not aligned this year. We now focus our efforts on Postgres Conference Silicon Valley 2020 and our Digital Events

Thank you all for your patience and support,

Postgres Conference Chairs

Joshua D. Drake     March 12, 2020

PostgresConf Beijing 2019

Join our Mailing List | Attend one of our events |

Last week was PostgresConf Beijing 2019. This event was an exercise in people understanding what it truly takes to run a conference. It was a standalone event unlike PostgresOpen China in 2018 which always takes a lot more work. We had generous sponsor support with the likes of Microsoft, Amazon Web Services, IBM, Pivotal, Inspur, HighGo, Credativ, and Command Prompt.

The overarching theme of the conference was of course People, Postgres, Data and we had many (translated) conversations about how Postgres can be the center of your Data Universe and how the ecosystem thrives with not only PostgreSQL but also technology such as TimescaleDB and Yugabyte. All of which are Open Source and enable People to use Postgres to manage their Data. In 2020, the plan is to have PostgresConf China in October or November. The timing will allow for a more moderate climate as well as have more time to generate international content.

English As A Second Language

As we continue to work with English-as-a-second-language communities we continue to find opportunities for them to grow and contribute. Of course the most common (and possibly difficult) opportunity is that in order to contribute code to PostgreSQL.Org, you must speak English. This is not an unreasonable requirement as English is the language of Computer Science.

A common piece of feedback we received was not that English was the consideration but the “level” of English proficiency was high. Unfortunately, verbosity is not always productive and it is certainly counterproductive when the vocabulary doesn’t take into account the non-native speaker. It would be a boost to productivity if we as a community tried to be succinct and as uncomplicated as reasonable in our communication. To put this another way and from a far more qualified source than us:

“Don't use a five-dollar word when a fifty-cent word will do.”

-- Mark Twain

Contribution Opportunities

While encouraging the Chinese community to contribute we continued to look for the low barrier of entry tasks. The obvious opportunity is translation of various project documentation. That is not the only prospect as PostgreSQL has fantastic extensibility and suggestions of developing new extensions. Contributing directly to PostgreSQL code has a high barrier of entry between English as a second language and overall overhead in building comprehensive knowledge of the core code. Extensions in contrast generally require needing to understand narrow areas of code to build a feature that is user-need specific. We are still exploring these opportunities but one option would be to invite extension authors to work with regional communities for translation or feature work.

Software You Weren’t Aware Of

Oleg from PostgresPro and PGConf.Russia was present and we were able to have some great conversations about the work they are doing, most of which can be found on Github. Although there is a lot of great software in that repository, the one that grabbed my eye as immediately useful was Zson. Zson is an extension that allows native compression of JSON/JSONB documents, greatly reducing disk space usage and increasing query speed of documents.

Please Replace IRC and Slack

Further conversations were had on how we can build a modern collaboration community that is internationally inviting, supports all languages, and is built on Open Source technologies. Initially it seems that Mattermost is a good contender but after further research it seems that we should also consider Matrix.org. The idea has barriers as the Chinese are partial to WeChat and the Professional U.S. community has left IRC for Slack, whereas other communities such as Brazil and Russia have settled on Telegram. We have a community member based working group determining next steps.

You may say that I'm a dreamer

But I'm not the only one

I hope someday you'll join us

And the world will be as one

-- John Lennon

Looking Forward

As People, Postgres, Data and PostgresConf continues to move forward we are looking forward to building on existing initiatives and events. We have PostgresConf Philly next week, PostgresConf Silicon Valley in September, and our next International event in October with PostgresConf South Africa. We are also continuing to work on our Inclusivity, Equit,y and Diversity initiative and launching Digital Events! This doesn’t include the growing number of meetups joining the idea of People, Postgres, Data including NYC Postgres, Silicon Valley Postgres, Philly Postgres, Seattle Postgres, and Montreal Postgres!

Quote of the week

“Those pig ears are really good.” -- Michael Meskes, Credativ and Postgresql.org committer.

Joshua D. Drake     July 11, 2019     #postgres #postgresconf

PostgresConf Silicon Valley is being held October 15th-16th at the Hilton San Jose and the schedule is now available.


The two day event received over 80 submissions! A lot of the usual and legendary speakers are present but we were pleasantly surprised to find that so many new (to the conference) speakers submitted. It shows that the mission of People, Postgres, Data is growing at an amplified rate. The presentations are all of the "best-in-class quality" our attendees have come to expect from PostgresConf events.



Whether your needs are Big Data, Google Cloud, AWS RDS, GPDR Compliance, or you just have a burning desire to learn more about Kubernetes, PostgresConf Silicon Valley has you covered!

We also have two fantastic training opportunities which are the first of their kind:



Joshua D. Drake     September 04, 2018