MySQL

MySQL is a widely spread, multi-threaded, multi-user SQL database, developed by Oracle.

Arch Linux favors MariaDB, a community-developed fork of MySQL, aiming for drop-in compatibility. Oracle's MySQL was dropped to the AUR: mysql^AUR. Another fork aiming to be fully compatible is Percona Server, available as percona-server.

The InnoDB storage engine by Oracle was also forked by Percona as XtraDB. The fork is used by both MariaDB and Percona Server.

Graphical tools

phpMyAdmin — MySQL web interface, written in PHP.

https://www.phpmyadmin.net || phpmyadmin

MySQL Workbench — Unified visual tool for database architects, developers, and DBAs. Developed by Oracle and not guaranteed to work with MariaDB.

https://www.mysql.com/products/workbench/ || mysql-workbench

For tools supporting multiple DBMSs, see List of applications/Documents#Database tools.

Console tools

MyCLI — A terminal client for MySQL with autocompletion and syntax highlighting.

https://www.mycli.net || mycli^AUR

Programmatic access

gollark: Well, you have to drop quality a bit to pack 68 years into 3MB.

gollark: Yes. You swap the data for 7 with the data for 8, and it acts as if it is 8 because it's basically 8.

gollark: They're actually bigints with a lot of data and a reference count and stuff.

gollark: Python has a cache of integers between -5 and 127 or something.

gollark: ```python>>> import sys>>> from ctypes import *>>> memmove(id(7), id(8), sys.getsizeof(7))140001623574848>>> 78```

This article is issued from Archlinux. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.