deltasql is a tool to synchronize databases with source code, which helps to keep database evolution under control. While developing mid-sized or big applications, developers make changes to the data model that go along with changes to the source code. From time to time, branches of source code are done to stabilize the code that will go to production. A sort of data model branch is also needed. deltasql provides a simple way to collect all scripts that change the data model and means to handle data model branches. The deltasql server runs on Apache and is backed by MySQL.
phpMyAdmin is a tool intended to handle the administration of MySQL over the Web. It can create, rename, and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data, and administrate one single database and multiple MySQL servers.
SymmetricDS provides file and database synchronization with support for multi-master replication, filtered synchronization, and transformation across the network in a heterogeneous environment. It supports multiple subscribers with one-direction or bi-directional, asynchronous data replication. It uses Web and database technologies to replicate data as a scheduled or near-realtime operation. The software has been designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
mysqlblasy is a Perl script for automating MySQL database backups. It uses "mysqldump" for dumping mysql databases to the files sytem. It was written with automated usage in mind. For example, it is silent during operation, and only produces noise on errors/problems. It rotates backups automatically to prevent the backup disk from getting full when the administrator is on vacation (or is lazy).
TinyButStrong is a template class for PHP that allows you to generate XML/HTML pages and any other files based on text source. The engine gives facilities to work with any databases, including in native PDO, MySQL, PostgreSQL, SQLite, PHP arrays, and more. It is possible to design templates using any visual editor (like Dreamweaver or FrontPage), and thus to make templates that are compatible with W3C standards for example. It features simple block management, useful display formats, conditional displaying for blocks and locators, remote XML/HTML attribute modification, a cache system, and the ability to include sub-templates and execute associated scripts. Plug-ins are supported since version 3.0.
eLabFTW is an electronic laboratory notebook system. Once installed on a server, every member of a lab can write up their experiments, upload files, manage a database of products (antibodies, chemicals, siRNA, papers, or whatever you want). It was created with usability and security in mind, is very easy to use, and has a long list of features specific to research life.
STK/Unit is a pure SQL testing framework for MariaDB and MySQL. Users can create Base Tests (Stored Procedures) which are part of Test Cases (databases) and, optionally, Test Suites (other Stored Procedures). Output is stored in internal tables. You can convert it to a human-readable string, valid HTML, or query some convenient views which group results. It can be used to test any SQL structure (tables, views, triggers, stored routines), as well as server upgrades or configuration changes.