Blog

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
Audience 945449 1920

 

Like most conference organizers we are learning to adapt to the new world; a world where physical events are no longer viable (at least in 2020). A world where people are genuinely and realistically concerned that an in-person event would increase their chances of receiving or spreading a life threatening virus.

 

The question is: Are in-person events a thing of the past?

 

The answer to that question is a difficult one. Our friends at O'reilly and Associates have permanently canceled their in person events. Our friends in Europe recently canceled the well respected PgConf.EU and Ibiza. We had to cancel our 2020 marque event in NYC in March and our upcoming Silicon Valley conference. The local community organizer website Meetup.com has even modified their capabilities to allow for online meetups. 

 

Humans in general seek out fellow human contact. That contact is usually of reasonably like minded individuals or at least mutual interests. This is why events like Postgres Conference are successful, because irrespective of any personal beliefs we are all there to learn and enjoy fellow Postgres professionals. But are virtual meetups and conferences going to be enough to satisfy that connection or are people going to demand a return to a historical norm?

 

Challenges

Even before COVID-19, in-person events came with challenges that put significant pressure on volunteers. Between cultural communication differences, having an independent Code of Conduct committee, pricing, economies of scale, partner demands, and now social distancing, conferences are now going to be more complicated than ever. A room that once could comfortably seat 100 can now only properly sit 30. An exhibit hall is likely out of the question and one-on-one mentoring and networking are likely not going to be viable.  How do we work around these limitations? Is it worth it? Are the people in our community even interested anymore or is it time to accept a new norm?

Opportunity

Without question this is a time of reflection, continued development of relationships, and looking into the magic 8-ball; a continual asking of questions to find the right path forward. The pandemic is a tough foe but true leaders are looking forward and trying to find ways to continue to serve. For that to be successful we need your help. We have put together a poll (that can be found here) to gain insight into what opportunities we may be able to pursue in the future. Please take a couple minutes and help shape the future of Open Source events. 

 

As a closing, we are actively moving forward with Digital Events across the globe and have an unending Call for Presentations open for Webinars. If you have any feedback or brilliant ideas, please send them to us via organizers@postgresconf.org.

 

Blatant Poll Link 

Joshua D. Drake     July 17, 2020

 

At Postgres Conference we are always optimizing our People, Postgres, Data experience, and as more events move to Digital,  we have worked hard to perfect that collaborative experience for our community. The hard work of our volunteers has paid off, our content is top notch, and our participant account is consistently high.

 

With a now-proven track record, we are pleased to announce that we are accepting Community and Commercial presentations via the Postgres Webinar Series Call for Presentations through the end of 2020. If your presentation is accepted we will contact you directly to arrange an appropriate time to deliver your content.

Recent awesome news

KDE, arguably the most complete desktop experience for Linux, is now hosted on a private instance of Gitlab. As is proper, Gitlab only supports Postgres as the backend database.

For those who who love #FarmFresh or #farmtotable, there is a new website that showcases Farms that are delivering. It was developed using React, Rails, and Postgres. 

Upcoming Digital Events

  • July 7, 10am PT: Deep Dive into PostgreSQL Indexing

A Deep Dive into PostgreSQL Indexing

  • July 15, 10AM PT: Working with JSON Data in PostgreSQL vs. MongoDB

Working with JSON Data in PostgreSQL vs. MongoDB

Previous Digital Events:

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. 

Joshua D. Drake     May 28, 2020

The Chairs (myself, Jim Mlodgenski, and Amanda Nystrom) have recently decided to bring some visibility to charities that are close to our hearts. They are listed below:

  • Joshua Drake: Navajo Water Project. The Navajo nation is approximately the size of West Virginia and has a population of over 150,000 people (300k in the tribe). Anywhere from 15% - 40% of the residents do not have access to running water. The Navajo Water Project aims to bring clean water to each person and family through support from those that donate. 
  • Jim Mlodgenski: St. Jude Children’s Research Hospital. The hospital is one of the premier research hospitals for cancer and other life threatening illnesses for some of our most vulnerable people. Approximately one in 285 children in the U.S. will be diagnosed with cancer before their 20th birthday. Through donations, St. Jude’s provides treatment to those with cancer, and is actively dedicating resources to the research and cure for cancer. 
  • Amanda Nystrom: ASPCA. The American Society for the Prevention of Cruelty to Animals (ASPCS) was the first humane society to be established in North America, with the goal of providing kind and respectful treatment to animals under the law. Unlike humans, cases of animal abuse aren’t compiled but studies have shown a correlation between domestic violence and animal abuse. The ASPCA prevents animal homelessness and actively rescues animals from dangerous and/or cruel situations.

