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
database
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 😬
RunAs Radio Show 1027 - SQL Server in 2026 with Bob Ward and host Richard Campbell
To celebrate SCaLE 23x (@socallinuxexpo), I’m giving away 5 digital copies of my book, PostgreSQL Mistakes and How to Avoid Them (published by @ManningPublications). Enter the giveaway below!
👇
https://kingsumo.com/g/3l5ron1/postgresql-mistakes-and-how-to-avoid-them-scale-23x-ebook-giveaway
#SCaLE23x #Giveaway #PostgreSQL #Postgres #Books #OpenSource #Database
The good news: #DuckDB now includes #Geometry as a built-in type, a major step forwards for this #database engine.
The bad news: it stores #Geographic #Coordinates backwards, with #longitude first. Beware of interoperability with other software.
Mark your calendars! PGConf.EU 2026 will be held on October 20-23, 2026, in Valencia, Spain.
Hettie Dombrovskaya "PostgreSQL and Academia: Establishing Partnership"
at @socallinuxexpo
Livestream 👉 https://www.youtube.com/live/yu1bCaoH-UI?si=6OVLEIFf-pFslkW0
#PostgreSQL #Postgres #Academia #OpenSource #SCaLE23x #Database
Edited 7d ago
Slides from my talk CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes at SCaLE 23x → https://vyruss.org/computing/slides/scale23x_cloudnativepg.pdf
#CloudNativePG #SCaLE23x #Postgres #PostgreSQL #Kubernetes #K8s #CloudNative #Database #OpenSource
Edited 7d ago
RE: https://fosstodon.org/@vyruss/116104664061886548
At 11:15 Pacific Time (20:15 CET), I'll be presenting @CloudNativePG at @socallinuxexpo ! Livestream link below!
👇
🔴 https://www.youtube.com/watch?v=ZqEkuN2rIGc
#PostgreSQL #OpenSource #Postgres #CloudNativePG #Kubernetes #K8s #Database #scale23x
Edited 8d ago
SQLite 3.52 fixes a WAL-reset database corruption bug and introduces CLI improvements, new SQL functions, and query planner optimizations.
https://linuxiac.com/sqlite-3-52-released-with-wal-corruption-fix-and-cli-improvements/
Nick Meyer and Practical PgBouncer Pain Prevention – #PostgreSQL @ SCaLE live now! https://www.socallinuxexpo.org/scale/23x/presentations/practical-pgbouncer-pain-prevention
- Hello, I would like admin privileges on my database because I use a "No code" framework and I would like to be free to change the schema whenever I want and don't depend on your team to prod
- How about no?
If the schema needs to be changed every day on prod, you need to stabilize it first because schema changes are not transparent. If they don't often lock, they can cause i/o spikes.
It's even more important if you use ORMs, "No code" framework or even AI where you, or the ops/DBA team don't even know what's under the hood. When things go bad, we'll be on-call. Will you?
Git in Postgres
"Instead of using git as a database, what if you used a database as a git?"
Years ago I created a #php #mysql #comics #database
https://sourceforge.net/projects/madcollector/
DM me If you'd be interested in reviving it.
Next Friday at @socallinuxexpo, let's take the fear out of running databases on #Kubernetes! I'll be showing you how the @CloudNativePG operator makes creating a highly available, self-healing #PostgreSQL architecture incredibly easy, even if you aren't an expert. Come hear my talk at SCaLE (use code SPK23 for 50% off), or catch the live stream online! 
☸️☁️
#CloudNativePG #Postgres #OpenSource #Database #CloudNative #CNCF #SCaLE23x #K8s
How do you guys design a DB from scratch? I sometimes ask for an excel example just to get an idea on how the users visualize data and from there get the basics of the schema.
Database Design Doesn't Start With Table. It Starts With Consequences
https://thetshaped.dev/p/database-design-foundations-backend-engineers-mistakes-and-lessons
Edited 19d ago
I can post 3000 character toots
#FediVerse #Mastodon #field #database #AU #social #socialmedia #federated #network #protocol
Edited 24d ago
Redis 8.6 in-memory data store is out with performance and latency improvements, alongside reduced memory usage across core data structures.
https://linuxiac.com/redis-8-6-improves-throughput-by-more-than-five-times-over-redis-7-2/
I call bullshit on #CE & #DHS welcoming body cams.
They like em b/c they can use facial recognition on images caught, then put all who've been ID'd on a watch list or worse. The rest go into a permanent #database to be used in future by them or anyone they choose to share em with.
Making the Police State stronger, not making US safer.
Dear Fedi,
Please find me a case, where there is a federated database. The data should be kept private for each company/participant, but all of them should be able to access the data and for example conduct research with it, without being able to pinpoint back to the original data&its owner. Technically this should be doable with a federated system.
Do you know if such system exists? Let me know, from any field and from anywhere in the world.
🤔 Random question for devs who work or have worked on backends with an underlying relational database.
Do you know what a database transaction is? What about isolation levels?
If you know about them, have you used them, or just know they're a thing?
I'll make this a poll, but since the options are limited, if you could provide extra context in the comments, that'd be great!
#SoftwareDevelopment #Backend #Sql #Database
Options: (choose one)
What can Inka Quipus teach us about data management?
A blog post about the ingenious methods used by the ancient Inca culture to encode information and what insights we might draw from them today for #datascience
The value of metadata, human readibility, schema flexibility and append-only #database? Its all there 🤓
https://www.openriskmanagement.com/what-inka-quipus-teach-us-about-data-management/
I was wondering why does SQL Server have the keyword `ISNULL`, when it already supports `COALESCE`. This was getting in the way of my queries working both for Postgres and SQL Server. As it turns out, `ISNULL` predates `COALESCE`, which was added to the standard with ANSI SQL-92.
But this is not all, there are functional differences as well in how data types are handled by both functions in SQL Server. More info at https://www.mssqltips.com/sqlservertip/2689/deciding-between-coalesce-and-isnull-in-sql-server.
In general I decided to always go with `COALESCE` and see how that works out with SQL Server as I go further on with adding Postgres support to our product.
New Blog Post: pg_statviz 0.9 has been released, with plenty of new features!
https://vyruss.org/blog/pg_statviz-0.9-released.html
#PostgreSQL #Postgres #extension #pg_statviz #database #stats #statistics #visualization