Joshua D. Drake Blog Posts

It is with great pleasure that we announce the preliminary program for PGConf Local: Austin!


We have received a plethora of positive feedback from the local Postgres and Data communities and we are proud to host a second PGConf event held in Austin in 2017.

Training Opportunity:
Breakout Sessions:
  • Event Sourcing with a Postgres Event Store by Scott Bellware
  • Using GIS in PostgreSQL by Lloyd Albin
  • Trees/Hierarchical Data in the SQL Database by Ryan Murphy
  • Amazon Aurora with PostgreSQL compatibility by James Finnerty
  • Deep Dive into the RDS PostgreSQL Universe by Grant McAlister
  • Open Source Communities as Biological Ecosystems by Debra Cerda
  • The Power of Postgres Replication by Joshua D. Drake
  • Multi-cloud deployment of PostgreSQL in minutes. by Stephen Holt

PGConf Local: Austin is made possible by the wonderful team of volunteers including the Austin PostgreSQL User Group and our sponsors:



Diamond2

Platinum: Compose.IO, OpenSCG, 2ndQuadrant, and Microsoft
Joshua D. Drake     November 09, 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 are pleased to announce that PostgresConf 2019 will be held at the Sheraton Times Square March 18th - 22nd, 2019. 


Following on the success of PostgresConf 2018, 2019 will include five days with added training and partner summits.



March 18th and 19th will have immersive training. Instructors are encouraged to submit half and full day material for consideration. The preferred topics are centered around Postgres but anything People, Postgres, or Data related will be considered.

Monday, March 18th through Friday, March 22nd will host several partner summits, including popular and upcoming topics within the Postgres community and the annually hosted Regulated Industry Summit. Break out sessions will be held from Wednesday - Friday.

Important Dates:
  • Call for Papers Open: 09/12/2018 
  • Call for Papers Close: 01/11/2019 
  • Confirmation/Acceptance: 01/18/2019
Can't wait until March? Join us at our West Coast event, PostgresConf Silicon Valley, October 15th and 16th, 2018 at the Hilton San Jose.

About PostgresConf:

PostgresConf is a global nonprofit conference series with a focus on growing community through increased awareness and education of Postgres and related technologies. PostgresConf is known for its highly attended national conference with the mission of:


Joshua D. Drake     September 25, 2018


On August 15th, Silicon Valley Postgres held their first Postgresql.org Patch Review workshop. The workshop was hosted by PostgresConf partner Pivotal. Attendees’ feedback indicate that we have found a great way to show how companies within the community can benefit Postgresql.org, Postgres User groups, and help us fulfill our mission:


There were 20 attendees, including Melanie Plageman of Pivotal presenting/coordinating “Postgres Patch Review,” and Postgresql.org -Hacker Jeff Davis as hands on help. This was the first workshop of its kind for Silicon Valley Postgres and with the feedback received, we are planning to plan similar events at least twice a year to provide an opportunity that is currently not available elsewhere. (Sneak peek: there may be one at PostgresConf Silicon Valley on October 15th and 16th, which is right around the corner!)

Eight patches were reviewed, with three including specific feedback to the patch authors:
We’re excited to be a part of this path of Postgres contributor building. Hopefully it will be a model for other meetups and community partners to follow in continuing to contribute to the Most Advanced Open Source Database ecosystem.

Silicon Valley Postgres is the fastest growing Postgres user group within North America. It was initiated just 12 months ago and will reach 700 members likely before Monday. The group exists to help all facets of Postgres users and the Postgres ecosystem, including, but not limited to, PostgreSQL, Greenplum, Aurora Postgres, AgensGraph, Yugabyte, ZomboDB, TimescaleDB.


Silicon Valley Postgres is also working with PostgresConf Silicon Valley to bring a high quality and cost effective education solution to the users of Postgres within the Silicon Valley. Early Bird tickets are now on sale and available. You will want to hurry as the Early Bird price ends on September 1st, 2018.
Joshua D. Drake     August 16, 2018

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

 

Image result for seattle hd wallpaper


It is with great pleasure that we announce the final program for PGConf Local: Seattle. The schedule is still being hammered out but we have finalized the content that will be presented. Please join us in celebrating Postgres in Seattle!

 
The conference is the first Postgres event to be held in Seattle since 2009 and we have received a lot of positive feedback from the local Postgres and Data communities. Clearly Postgres has been missed in the Emerald City!
 
Training Options:
Breakout Sessions:

Track: Ops

  • Develop intelligent apps on the Azure platform using the Azure Database for PostgreSQL by Sunil Kamath
  • Tuning PostgreSQL for High Write Workloads by Grant McAlister
  • POSTGRESQL V10: AN AMPLIFIED VERSION OF POSTGRES by Joshua D. Drake
  • Enterprise Data Architecture with PostgreSQL by Kevin Kempter
  • All the dirt on Vacuum by Jim Nasby
  • Building a scalable time-series database on PostgreSQL by Matvey Arye

