21 of the Best Free Linux Text Editors and 42 of the Best Free Linux Scientific Software (Read more)
Links:
Apache-logViewSQL a PHP frontend for mod_log_sql (formerly mod_log_mysql) which supports live viewing of Apache log data via MySQL. It provides the ability to drill down on live data as it comes in, and it also integrates with geoIP databases ASN RADIUS Admin ARA (ASN RADIUS Admin) is a Web application which provides a user-friendly interface for administering a FreeRADIUS database. It allows easy and efficient manipulation of users, groups, network access servers, and more. auth2db auth2db parses auth.log files and inserts details about logins into a MySQL database. It allows you to display in the shell or in a Web front-end the date and time, IP, username and service (ssh, smb, login, su, gdm, etc.) for each login. dbi4php php4dbi is a database abstraction layer for PHP. It is simple to use (a single file with a simple API) and lean enought to not bloat your PHP application. It provides a common API for accessing a variety of database systems. This allows you to develop your application without limiting it to working on just a single database. deltasql deltasql is a tool to synchronize databases with source code, which helps to keep database evolution under control. innotop innotop is a MySQL and InnoDB monitor that lets you view and manage what's happening inside your MySQL servers. Features include a top-like query list, a top-like InnoDB transaction list, and much more. This tool gives you a high level of insight into the inner workings of InnoDB. Irving Irving is intended to be the simplest and quickest way to get from a MySQL database schema to the beginnings of a PHP application. KInterbasDB KInterbasDB is a Python extension package that implements Python Database API 2.0-compliant support for the open source relational database Firebird and some versions of its proprietary cousin Borland® Interbase®. In addition to the minimal feature set of the standard Python DB API, KInterbasDB also exposes nearly the entire native client API of the database engine. migratedata migratedata allows you to write a simple XML file to define how to copy data from one database to another, and perform very simple transformations on the way. Mr. LDIF Mr. LDIF is a script that builds a seed LDAP authentication database. It's similar to the PADL Migration Tools, but includes support for porting Samba v3 users. mssqldump mssqldump.php is a PHP script that dumps a Microsoft SQL Server database into a SQL script. It can also dump a table into CSV format. myhttp Web Service Engine for MySQL is a storage engine for the MySQL database. It takes basic SQL and translates this through the engine interface into HTTP request methods. MyProfi MyProfi is a command line tool that parses MySQL query logs and outputs statistics for the queries found. Mysql PHP to PostgreSQL MySQL PHP to PostgreSQL is a program that takes a php page that uses mysql calls and changes them into PostgreSQL calls. This allows any website that was written in PHP for MySQL to run as a website written to run on PostgreSQL. MySqueaks MySqueaks is a PHP class that allows you to create MySQL statements with the flexibility of OOP and throws in a simple database interface as well. This means that you can create PHP objects to represent your database tables and use the various methods provided to select, update, or delete data. This also means that instead of having to write out a very long SQL query, you can simply convert the representation into a series of "steps", which can be easier to understand and debug. MySysop MySysop is a PHP tool with AJAX support for managing MySQL server settings and monitoring process, variables, and status. MyZipCodeDB MyZipCodeDB is a MySQL ZIP code database with a PHP locator. It integrates with existing location tables to provide locater functionality on any table that contains a 5-digit ZIP code column. There is no need to dump, reformat, and reload existing location data into a vendor-provided location table. PHP Mini SQL Admin PHP Mini SQL Admin is a light, standalone script for accessing MySQL databases. It is intended for Web developers and requires knowledge of SQL commands. php-sqlite3 php-sqlite3 is a PHP extension that lets you access SQLite3 databases within your scripts. phpDatabase.net phpDatabase.net is a pure PHP database script which can be used for an application as a light-weight database. It implements basic database functions like creating and dropping database; creating, changing, and dropping tables and sequences; selecting, inserting, updating, and deleting data from tables; automatic locking of files, so simultanous changing the data is possible; transaction processing, commiting, or rolling back of changes; and a default auto-commiting mode. pimentech-dbutils pimentech-dbutils provides a set of tools for designing a database in XML, computing the SQL database generation code and the diagram (in dot), and doing other useful tasks. Pork.dbObject Pork.dbObject is an Object-Relation mapper for PHP 5 that attempts to be easy, fast, and lightweight. It uses optimized database queries and provides an easy Find() function very loosely based on Rails'. In short, the O/R mapper handles all your SELECT, INSERT, UPDATE, DELETE, and JOIN statements so you won't have to write the same SQL over and over again. Pork.Generator Pork.Generator is a Web based tool to inspect your databases and generate Pork.dbObject based code. The generator analyzes the relations in your database by trying to match primary keys to fields of other tables. If you have created your table structure following some simple rules, this project can either create a complete CRUD (Create, Read, Update, Delete) interface into a .zip file, or just output your complete database schema into O/R mapped objects. Pork.dbObject is an Object-Relation mapper for PHP 5 that attempts to be easy, fast, and lightweight. Scaffoldr Scaffoldr is a PHP scaffold (skeletal) generator for MySQL databases. Just provide the connection credentials and the script will generate CRUD pages for you. schema-compare Schema-compare is a script that will compares two database schema and show the differences side-by-side. It can also generate SQL statements that will alter the old database to match the schema of the new database. SPT Relational Database Web Tool The SPT Relational Database Web Tool (RWT) is a simple application that can help developers connect to databases configured as a DataSource in the application server or directly through JDBC. The RWT application attempts to replicate basic features found in the popular Aqua Data Studio application. Per user settings (saved connection parameters, saved queries), single and batch query processing, a history browser, multiple query browsers, a tree view of database metadata, and other features are supported. Full source code is available. SQLBuster SQLBuster is a simple MySQL benchmarking utility that runs a query a specified number of times over a given number of threads and displays how long it took. SymmetricDS SymmetricDS is Web-enabled, database independent, data synchronization software. It uses Web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. Taggee Taggee is a scalable distributed tagging server. It features an HTTP interface making it usable from any application where tagging is needed. It can also be used as a standalone bookmark server with its HTML interface. Triplify Triplify is a small plugin for database driven Web applications which exposes RDF, Linked Data, and JSON. It is extremely simple to configure by providing some SQL queries and selecting the information to be exposed. It is complemented by a light-weight registry for RDF data sources. Ultimate MySQL Ultimate MySQL is a PHP class that provides an easy and powerful wrapper for MySQL database access. It can establish MySQL server connections, execute SQL queries, retrieve query results into arrays, retrieve the last inserted ID, manage transactions, retrieve the list tables of a database, retrieve the list fields of a table, retrieve the length of a field, measure the time a query takes to execute, display query results in an HTML table, and more. Vipaka Vipaka is a monitoring program along the lines of Big Brother for Oracle databases. It is able to monitor table space usage, fragmentation, hit ratios, and other information. XBlock-Reporter Xblock reporter is a set of PHP and shell scripts to insert an exported report from an 8e6 Xstop R3000 appliance into a database, and then output that in a searchable web based format. XMasDB XMasDB is a Christmas gift database which can record recipient names and gift ideas into a MySQL database, protected by a password. It also includes a tracker to see which gifts have been purchased and an option to export the data to MS Excel. XML Gateway The XML Gateway is a lightweight middleware system that allows end users or external systems to directly access / integrate with various data sources (including any SQL database and the Remedy AR System workflow platform) without the need to write specific C / C++ or Java code. XMLToaster XMLToaster is a tool that allows you to integrate relational databases with XML. It lets you to generate XML using the simplicity of SQL and to save XML into a database using a powerful mapping script. In situations where you want to generate XML quickly and easily, an XMLToaster solution can have you up and running in a matter of minutes. It also has the flexibility to handle mapping and persistence between database tables and very complex XML schemas. This is achieved using a simple yet powerful mapping script. XMLToaster XMLToaster is a tool that allows you to integrate relational databases with XML. It lets you to generate XML using the simplicity of SQL and to save XML into a database using a powerful mapping script.
