Video: Adding a foreign key constraint to an existing #SQLite table using Database Workbench.

https://www.youtube.com/watch?v=ZnFf4sj8jro

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Bless your transactions by committing them with "amen" in @mariadb

https://mariadb.org/amen-statement-for-committing-transactions/

#AprilFools
#MariaDB
#Database
#Transaction

Video: Convert a #MySQL database to #PosgreSQL using Database Workbench.

https://youtu.be/L4nOo26CIdU

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

For our May meetup (that's the one after the next one) we have @mariadb_org as a host and they are also organising a hackathon! There are a few €500 Verkkokauppa gift cards as prizes for the best use of their new vector extension to @mariadb.

Deadline for sign up is Monday (31st). Find out more details via their announcement blog post, and join up on our Discord via https://helsinki-python.github.io

Video: Creating an #SQLite database with tables and foreign key relationships.
https://www.youtube.com/watch?v=w88NySp6Ydk

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Auch nett: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Wird vielleicht doch Zeit für tiefere Optimierungen an #mariadb…

Quick Clip: using #SQLite with Database Workbench
https://www.youtube.com/watch?v=9kD8JIUf14Q

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#databasetools #databasedevelopment #DatabaseWorkbench

Quick Clip: object list filtering in Database Workbench

https://www.youtube.com/watch?v=XseaNdp8oGM

#MySQL
#MariaDB
#SQLServer
#Oracle
#Firebird
#InterBase
#PostgreSQL
#NexusDB
#SQLite
#databasetools #databasedevelopment #DatabaseWorkbench

It's easy to use a #FirebirdSQL server and database with #DatabaseWorkbench - check the video here!
https://www.youtube.com/watch?v=ZCzW0Du2D-w

Join our AI Hackathon with MariaDB Vector: https://mariadb.org/ai-hackathon/ #ai #RAG #mariadb #OpenSource #relational #Database #Python

Report from the MariaDB Foundation Board: https://mariadb.org/report-from-the-board-2025-01/ #mariadb #opensource #relational #Database

14,6 GB Datenbank-Dump und in der ersten Zeile ist ein Eintrag, der den Re-Import verhindert.

Hab es gelöst bekommen, aber Not tut sowas nicht.

This month in MariaDB Foundation: Jan 2025: https://mariadb.org/this-month-2025-jan/ #mariadb #OpenSource #relational_database

Self-Hosting a Firefox Sync Server
https://blog.diego.dev/posts/firefox-sync-server/
#ycombinator #Firefox_Sync #Self_hosting #LibreWolf #Firefox #Syncstorage_rs #MariaDB #Reverse_Proxy #Caddy #Server_Management #Database #Docker #Open_Source

Am Wochenende werde ich mich also mal in die unendlichen Tiefen (Weiten?) der Berechtigungen einer #MariaDB Datenbank stürzen müssen.

Es muss doch möglich sein, #Friendica per #Portainer / #Docker zu installieren.

Store and compare embeddings with #MariaDB Vector Search

https://www.youtube.com/shorts/62Gitdx3uO0

As my #Friendica server, my-place.social, has grown to some 315 active users in just 5 months, I'm starting to hit up against #mariaDB limitations relating to the default memory manager, #MALLOC. This weekend I'm going to replace it with #jemalloc to reduce stalls, memory fragmentation issues, out-of-memory problems, and instability.

Friendica puts a lot of pressure on the database, mariaDB in this case, much more than Mastodon apparently does on PostgreSQL. My feeling is that the Mastodon developers have done much better database tuning.

But, none-the-less, the update must be done. This will be done on an Ubuntu server.

Does anyone who has changed the MariaDB or mySQL memory manager have any advice to share to keep me out of trouble?

BTW, #TCMalloc is not an option as other admins have reported crashes using it with Friendica.