Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRj2t-002kFT-Vn for pdxpug@arkaria.postgresql.org; Fri, 04 Aug 2023 00:52:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qRj2s-001aul-Fx for pdxpug@arkaria.postgresql.org; Fri, 04 Aug 2023 00:51:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRj2s-001anm-A2 for pdxpug@lists.postgresql.org; Fri, 04 Aug 2023 00:51:58 +0000 Received: from mail-pf1-x434.google.com ([2607:f8b0:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qRj2p-000PTE-KB for pdxpug@lists.postgresql.org; Fri, 04 Aug 2023 00:51:56 +0000 Received: by mail-pf1-x434.google.com with SMTP id d2e1a72fcca58-686f0d66652so1381264b3a.2 for ; Thu, 03 Aug 2023 17:51:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1691110314; x=1691715114; h=content-transfer-encoding:content-disposition:mime-version :message-id:subject:to:from:date:from:to:cc:subject:date:message-id :reply-to; bh=hyuQ/wz1sH8+t1qTXD9avu6blaopsmSFTjBx2jninEw=; b=ol9w+K8wf0DabE5WNCLDYIOwA7KG+dg7bC91IVQgAWHCkRRgNbun/OmBWAYCDO050k EOk1GfK5eYiSaKSih8TkK45RBezwQtsgVHFKSVNGuTDetNteA84aMj1gLNALo5La3som 81+HRPf0jiGS9jymKFgtTV729gjLnEUJe/6AT2iGeGo4SY71/VvNUwWWPgg6UNs52LMS 4PDac6NBgQRrKjFAuCKh0tuwZqKouG4JNz5NnQGVRe7hkaNQL27+349PsC/xKXiGDsWo MlgigziUY5PaLGG4CilqWyLeINFbtEAd5ei2CePtKyTr4fF5z6boExnOJh4zKOMz02kb xZUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1691110314; x=1691715114; h=content-transfer-encoding:content-disposition:mime-version :message-id:subject:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=hyuQ/wz1sH8+t1qTXD9avu6blaopsmSFTjBx2jninEw=; b=czHvjGu+DABJhknetzC+Pqi9bHr2O4LPfsqKCwKCqqMsb/PvN2wIvUiYIJXZCNdIwh hIIvxDBxEFpu8e1CUUMH6pJrYBo9Kf4mKYHtUA66fbaxYGajgLSy8odU+yluBxZeaN5K r3y9pmnlCNqV7s4CBIxNKyhIhzl4DyOgLGdEHrzREtN8b+B1EdcucwEZCwPlVLUlC7TX qVgsagO3xL6bIEWvcAOzrXF+eDybbssMg3SZs1VN/wYprS3bCZS9Z/bXjvCXaznCEiIV X/5wVZ/J5Pm48woeVwBePjMotU41uaP2z3iDNbFMpouO/0ED+athikuQHSqo56+tGCby 42HQ== X-Gm-Message-State: AOJu0Yy8ONakvwpb8t6U+XW1LWfflQACw+aExDjhnDGF4XCe2iImhu70 1YDS5aXgiA+rtOTs21NPwoQ+14fwl4H7gw== X-Google-Smtp-Source: AGHT+IEjzn6E+iyivQwmtHl7Fw+ChZPsbXMve8wMvAQyPLV7Jh4zUVOjF/LZWqlQjgFURUfG9NUW1g== X-Received: by 2002:a05:6a20:160d:b0:12e:4d86:c017 with SMTP id l13-20020a056a20160d00b0012e4d86c017mr268152pzj.10.1691110313773; Thu, 03 Aug 2023 17:51:53 -0700 (PDT) Received: from moubin (71-36-126-244.ptld.qwest.net. [71.36.126.244]) by smtp.gmail.com with ESMTPSA id j26-20020aa783da000000b0067a1f4f4f7dsm405212pfn.169.2023.08.03.17.51.52 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 03 Aug 2023 17:51:53 -0700 (PDT) Date: Thu, 3 Aug 2023 17:51:51 -0700 From: Mark Wong To: pdxpug@lists.postgresql.org Subject: Thursday Aug 17, 2023, Meetup: Developing Your Own Database Extensions Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 2023 Aug 17 Thursday Meeting 6:30pm-8:30pm Location: TBD Speaker: Jerry Sievert Extensions are part of what makes Postgres such a powerful and popular database. Being able to add new capabilities to your database allows developers to adapt Postgres to many different use cases from geospatial (PostGIS), to multi-server sharding (Citus), to custom datatypes (pg_semver), to foreign data wrappers (postgres_fdw), and others. Jerry is going to walk us through getting started working on database extensions. We will cover how extensions work and getting started authoring your very own first database extension! Time permitting, and with interest, we will cover operators and types. This talk is intended for all developers and DBA’s alike, so bring your questions. If you have a favorite extension, we want to know, so bring it to the discussion. I’ll go first: favorite extension: most flavors of FDW’s for sure. Now a bit about Jerry. He’s currently working at Hydra (https://hydra.so/) on data warehousing with Postgres, but has been using Postgres for waaaay too long. If you’ve ever used PLJS (https://github.com/plv8/pljs), he’s the author, and he is the maintainer of PLV8 (https://plv8.github.io/). Please sign up on MeetUp to help us estimate head count: https://www.meetup.com/pdxpug/events/295229582/