Interesting insight into the inner workings of #PostgreSQL.

https://blog.danslimmon.com/2025/03/14/did-u-ever-read-so-hard-u-accidentally-wrote/

What do you want for the next article in my #blog?

- Correct configuration of #GitLabRunner caching on local filesystem
- Building a #OCI image #mirror with #GitLabCI and #Renovate
- Batch configuration of #GitLab's new automatic #pipeline cleanup
- Migrating a #Nextcloud from #MariaDB to #PostgreSQL
- Prefer #IPv6 with #musl under #Docker's IPv6 #NAT
- Renovate: update indirect #dependencies of #golang projects

Please tell it via comments, as a poll is only allowing 4 different options. :)

You can make Postgres scale

https://pgdog.dev/blog/you-can-make-postgres-scale

Xata Agent: AI agent expert in PostgreSQL

Link: https://github.com/xataio/agent
Discussion: https://news.ycombinator.com/item?id=43356039

Upscene releases new version Advanced Data Generator.

A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, script or data files.

Feature highlights:
- Data library to generate life-like fake date, also non-English
- Supports binary data
- Master/detail functionality
- Statistical data
- Templates

#testdatagenerator #testdata #fakedata #oracle #sqlserver #mysql #firebird #postgresql #sqlite #access #interbase
https://www.upscene.com/news/item/20250312

In 2024, the Data Bene team traveled to, presented at, & sponsored a number of #PostgreSQL community events, as well as started a blog, began a podcast in collaboration with Xata, and contributed back to #OpenSource.

Curious to know the details and see what we learned as a result of our experiences? Check out our new #Substack (free to subscribe) to see our recap for the year:

https://open.substack.com/pub/databene/p/engaging-with-the-postgresql-community

If there was a #PostgreSQL Conference happening in #Gdansk (Poland), would you be interested in co-organizing it? This is an unofficial call for organizers/volunteers.

Please DM ~~me~~ Jan in the linked posting.

https://www.linkedin.com/posts/janwie_postgresql-gdansk-activity-7303374487910047744-flik

Postgres friends: I have a container that needs a Postgres database. It will literally have one user with light usage. What are some options that I can have that are containerized? My hope is to run it from a podman quadlet and have it autoupdate through minor releases. Thank you. #postgresql #podman #Flatcar

Schedule for #PGConfDE 2025 in Berlin is published

Now it's the best time to get your ticket for the conference!

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

The Internals of PostgreSQL

Link: http://www.interdb.jp/pg/index.html
Discussion: https://news.ycombinator.com/item?id=43241404

BM25 in PostgreSQL

Link: https://blog.vectorchord.ai/vectorchord-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch
Discussion: https://news.ycombinator.com/item?id=43237911

It's 27 years now that #PostgreSQL lost the ability to travel back in time.

Release 6.3, which was published on this day in 1998, removed the "Time Travel" feature which allowed to peek into previous versions of a row.

Do you want this feature back? And why?

Reliably Replicating Data Between PostgreSQL and ClickHouse

Link: https://benjaminwootton.com/insights/clickhouse-peerdb-cdc/
Discussion: https://news.ycombinator.com/item?id=43111294

Representing Graphs in PostgreSQL

Link: https://www.richard-towers.com/2025/02/16/representing-graphs-in-postgres.html
Discussion: https://news.ycombinator.com/item?id=43078100

This has been pretty successful week in my #selfhosting journey. I got #postgresql running early in the week. I then made my own personal database to play with and got databases running for #freshrss, #redmine, #vikunja, and finally #forgejo. Once I was happy with the setup I did pg_dumpall because I know today I'll probably get over confident and break something. First thing I'm going to do this morning is setup another postgresql #docker and make sure I understand how to import pg_dumpall.

For years I've only queried databases. Setting these up and seeing the data behind the applications has been lot of fun! The access to this data makes me highly motivated to use it in my own ways such as populating my personal database with various stats and then learning Python and Flask to build simple tools for myself.

#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

Sicherheitslücke: Angreifer können #PostgreSQL-Datenbanken attackieren | Security https://www.heise.de/news/Sicherheitsluecke-Angreifer-koennen-PostgreSQL-Datenbanken-attackieren-10282360.html #Patchday

Sicherheitslücke: Angreifer können PostgreSQL-Datenbanken attackieren | heise online
https://heise.de/-10282360 #Datenbank #PostgreSQL #Sicherheitslücke

Happy #iloveFS day! Spending Valentine’s with my SO chilling with some #python shenanigans.

That all wouldn’t be possible without all the great #foss tools we’re using. Some that I especially want to thank today are:

#grafana #opensuse #vscodium #mastodon #kde #OrganicMaps #bitwarden #matrix #ubuntu #linux #vlc #blender #homeassistant #Zellij #lemmy #postgreSQL #asahilinux

thanks everyone for your dedication.