Upcoming Webinars

With the Coronavirus causing the conference market to dry up for 2020, we at Postgres Conference have pivoted to ensure that we continue to provide quality Postgres content to the world of People, Postgres, Data. We have been performing multiple webinars per month. Here is the current schedule and you can register (free) here:

 

  • May 21, 11am PT: A Deep Dive into PostgreSQL Indexing
  • June 2, 10AM PT: How to Move Data from Oracle to Postgres in Near-Real Time
  • June 9, 11am PT: Community vs. Enterprise Open Source – Which is Right for Your Business?
  • June 10, 11am PT: Bring Compression to Postgres at Zero Cost of Performance
  • June 16, 11AM PT: Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database
  • June 30, 11am PT: Deeper Understanding of PostgreSQL Execution Plan: At plan time and run time
  • July 15, 10AM PT: Working with JSON Data in PostgreSQL vs. MongoDB
  • June 17, 11am PT: Postgres vs. MongoDB for real-time machine learning on wind turbine data

Articles from the community

Coronavirus Resources:

Joshua D. Drake     May 19, 2020

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

What is the future of Postgres?

When you observe the ecosystem you can’t help but ask yourself where the community and software is going next. It is without question that the future of data will reside in something Postgres. It may be PostgreSQL, Cockroach, Yugabyte, Aurora, Azure, or workload specific Postgres such as Greenplum. Based on the sheer number of successful software adventures that are based on Postgres, there is no doubt in our minds that it is the future. 

This is why the inclusivity of People, Postgres, Data is vital to the continued success of the community. It is also why we invite all of Postgres to Come As You Are from March 23rd - 27th, 2020 at the Marriott Marquis in Manhattan! 

Isn’t Postgres, PostgreSQL?

Yes, and no. It is true that the term Postgres is sometimes used as a short version of PostgreSQL which allows easier pronunciation of the project and software name. It is also true that PostgreSQL contains a great deal of Postgres code but it is not technically Postgres. In fact, Postgres predates PostgreSQL by quite a few years and had an interim fork called Postgres95 before the PostgreSQL project was founded. That is why we use Postgres as an inclusive term for all software Postgres including many that some would consider forks. Fun fact:  Did you know that Informix is based on Illustra, a commercial Postgres fork from 1997?

Call for Papers

We are actively seeking people to deliver exceptional educational opportunities at Postgres Conference 2020. Postgres Conference is the perfect opportunity for students, hobbyists, and professionals to exhibit their knowledge in solving problems that are People, Postgres, or Data related. Submit your proposal today.

Instructor lead Digital Training

We have the following training opportunities in November and December:

  • November 12th: PostgreSQL Performance and Maintenance
  • November 14th: Finding and Fixing Slow Queries in PostgreSQL
  • November 21st: PostgreSQL and Kubernetes
  • December 10th: PostgreSQL Replication deployment and best practices
  • December 12th: PGPool-II: Performance and best practices

Register here.

Webinars

We have the following webinars in November:

  • Nov 13: Designing a Change Data Capture and Two Data Center Architecture for a Distributed SQL Database
  • Nov 14: Yugabyte DB 2.0 Jepsen Test Results and Distributed Transactions Algorithms in Google Spanner, YugabyteDB and CockroachDB
  • Nov 20: Zero Down-Time Oracle to Cloud-Native PostgreSQL Migrations

Find more information here.

Interesting projects

  • http://postgrest.org/en/v6.0/ PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
  • https://www.haproxy.org/ HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. It is particularly suited for very high traffic web sites and powers quite a number of the world's most visited ones. Over the years it has become the de-facto standard opensource load balancer, is now shipped with most mainstream Linux distributions, and is often deployed by default in cloud platforms. Related content.

 

Joshua D. Drake     November 07, 2019

Where is your path leading you?

 

At Postgres Conference Silicon Valley I promised during the launch that after the conference was completed PostgresWarrior and I would be taking a freedom tour to various National Parks. 

 