Track: Dev

  • Semantic Search Web System on PostgreSQL by QUAN-HA LE
  • Increase Application Performance with SQL Auto-Caching; No Code Changes by Roland Lee
  • Introduction to JavaScript Stored Procedures by Jim Mlodgenski
  • Under the hood: API integrations and more in an energy efficiency PostgreSQL + Django application by Jennifer Scheuerell
  • Using GIS in PostgreSQL by Lloyd Albin

Tracks: Big Data, Data Science and AWS/Cloud

  • With Great Power Comes Great Responsibility by Michael Sacks
  • Data Quality Expert Is Not Harvard's Sexiest Job...But... by Ben Rogojan
  • GRAKN.AI: the hyper-relational database for knowledge-oriented systems by Haikal Pribadi
  • Best Practices with Managed PostgreSQL in the Cloud by Jignesh Shah
PGConf Local: Seattle is made possible by the wonderful team of volunteers including the Seattle Postgres User Group and our sponsors:
 
 
Diamond2
 
Platinum: Compose.IO, OpenSCG, 2ndQuadrant, and Microsoft
Joshua D. Drake     October 19, 2017

Silicon Valley Postgres and PostgresConf Silicon Valley are happy to announce that early bird tickets are now available! You can purchase them here. You will want to hurry as early bird discounted tickets are only available until September 1st, 2018.

PostgresConf Silicon Valley takes place on October 15th and 16th, 2018 at the Hilton San Jose. The schedule is not finalized. However, we have a comprehensive list of content from technical leaders in the Postgres ecosystem we are reviewing. Here is a brief list of some (but not all!) of the topics to be presented:

  • Postgres 11
  • Data integrity at scale
  • Distributed data and GPDR
  • Massively Parallel Postgres for Analytics
  • Data intersection between roles
  • RDS tips and tricks
  • I didn’t know Postgres could do that!
  • Performant time-series data management analytics
The Silicon Valley schedule is expected to be published this week and we are looking forward to seeing you all in October!

PostgresConf is organized by an all volunteer team of fantastic individuals and is backed by a 501c3 non-profit. The Silicon Valley conference provides the most cost effective avenue to learn all about Postgres and the Postgres ecosystem. We invite everyone to enjoy our expertly delivered presentations, good food, the hallway track and the opportunity to learn, network and appreciate everything that is Postgres.

Joshua D. Drake     August 21, 2018

PostgresConf, in partnership with Silicon Valley Postgres, is pleased to announce that the call for papers for PostgresConf Silicon Valley is open.


The inaugural PostgresConf Silicon Valley will be held October 15th - 16th, 2018 at the Hilton San Jose (300 Almaden Boulevard, San Jose, CA 95110).


This two day, three track conference is a perfect opportunity for users, developers, business analysts, and enthusiasts from Silicon Valley and San Francisco to amplify Postgres and participate in the Postgres community.

The Call for Papers for PostgresConf Silicon Valley can be found here

Call for papers will be open from
May 23rd until August 15th. Speakers will be notified of acceptance/decline no later than August 20th.


Conference Schedule at a glance:
  • Monday, October 15th: Trainings and Data track
  • Tuesday, October 16th: Keynotes, Dev and Ops tracks

Partner Opportunities
PostgresConf Silicon Valley is supported by its generous sponsors:

  • Conference Sponsors: Amazon Web Services and Pivotal
  • Premiere Sponsors: Compose, 2ndQuadrant, Timescale, and Microsoft 

Please contact us if you are interested in becoming a partner!


About PostgresConf:
PostgresConf is a global nonprofit conference series with a focus on growing community through increased awareness and education of Postgres and related technologies. PostgresConf is known for its highly attended national conference held in Jersey City, New Jersey with the mission of:



Contact: siliconvalley@postgresconf.org

Joshua D. Drake     May 29, 2018

You will want to mark your calendars folks on August 15th the Call for papers for PostgresConf Silicon Valley will close. That is just two weeks away!

So let's point your Firefox, Google Chrome, or Safari app to this link right here and get your presentation submitted.

This is the inaugural Silicon Valley conference and from the current submitted papers it is shaping up to be a fantastic event. We can't wait to see everyone and continue our mission of:




Joshua D. Drake     July 31, 2018

Join the fantastic and growing Postgres community in Cape Town, South Africa for a single day event on October 3rd, 2017! The event is being hosted by fellow Postgres advocates who travel from South Africa each year to attend our National Event in order to increase their knowledge of Postgres and be a part of the community. This year they are joining us and making a commitment to build out our International community and conferences!

This single day event takes place at the same venue as PyCon South Africa and is scheduled the day before PyCon to ensure the greatest possible value in attending.

Image result for PGConf US

Local events are designed to bring comprehensive educational content and networking opportunities to the "local" Postgres community where the event is being held. They are perfect opportunities to show support for Postgres, find leads, and build relationships with other professionals and companies using and supporting Postgres.

Joshua D. Drake     August 15, 2017