PostgreSQL Person of the Week interview with: Samed YILDIRIM

https://postgresql.life/post/samed_yildirim/

#PostgreSQL #Interview

PostgreSQL Person of the Week interview with: Samed YILDIRIM

https://postgresql.life/post/samed_yildirim/

#PostgreSQL #Interview

We've posted a video of Thomas Munro's talk Investigating Multithreaded PostgreSQL https://youtu.be/7BvLaRkaijc
#postgresql #PGConfdev

We've posted a video of Thomas Munro's talk Investigating Multithreaded PostgreSQL https://youtu.be/7BvLaRkaijc
#postgresql #PGConfdev

We've posted a video of Jonathan Katz's talk Vector search is now boring, but PostgreSQL has ways to go https://youtu.be/frG8L7GDcLc #postgresql #PGConfdev

Message de service : notre instance #mobilizon est en maintenance depuis 3 jours.

Contexte : suite à la dernière mise à jour mineure, on a découvert que la version minimum de #PostgreSQL est passée de 11 à 13. On doit donc mettre à jour notre cluster PGSQL pour régler le problème.

Django 5.2에서 PostgreSQL 선언적 파티셔닝 구현하기

목표와 접근 방법

최근 프로젝트에서는 대용량 데이터를 처리해야 해서 테이블 파티셔닝을 사용해볼 법한 상황이었다. 내 목표는 Django의 고수준 ORM API를 최대한 활용하면서도 관리 포인트를 줄이고, PostgreSQL의 내장 선언적 파티셔닝 기능을 효과적으로 사용하는 것이었다. PostgreSQL의 공식 Table Partitioning 문서를 참조하여 구현을 진행했다.

초기 문제점과 해결 시도

Django에서는 PostgreSQL의 선언적 파티셔닝과 관련된 바인드된 API가 제공되지 않는다. 이로 인해 처음에는 RunSQL을 사용하여 raw SQL로 파티셔닝을 구현하고 마이그레이션을 관리하는 방법을 시도했다.

Django ORM에서는 모델의 Meta 클래스에서 managed=False 옵션(Options.managed)을 사용하여 고수준 API에서 마이그레이션을 관리하지 않는 테이블을 ORM 모델 클래스를 통해 조작할 수 있다.

이 접근 방식을 사용하면 파티션들의 논리적 부모 역할을 하는 부모 테이블과 raw SQL로 생성한 자식 파티션들을 생성한 후, 부모 테이블에 대해 unmanaged ORM 모델을 연결할 수 있다. 이렇게 하면 PostgreSQL에 직접 접속해 SQL 쿼리할 때와 동일한 방식으로 부모 테이블에 대해 질의하는 것만으로 PostgreSQL 쿼리 플래너가 자동으로 자식 테이블들에 대해 쿼리하도록 할 수 있다.

PostgreSQL 파티셔닝의 중요한 제약사항

PostgreSQL에서 파티션 테이블을 사용할 때 반드시 고려해야 할 중요한 제약사항이 있다. PostgreSQL 공식 문서에 따르면, 파티션 테이블에 기본 키(primary key)나 고유 제약(unique constraint)을 정의할 때, 해당 제약 조건에 파티션 키가 반드시 포함되어야 한다. 따라서 BY RANGE 구문에서 지정한 파티셔닝 키 컬럼(여기서는 created_at)은 복합 primary key에 포함시켜야 한다.

최신 Django 버전의 복합 PK 지원 활용

개발 중 팀 내에서 PostgreSQL 확장인 TimescaleDB 사용을 제안하는 의견이 나와서, 기존 마이그레이션을 물리고 모델 설계를 검토하던 중 최근 릴리즈된 Django 버전에서 복합 PK를 지원하게 되었다는 것을 발견했다.

복합 PK를 ORM 수준에서 선언하면 managed=False 옵션을 사용한 뒤 직접 복합 PK와 다른 필드를 raw SQL로 생성할 필요도 없고 makemigrations 커맨드로 마이그레이션 파일을 생성 후 해당 테이블에 대해 내장 파티셔닝 기능 사용을 선언하거나 TimescaleDB hypertable로 변환하는 것만으로 테이블 마이그레이션이 가능하다. 즉 ORM 고수준 API의 이점을 더 활용할 수 있다.

구현 코드

class Example(models.Model):
    # https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
    # Declarative Partitioning 사용시 
    # 반드시 Partitioning Key를 Composite PK에 포함해 설정
    pk = CompositePrimaryKey("uuid", "created_at")
    uuid = models.UUIDField(default=uuid.uuid4, editable=False, auto_created=True)
    # Partitioning Key
    created_at = models.DateTimeField(
        db_index=True,
        auto_now_add=True,
    )
    # ... (나머지 필드)

결과 및 향후 개선점

이 방법을 사용하면 여전히 makemigrations 커맨드로 생성된 파일에 RunSQL로 변환 SQL문을 추가해주어야 하지만, managed=True 상태로 ORM 모델을 관리할 수 있다. 또 바닐라 ORM 모델에 쿼리하는 것과 같은 방식으로 쿼리하는 것만으로 자식 파티션 테이블들에 대해 PostgreSQL 내장 스케줄러를 사용한 쿼리가 가능하다.

물론 data retention 등 정책은 Django custom command나 TimescaleDB 확장 쿼리로 따로 관리해주어야 한다.

당장은 만족스러운 편이지만 더 나은 방법이 있을 수 있으므로 찾아보고 있다 . . .

Django 5.2에서 PostgreSQL 선언적 파티셔닝 구현하기

목표와 접근 방법

최근 프로젝트에서는 대용량 데이터를 처리해야 해서 테이블 파티셔닝을 사용해볼 법한 상황이었다. 내 목표는 Django의 고수준 ORM API를 최대한 활용하면서도 관리 포인트를 줄이고, PostgreSQL의 내장 선언적 파티셔닝 기능을 효과적으로 사용하는 것이었다. PostgreSQL의 공식 Table Partitioning 문서를 참조하여 구현을 진행했다.

초기 문제점과 해결 시도

Django에서는 PostgreSQL의 선언적 파티셔닝과 관련된 바인드된 API가 제공되지 않는다. 이로 인해 처음에는 RunSQL을 사용하여 raw SQL로 파티셔닝을 구현하고 마이그레이션을 관리하는 방법을 시도했다.