For us, our path is serving the community through education and professional and personal development. This happens in many forms including these newsletters.

 

Recent projects have been coordinating a successful webinar series from Yugabyte, creating  online live Postgres instructor lead training, and launching a new educational series on PostGIS. This is all happening while the Call for Papers for Postgres Conference 2020 now open! The ongoing goal is to allow any person to receive the education they need to be successful with People, Postgres, Data year around.

Training

The current training options from Postgres Conference can be found here:

https://postgresconf.org/conferences/Postgres-Digital-Training-Series/schedule/events

We have two performance trainings coming up in October:

  • PostgreSQL Performance & Maintenance on October 29th
  • Finding and Fixing Slow Queries on October 30th

 

Both of these training opportunities sell out at the physical conferences. They are solid content and at a reasonable price (149.00 USD ) it is hard to say no to a few hours for education in your day!

Software

Are you frustrated with the limitations and fragility of Logical Replication in PostgreSQL Core? There is a new software on the block called pgcat and it has an impressive list of features to allow your Logical Replication experience to be exceptional.

 

Looking for a simple script to help find tuning opportunities for PostgreSQL? The perl script postgresqltuner may just be what you are looking for. Yes, there really is an active developer community for the Perl language still.

 

A HyperLogLog data type for PostgreSQL from our friends at Citus. This Postgres module introduces a new data type hll which is a HyperLogLog data structure. HyperLogLog is a fixed-size, set-like structure used for distinct value counting with tunable precision. For example, in 1280 bytes hll can estimate the count of tens of billions of distinct values with only a few percent error.

 

Our partner Heimdall Data has been creating a new type of connection pool that removes a significant limitation within other software such as PgBouncer and PgPool. If you are looking for Enterprise Authentication (Active Directory/LDAP) as well as intelligent pooling for many users (and connections), it may be worth a look. There is a webinar next week on how it all works!

Does your path allow people to “Come as you are?”

In consideration of all of the great news from our community we can’t help but reflect on the blessings we have in the world of Open Source. Remember that Open Source is about exceptionalism, creativity, and most importantly freedom. When communities start restricting these three tenets of Open Source, they are no longer Open Source communities, even if their software is.

 

The theme for Postgres Conference 2020 in NYC is “come as you are” and we are asserting this mantra throughout our entire community. Over the past few years there has been an influx of toxicity throughout all circles and it is time for civility and grace to return. It is time to remember that we are all human. We all have angels and demons to our personalities. We are all flawed and we are all exceptional in our own way.

 

"But just because I don't agree with someone on everything doesn't mean that I'm not going to be friends with them. When I say, 'be kind to one another,' I don't only mean the people that think the same way that you do. I mean be kind to everyone."

 

-- Ellen DeGeneres

 

(Yes, this happened. No, it wasn’t planned.) 

Just outside of Moab Utah.

 

Find YOUR path.



Joshua D. Drake     October 17, 2019

Welcome to "Cultivating DEI" , a series in which Postgres community members share their insight and experience about creating a more diverse and inclusive Postgres environment where all are welcome.

Recently I've been thinking a lot about relationships between the PostgreSQL community and the Database research community. To put it bluntly – these two communities do not talk to each other!

There are many reasons why I am concerned about this situation. First, I consider myself belonging to both of these communities. Even if right now I am 90% in industry, I can't write off my academic past. Writing a scientific paper with the hope of being accepted to the real database conference is something which appeals to me.

Secondly, we want to have quality candidates for database positions. Anyone who has tried recently to fill these positions knows that this is not an easy task. If you are looking at recent college grads, there are almost no chances that you can find somebody who has PostgreSQL experience. Here is where we face the other side of the problem.

The problem is not simply that scientists do not speak at the PostgreSQL conferences, and that PostgreSQL developers do not speak at academic conferences. The larger issue is that for many Computer Sciences (CS) students, their academic research and practical experience do not intersect. They learn about some incredible algorithms, and as part of their coursework they may suggest some enhancements to existing algorithms. They then practice their SQL skills with MySQL, which from my observations lacks so many basic features, that it can hardly be taken seriously as a data platform.

If students practiced using PostgreSQL, they would have a full-scale enterprise ready object-relational database -- not a "light" version, but a robust platform, which supports a multitude of index and data types, constraints, procedural languages and much more.

