fosstodon.org is one of the many independent Mastodon servers you can use to participate in the fediverse.
Fosstodon is an invite only Mastodon instance that is open to those who are interested in technology; particularly free & open source software. If you wish to join, contact us for an invite.

Administered by:

Server stats:

8.8K
active users

#MySQL

13 posts11 participants0 posts today

Got Cobra working in Go for my db2xlsx project which exports a MySQL / MariaDB database structure to an Excel file.

Benefits:

Simplifies the parsing
Allows for sub commands
Supports mandatory arguments

Three issues closed as a result, and I'll be able to tackle two of the others based on the groundwork laid.

github.com/godev-uk/db2xlsx

Database structure export to XLSX. Contribute to godev-uk/db2xlsx development by creating an account on GitHub.
GitHubGitHub - godev-uk/db2xlsx: Database structure export to XLSXDatabase structure export to XLSX. Contribute to godev-uk/db2xlsx development by creating an account on GitHub.

Today's fun challenge:

Can't export a MySQL database using MariaDB mysqldump because the tools have now diverged too far

Can't install the MySQL mysqldump because it conflicts with the MariaDB one

Can't use the Docker MySQL image because it doesn't allow interaction (to provide the password)

Can't use the Docker MySQL image with an environment variable because that's ignored when redirecting output to a file

Альтернатива чатам с ИИ для анализа и оптимизации SQL запросов

Всем привет! Экспериментировал с оптимизацией SQL запросов в ChatGPT и Claude. В какой-то момент понял, что это превращается в одно и то же: Напиши промт → вставь SQL → подожди → поправь → повтори

habr.com/ru/articles/929730/

ХабрАльтернатива чатам с ИИ для анализа и оптимизации SQL запросовВсем привет! Экспериментировал с оптимизацией SQL запросы используя ChatGPT и Claude. В какой-то момент понял, что это превращается в одно и то же: Напиши промт → вставь SQL → подожди → поправь →...
#sql#mysql#mariadb

Tuyệt vời! Một cuốn sách mới hướng dẫn xây dựng database server tương tự PostgreSQL hoặc MySQL đã ra mắt. Bạn sẽ học cách tạo ngôn ngữ lập trình kiểu tường minh, thực thi SQL và hiểu rõ hơn về cấu trúc bên trong của các database thực thụ. Có bản xem trước miễn phí nữa đó!

#database #databaseserver #postgresql #mysql #lập trình #congnghe #database #databaseserver #postgresql #mysql #programming #technology

leanpub.com/build-a-database-s

LeanpubBuild a Database Server

On my the trash was not working anymore because the corresponding table was corrupt and could not be repaired. Deleted the table, recreated it with info from a mysql dump. Scary as hell, but now everything works again, even the files that were in the trash before reappeared in the GUI 😀

Deploying High Availability and Disaster Recovery MySQL on OCI like a devops
We all know MySQL InnoDB ClusterSet, a solution that links multiple InnoDB Clusters and Read Replicas asynchronously to easily generate complex MySQL architectures and manage them without burdensome commands. All this thanks to the MySQL Shell's Admin
lefred.be/content/deploying-hi