Django ORM에서는 모델의 Meta 클래스에서 managed=False 옵션(Options.managed)을 사용하여 고수준 API에서 마이그레이션을 관리하지 않는 테이블을 ORM 모델 클래스를 통해 조작할 수 있다.

이 접근 방식을 사용하면 파티션들의 논리적 부모 역할을 하는 부모 테이블과 raw SQL로 생성한 자식 파티션들을 생성한 후, 부모 테이블에 대해 unmanaged ORM 모델을 연결할 수 있다. 이렇게 하면 PostgreSQL에 직접 접속해 SQL 쿼리할 때와 동일한 방식으로 부모 테이블에 대해 질의하는 것만으로 PostgreSQL 쿼리 플래너가 자동으로 자식 테이블들에 대해 쿼리하도록 할 수 있다.

PostgreSQL 파티셔닝의 중요한 제약사항

PostgreSQL에서 파티션 테이블을 사용할 때 반드시 고려해야 할 중요한 제약사항이 있다. PostgreSQL 공식 문서에 따르면, 파티션 테이블에 기본 키(primary key)나 고유 제약(unique constraint)을 정의할 때, 해당 제약 조건에 파티션 키가 반드시 포함되어야 한다. 따라서 BY RANGE 구문에서 지정한 파티셔닝 키 컬럼(여기서는 created_at)은 복합 primary key에 포함시켜야 한다.

최신 Django 버전의 복합 PK 지원 활용

개발 중 팀 내에서 PostgreSQL 확장인 TimescaleDB 사용을 제안하는 의견이 나와서, 기존 마이그레이션을 물리고 모델 설계를 검토하던 중 최근 릴리즈된 Django 버전에서 복합 PK를 지원하게 되었다는 것을 발견했다.

복합 PK를 ORM 수준에서 선언하면 managed=False 옵션을 사용한 뒤 직접 복합 PK와 다른 필드를 raw SQL로 생성할 필요도 없고 makemigrations 커맨드로 마이그레이션 파일을 생성 후 해당 테이블에 대해 내장 파티셔닝 기능 사용을 선언하거나 TimescaleDB hypertable로 변환하는 것만으로 테이블 마이그레이션이 가능하다. 즉 ORM 고수준 API의 이점을 더 활용할 수 있다.

구현 코드

class Example(models.Model):
    # https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
    # Declarative Partitioning 사용시 
    # 반드시 Partitioning Key를 Composite PK에 포함해 설정
    pk = CompositePrimaryKey("uuid", "created_at")
    uuid = models.UUIDField(default=uuid.uuid4, editable=False, auto_created=True)
    # Partitioning Key
    created_at = models.DateTimeField(
        db_index=True,
        auto_now_add=True,
    )
    # ... (나머지 필드)

결과 및 향후 개선점

이 방법을 사용하면 여전히 makemigrations 커맨드로 생성된 파일에 RunSQL로 변환 SQL문을 추가해주어야 하지만, managed=True 상태로 ORM 모델을 관리할 수 있다. 또 바닐라 ORM 모델에 쿼리하는 것과 같은 방식으로 쿼리하는 것만으로 자식 파티션 테이블들에 대해 PostgreSQL 내장 스케줄러를 사용한 쿼리가 가능하다.

물론 data retention 등 정책은 Django custom command나 TimescaleDB 확장 쿼리로 따로 관리해주어야 한다.

당장은 만족스러운 편이지만 더 나은 방법이 있을 수 있으므로 찾아보고 있다 . . .

Django 5.2에서 PostgreSQL 선언적 파티셔닝 구현하기

목표와 접근 방법

최근 프로젝트에서는 대용량 데이터를 처리해야 해서 테이블 파티셔닝을 사용해볼 법한 상황이었다. 내 목표는 Django의 고수준 ORM API를 최대한 활용하면서도 관리 포인트를 줄이고, PostgreSQL의 내장 선언적 파티셔닝 기능을 효과적으로 사용하는 것이었다. PostgreSQL의 공식 Table Partitioning 문서를 참조하여 구현을 진행했다.

초기 문제점과 해결 시도

Django에서는 PostgreSQL의 선언적 파티셔닝과 관련된 바인드된 API가 제공되지 않는다. 이로 인해 처음에는 RunSQL을 사용하여 raw SQL로 파티셔닝을 구현하고 마이그레이션을 관리하는 방법을 시도했다.

Django ORM에서는 모델의 Meta 클래스에서 managed=False 옵션(Options.managed)을 사용하여 고수준 API에서 마이그레이션을 관리하지 않는 테이블을 ORM 모델 클래스를 통해 조작할 수 있다.

이 접근 방식을 사용하면 파티션들의 논리적 부모 역할을 하는 부모 테이블과 raw SQL로 생성한 자식 파티션들을 생성한 후, 부모 테이블에 대해 unmanaged ORM 모델을 연결할 수 있다. 이렇게 하면 PostgreSQL에 직접 접속해 SQL 쿼리할 때와 동일한 방식으로 부모 테이블에 대해 질의하는 것만으로 PostgreSQL 쿼리 플래너가 자동으로 자식 테이블들에 대해 쿼리하도록 할 수 있다.

PostgreSQL 파티셔닝의 중요한 제약사항

PostgreSQL에서 파티션 테이블을 사용할 때 반드시 고려해야 할 중요한 제약사항이 있다. PostgreSQL 공식 문서에 따르면, 파티션 테이블에 기본 키(primary key)나 고유 제약(unique constraint)을 정의할 때, 해당 제약 조건에 파티션 키가 반드시 포함되어야 한다. 따라서 BY RANGE 구문에서 지정한 파티셔닝 키 컬럼(여기서는 created_at)은 복합 primary key에 포함시켜야 한다.

최신 Django 버전의 복합 PK 지원 활용

개발 중 팀 내에서 PostgreSQL 확장인 TimescaleDB 사용을 제안하는 의견이 나와서, 기존 마이그레이션을 물리고 모델 설계를 검토하던 중 최근 릴리즈된 Django 버전에서 복합 PK를 지원하게 되었다는 것을 발견했다.

복합 PK를 ORM 수준에서 선언하면 managed=False 옵션을 사용한 뒤 직접 복합 PK와 다른 필드를 raw SQL로 생성할 필요도 없고 makemigrations 커맨드로 마이그레이션 파일을 생성 후 해당 테이블에 대해 내장 파티셔닝 기능 사용을 선언하거나 TimescaleDB hypertable로 변환하는 것만으로 테이블 마이그레이션이 가능하다. 즉 ORM 고수준 API의 이점을 더 활용할 수 있다.