I've heard from several professors that "MySQL is okay for "learning SQL." I want to ask -- what does "learning SQL" mean? Is it just learning how to write a syntactically correct SQL? One contributing factor to the problem is that MySQL comes on each laptop by default, integrated with basic tools that allow building websites. It is integrated with Wordpress. There is no reason for PostgreSQL not to have similar support, but it is not in place.

This is particularly frustrating when you recognize the amount of database research was completed using Postgres, for Postgres or with help of Postgres; R-Tree and GIST indexes, for example. Also, the SIGMOD Test of Time Award in 2018 went to the paper "Serializable isolation for snapshot databases," which was implemented in PostgreSQL.

I know the answer to the question "why do they not talk?" Researchers do not want to talk at the PostgreSQL conferences, because those are not scientific conferences, and participation in these conferences will not result in a publication. Postgres developers do not present at the CS conferences, because they do not want to write long papers. Even if they do submit something, their papers are often rejected as "not having any scientific value." I have experienced this on multiple occasions.

I came across another example of "why” when I attended the ACM/SIGMOD conference in Amsterdam. I attended a compelling presentation on the problem of cardinality estimation over multi-join queries, that introduced new optimization techniques. The presenter mentioned that he had used Postgres to build the prototype. I was too far back in the room to ask my question, so I reached out via the conference website.

I asked the presenter why he didn't submit a patch. He replied that their approach was hacky, and it needs more work to think about adding it to Postgres. I've asked whether he would be interested in working on it with some PostgreSQL community members. His reply? "Not in the next two years, I've just received a post-doc position at Microsoft, so I can't do it for the next two years."

So yes -- I know the answer as to why these two communities historically do not communicate. However, I do not like or accept it. Perhaps we can talk about and resolve this problem together?!

Contributor Bio:

Henrietta 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. She taught Database and Transaction theory at the University of Saint – Petersburg (Russia), as well as multiple database tuning classes for both beginners and advanced professionals.

Her professional experience includes consulting for a number of government projects in Chicago and New York, and providing Data services in the financial sector, manufacturing, and distribution. She is a co-author, with B. Novikov, of the book “System Tuning”, BHV, S.-Petersburg, Russia. Her researches in overcoming object-relational impedance mismatch were publish in the Proceedings of EDBT 2014 Athens and ICDE 2016 in Helsinki. At Braviant Holdings she is happy to have an opportunity to implement the results of her research in practice.

Henrietta Dombrovskaya is a co-organizer of the Chicago PostgreSQL User Group and a member of the Diversity, Equity, and Inclusion Work Group for the Postgres Conference Series. She was recently awarded the 2019 "Technologist of the Year" award by the Illinois Technology Association. This award is  "presented to the individual whose talent has championed true innovation, either through new applications of existing technology or the development of technology to achieve a truly unique product or service."

Come as you are

The theme of Postgres Conference for 2020 is: Come as you are. We want everyone to feel welcome. You are welcome for your love of People, Postgres, Data and a desire to ascend beyond the box. It isn’t about your race, gender, sexuality, political affiliation, or love of blueberry flavored popcorn. It is 100% about you, the creativity and excellence that only you can bring to our community.

Postgres Conference 2020 CFP now open

We are actively seeking content for the largest Postgres Conference in the world, set to be held from March 23rd to 27th, 2020  at the Marriott Marquis, Time Square! Please submit your content here.

Postgres Conference Silicon Valley 2019

Postgres Conference Silicon Valley doubled its attendance, making it the largest Postgres  Conference on the West coast ever! We are very pleased to be able to bring so many community members together for education, fun, and ecosystem support!

 

Training

  • Postgres Conference is now offering live digital training throughout the year. Continuing on our mission of creating exceptional Postgres people, you can now not only register for pre-defined training but request specific training and we will connect you with a class! The current training options are:
    • PostgreSQL Performance and Maintenance
    • Finding and Fixing slow queries
    • Postgres + Kubernetes: yes it really is a match made in heaven
    • PostgreSQL Replication deployment and best practices
    • PgPool-II Performance and best practices

 

Register here: https://postgresconf.org/conferences/Postgres-Digital-Training-Series

 

Digital Events

We have free digital events coming up including topics such as Kubernetes, DistributedSQL, Backups, Postgis and many more. Coming up: 

Joshua D. Drake     October 02, 2019

Latest Posts