ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

On this day, 25 years ago, 6.5 was released.

Notable features include MVCC, Numeric data type, and consistent snapshots with pg_dump. Oh, and Windows NT support.

This version is EOL for 20 years now - if you are still running it: good luck!

https://www.postgresql.org/docs/6.5/release14025.htm

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
paulox, to django
@paulox@fosstodon.org avatar

Raphael Michel is presenting the talk "Fast on my machine: How to debug slow requests in production" at DjangoCon Europe 2024 🦄

CC @djangoconeurope @django @rami

Raphael presenting his talk
Portrait of Raphael
Slide with explain analyze command

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

Event Calendar, Reminder:

🌐 POSETTE 2024

Date: 2024-06-11 - 2024-06-13

ICS file: https://ics.postgresql.life/cpi34p1k74p3eb9gc5j62b9k75ij2b9p6crjab9h74sjgd1j6lhm4e9ick.ics

paulox, to django
@paulox@fosstodon.org avatar

Karen Jex is presenting the talk "When I Grow up I Want to be a Database Administrator (said no one ever)" to kick off the 3rd day of DjangoCon Europe 2024 🦄

CC @djangoconeurope @django @karenhjex

Audience of Karen talk
Karen showing a picture of mine
Portrait of Karen

kubikpixel, to webdev German
@kubikpixel@chaos.social avatar

I've only just discovered @graphile and will have to take a look at it. Do any of you WebDev's dev with PostgreSQL and GraphQL and know about it and what do you think?

📺 https://invidious.jing.rocks/watch?v=x0FMjL5-kNI
🔮 https://www.graphile.org


hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

Deciphering Encryption: A Beginner's Guide - Highgo Software Inc. https://www.highgo.ca/2024/02/13/deciphering-postgresql-encryption-a-beginners-guide/

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

(plausible) random geography generation with postgis: fluviation #gis #postgresql https://di.nmfay.com/random-geography-fluviation

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

New entry in #PostgreSQL Event Calendar:

👫 PGDay UK 2024

Date: 2024-09-11
Location: London, UK

ICS file: https://ics.postgresql.life/6th3id9i74o3cbb26hhj8b9kc4sjebb1c9j36b9i6kpj2e366pgjieb670.ics

ewen, to PostgreSQL French
@ewen@mastodon.fedi.bzh avatar
hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

Recommended resources to improve your knowledge of Databases and | Select * from Adrien https://blog.anayrat.info/en/2024/02/12/recommended-resources-to-improve-your-knowledge-of-databases-and-postgresql/

cooptilleuls, to PostgreSQL French
@cooptilleuls@mastodon.online avatar

Nous sommes ravi·es d’accueillir le meetup @postgresqlfr Lille dans nos bureaux, à quelques jours du ! Notre coopérateur @dunglas présente comment @ApiPlatform et @symfony tirent partie de 🐘

Kevin Dunglas présentant une conférence au meetup PostgreSQL Lille

pgconfnyc, to PostgreSQL
@pgconfnyc@fosstodon.org avatar

Today is the last day to submit your talk for PGConf NYC 2024! You have until midnight, so go, go, go!

https://2024.pgconf.nyc/callforpapers/

@PostgreSQL #PostgreSQL #postgres #pgconfnyc

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

Enhance #PostgreSQL TLS Security with OCSP Stapling - Highgo Software Inc. https://www.highgo.ca/2024/02/09/enhance-postgresql-tls-security-with-ocsp-stapling/

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

Event Calendar, Reminder:

👫 P2D2 2024

Date: 2024-06-04 - 2024-06-05
Location: Prague, Czechia

ICS file: https://ics.postgresql.life/27pes102ld5ik848uuj3dtsje4.ics

clairegiordano, to PostgreSQL
@clairegiordano@hachyderm.io avatar

If you are looking for a guide to help you choose which virtual #PostgreSQL talks to attend during the 4 @posetteconf #PosetteConf livestreams Jun 11-13, you're in luck! 🐔🐣

This is your ultimate guide 🧭 so you can plan & mark your calendar for POSETTE (& ideally join us for the virtual hallway track on Discord during some of the livestreams)

Boosts appreciated, word of mouth is gold 🚀

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/ultimate-guide-to-posette-an-event-for-postgres-2024-edition/ba-p/4160130

#Postgres #community #opensource #Azure #Microsoft

anze3db, to PostgreSQL
@anze3db@fosstodon.org avatar

Mystery solved! The problem was that requests were creating new db connections which is super expensive.

Adding POOL to the database OPTIONS (added in Django 5.1a1) solves this problem and brings throughput on par with SQLite 🎉

https://docs.djangoproject.com/en/dev/releases/5.1/#postgresql-connection-pools
https://fosstodon.org/@anze3db/112557766800166792

helge, to PostgreSQL
@helge@mastodon.social avatar

Did I mention that it would be really nice to have as an embeddable library similar to ? Size wise that should be fine, I think the whole PG daemon is just ~5MB.
I know that the architecture doesn't lean to it, but someone has to do this eventually! 🙂

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

Call for Papers for the PostgreSQL Conference Europe 2024 in Athens is open. You have about 4 weeks to submit your cool talks!

And please limit the number of submissions to a reasonable number ...

https://www.postgresql.eu/events/pgconfeu2024/news/call-for-papers-for-postgresql-conference-europe-2024-is-now-open-131/

oskardudycz, to programming
@oskardudycz@hachyderm.io avatar

Are you building applications in ? Are you tired of maintaining your homebrew solutions? I'm planning to add storage to (plus other features like telemetry etc.). Getting sponsorship would help me to prioritise that effort. As I built a few cases like that I think that it should be cheaper in the longer term to outsource that to me, rather than maintain it on your own 🙂

1/

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar
ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

#PostgreSQL Event Calendar, Reminder:

👫 PG Development Conference 2024

Date: 2024-05-28 - 2024-05-31
Location: Vancouver, BC, Canada

ICS file: https://ics.postgresql.life/7c61p323nvvu9ul2r4v07rmp71.ics

ascherbaum, to PostgreSQL
@ascherbaum@mastodon.social avatar

TIL (ok, last week): #PostgreSQL has 375+ extensions

According to Abigale Kim at #PGConfdev

hunleyd, to PostgreSQL
@hunleyd@fosstodon.org avatar

Waiting for 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR – select * from depesz; https://www.depesz.com/2024/02/07/waiting-for-postgresql-17-add-new-copy-option-save_error_to-rename-copy-option-from-save_error_to-to-on_error/

  • All
  • Subscribed
  • Moderated
  • Favorites
  • JUstTest
  • mdbf
  • everett
  • osvaldo12
  • magazineikmin
  • thenastyranch
  • rosin
  • normalnudes
  • Youngstown
  • Durango
  • slotface
  • ngwrru68w68
  • kavyap
  • DreamBathrooms
  • tester
  • InstantRegret
  • ethstaker
  • GTA5RPClips
  • tacticalgear
  • Leos
  • anitta
  • modclub
  • khanakhh
  • cubers
  • cisconetworking
  • provamag3
  • megavids
  • lostlight
  • All magazines