구현 코드

class Example(models.Model):
    # https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-LIMITATIONS
    # Declarative Partitioning 사용시 
    # 반드시 Partitioning Key를 Composite PK에 포함해 설정
    pk = CompositePrimaryKey("uuid", "created_at")
    uuid = models.UUIDField(default=uuid.uuid4, editable=False, auto_created=True)
    # Partitioning Key
    created_at = models.DateTimeField(
        db_index=True,
        auto_now_add=True,
    )
    # ... (나머지 필드)

결과 및 향후 개선점

이 방법을 사용하면 여전히 makemigrations 커맨드로 생성된 파일에 RunSQL로 변환 SQL문을 추가해주어야 하지만, managed=True 상태로 ORM 모델을 관리할 수 있다. 또 바닐라 ORM 모델에 쿼리하는 것과 같은 방식으로 쿼리하는 것만으로 자식 파티션 테이블들에 대해 PostgreSQL 내장 스케줄러를 사용한 쿼리가 가능하다.

물론 data retention 등 정책은 Django custom command나 TimescaleDB 확장 쿼리로 따로 관리해주어야 한다.

당장은 만족스러운 편이지만 더 나은 방법이 있을 수 있으므로 찾아보고 있다 . . .

Submission deadline for community projects on Tuesday before #PGConfEU is next week! Get your ideas and proposals in!

https://www.postgresql.eu/events/pgconfeu2025/news/pgconfeu-2025-call-for-community-events-activities-172/

#PostgreSQL #Conference #Riga #Latvia #Community

Every Tuesday at 11:00am ET, join the pgEdge team for #TechTuesday — all about mastering Distributed #PostgreSQL high availability, and edge-ready database solutions. Whether you’re scaling apps or seeking zero downtime, these sessions are packed with hands-on insights, real-world demos, and live Q&A with the experts.

Don’t miss out! Learn more here: https://hubs.la/Q03qbnT70

Join us on Tuesday at 11am ET here: https://hubs.la/Q03qbltY0

#pgEdge #EdgeComputing #OpenSource #WebDev #DatabaseTips

Submission deadline for community projects on Tuesday before #PGConfEU is next week! Get your ideas and proposals in!

https://www.postgresql.eu/events/pgconfeu2025/news/pgconfeu-2025-call-for-community-events-activities-172/

#PostgreSQL #Conference #Riga #Latvia #Community

Ami/es de la Transformation, bonsoir.
Tu souhaites toi aussi devenir un/e Transformers ?

Viens donc découvrir cet article, suite du précédent qui abordait #AirFlow : cette fois-ci, on transforme la data grâce à #dbt dans des bases #PostgreSQL, afin de la diffuser via #QGIS notamment.

Un cas d'usage sur des données #Mapillary, pour les panneaux de signalisation sur le département du Gard.

✍️ Rédigé par Michaël Galien

😎 Relu par @guilhem_allaman et @geojulien

https://geotribu.fr/articles/2025/2025-06-05_taradata_transform_mapillary/

Ami/es de la Transformation, bonsoir.
Tu souhaites toi aussi devenir un/e Transformers ?

Viens donc découvrir cet article, suite du précédent qui abordait #AirFlow : cette fois-ci, on transforme la data grâce à #dbt dans des bases #PostgreSQL, afin de la diffuser via #QGIS notamment.

Un cas d'usage sur des données #Mapillary, pour les panneaux de signalisation sur le département du Gard.

✍️ Rédigé par Michaël Galien

😎 Relu par @guilhem_allaman et @geojulien

https://geotribu.fr/articles/2025/2025-06-05_taradata_transform_mapillary/

Our goal is straightforward, really: to help the world understand the power of #PostgreSQL, at scale. Our team has worked with #Postgres for decades. We specialize in creating solutions for #OpenSource, fully distributed PostgreSQL for high availability (& much more).

Check out our site to run fully distributed, multi-master Postgres on your own: https://www.pgedge.com/get-started/containers

You can also always get in touch or try pgEdge Cloud free for 30 days: https://www.pgedge.com/

#introduction #developer

Seen at the podium at #PGConfdev last week in Montréal, this is #PostgreSQL committer Peter Geoghegan of AWS presenting on "Multidimensional search strategies for composite B-Tree indexes"

Seen at the podium at #PGConfdev last week in Montréal, this is #PostgreSQL committer Peter Geoghegan of AWS presenting on "Multidimensional search strategies for composite B-Tree indexes"

Where are you on your journey to learning about #data management? @posetteconf seeks to help you address questions you didn't even know you had about using #PostgreSQL across every industry and scenario you can imagine.

Learn more free during this #Microsoft event (or after, watching the recordings!).

Two of our team will be presenting; attend live to talk directly, ask questions, & learn. 🐘

#learntocode #hacking #sql #database #foss #oss #developer #devcommunity #programming #techevent

Where are you on your journey to learning about #data management? @posetteconf seeks to help you address questions you didn't even know you had about using #PostgreSQL across every industry and scenario you can imagine.

Learn more free during this #Microsoft event (or after, watching the recordings!).

Two of our team will be presenting; attend live to talk directly, ask questions, & learn. 🐘

#learntocode #hacking #sql #database #foss #oss #developer #devcommunity #programming #techevent

On the big stage at #PGConfdev is #PostgreSQL core team member Peter Eisentraut of EDB presenting on “What is new in C and POSIX?” & the spoiler is new standards were released for both in 2024!

On the big stage at #PGConfdev is #PostgreSQL core team member Peter Eisentraut of EDB presenting on “What is new in C and POSIX?” & the spoiler is new standards were released for both in 2024!

The #PostgreSQL Development Conference has begun! 💥 Looking forward to seeing all the 🐘 Postgres people. Seen today near the registration desk at #PGConfdev in Montréal: Magnus Hagander, Katherine Saar, Paul Ramsey, & Steve Singer

The #PostgreSQL Development Conference has begun! 💥 Looking forward to seeing all the 🐘 Postgres people. Seen today near the registration desk at #PGConfdev in Montréal: Magnus Hagander, Katherine Saar, Paul Ramsey, & Steve Singer

