Links:
A_DBC Abstract Data Base Connector is an abstact OOP way to connect to several databases. Acquired Virtual Distribution AVD is a continuation of the swim project. The goal is to create a suitable SQL server from swim's not-installed DB, and to maintain the swim client. AVD will be used as a gBootRoot method. auth postgresql auth postgresql would provide the capability to keep all users info in a PostgreSQL database instead than in plain text files (as usually) and even more have a more performant system than NIS+. BabelQL BabelQL is a C preprocessor script that allows many different SQL dialects to be generated from a single source file. Broadcast Oracle Sql A Python/Perl/Ruby script useful to submit a SQL statement to several Oracle instances. Cacti Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG. cx_OracleDBATools Contains a number of Python scripts that handle Oracle DBA tasks in a cross platform manner. DataDiff DataDiff is a utility for comparing the contents of two identical sets of tables in MySQL and returning the rows that differ between the two. dba-dialog A dialog interface to the four major RDMS (Oracle, DB2, PostgreSQL and MySQL). It is written in bash, and uses the dialog and Xdialog facility to let a DBA perform various administration tasks. dbauth dbauth is a command-based utility used for creating, updating, removing and/or importing user's authenticated information such as: user IDs, passwords, groups and optionally comments, in a DB or DBM database format. dbauth supports three types of password encryption method and all types of Apache Limit directives. DBConsole DBConsole is a database shell that currently supports SQLite, PostgreSQL, and MySQL. DBD::InterBase A DBI driver for InterBase, written using InterBase C API. dbischema A database schema update and porting tool. dbischema is written in perl, it requires DBI, XML::Parser, and DBD::mysql, DBD::Pg or both. dbMan A simple SQL monitor for common database system (PgSQL, Oracle, MySQL etc.). It's based on Perl, Tk and DBI interfaces. dbo dbo is a database object relational mapper (ORM) written entirely in Python. Tables are represented using a straightforward python class and row instances are encapsulated as python instances. Joins, views, transactions, and more. DBOW DBOW is a database compiler-compiler or front-end. It takes table definitions in a meta language and prepares C, C++, PHP, Perl (etc) functions for manipulating the database. It will also produce SQL table data for MySQL. DBTCP DBTCP is a proxy server for ODBC connection. It allows you to make a query from a linux machine to a database in a Windows machine through ODBC. dbtool dbtool can be used to store and retrieve data in a key/value format in a hash database. Perl compatible regular expressions are supported both for storing and retrieving of data. It's main advantages are the ability to maintain huge amounts of data and speed. As of version 1.4 dbtool supports encrypted databases using the RIJNDAEL cipher algorithm. DbtuTools A collection of tools for IBM's DB2 UDB database. DiaDBDesigner DiaDbDesigner is a standalone module for constructing databases with the help of the diagram creation program Dia. In an easy to use environment you can join multiple diagrams together to form one model of interconnected tables. Dumpgdbm Dumpgdbm is a batch or interactive tool which can dump keys and data from a GNU DBM file. It can display data in ASCII, decimal, hex, and octal formats. Posix regexp search functions are also provided. ElyCA ElyCA is a certification authority (as well known as CA) written in Python released the General Public License (GPL) which provides an easy to use web interface to generate private keys, certificates, pkcs#12 and CRLs. Emacs Photo Database Emacs Photo Database provides functions for managing a collection of photographic films, negatives, and prints stored in a SQL database. It is targeted at fine-art photographers and other people who use a wet-process workflow instead of digital imaging. EMS MySQL Manager (commercial) EMS MySQL Manager is a powerful tool for MySQL® Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It offers plenty of powerful tools for experienced users to satisfy all their needs. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it. EMS MySQL Utils (commercial) Provides powerful data management utilities for MySQL Server, which make your work with the server much easier and faster. Currently MySQL Utils include MySQL Export - a powerful tool for MySQL data export, and MySQL Import - an utility for quick importing data to MySQL tables. EMS PostgreSQL Utils (commercial) Powerful data management utilities for PostgreSQL Server, which make your work with the server much easier and faster. Currently PostgreSQL Utils include PostgreSQL Export - a powerful tool for PostgreSQL data export, and PostgreSQL Import - an utility for quick importing data to PostgreSQL tables. eRServer (commercial) Enables PostgreSQL database users to improve the performance, data integrity, and distribution of information through: Query Distribution & Load Leveling, Master to Slave Replication, Master to Multi-Slave Replication. FileExtender FileExtender is a Perl script to evaluate embedded SQL statements in any kind of text file (incl. HTML files) and extends these files with results from the database queries. Freedbtool Freedbtool is a component of the Cjukebox music management system. It is a commandline tool for accessing the freedb.org database. It supports both download and upload of database files via the http version of the protocol. It also includes a modified version of Jeremy D. Zawodny's discid program Gentry GTK Entry: a program to do data entry into a MySQL database using an GTK GUI application. GreenSQL GreenSQL is a database firewall used to protect databases from SQL injection attacks. GreenSQL works in a proxy mode and has built-in support for MySQL. The logic is based on evaluation of SQL commands using a risk scoring matrix as well as blocking known DB administrative commands (such as DROP and CREATE). GTK DBF Editor GTK DBF Editor is a simple DBF editor built with GTK+. It allows basic editing of DBF (dBase) files. HandySQL HandySQL is a perl interface for MySQL. It connects directly to MySQL server, not using DBI/DBD and Mysql-msql modules. The main routines are written in C, and the top-level object-oriented interface is done in perl. HashMan Database Tool A tool for managing GDBM, traditional DBM and Berkeley/Sleepycat DB hashfiles. Database through a command line interface or an interactive terminal based interface. IMDbPY IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about both movies and people. Platform-independent and written in pure Python (and few C lines), it can retrieve data from both the IMDb's web server and a local copy of the whole database. InnoInfo InnoInfo is a small command-line utility to analyze and dump data from innodb databases. It works completely seperate from MySQL and accesses the innodb data files directly. It can also be used to recover data from broken innodb stores. JasperETL JasperETL is a complete and ready-to-run data integration platform for organizations of all sizes, providing high performance data extract-transform-load (ETL) capabilities. JasperETL is appropriate for all analytic and operational data integration needs, regardless of complexity. When used as part of the JasperSoft BI Suite, organizations can develop, manage, and document data integration processes for more accurate, more comprehensive reporting and online analytical processing (OLAP) with JasperReports, JasperServer, and JasperAnalysis. JDB A package of commands for manipulating flat-ASCII databases from shell scripts. JDB is useful to process medium amounts of data. KESI KESI is a tool to easily import CSV files into your SQL database tables. CSV files can be created using almost every spreadsheet and lots of other applications (E.g. KSpread). KESI can be configured to understand almost every possible CSV format. Additionally it is very easy to use, because of its KDE GUI. KFreeDB KFreeDB is a KDE interface to the FreeDB CD information database. It allows you to query the FreeDB disc database and also submit discs yourself. It is one of the very few applications that supports submitting by HTTP protocol. kmysqladmin kmysqladmin manages mysql-servers written with QT and KDE. KSqlAnalyzer The KSqlAnalyzer is a tool for easy accessing the data of a MS-SQL-Database. It is made for developing and testing new SQL-Query's direclty on the Server. The functionality and the look&feel are similar to the program 'SQL-Query-Analyzer' written by Microsoft. libdejector Libdejector is a database tool which defeats SQL injection attacks by performing context-free validation of queries. While written in C, SWIG wrappers exist for Python and other languages will be following soon. mtop mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided. MyLUA A patch to MySQL that allow users to write procedures in a scripting language called LUA. mylvmbackup mylvmbackup is a Perl script for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. MySQL Activity Report The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes. MySQL Backup MySQL Backup is written in Perl. It uses mysqlshow to grab the database names and "show tables" to grab the table names for a user's account, and then uses mysqldump to save the data in a subdirectory named in the script. It then tars and gzips the files, using the date and time for the file name. It can be run from cron on a daily basis. MySQL Cluster Administration Tools The MyCAT project is a toolset for managing MySQL/Linux servers, and could be helpful for anyone managing a network of *nix servers whether running MySQL Cluster, standard replication, or not running MySQL at all. MySQL High Availability clustering MySQL High Availability clustering is a set of scripts and programs that provide a high availability database cluster using MySQL replication. It is transparent to client applications, as the cluster uses a shared logical IP to provide the service. mysql_auth An authentication module for the Squid proxy server to authenticate users on an mysql database. The database is a single table, and the table is a very simple user-password pair, with plain or encrypted passwords. MySQL_CBN A script that check, periodically the tables of a MySQL Server. Using the BACKUP, CHECK, OPTIMIZE and ANALYZE, the script checks if everything is ok and alert you if anything is wrong. mysqlconf mysqlconf is a Linuxconf module to help you configure MySQL database. It currently supports basic configuration like creating/destroying databases and users. It also allows to configure a few parameters in the my.cnf file. mysqldiff mysqldiff is a Perl script front-end to the CPAN module MySQL::Diff which compares the data structures (i.e. table definitions) of two MySQL databases, and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch). mysqldoc mysqldoc is a command-line tool for auto-documenting MySQL schemas. Output formats include XML, HTML, and TXT. mysqldoc takes COMMENT arguments and translates them into useful formats. NdeX A command line utility for fast binary searching sorted flat file constant databases. Partial key searches and files with tab delimited fields are supported. The archive, ndex.tar.gz, consists of the ANSI Standard C sources for the ndex program, and the rename, program that can be used to update a database, without locking, in a multiuser environment. Object Relational Membrane The Object Relational Membrane is a Python package that provides the functionality of an object relational layer like EJB or other persistence storage systems. It is a thin compatibility layer between SQL table layouts and Object Oriented Python. While providing a good deal of functionality, it tries to be as small and simple as possible. It currently works with PostgreSQL, Firebird and MySQL. odbc-bench OpenLink ODBC Bench is an open-source ODBC Benchmarking tool providing real-time comparative benchmarking for ODBC Drivers, Database Engines, and Operating Systems combinations. OpenFTS OpenFTS (Open Source Full Text Search engine) is an advanced PostgreSQL-based search engine that provides online indexing of data and relevance ranking for database searching. Close integration with database allows use of metadata to restrict search results. PEAR MDB PEAR MDB is a merge of the PEAR DB and Metabase php database abstraction layers. It provides a common API for all support RDBMS. The main difference to most other DB abstraction packages is that MDB goes much further to ensure portability. pgdiff pgdiff compares the structures of two PostgreSQL databases and returns the differences as a sequence of SQL commands which can be fed to psql to transform the structure of the first to be identical to the second (analagous to diff and patch). PgSqlClient PgSqlClient is an ADO.NET Data provider for PostgreSQL 7.4+ written in C#, 100% managed code, for use with MS .NET and Mono:: platforms, with support for the 3.0 protocol of PostgreSQL. PostGIS PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. Postgresql AutoDoc A utility which will run through PostgreSQL system tables and returns HTML, Dot, Dia and DocBook XML which describes the database. PostgreSQL Table Log PostgreSQL Table Log allows to track changes on a specific table. protosquared A "data server prototype". It supports several data sources, such as XML and SQL databases and the communication protocol is highly configurable too. psycopg psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0, being thread safe at level 2 and providing some very usefull extensions like the user-defined type casters. pxview pxview is a program to read Paradox DB files. It is based on the pxlib library. pxview allows to output csv for reading with spread sheets, sql to import into a relational database, html and sqlite. pybliographer Pybliographer is a tool for managing bibliographic databases. It can be used for searching, editing, reformatting, etc. In fact, it's a simple framework that provides easy to use python classes and functions, and therefore can be extended to many uses (generating HTML pages according to bibliographic searches, etc). Python Schema Diff Python Schema Diff is a python-based tool which permits to give the differences between two database schema. Its HTML rendering makes it easy for sharing this useful information among a team. Querylog Querylog is a console tool for performing SQL queries on a (log) files. Lines from one or more text files or stdin are matched, using regular expressions to an in memory database on which SQL queries can be performed. Round-Robin SQL Round Robin SQL (RRS) is a SQL implementation of a round robin database. Ruby Dataquery Shell RDQS is a shell for querying various datasources such as SQL from a common interface. It does/should offer different data outputs, syntax highlighting, (grammatical) completion, shell interaction (e.g. backticks) and programmability. scrmgr SCRMGR is a curses-based (text screen or 'console') screen manager and data entry system. It makes heavy use of "softkey labels" and "softkeys" (a.k.a. function keys F1-F10) to guide the user. ShellSQL ShellSQL is a suite of programs designed to enable LINUX/UNIX shell scripts to connect to SQL engines and execute SQL queries and commands in a simple way enabling intergration with the rest of the script. Simple DB The general idea of simple-db is to wrap the native client API of the database system into as thin a layer as possible and to provide the simple and uniform API to the upper levels. Skeleton Engine for MySQL Skeleton Engine for MySQL is a full framework to plug in a new storage engine. It comes with prebuild autoconf files, and a full framework to plug in your own design. The AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine. SkunkDB SkunkDB is a collection of tools to deal with skunk databases. The aim is to create a library, support tools, and a format suitable for high-speed data retrieval. The database is a static key -> value mapping. The databases cannot be inserted into, or deleted from. They are designed to be created once and queried many times. SQL Load Balancer The SQLB project is used to improve SQL requests to a database. It provides programs that have permanent connections to a DB, a program that checks the integrity of transactions, and a library to link with programs that need to make SQL queries. SQLIer SQLIer takes an SQL Injection vulnerable URL and attempts to determine all the necessary information to build and exploit an SQL Injection hole by itself, requiring no user interaction at all (unless it can't guess the table/field names correctly). By doing so, SQLIer can build a UNION SELECT query designed to brute force passwords out of the database. sqlmap sqlmap is an automatic blind SQL injection tool, developed in python, capable to enumerate entire remote database, perform an active database fingerprint and much more. The aim of this project is to implement a fully functional database mapper tool which takes advantages of web application programming security flaws which lead to sql injection vulnerabilities. SybSQL SybSQL is an easy-to-use X11 (Qt) based SQL editor that helps you compose, execute SQL commands and view or save results. SybSQL supports connections to Sybase Adaptive Server Enteriprise as well as MS SQL 6.5 ( not tested on SQL 7.) The MySQL Sandbox MySQL Sandbox is a tool for installing one or more MySQL servers in isolation, without affecting other servers. tyserv A DBMS for UNIX-like systems. It has isam-like access, transaction control, rollback, commit, exclusive lock, access control by client IP address, and user authentication. If you like old but simple database programming environments like COBOL+VSAM(KSDS) or C+C-ISAM, you will like Tyserv. umbrello2sql umbrello2sql reads a umbrello entity relationship diagram and generates the correspondent SQL instructions to create a PostgreSQL database. Universal Data Access Driver Suite A collection of utlities for ODBC and JDBC Driver benchmarking, and Data Access API implementation diagnostics. XQuare Bridge XQuare Bridge expands existing relational database functionalities with advanced XML import/export capabilities. It supports flexible extraction and publishing of relational data into any target XML format, using the XQuery language. Using a powerful mapping language, it can also perform efficient insertion of structured XML data into existing relational tables, while taking into account the database integrity constraints and transforming the implicit relations appearing in the XML document into explicit ones in the database. XQuare Fusion XQuare Fusion is a powerful information integration engine for querying in real-time multiple, heterogeneous and distributed data sources. Using XML-based data sources federation, it presents to applications a single, uniform XML view of all business information, which can then be queried with XQuery to produce XML documents. ZeosLib The main ZeosLib product is a set of native datasets and database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle, DB/2 for Borland compilers such as Delphi, C++ Builder and Kyli ZFireBirdDA A python module needed as an interface between Zope and Kinterbasdb to access Firebird databases.
