Deploy Java Like a Pro: Your First Quarkus App on OpenShift in Minutes
A fun, hands-on guide for Java developers to build a REST API with Quarkus, PostgreSQL, and deploy it to OpenShift Developer Sandbox
https://myfear.substack.com/p/quarkus-rest-api-openshift-postgresql-guide
#Quarkus #Java #OpenShift #PostgreSQL #Kubernetes

After a month of serious use and study of PostgreSQL, I can say that I absolutely stand by this technology. It is rare that I found something that disappointed me.

Speaking of which, I find PostgreSQL's lack of support for the IGNORE NULLS behaviour on window functions to be quite unfortunate.

DB-Engines Ranking climbers of the month:

#PostgreSQL

#Snowflake

#SQLite

https://db-engines.com/en/ranking

I guess I need to rewrite this query #postgresql #pgadmin #testing

Amazon RDS for PostgreSQL 17.4

Link: https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4
Discussion: https://news.ycombinator.com/item?id=43833195

Behold! Amazon's RDS for #PostgreSQL 17.4 brings you the exciting world of inconsistent databases, complete with bonus Long Forks and "Gnonadjacent" cycles! Who knew cloud-hosted chaos could be so much fun?
https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4 #AmazonRDS #InconsistentDatabases #CloudChaos #DatabaseFun #HackerNews #ngated

PandaDoc is hiring Senior Python Engineer (Growth)

#python #django #aws #docker #kafka #kubernetes #postgresql #redis #seniorengineer
Remote; Poland
Full-time
PandaDoc

Job details https://jobsfordevelopers.com/jobs/senior-python-engineer-growth-at-pandadoc-com-feb-13-2025-1a7eca?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Building a Robust Full-Network Relay with Bluesky's Bigsky Software

Setting up a full-network atproto Relay using Bluesky's Bigsky software reveals critical insights into resource management and configuration for scalability. This article dives into the technical nuan...

https://news.lavx.hu/article/building-a-robust-full-network-relay-with-bluesky-s-bigsky-software

Need help with #PostgreSQL training, consulting, and/or support services? Our team can help, whether you're looking to migrate to #Postgres, improve performance, implement monitoring & security measures or disaster recovery, or ensure high availability.

Get in touch anytime with our team and we'll be happy to hop on a call with you and find out how we can best help.

https://data-bene.io

Movim is powerful web frontend for XMPP. Movim is officially dropping support for MySQL. They will only provide official support for PostgreSQL (default) and MariaDB.

https://movim.eu/

Movim is officially dropping support for MySQL

It is too difficult to maintain compatibility with all the quirks and specificity of this database MySQL was already broken for a while (migrations not running, broken queries).

Don't worry we are still fully compatible with PostgreSQL (that is the recommended one) and MariaDB. You can find those two databases in all the major distributions

This will greatly simplify and streamline the development of the project

Revolutionize Project Prototyping with CreateMVP: An AI-Powered Full-Stack Solution

CreateMVP is transforming the way developers approach project prototyping and implementation planning by leveraging multi-model AI integrations. With features that streamline documentation and impleme...

https://news.lavx.hu/article/revolutionize-project-prototyping-with-createmvp-an-ai-powered-full-stack-solution

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

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

#Easter #PostgreSQL #mashup
#cadbury #cremeegg #elephant #bunny #nerdhumour

I always wanted to play with osm2pgsql. Getting it running was easier than I thought. I now have access to crucial information, like knowing I'd have to travel 3200km to reach the bakery which is furthest from my house but still on the Australian mainland.

New blogpost: https://blog.tyk.nu/blog/the-story-of-postgresql-choking-on-an-unreadable-home/

It is a lovely story about debugging TLS connection issues from Django to PostgreSQL.

The root cause turned out to be libpq erroring out when running with the environment variable $HOME set to an existing but unreadable path, in this case "/root"

Enjoy!

Did you know PostgreSQL has its own built-in full-text search engine?

-- Create a tsvector column with GIN index
ALTER TABLE articles ADD COLUMN search_vector tsvector;
CREATE INDEX articles_search_idx ON articles USING GIN (search_vector);

UPDATE articles SET search_vector =
to_tsvector('english', title || ' ' || content);

-- Search
SELECT title FROM articles
WHERE search_vector @@ to_tsquery('english', 'postgresql & search');