Y a-t-il des adeptes de #PostgreSQL dans le Fédiverse qui vivent à #Lille et sa périphérie ?

J’envisage de créer un compte Mastodon pour le Meetup éponyme de ma région, et varier les canaux de communication pour ne pas être enfermé sur LinkedIn. EDIT: c’est fait, n’hésitez pas à suivre l’actualité depuis le compte @postgresql_lille

Un repouet fait vivre la communauté et nourrit des pachydermes 🐘

Y a-t-il des adeptes de #PostgreSQL dans le Fédiverse qui vivent à #Lille et sa périphérie ?

J’envisage de créer un compte Mastodon pour le Meetup éponyme de ma région, et varier les canaux de communication pour ne pas être enfermé sur LinkedIn. EDIT: c’est fait, n’hésitez pas à suivre l’actualité depuis le compte @postgresql_lille

Un repouet fait vivre la communauté et nourrit des pachydermes 🐘

Sponsor sessions and sponsor keynotes are now available in the #PGConfDE 2025 schedule.

https://www.postgresql.eu/events/pgconfde2025/schedule/

#PostgreSQL #Conference #Berlin

Sponsor sessions and sponsor keynotes are now available in the #PGConfDE 2025 schedule.

https://www.postgresql.eu/events/pgconfde2025/schedule/

#PostgreSQL #Conference #Berlin

@joomla maintainers are in progress to define the minimum requirements for #joomla 6. In question is #php #mysql #mariadb #postgresql #apache #ngnix #iis
What's your suggestion?

pgAdmin 4 v9.2 Released

https://www.postgresql.org/about/news/pgadmin-4-v92-released-3050/

#IT #postgresql #pgadmin

pgAdmin 4 v9.2 Released

https://www.postgresql.org/about/news/pgadmin-4-v92-released-3050/

#IT #postgresql #pgadmin

pgAdmin 4 v9.2 Released

https://www.postgresql.org/about/news/pgadmin-4-v92-released-3050/

#IT #postgresql #pgadmin

pgAdmin 4 v9.2 Released

https://www.postgresql.org/about/news/pgadmin-4-v92-released-3050/

#IT #postgresql #pgadmin

Hello, hachyderm! we've been working hard on building up our ansible runbooks and improving hachyderm's overall resilience. Recently, we've been focusing on is database resilience.

We're getting close to retiring our original database server (finally!) and preparing to move to a fully ansible-managed set of databases servers, primary and replica on new hardware. We'll send another announcement when we do the cut over. The team has done excellent work to make this highly automated, quick, and painless!

Done:

✅ author ansible roles for managing postgresql, pgbackrest (backups), pgbouncer, and primary/replica failover
✅ decide to continue with pgbouncer and *not* use pgcat
✅ rotate database passwords
✅ order new replica database hardware
✅ order new future primary database hardware

To do soon:

🟨 rebuild replica database with ansible scripts
🟨 prepare primary database with ansible scripts
🟨 start replicating to new database replica
🟨 cut over to new database server 🎉

We're also planning on open-sourcing our ansible roles in the coming weeks - just a little housekeeping & tidying up before we do!

#hachyderm #devops #sre #ansible #postgresql

Hello, hachyderm! we've been working hard on building up our ansible runbooks and improving hachyderm's overall resilience. Recently, we've been focusing on is database resilience.

We're getting close to retiring our original database server (finally!) and preparing to move to a fully ansible-managed set of databases servers, primary and replica on new hardware. We'll send another announcement when we do the cut over. The team has done excellent work to make this highly automated, quick, and painless!

Done:

✅ author ansible roles for managing postgresql, pgbackrest (backups), pgbouncer, and primary/replica failover
✅ decide to continue with pgbouncer and *not* use pgcat
✅ rotate database passwords
✅ order new replica database hardware
✅ order new future primary database hardware

To do soon:

🟨 rebuild replica database with ansible scripts
🟨 prepare primary database with ansible scripts
🟨 start replicating to new database replica
🟨 cut over to new database server 🎉

We're also planning on open-sourcing our ansible roles in the coming weeks - just a little housekeeping & tidying up before we do!

#hachyderm #devops #sre #ansible #postgresql

New (more or less) #PostgreSQL folks and projects on Mastodon:

@bilgegunduz
@ehstanton
@pgxn
@emmasaroyan
@edbpostgres
@c2main
@corneliabiacsics
@dougortiz
@CloudNativePG
@dalibo

Do you know other account? Please let me know.

Previous postings:
https://mastodon.social/@ascherbaum/109319603453401009
https://mastodon.social/@ascherbaum/109382856990028550
https://mastodon.social/@ascherbaum/109541161628270452
https://mastodon.social/@ascherbaum/109778860645844896
https://mastodon.social/@ascherbaum/110689201525340594
https://mastodon.social/@ascherbaum/111902934327303738
https://mastodon.social/@ascherbaum/113329503663749302

howdy, folks - it's been a bit since our last #hachyderm infra check in.

stuff in motion:

- ditching #terraform cloud & tf for #opentofu and #atlantis. we are just about to import our dev environment and put it through its paces.
- bringing #postgresql under ansible management. the team has been doing awesome work, and we've started to spin up dev nodes using the new playbooks. soon: production!
- moving #DNS zones away from AWS route 53. we chose bunny DNS as our provider and have been doing basic tests in dev. we'll likely prep our records for production this week with a plan for a cutover in one of the coming weekends.

and if you filled out our volunteer form and haven't heard from me in a bit - you're still on the list. we'll onboard a new batch of folks in the next couple of weeks.

#devops #sre #mastoadmin

Il a suffi qu’une personne parle de https://monrer.fr sur un certain réseau social à une lettre pour que le site se prenne en une journée de week-end l’équivalent de trois jours de trafic normal en semaine.

En tout cas, ça a l’air d’avoir bien tenu, et c’est à la fois grâce à mes efforts d’optimisation et à la puissance de #Perl et de #PostgreSQL sur #FreeBSD !

howdy, folks - it's been a bit since our last #hachyderm infra check in.

stuff in motion:

- ditching #terraform cloud & tf for #opentofu and #atlantis. we are just about to import our dev environment and put it through its paces.
- bringing #postgresql under ansible management. the team has been doing awesome work, and we've started to spin up dev nodes using the new playbooks. soon: production!
- moving #DNS zones away from AWS route 53. we chose bunny DNS as our provider and have been doing basic tests in dev. we'll likely prep our records for production this week with a plan for a cutover in one of the coming weekends.

