🔍 Readyset's magical #SQL rewriting pipeline! Because clearly, the world needed another way to transform your queries into obscure gibberish, just so you can marvel at how slow your #database can still be. 🐢✨ Exciting times for anyone who enjoys endlessly talking about #query #optimization while nothing actually gets faster. 🚀💤
https://readyset.io/blog/how-readyset-rewrites-your-sql-inside-the-query-transformation-pipeline #Readyset #performance #tech #news #HackerNews #ngated
#database — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #database, aggregated by home.social.
-
-
RDS → EC2: cheaper, sure… but what about performance? 🤔
A real-world story of migrating a 500+ GB production #MariaDB database from Amazon RDS to self-managed EC2.
Replication, cutover, rollback, performance — and the actual cost impact.
-
An Iranian, an Egyptian and a French bourge walk into a database table.
ERROR 1406: Data too long for column 'first_name'
-
Welcome Liberatii as a Bronze sponsor of PGConf.EU 2026 in Valencia!
-
Full Guide to #PostgreSQL #Database Management in #cPanel Here's a comprehensive guide on PostgreSQL database management in cPanel accounts, designed for developers, sysadmins, or site owners using cPanel-managed hosting.
What is PostgreSQL?
PostgreSQL is an open-source, ...
Continued 👉
Full Guide to PostgreSQL Datab... -
How to Install #Osquery on #Ubuntu #VPS
This article provides a guide describing how to install Osquery on Ubuntu VPS.
What is Osquery?
Osquery is a lightweight, SQL-powered agent that lets you query your Linux system like a ...
Continued 👉 #database #selfhosting #selfhosted #opensource
How to Install Osquery on Ubun... -
📢 New #updates · 5 Oct #14
· Rocket.Chat 8.9.0 — Apps-Engine version bump
· Dozzle v11.3.0 — Added image update checks and container update pushes
· fluxer [email protected] — Added support for custom user roles
· lightdash 2.436.0 — AI agents now have customizable skills
· OpenCloud v8.1.0
· kroki v0.33.0 — Mermaid now uses ELK layout by defaultAll updates live on https://selfhost.directory
-
Aggregate CPU, memory, latency metrics into 5m buckets with PostgreSQL and psycopg2. 282 lines, advanced level. Full script at https://www.valtersit.com/python/time-series-data-aggregator-with-postgresql/ #python #database #postgresql
-
Show HN: Minigraf – An embedded, bi-temporal graph database in Rust
-
Techstrong IT's Mike Vizard covers the pgEdge Starfleet launch. Phillip Merrick on the goal, an easily accessible #Postgres instance to "build applications that can then be deployed on the same database that many IT teams run in production environments."
Developers can set up a fully functional instance in under two minutes, with an MCP server, RAG API & copy-on-write branching. Not exposed to the internet by default.
Read the coverage: 📖 https://techstrong.it/featured/pgedge-adds-postgres-database-service-to-improve-the-developer-experience/
-
ExplainDB: A Database System Built for Understandability
-
📢 New #updates · 5 Oct #10.1
· Tolgee v3.225.0 — Tomcat upgrade and Figma plugin update
More self-hosted updates → https://selfhost.directory
-
This Thursday (Oct 8th) I'm speaking at the Iceberg Europe Community #Meetup in #London! I'll present 🐘🧊 #ColdFront: transparent #Postgres data tiering to Apache Iceberg for the modern #Lakehouse. Come say hi! Or join online.
-
This Wednesday (Oct 7th) I'm speaking at the #London #PostgreSQL #Meetup! I'll present 🐘🧊 #ColdFront: transparent #Postgres data tiering to Apache Iceberg for the modern #Lakehouse. Hopefully see you there? Come and say hi!
RSVP: https://www.meetup.com/london-postgresql-meetup-group/events/316581290/
-
Last week we've published another implementation of our concept for running a map-based web application with reduced demand for resources.
The map is based on OSM and a small custom REST service is processing user feedback. But everything else is solely based on files served by a rather simple web server. This includes a mock of a database API built with our ConcreteDB.
-
We ported the original Doom to SQL
https://cedardb.com/blog/sqldoom/
Comments: https://news.ycombinator.com/item?id=49948300
#HackerNews #Doom #SQL #porting #gaming #programming #database
-
#ICE Has Been Dumping #Protester Photos Into a #Palantir #Database
#DHS agents not only tracked and intimidated people observing ICE activity in #Maine , but stored information about them in a Palantir-built database, newly unsealed court filings say.
#privacy #security #surveillance #facialrecognitionhttps://www.wired.com/story/ice-has-been-dumping-protester-photos-into-a-palantir-database/
-
How to Deploy #CloudBeaver on #Ubuntu #VPS
This article provides a guide demonstrating how to deploy CloudBeaver on Ubuntu VPS.
What is CloudBeaver?
CloudBeaver is a web-based #database management platform from the ...
Continued 👉 #selfhosted #letsencrypt #mariadb #certbot #ufw #selfhosting
How to Deploy CloudBeaver on U... -
How to Deploy #CloudBeaver on #Ubuntu #VPS
This article provides a guide demonstrating how to deploy CloudBeaver on Ubuntu VPS.
What is CloudBeaver?
CloudBeaver is a web-based #database management platform from the developers of DBeaver. It provides a browser-accessible interface for working with PostgreSQL, MariaDB, MySQL, SQL Server, Oracle, and numerous other databases without requiring ...
Continued 👉 https://blog.radwebhosting.com/deploy-cloudbeaver-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #letsencrypt #certbot #selfhosting #mariadb #selfhosted #ufw -
Stop using leaky auto-increment IDs. UUIDv7 is the modern standard for distributed systems. Learn how to engineer better databases. Explore at klytron.com #Database #TechExplained #SoftwareEngineering #Klytron
#Database #TechExplained #SoftwareEngineering #Backend #Klytron
-
📢 New #updates · 4 Oct #12
· Sunshine v2026.1004.122811 — Fixed Flatpak commands and updated dependencies
· windmill v1.823.0 — Service logs page redesigned
· surfsense v2.1.0 — UI tweaks, artifact cleanup, and export fixes
· fluxer [email protected] — Added support for new API endpoints
· lightdash 2.425.0 — AI file drag-and-drop supportBrowse everything at https://selfhost.directory
-
“Influence is not ownership.”
A very interesting interview with Anna Widenius and Kaj Arnö about open source governance, the future of MariaDB, extensibility, community contributions, Vector, DuckDB and more.
Worth a read 👇
-
A Cartesian join can take down a million dollar Oracle cluster in seconds. Here is how to find the query behind the TEMP tablespace explosion before your SAN melts. https://www.valtersit.com/guides/databases/oracle-db_when_bad_queries_explode_your_temp_tablespace/ #oracle #database #dba
-
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 ...
Continued 👉 https://blog.radwebhosting.com/install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #databasecluster #mysql #selfhosting #installguide #selfhosted -
MySQL's utf8 isn't UTF-8. It's 3-byte, so emojis and many CJK chars get truncated or throw error 1366. Here's how to migrate to real utf8mb4 without data loss.
-
📢 New #updates · 4 Oct #5
· Wekan v12.18 — Updated image processing and development dependencies
· fluxer [email protected] — Improved data processing efficiency
· MCSManager v10.19.0 — Added automatic updates and fixed bugsMore self-hosted updates → https://selfhost.directory