• Friday, September 29, 2017: Trainings

Mastering Postgres Administration: Bruce Momjian

Postgres Performance and Maintenance: Joshua D. Drake 

• Saturday, September 30, 2017: Breakout Sessions (To be announced)

1. Mastering PostgreSQL Administration by Bruce Momjian
2. Migrating from Oracle to PostgreSQL by Jim Mlodgenski
3. Postgres Performance and Maintenance by Joshua (JD) Drake
4. Database Automation by Robert Bernier 

• PostgreSQL v10 an Amplified version of Postgres!
• Using Kubernetes/Docker/Helm to Deploy On-Demand PostgreSQL Streaming Replicas
• Postgres Window Magic
• BDR Around the globe

• Diamond: Amazon Web Services
• Platinum: Compose, OpenSCG, 2ndQuadrant
• Partner: Quest
• Supporter: Command Prompt
• Media: @amplifypostgres

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.

Postgres Conference organizers come to us through a variety of channels, but they all have their own unique story and pathways. Unlike many of our organizers, Lindsay Hooper’s background is non-technical and focused on the logistics, partnerships, and outcomes of Postgres Conference. Read on to learn more about her and her non-profit organization of choice

What is your background?

I majored in art and film at Bucknell University, and I started my career working in art galleries in Manhattan. I quickly moved to events and marketing, and within a few years I started doing events and marketing for tech companies and startups.

What do you do in your full-time job?

I have my own events company called LRH Events, and most of my clients are either in the non-profit or tech worlds. Events are a great tool for gaining brand awareness and for creating community, but getting an event off the ground takes some serious marketing chops, and so I do marketing as well.

What’s your favorite part of Postgres Conference?

There’s so much to love about Postgres Conference. When it comes to the conference itself, I love the logistics and planning that goes into what the event actually looks like. I love everything from brainstorming what the conference should look and feel like, to coordinating with speakers, streamlining talks, and coming up with schedules.

Beyond the actual events, my favorite part is the People, Postgres, Data community that surrounds the organization. I’ve never experienced such a truly people-first group, and I think that that shows in the fact that this isn’t a twice a year conference - it’s a constant connection that’s focused on people, not just Postgres or open source technology.

How do you spend your free time?

I am based in NYC, which affords me the opportunity to spend a lot of my free time exploring the city’s restaurants and museums. I highly recommend an afternoon at The Met, followed by dinner down in the East Village at either Raclette or Dirt Candy. 

Beyond that, I’ve been involved with a non-profit called Mouse for the last five years, so I also spend a few evenings each week working on fundraising and awareness initiatives. Mouse’s mission is to provide vulnerable youth with the computer science skills needed to enter and succeed in higher education and the high tech workforce. We are committed to fostering greater diversity and humanity in STEM and empowering youth - and all those that educate them - to access and amplify technology as a force for good.

How did you begin working with Mouse and what’s your role there?

I started working with Mouse five years ago when they launched the Diversity in Tech Awards, which is their annual awards event that honors folks in the tech ecosystem who foster greater diversity and humanity in STEM and empower youth. They needed event support, and I was able to step in to help.

Since then, I joined Mouse’s associate board, became the VP, and am currently the Associate Board President. 

What are the biggest challenges facing STEM education right now?

The greatest challenges facing education as a whole have shifted in the last few months due to the COVID-19 pandemic. In speaking with Mouse students, I’ve learned that a lot of what they’re up against is the variety of platforms that they’re receiving school work on and the lack of collaboration. On the flip side, most teachers are experiencing a learning curve themselves when it comes to remote teaching.

During the COVID-19 crisis, Mouse has played a frontline role in meeting the emergency educational needs. Responding to a call from the NYC Department of Education after schools closed, Mouse has:

• Trained more than 4,000 teachers in online teaching methods so they can reach their students.
• Helped more than 100,000 NYC students get access to online learning
• Digitized youth programs like the Emoti-Con Virtual Showcase and Mouse Design League for students to continue their computing projects
• Made our STEM and computer science learning platform, Mouse Create, free for all users during the crisis

How can I get involved in Mouse?

If you’re interested in getting involved with Mouse, please feel free to reach out to me directly at Lindsay@postgresconf.org

Alternatively, Mouse is proud to be able to continue our work with students and educators during the COVID-19 crisis. Please give generously today at www.mouse.org/donate so we can continue to make great strides in finding new ways to help our community in these challenging times. 

Brass tacks

• Silicon Valley is selling tickets briskly, get yours today and join us at the largest gathering of Postgres leaders on the West Coast.

• South Africa is set to release their schedule shortly. Watch the site for opportunities in October.

• We have hinted at digital events in the past and they are in the final planning stages. Digital events will encompass best in class content from our community in the format of Webinars, Q&A sessions and Professional electronic training opportunities. Watch for more news on these unique opportunities as we get closer to Fall 2019.

Seasons

It is the middle of summer, and as Glenn Frey would say, “The Heat is on!” Summer is the time when everyone is busy, yet nobody is busy. You have a contract to execute but the signer is on vacation. You have a project to complete but your digital nomad developer took off for the beach. Suddenly even checks may be delayed because of a long weekend up in the mountains. It is also a time to catch up on the things that may have been overlooked. When the person driving your priorities is on vacation it is easier to step back and observe your purpose.

Introduction

At PostgresConf 2019 in Manhattan we organized a Diversity and Inclusion panel with the help of Plato. The panel was well attended, but not as much as we had hoped. This fact outlined that we had more work to do on expanding our leadership position within Diversity, Equity and Inclusion in the Professional Postgres community.

We take this topic very seriously and we would consider PostgresConf and our focus on People, Postgres, Data a success if the only outcome was for all to feel welcome and supported within our community. Thankfully we have organizers and volunteers who are passionate about this very topic.

We would like to introduce the PostgresConf and PgCentral Foundation DEI (Diversity, Equity and Inclusion) Work Group:

• Debra Cerda: DEI Organizer

• Henrietta Dombrovskaya: Contributor

• Ryan Lambert: Contributor

• Mara Lemagie: Contributor

• Vikki McCormick: Contributor

• Amanda Nystrom: Co-Chair Sponsor

Over the coming months we will be continuing to communicate our passion, our purpose, our action and our accomplishments in bringing true Diversity, Equity and Inclusion to our community.

“A genuine leader is not a searcher for consensus but a molder of consensus” -- Martin Luther King

PostgresConf Philly which is organized in conjunction with Philly Postgres sold out in July! A packed room, great content and glorious collaboration was available to all for free due to the generous support of the Wharton School for Business!

As we continue to build our professional relationships, connections with academia are going to be vital. Academia is one of the few spaces that Postgres has not been able to make assertive gains in adoption and it crucial to the long term vision of our community that Academia recognize and adopt Postgres as the World’s Database and a viable option for teaching the next generation of data experts.

International communication

As our community grows Internationally with strong ties to Asia, and countries in the Southern Hemisphere it becomes difficult to connect with those cultures using our normal nomenclature. In our last newsletter we used a quote meant to be a compliment and challenge to the Western communities to try new things. The quote was about pigs ears and how they are delicious. The quote was interpreted by some in the Asia community as negative.

While writing this newsletter, we had used a spelling variation for the term “Wowzers” which in American pop culture is meant to be an exclamation of amazement. However in other cultures it maintains a negative connotation causing us to change the term to Kapow. These communication challenges show us that we must be open and without pride in our communication. We must show patience and understanding with cultures that are not like ours and that the communities that are able to achieve this will lead the future of Open Source and Postgres.

“Every human is like all other humans, some other humans, and no other human” — Clyde Kluckhon