and if you filled out our volunteer form and haven't heard from me in a bit - you're still on the list. we'll onboard a new batch of folks in the next couple of weeks.

#devops #sre #mastoadmin

Made my first #deno steps today with #typescript, without a doubt it's the beggining of a great new friendship. Lots of JS5 to Typescript porting ahead. The first thing I'll port is the sqlexecutor family, particularly the #postgresql executor lib
https://github.com/allex-libs/postgresqlexecutor

Made my first #deno steps today with #typescript, without a doubt it's the beggining of a great new friendship. Lots of JS5 to Typescript porting ahead. The first thing I'll port is the sqlexecutor family, particularly the #postgresql executor lib
https://github.com/allex-libs/postgresqlexecutor

Made my first #deno steps today with #typescript, without a doubt it's the beggining of a great new friendship. Lots of JS5 to Typescript porting ahead. The first thing I'll port is the sqlexecutor family, particularly the #postgresql executor lib
https://github.com/allex-libs/postgresqlexecutor

Thank you so much to the volunteers who made #SCaLE22x @socallinuxexpo possible, to the wonderful speakers, and of course to the fantastic audience who kept us on our toes with their questions. As my little token of gratitude ♥️ I am giving away 5 eBooks of "PostgreSQL Mistakes and How to Avoid Them"! Please reply to this post, and I will use a random picker.

https://mng.bz/vKd4

#PostgreSQL #OpenSource #Postgres #Giveaway #Database

Thank you so much to the volunteers who made #SCaLE22x @socallinuxexpo possible, to the wonderful speakers, and of course to the fantastic audience who kept us on our toes with their questions. As my little token of gratitude ♥️ I am giving away 5 eBooks of "PostgreSQL Mistakes and How to Avoid Them"! Please reply to this post, and I will use a random picker.

https://mng.bz/vKd4

#PostgreSQL #OpenSource #Postgres #Giveaway #Database

📣 Today is March 5th so the schedule for #PosetteConf 2025 has just dropped! 💥

👋 Huge welcome to each of the 43 a-ma-zing #PostgreSQL speakers. Check out the schedule and be sure to Register & Save-the-Date! 🗓️

https://posetteconf.com/2025/schedule/

Il a suffi qu’une personne parle de https://monrer.fr sur un certain réseau social à une lettre pour que le site se prenne en une journée de week-end l’équivalent de trois jours de trafic normal en semaine.

En tout cas, ça a l’air d’avoir bien tenu, et c’est à la fois grâce à mes efforts d’optimisation et à la puissance de #Perl et de #PostgreSQL sur #FreeBSD !

Critical PostgreSQL bug tied to zero-day attack on US Treasury

A high-severity SQL injection bug in the #PostgreSQL interactive tool was exploited alongside the zero-day used to break into the US Treasury in December, researchers say.

Rapid7's principal security researcher, Stephen Fewer, disclosed CVE-2025-1094 (8.1) on Thursday, saying it was a key part of the exploit chain that also included the BeyondTrust zero-day (CVE-2024-12356).

https://www.theregister.com/2025/02/14/postgresql_bug_treasury/ #infosec

#Development #Launches
SQL Noir · A game to learn SQL by solving crimes https://ilo.im/162ciw

_____
#OpenSource #Game #Database #SQL #MySQL #SQLite #PostgreSQL #Npm #WebDev #Backend

#Development #Launches
SQL Noir · A game to learn SQL by solving crimes https://ilo.im/162ciw

_____
#OpenSource #Game #Database #SQL #MySQL #SQLite #PostgreSQL #Npm #WebDev #Backend

Call for Papers for #PGConfDE 2025 in #Berlin ends tomorrow!

Last chance to submit your talk.

https://2025.pgconf.de/

#CallForPapers #Conference #PostgreSQL

Call for Papers for #PGConfDE 2025 in #Berlin ends tomorrow!

Last chance to submit your talk.

https://2025.pgconf.de/

#CallForPapers #Conference #PostgreSQL

@psycopg I am honored to have participated in the resolution of issue #999 :)

https://github.com/psycopg/psycopg/issues/999

#Django #Psycopg #PostgreSQL #Memcached #PyLibMC #Python #Cache

