Chicago PUG Blog

Things are opening up in the world of PostgreSQL. There are four upcoming events of which you should be aware. Henrietta Dombrovskaya is a world renowned PostgreSQL expert, published author, and the lead organizer of the Chicago PostgreSQL User Group .  If you are a Chicago PUG member, you have probably received promotional emails from her. She is presenting two webinars courtesy of the Postgres Conference Webinar Series . Long Queries and the Art of Full Scan is scheduled for September 22 at Noon CDT . Register for free at the link below. https://postgresconf.org/conferences/2021_Postgres_Conference_Webinars/program/proposals/long-queries-and-the-art-of-full-scan Functions: Use and Misuse is scheduled for October 26 at Noon CDT . Register for free at the link below. https://postgresconf.org/conferences/2021_Postgres_Conference_Webinars/program/proposals/functions-use-and-misuse PGConf NYC 2021 is an in-person conference with multiple parallel tracks and speakers cove...

Are you familiar with how publicly funded TV and radio stations have pledge drives to attract and retain new members and to raise revenue? The Chicago PostgreSQL User Group will have its own version of a pledge drive. All we ask is your participation. We need your help and input to improve Chicago PUG . There are big changes in store and if you want to be part of the decision-making process, you must participate. The Chicago PUG Participation Drive will consist of performing a series of simple tasks. A few moments of your time is all that is required. TASK 1: Sign up and register to the Chicago PostgreSQL Meetup Group website Create a free account on meetup.com Join the Chicago PostgreSQL Meetup Group Now find the next meeting, sign up, and attend. TASK 2: Subscribe to Chicago PUG Blog The email subscription form is located at the top and bottom of this post. Just type in your name and email address in the respective fields, then click on the blue Subscribe button. If there a...

The purpose of this post is to define exactly what PostgreSQL is and to set up future articles that will go into further detail. Is it PostgreSQL or Postgres? PostgreSQL is officially written as “PostgreSQL”. The standard pronunciation is "post-GRES-cue-ell" . Some choose to pronounce this as “postgres sequel”. Also, sometimes “Postgres” is used interchangeably with “PostgreSQL”. Confused? Let's delve into the history to clarify things. History of PostgreSQL The name “PostgreSQL” is derived from Ingres, a relational database developed by Michael Stonebraker. In 1986, Stonebraker initiated an upgrade to Ingres called POSTGRES (Post + Ingres) that added new features including object programming. In 1994, POSTGRES become an open-source project with an MIT license. In 1995, Andrew Yu and Jolly Chen replaced the POSTGRES internal query language named  QUEL with the nascent SQL language. After a brief name change to Postgre95, the project was rebranded as Postgre...

Welcome to the Chicago PostgreSQL User Group (PUG) , a group dedicated to the utilization and promotion of the open-source database PostgreSQL . Chicago PUG is one of several worldwide regional user groups that host regular meetings [formerly in-person and currently virtual] with speakers presenting on topics related to PostgreSQL. These sessions are free and open to all. This is the first inaugural post of the official Chicago PUG blog. The purpose of PUG in general and this blog in particular is to educate participants about the various uses of PostgreSQL as a relational database. The blog will supplement and enhance the meetup site and webinars. Content of future blogs will consist of the following: Schedule of upcoming meetings with speaker bios and topic descriptions Announcements and event details Subject matter discussions and tutorials UPCOMING EVENTS Valentin Kulichenko from GridGain Systems will present a talk entitled  "Distributed Java Databases Under the Hood: ...