All this built right into the #database (#clickhouse) in this case is amazing I think.
I would still try to be aware of the performance impact, since I believe calling `detectLanguage` on millions columns in every query is probably not that efficient. I guess I have to read about the caching it does (or does not?).

How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS.
What is ClusterControl?
ClusterControl is a robust #database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. ...
Continued 👉 https://blog.radwebhosting.com/how-to-install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mysql #installguide #databasecluster

Replication Manager è lo strumento pensato per chi gestisce cluster MySQL, MariaDB o Percona e vuole controllo, automazione e alta disponibilità senza compromessi. Un orchestratore completo, affidabile e ricco di funzionalità. #ReplicationManager #Software #Database #MySQL #MariaDB

https://www.linuxeasy.org/replication-manager-lorchestratore-open-source-per-mariadb-e-mysql/?utm_source=mastodon&utm_medium=jetpack_social

🕐 2026-03-13 12:00 UTC

📰 MySQLが好きな私が、今はPostgreSQLを勧めたい理由 (👍 219)

🇬🇧 A longtime MySQL user explains why they now recommend PostgreSQL for new projects after discovering its advantages in practice.
🇰🇷 오랜 MySQL 사용자가 실무에서 PostgreSQL의 장점을 발견하고 이제 새 프로젝트에 추천하는 이유를 설명합니다.

🔗 https://zenn.dev/catatsuy/articles/f3721135c6f8f6

#MySQL #PostgreSQL #Database #Zenn

I discovered, to my horror, the shit legacy codebase at work that was amateurishly written does not use database transactions. For anything! There's so many places I can see where inserts and updates could be literally catastrophic.

#rant #database #sql

Subquery Returns Multiple Rows In Comparison?!

Using subquery that returns multiple rows in = comparison crashes! SQL doesn't know which row to use. This breaks subqueries! Watch!

#sql #sqltricks #database #sqltutorial #subqueries #multiplerows #sqlquiz #codingchallenge #sqlshorts #sqlbugs #subqueryerrors #sqlwtf

https://www.youtube.com/watch?v=x15LSXR-uVM

#libraries #database #access

OK, so, this morning, #Viaf has decided that I cannot work, because I'm "rate limited" ! WTF

Viaf is an international Database for library Authorities, and, as a librarian, I consult it 100-200 times/day...

If I cannot use it, I may as well go back home and sleep 😬

🕐 2026-03-13 06:00 UTC

📰 MySQLが好きな私が、今はPostgreSQLを勧めたい理由 (👍 187)

🇬🇧 A long-time MySQL user explains why they now recommend PostgreSQL for new projects despite initial resistance
🇰🇷 오랜 MySQL 사용자가 처음엔 저항감이 있었지만 이제 새 프로젝트에 PostgreSQL을 추천하는 이유를 설명

🔗 https://zenn.dev/catatsuy/articles/f3721135c6f8f6

#Database #PostgreSQL #Zenn

"Design Me a Highly Resilient Database"

https://nikogura.com/DatabaseDesign.html

#HackerNews #Design #Resilient #Database #DatabaseDesign #DataArchitecture #TechInnovation

“Design me a highly resilient database”

https://nikogura.com/DatabaseDesign.html

#database

I am normally adverse to putting business logic in databases, but I have found a nice self contained use case for it. Instead of adding another scheduled job in my application, I use PostgreSQL's pg_cron extension.

#dotnet #csharp #postgresql #database #programming #sql

📰 MySQLが好きな私が、今はPostgreSQLを勧めたい理由 (👍 146)

🇬🇧 A longtime MySQL fan now recommends PostgreSQL. Real-world experience reveals PostgreSQL's strengths over MySQL's historical quirks for new projects.
🇰🇷 오랜 MySQL 애호가가 이제 PostgreSQL을 추천하는 이유. 실무 경험을 통해 발견한 PostgreSQL의 장점과 MySQL의 과거 문제점.

🔗 https://zenn.dev/catatsuy/articles/f3721135c6f8f6

#PostgreSQL #MySQL #Database #Zenn

marmelab web developer Thiery Michel shares in this article his use of PostgreSQL features that allow us to draw certain data validation logic away from the application layer, and into the database. The proposed solutions in some instances can be more elegant than a purely application layer data validation approach.

"9 Advanced PostgreSQL Features I Wish I Knew Sooner"

https://marmelab.com/blog/2026/02/23/do-you-know-psql.html

#programming #sql #postgresql #database #datavalidation

Quite interesting. https://datahike.io/notes/stratum-analytics-engine/
#database #analytics #postgresql

Mastering SQL Joins is essential for every data professional.
• Inner Join: Matching rows only
• Left/Right Inclusive: Keep all rows from one side
• Left/Right Exclusive: Keep non-matching rows
• Outer Inclusive: Combine all data
• Full Outer Exclusive: Return only non-matching rows

These joins turn raw tables into meaningful insights.

📕 https://ebokify.com/sql

📕 https://ebokify.com/ai-data-science

#SQL #DataAnalytics #Database #DataEngineering #BusinessIntelligence #LearnSQL #DataScience

📰 MySQLが好きな私が、今はPostgreSQLを勧めたい理由 (👍 132)

🇬🇧 A longtime MySQL user explains why they now recommend PostgreSQL for new projects, sharing insights from hands-on experience with both DBs
🇰🇷 MySQL을 오래 사용한 개발자가 이제는 PostgreSQL을 추천하는 이유. 두 DB를 실제로 사용한 경험을 바탕으로 한 인사이트 공유

🔗 https://zenn.dev/catatsuy/articles/f3721135c6f8f6

#Database #PostgreSQL #Zenn

TIL: Defining a default value within register_post_meta drives you crazy if you no more aware of that you did it. It still persists, even if it is not in the database or the object cache.

Found out around an hour later … 🥲

In the period where we both wrote our static web pages in HTML and the period where I wrote Dynamic webpages with database backends in the most simple HTML and JavaScript possible all websites were still fast.

The first is the netscape period. The second a few years later.

Somewhere down the line people started to use IDEs to code static websites. The programmers of the IDEs never imagined that people would abuse those environments in such a way.

Since those days it started to go down fast. It became catastrophic when people started to use yswyg HTML editors.

@rl_dane

#HTML #static #Dynamic #database #JavaScript #HTML5 #programming

:postgresql: Slides from our March 10th meetup are now available!

We had three great talks:

🔹 MobilityDB: Bringing Mobility Data Inside PostgreSQL
🔹 Scaling Semantic Models: Bespoke PostgreSQL Schemas at SaaS Scale
🔹 Percona Operator for PostgreSQL: An Honest Overview

Grab the slides here 👇
https://github.com/pgstef/postgresbe/tree/main/meetups/2026

Thanks to our speakers for sharing their knowledge! 👏

Stay tuned for upcoming events:
🔗 https://www.meetup.com/postgresbe

#PostgreSQL #Belgium #Database #OpenSource #Meetups

Quick question:

I'm building a tiny, lightweight service monitoring solution. Currently it's set up using SQLite. Should I make it compatible with some TSDB, like InfluxDB?

#prpject #selfohost #linux #development #database #sqlite #influxdb #question