¡Hola! Llevo algún tiempo en Mastodon pero no había hecho presentación. Soy chileno (#Valdivia '04-'22, #Santiago '91-'04, aprobé el 2022) viviendo en Alemania desde '22, chapurreo el alemán a duras penas. Mi pasión es leer. Soy desarrollador de software #postgresql desde el '02, he dado charlas sobre eso en muchos lugares. Tolkien es mi copiloto.
En mi foto de cabecera estoy dando una charla en un meetup en Santiago el 2016.
INTP cis-masc
#presentacion

One thing I'm still investigating: how to make #SQLite as similar to #PostgreSQL as possible via pragmas (https://www.sqlite.org/pragma.html).

I'm ok sacrificing some speed for referential integrity. I'm currently looking into:

PRAGMA strict = ON;
PRAGMA case_sensitive_like = ON;
PRAGMA recursive_triggers = ON;
PRAGMA automatic_index = ON;
PRAGMA encoding = 'UTF-8';

Anyone have experience with these? I'm thinking about modifying @anze3db benchmark in https://blog.pecar.me/django-sqlite-benchmark to see what the impacts are.

Hey, Fediverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?

Thanks!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

Hey, Fediverse! I'm looking for informed opinions on database choices.

I can stand up an Internet-facing application and have it use either mysql or postgresql. Which is the better choice, and why do you think so?

Thanks!

#Mastodev #SelfHosted #SelfHosting #Postgresql #mysql

I'm waivering a bit on my choice to create a single PostgreSQL server for my homelab. This felt like a good idea because I come from the Microsoft world, where every software license costs $$$$$$.

Most applications I want to use combines the database server within the install itself. This ensures no conflicts with other databases and silos performance issues as well. Which sounds like a good idea to me.

The downside - repetitive maintenance task, like backups.

#HomeLab #postgresql

【個人開発】引っ越しで後悔しない！~新卒エンジニアが“住む場所”の選び方を決めるアプリ「LiveSpot」を開発しました~
https://qiita.com/k_ohmikawa/items/bce650e2d861740bc7c3?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Django #PostgreSQL #ポートフォリオ #React #個人開発

If you're thinking about submitting a talk proposal to a #PostgreSQL conference, you're in luck. 💥 There are 6 conference CFPs open now! But some of the CFPs close as soon as Dec 31st, others in Jan or early Feb.

So carpe diem: Submit that talk proposal & share your expertise and interesting stories, successes, failures, insights, whatever.

Also, boosts appreciated 🚀, please tell your friends & teammates so they don't miss their shot!

#CFP #CallForSpeakers #OpenSource #conference #database

Database：Optimistic LockとPessimistic Lock
https://qiita.com/Ian_C/items/c3c4cb00a63fb6092a37?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #MySQL #SQL #PostgreSQL

CVE-2024-10979をローカルで再現してみる
https://qiita.com/ikeda_takato/items/df354bcd5953a1c11ef6?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgreSQL #Security #CVE_2024_10979

Apparently #PostgreSQL 18 will offer a new function named uuidv7()!

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=78c5e141e9c139fc2ff36a220334e4aa25e1b0eb

...and here is a hint #2

#postgresql #database #opensource

ジェイソン記念日なのでJSON_TABLEを試してみる
https://qiita.com/sapi_kawahara/items/7b47d236abc042f9afa5?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #PostgreSQL #JSON #初心者 #Database #データべース設計

We know you’re curious about where the next conference will take place, so here’s a first hint.

#postgresql #database #opensource

I looked at several different ways to install Postgres in my Homelab:

Portainer > Docker Container
ProxMox > VM or LXC > Postgres
ProxMox > VM > Supabase
Kubernetes (I'm scared of this lol)

Decided on ProxMox > LXC. Supabase looks cool but I feel like it would hide a lot of things a newbie should really know first.

Installing as an LXC template gave me a Turnkey Linux web interface as well, tho I don't know much about it yet.

Next: A backup plan.

#HomeLab #Postgresql #TurnkeyLinux

PGConf.EU is coming to town...
#postgresql #database #opensource

I haven't had a need to install a database server in my homelab other than sqllite setups for various applications. But I've got two projects that mention a need for them now. Really don't want to pay for this if I can run it locally (is that a dumb idea?).

So, guess it's time to learn something new.

https://www.postgresql.org/download/linux/ubuntu/

#HomeLab #postgresql

I'm a senior backend engineer, did most stuff with #ruby. I like #linux know also #clang the usual scripting stuff, #python. I know a little bit #java did #openshift ( #kubernetes ) and #docker containers. My preferred database is #postgresql

Is someone searching for #vienna in #austria ? I mean finding a job should not be hard with that kind of profile, right?

#GetFediHired

Find some great PostgreSQL videos from PGconf.EU 2024 on https://www.youtube.com/playlist?list=PLF36ND7b_WU4QL6bA28NrzBOevqUYiPYq and don't forget to subscribe!
#postgresql #database #opensource #athens #speakers #postgres

#PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released! https://www.postgresql.org/about/news/postgresql-172-166-1510-1415-1318-and-1222-released-2965/

PGConf.EU 2024 Lightning Talks

https://andreas.scherbaum.la/post/2024-11-19_pgconf-eu-2024-lightning-talks/

#PGConf.EU #Athens #Greece #Conference #PostgreSQL #LightningTalks #Talk #Presentation

We're always looking for speakers for our virtual Meetups! Got something to share? We'd love to hear from you! Drop us a DM and you could be our next speaker!

#speaker #postgres #PostgreSQL #bayareapostgres

Post in Italiano per tutti gli appassionati di PostgreSQL,

Il PGDay/MED 2024 si terrà a Napoli il prossimo 5 dicembre 2024!

Questa giornata dedicata interamente a PostgreSQL offrirà l'opportunità di incontrare esperti del settore, conoscere le ultime novità e tendenze, e partecipare a talk interessanti e coinvolgenti.

Per maggiori informazioni sul programma e per registrarti, visita il sito ufficiale:

https://2024.pgdaymed.org/

Grazie.
#PostgreSQL #Napoli #pgday #pgdaymed #conferenza

Hey #PostgreSQL ppl, this Wed 13 Nov at 10:00am PST, I'll be doing a LIVE recording of Ep21 of the #TalkingPostgres podcast with my guest @andatki

Topic this month = Helping Rails developers learn Postgres.

Join us! Calendar invite: https://aka.ms/TalkingPostgres-Ep21-cal

(or you can listen to the episode after we publish on all the platforms. You can find all the podcast episodes here: https://TalkingPostgres.com)

#Postgres #databases #community #opensource #Microsoft

Transaction Isolation in Postgres, explained

https://www.thenile.dev/blog/transaction-isolation-postgres

#postgresql

Hmmm du coup la création de l'user c'est okay :

createuser --createdb --pwprompt hollo
Enter password for new role: 
Enter it again: 

                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 freebox   |                                                            | {}
 hollo     | Create DB                                                  | {}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

createdb --username=hollo --encoding=utf8 --template=postgres hollo
createdb: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "hollo"

The PGDay/MED call for Sponsors is now open!

There are two simple sponsorship levels, Partner and Supporter, giving you a chance to both showcase your services and products, and to support the community and the conference!

https://2024.pgdaymed.org/sponsors/

#postgresql #pgday #pgdaymed #napoli #conference #postgres #december

I was honoured to serve on the @pgconfeu organising committee, #PGConfEU #Athens 2024 was awesome in no small part due to the amazing #PostgreSQL #Community. As always, I wish there was more time to meet more of you, but we can always do this at the next #Postgres event. Many thanks to all the committees, volunteers, sponsors, speakers and attendees that helped make this #conference a reality. 🥰

#openSource #database

Da var dette over for i år

#Postgresql

New (more or less) #PostgreSQL folks and projects on Mastodon:

@fljdin
@valgog
@pgconfdev
@jonahharris
@pjmodos
@BayAreaPostgres
@flavio
@yrashk
@katharinesaar

Do you know other account? Please let me know.

Previous postings:
https://mastodon.social/@ascherbaum/109319603453401009
https://mastodon.social/@ascherbaum/109382856990028550
https://mastodon.social/@ascherbaum/109541161628270452
https://mastodon.social/@ascherbaum/109778860645844896
https://mastodon.social/@ascherbaum/110689201525340594
https://mastodon.social/@ascherbaum/111902934327303738

Backup your postgres database to Hetzner S3 Object Storage: https://blog.popescul.com/posts/2024-10-12-backup-postgresql-with-docker/ #postgresql #hetzner #docker

Hello good morning!

I have some consulting time available in the near future. Let me know if you're looking for help with something like:

- #Ruby #Rails
- #Stripe or other payment provider integrations
- #Database performance optimization, particularly #Postgresql
- Architecture analysis

Website and email are in my profile or feel free to DM me.

(also, cliche, but boosts very much welcome!)

#fedihired #fedihire

#PostgreSQL v10 was released today, 7 years ago, and is now EOL for 2 years already.

Are you still running v10, or older? Do you have plans for an upgrade?

#PostgreSQL v14 is now exactly 3 years old, on this day, released on September 30th, 2021.

This version has two more years of support before it is end of life. It's a good time to start with plans for a migration to a newer version.

PostgreSQL is now officially the #2 preferred NoSQL database by Rails developers. 🙃

(That's as of this year, they didn't poll Postgres/JSONB previously.)

Source: https://railsdeveloper.com/survey/2024/#which-nosql-databases-do-you-use

#postgres #postgresql #rails #nosql #sql

PostgreSQL Person of the Week interview with: Nicolas Payart

https://postgresql.life/post/nicolas_payart/

#PostgreSQL #Interview

#PostgreSQL Contributions week 38

* New logo for PGEU diversity committee
* #Postgres community migration to #Mastodon
* Translations for the upcoming v17 release

https://postgres-contrib.org/post/14/

I just wrote and article... :)

https://dev.to/lifen/as-rails-developers-why-we-are-excited-about-postgresql-17-27nj

#Rails #postgresql

Feels more and more that all the so-called friends of #foss have fallen:

#Google , #Mozilla , #Canonical , #Microsoft , #GitHub , #Mastodon , #RedHat ... the list goes on.

Who is really left? #Linux #Debian #postgresql ?

Tickets for #PGConfEU in #Athens this year are selling quicker than previous years. Get your ticket soon!

The agenda with talks is available on the conference website, in case you need another reason to convince you to come to #Greece.

See you there!

#PostgreSQL #Conference @pgconfeu

Magnus Hagander on #PostgreSQL 17 development: commit fests, feature freezes, release candidates and that when we're counting LoC, let's count deletions (sad of course when it's features but they'll have another shot for 18) @pgdayuk

With all the new Mastodon users, it’s maybe time I wrote my #introduction (a.k.a. #introductions)

I am a father of 2, husband of 1. I live in The Netherlands.

I work as a freelance Database Admin for several companies, using #postgresql #oracle #mysql and many others. I also do some related stuff like #linux #ansible #kubernetes etc.

1/2

Hey folks, I'm looking for a new role.

I specialize in software delivery, reliability, and performance for growing organizations.

Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex #OpenStack

See my profile & DM me for details!

#GetFediHired

🌿 Data Bene: Your go-to #PostgreSQL service provider and #FOSS advocate. We're globally distributed with decades of experience working with Postgres and open source technologies. We're committed to preventing vendor lock-in and promoting sustainable and secure business practices. Follow us for content around the Postgres community, open-source and cybersecurity news, and sustainable practices in tech. 🐘

#introduction #tech #technology #OpenSource #Postgres

New Meetup group "Postgres Meetup for All", organizing online meetups.

Join to see the upcoming talks, or contact the organizers if you want to present.

#PostgreSQL #Postgres #Meetup

https://www.meetup.com/postgres-meetup-for-all/

🐳 If you are using the very, very old official PostgreSQL Docker image for PostgreSQL 8 (`postgres:8`), you might be interested in https://hub.docker.com/r/joschi/postgres8 which is a identical copy of the Docker image (`postgres:8`, `posgres:8.4`, `postgres:8.4.22`) which was still using the deprecated and planned for removal image manifest v2 schema 1 and "Docker Image v1" formats.

https://docs.docker.com/engine/deprecated/#pushing-and-pulling-with-image-manifest-v2-schema-1

#Docker #PostgreSQL #Deprecation

What is it?

• Aardwolf-Social aims to be a familiar and user-friendly federated social-media application. Choices have been made to replicate the visual feel, and functionality of Facebook with some elements also being borrowed from Mastodon (hence familiar).

Who is it for?

• Anyone that wants to use a privacy-oriented social-media site with Facebook-like feature set.

Planned Features at a Glance

• Familiar user interface
• Long-form posting
• Calendar
• Groups
• Integration with existing Fediverse networks (Mastodon, PixelFed, others)

Current Status

• In Development, not ready for use

Technical Details

• Built with #RustLang for reasons of code security, and performance
• Designed to be Modular! Though it is being developed as a packaged application, the project is actually split into multiple logical parts that can be swapped to suit the needs of the developer/sysadmin.
• Frontend: Currently using #YewFramework (WASM), #Bulma (CSS Framework), and #ForkAwesome (Icons)
• Backend: Currently using #Actix, and #PostgreSQL
• Docker images are planned, developer images were working but need to be refreshed.

Contributing

• There are two repositories "Aardwolf" and "Aardwolf-Interface". Aardwolf is the primary repo for the application, and brings all of the parts together (Actix backend, DB Models, UI Templates/Translations, Rust Types). Aardwolf-Interface is a secondary repository for being able to work on the user interface without the need for a complete Rust development environment.

• The main repo (Aardwolf) has been recently updated to run on Rust stable, but uses the Ructe template system which was never fully implemented.

• The interface repo is presently where all of the Yew framework updates are being done. Approximately 80% of the HTML has been added to the Yew application but so far none of the routing or functionality has been added.

LINKS
This is the GitHub Organization Page. The two Pinned repositories are the ones being actively developed.
https://github.com/Aardwolf-Social

I accept a few new customers in the coming weeks.

I'm on a mission to enable high performance IT systems and software delivery for growing organizations.

Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex

See my profile & DM me for details!

#GetFediHired

Want a sneak peek at some of the accepted PGConf.EU conference talks? Here: https://www.postgresql.eu/events/pgconfeu2024/sessions/. Other sessions are still pending speaker confirmations as we’re tirelessly working on putting together the schedule.

#postgresql #database #opensource #athens

Sentry is hiring Senior Software Engineer, Platform

🔧 #golang #python #rust #django #kafka #postgresql #redis #seniorengineer
🌎 Toronto, Canada
⏰ Full-time
🏢 Sentry

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-platform-at-sentry-io-feb-22-2024-9c4dd4?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

The web-based open source software #CATMAID was devised as "google maps but for volumes". Documentation at https://catmaid.org and source code at https://github.com/catmaid/CATMAID/

Modern #CATMAID enables hundreds of #neuroscience researchers world wide to collaboratively map neuronal circuits in large datasets, e.g., 100 TB or larger, limited only by bandwidth and server-side storage. The goal: to map and analyse a whole brain #connectome.

Running client-side on #javascript and server-side on #django #python #postgresql, it's a pleasure to use–if I may say so–and easy to hack on to extend its functionality with further widgets.

The first minimally viable product was produced in 2007 by Stephan Saalfeld (what we now refer to, dearly, as "Ice Age CATMAID), who demonstrated to us all that the web, and javascript, where the way to go for distributed, collaborative annotation of large datasets accessed piece-wise. See the original paper: https://academic.oup.com/bioinformatics/article-abstract/25/15/1984/210794

See also public instances at the #VirtulaFlyBrain http://virtualflybrain.org/ particularly under "tools - CATMAID - hosted EM data such as this #Drosophila first instar larval volume of its complete nervous system https://l1em.catmaid.virtualflybrain.org/?pid=1&zp=108250&yp=82961.59999999999&xp=54210.799999999996&tool=tracingtool&sid0=1&s0=2.4999999999999996&help=true&layout=h(XY,%20%7B%20type:%20%22neuron-search%22,%20id:%20%22neuron-search-1%22,%20options:%20%7B%22annotation-name%22:%20%22papers%22%7D%7D,%200.6)

Doing SQL for over two decades. I used Oracle, SQL Server, MySQL/MariaDB and in the last 6+ years PostgreSQL.

I can say with confidence, PostgreSQL is for almost all cases *the best* option, by far.

At this point I'd say that there is no justification to pay exorbitant license fees for Oracle or SQL Server for any new project. Except for very few niche use cases, PostgreSQL offers more features, *and* better performance, even compared to Oracle.

If you _must_ use Oracle/SQL Server for a legacy project, consider hiring a professional to migrate your project. It'll pay off next time when Microsoft or Oracle start to count your CPU cores.

#sql #postgresql #SQLServer #oracle #mysql

Mon #introduction
Un gentil administrateur de bases de données (#PostgreSQL).
Je suis sous #Linux depuis très (très) longtemps.

J'aime l’esprit du logiciel libre et de ses communautés.

Je suis en télétravail depuis de nombreuses années et quand je ne travaille pas :
- promener mes #chiens (et parfois mon #chat) dans la forêt
- cuisiner pour mes filles (et elles sont difficiles)
- cultiver mon #potager punk
- chercher les œufs que mes #poules cachent dans le jardin
(suppression auto des msg)

From 2 amazing open source projects #Rails & #PostgreSQL, w/ 9 months writing to 1st draft, 12 mo. editing to “in print,” 15 chapters, 26 mo. since contract signing, 35 contributors, 450 pages, & 900 newsletter subs…

📖🚀 It’s done and in print! TY! 🥳

https://mastodon.social/@andatki/110979864532653417

Karen Jex: When I grow up I want to be a Database Administrator (said no-one ever) https://karenjex.blogspot.com/2024/06/httpskarenjex.blogspot.com202406when-i-grow-up.html.html
#postgres #postgresql

📘 Big news! My book-in-progress "PostgreSQL Mistakes and How to Avoid Them" is now available in @ManningPublications Early Access Program (MEAP) — I hope it will help application developers, software architects & database administrators not only avoid mistakes but also learn the right way to do things in #Postgres.

Use code "au35ang" to get 35% off 💕

🌐 http://mng.bz/D9mR

#PostgreSQL #Manning #MEAP #Development #Databases #OpenSource #TechBooks #BookLaunch

Couldn't be prouder to announce the release of the PostgreSQL 16 Administration Cookbook! Massive thanks to my co-authors Gianni Ciolli, Boriss Mejías @tchorix, Vibhor Kumar and Simon Riggs, and Packt for a spectacular effort on a book that is bound to be a valuable resource for the #PostgreSQL community.

🌐 Amazon: https://packt.link/6PurB

🌐 Packt: https://www.packtpub.com/product/postgresql-16-administration-cookbook/9781835460580

🌐 Amazon UK: https://www.amazon.co.uk/PostgreSQL-Administration-Cookbook-real-world-challenges/dp/1835460585

#postgres #opensource #database #databases #administration #dba #book #cookbook

Hello! I am part of the Twitter migration & just changed servers, am now on hachyderm.io. About me:

* Work on open source PostgreSQL community initiatives at Microsoft
* Live in California in USA, a transplant from NH
* Host of Talking Postgres #podcast
* Co-creator of POSETTE: An Event for Postgres (formerly Citus Con)
* Love sailing in Greek islands
* Alum of Sun, Amazon/A9, Citus Data, and Brown CS
* Love chocolate lab

#introduction #PostgreSQL #Citus #PosetteConf #OpenSource #Community

Hello world! Been lurking a few days, time for an #introduction I guess.

Been in infosec for almost 14 years now (wow time flies!). Went the military way - studied computer engineering, then ended up in a infosec type junior leadership position straight out of uni.

Worked with some great people and had some awesome opportunities. Worked in forensics and building up training programs. But it was here where I largely realized I didn't want to play the promotion/leadership game. I like doing technical work more than people management work.

I worked in mil/government for a few more years, did some SIEM engineering work and then packet and malware analysis.

Now in the private sector but in a largely infra/operations role, working on automating all the things. Lots of work with #ansible, #python, #postgresql.

I think this toot is probably more text then I ever wrote on the birdsite over many years.

So hey! I started my computer journey with a Sinclair ZX Spectrum in 1984, studied Computing Science and worked for a bunch of companies, mainly in #software #architecture. I discovered #opensource 25 years ago and never stopped using it & engaging with the community. I'm now lucky enough to work in a #PostgreSQL #Database related role, occasionally contribute to #Postgres & frequently speak about it at conferences. I also sing and play the guitar & keyboards (badly). #introduction