Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzPm5-00010J-No for pdxpug@arkaria.postgresql.org; Wed, 17 May 2023 22:37:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pzPm4-0005QL-Mt for pdxpug@arkaria.postgresql.org; Wed, 17 May 2023 22:37:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pzPm4-0005Py-Gy for pdxpug@lists.postgresql.org; Wed, 17 May 2023 22:37:36 +0000 Received: from mail-pg1-x529.google.com ([2607:f8b0:4864:20::529]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pzPm0-000QOT-Tx for pdxpug@lists.postgresql.org; Wed, 17 May 2023 22:37:35 +0000 Received: by mail-pg1-x529.google.com with SMTP id 41be03b00d2f7-5289cf35eeaso418668a12.1 for ; Wed, 17 May 2023 15:37:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1684363051; x=1686955051; h=content-disposition:mime-version:message-id:subject:to:from:date :from:to:cc:subject:date:message-id:reply-to; bh=N3HefokDNoQHMlukRcFjfJQ5JH99gIzCSbOZqZhnkvU=; b=qF0q2ElTKvjnR+WTymNx+iZxxFsO44YW/WmETw6AfPhI7ixptmKv8raJgEYeXlLneR ZxOUs3cPq4xLXrVXRNvvWB5lSL12tlsZs74apKBC3PWqSTiOiQzeUz9Ln/E8R8dRi/xd hLuM4e8VEFmZQBexWGgOZgfpRsDBvw/GK5zMC8UERO/onInUiUwxSEZI8qrIAZgzbLLO W1Q2mv2oOc4e0sUlXKPTtWvQYgCqBu7lrl6FiyZ0CAHjh8TRkitFEHglHkfjGdDejpZU O5JunZ4dXf7d43nDT92oZXkK8i/LZBnk+8lKiBYVPXboVR13IAv+JaglR0L9Fta/hlHv 1Gjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1684363051; x=1686955051; h=content-disposition:mime-version:message-id:subject:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=N3HefokDNoQHMlukRcFjfJQ5JH99gIzCSbOZqZhnkvU=; b=csojOWD+oMLXMF1zxWDBnw8/sJ9XrZP8/N+BuZq2nASRW78bAS5vsHRCVDhaZN+LZ3 9s62kCua+0+PAjnRVYXq3zkdmeC9S1A757OlA6OWygKkK3eFmQtaVQg/dcMVqn3vn2F7 LJGOujcGWJvJHukfE1wH25HJ5IloHUfr/lJ5wO85FdcLOX0k2F40z+2+TsJkR59FuhJc 2EsxvE2X8Ulq/vlVh7K+ewJnOj5F4/rvH5KdND5ZE8ZO+Knl/PX5g9glJ0VzL3sk6qal Gz7ONmDnhDUNXwGK4BOHOYEHNFTr9GlOqgNRAx0iQLEGXzwXP68PdASJwDEkud8IPAtK Cp3w== X-Gm-Message-State: AC+VfDwtU2KVEppP4dzmMVgsaoYmHLo63edy94p4ULYL5KFXbTaB5VBJ +MwYnzqz0gyFAmfZsrw9QY47zurFEiA= X-Google-Smtp-Source: ACHHUZ7PbU2uLB9/IV0twf7WhPaCV7zkpnZ8dcINbW9mpxV+U0XDdO2ODCqeBrb4zCJpXNSV3+F1kg== X-Received: by 2002:a17:90a:ce8a:b0:253:25c3:7a95 with SMTP id g10-20020a17090ace8a00b0025325c37a95mr290647pju.14.1684363051048; Wed, 17 May 2023 15:37:31 -0700 (PDT) Received: from moubin (71-36-119-67.ptld.qwest.net. [71.36.119.67]) by smtp.gmail.com with ESMTPSA id s10-20020a17090a880a00b0024e2980574asm2158143pjn.4.2023.05.17.15.37.30 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 17 May 2023 15:37:30 -0700 (PDT) Date: Wed, 17 May 2023 15:37:29 -0700 From: Mark Wong To: pdxpug@lists.postgresql.org Subject: Thursday June 15, 2023, Meetup: SQL Antipatterns Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 2023 June 15 Thursday Meeting 6:30pm-8:30pm Location: PDX Code Guild 407 NE 12th Avenue, Portland, OR 97232 The parking lot is behind the building on Flanders. Few abstractions and tools have proved as enduring in the field of Computer Science as the relational database model. Due to the diligent efforts of the Postgres team, the Postgres project has an ever increasing popularity in the software world and a fully modernized feature set. One effect of the longevity of the project has been to create a deep pool of received wisdom regarding the use and misuse of Data Models and SQL. Revisit some of the wisdom from a classic of the genre: SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin, with updated opinions and commentary to modernize the material. Stay after for pizza and a rousing exchange of ideas on the past, present, and future of SQL and of the Postgres project. Speaker: Joseph Hammerman Joseph Hammerman is a Linux Systems Administrator and Database Reliability Engineer with 18 years of experience. For the last 10 years that work has focused on Postgresql database reliability and High Availability engineering practices. Some career highlights include: serving on the iHeartRadio launch team, working at SecondMarket prior to and during their acquisition by NASDAQ Private Markets, and founding and serving on the Squarespace Database Reliability Engineering team. He is currently employed as Technical Lead for the DataDog Postgresql database reliability engineering team. He is a passionate advocate of Free and Open Source software and the ideals that it embodies. Please sign up on MeetUp to help us estimate head count: https://www.meetup.com/pdxpug/events/293599321/ -- Mark Wong EDB https://enterprisedb.com