Tootfinder

#PostgreSQL #ZFS Best Practices.key - scale15x-2017-postgresql_zfs_best_practices.pdf
https://

https://bytebase.com/blog/features-i-wish-postgres-had/ - Features I wish PostgreSQL had as a developer.

#PostgreSQL FOR UPDATE vs FOR NO KEY UPDATE
https://vladmihalcea.com/postgresql-for-no-key-update/

Tage Seit #PostgreSQL explodiert ist? 0.
Aber hey. Locking ist offenbar kompliziert. >_>

2021 retro-link! https://info.crunchydata.com/blog/fuzzy-name-matching-in-postgresql - Fuzzy string matching in PostgreSQL.

Oh no, PostgreSQL developer Simon Riggs passed away a few days ago.
He came in to my workplace in 2008 to do some postgres training which I really enjoyed, and I caught up with him a couple of times since then at various conferences, always a good chat.
https://www.…

When #selfhosting, many services give the user the choice of using their own #sqlite database or to connect to an existing #postgresql server.
When faced with this choice, which option do you pick? W…

http://peter.eisentraut.org/blog/2024/04/29/postgresql-supported-platforms-over-time - PostgreSQL supported platforms over time.

why is postgresql so miserable to use

Lesser Known #PostgreSQL Features
https://hakibenita.com/postgresql-unknown-features

Have you unlocked the geospatial powers of PostgreSQL? At this year's Berlin Buzzwords, join @… as he will discuss 3 neat features of how to use PostgreSQL effectively to handle geospatial time series in a new domain. #bbuzz

2021 retro-link! https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/ - Waiting for PostgreSQL 14: SEARCH and CYCLE clauses.

An interview with Andres Freund, a Microsoft database engineer working on PostgreSQL, on discovering the XZ Utils backdoor, doubting his own findings, and more (Kevin Roose/New York Times)

Did One Guy Just Stop a Huge Cyberattack?
A Microsoft engineer noticed something was off on a piece of software he worked on. He soon discovered someone was probably trying to gain access to computers all over the world.

Have you unlocked the geospatial powers of PostgreSQL? At this year's Berlin Buzzwords, join @… as he will discuss 3 neat features of how to use PostgreSQL effectively to handle geospatial time series in a new domain. #bbuzz

"On 29 March 2024, Andres Freund, a PostgreSQL developer working at Microsoft, announced that he had found a backdoor in XZ Utils, impacting versions 5.6.0 and 5.6.1. Compressed test files had been added to the code for setting up the backdoor via additions to the configure script in the tar files. He started his investigation because "After observing a few odd symptoms around liblzma (part of the xz package)" as he found that ssh logins using sshd were "taking a lot of C…

2022 retro-link! https://supabase.com/blog/postgresql-commitfest - What is PostgreSQL commitfest?

PostgreSQL in #WASM allows you to run a #PostgreQL instance in the browser, Node.js, or Bun. Finally a proper, dependency-less database server for your browser :) #linktuesday

GitHub - electric-sql/pglite: Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno
Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno - electric-sql/pglite

I feel this strongly, as a dilettante #FOSS coder.
Modern mature software can be inherently complicated. PostgreSQL is a deep RDBMS that has been under development since the 80s. Writing new code for that is hard, especially in C. The only FOSS projects I‘m in at all active in are all Perl (i.e. ‘dilletante’) but they are also big and arcane. E.g. there are parts of

2021 retro-link! https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/speeding-up-recovery-and-vacuum-in-postgres-14/ba-p/2234071 - Speeding up crash recovery and VACUUM in Postgr…

Been having problems with 2 local #PHP projects on my Mac closing the connection when using PHP-FPM. Finally after almost 1 year (since Sonoma apparently) I found the solution:
https://<…

PHP pg_connect() does not return in PHP-FPM after MacOS Sonoma Upgrade
I have wasted a lot of time on this and I'm stumped. Anyone have some insight or work arounds? Thanks in advance for your attention... My PHP/PostgreSQL/NGINX app has been running on MacOS using PH...

2021 retro-link! https://fluca1978.github.io/2021/04/02/OOMKillerFreeBSD.html - Protecting PostgreSQL from FreeBSD's OOM killer.

I feel this strongly, as a dilettante #FOSS coder.
Modern mature software can be inherently complicated. PostgreSQL is a deep RDBMS that has been under development since the 80s. Writing new code for that is hard, especially in C. The only FOSS projects I‘m in at all active in are all Perl (i.e. ‘dilletante’) but they are also big and arcane. E.g. there are parts of

https://duckdb.org/2022/09/30/postgres-scanner.html - Querying PostgreSQL tables from DuckDB.

2021 retro-link! https://blog.urth.org/2021/03/14/writing-a-postgres-sql-pretty-printer-in-rust-part-1/ - Writing a PostgreSQL formatter / pretty printer in Rust.