FlameRobin

FlameRobin is a database administration tool for Firebird DBMS. New features of FlameRobin are as follows

• Support for trusted authentication
• Databases can now be recreated from existing registration info
• Transaction isolation level can now be selected in SQL editor
• Win64 port
• Allowed deleting from system tables (ex. to stop queries via MON$STATEMENTS)

Other features are

• lightweight (small footprint, fast execution)
• cross-platform (Linux, Windows, Mac OS X, FreeBSD, Solaris) 
• dependent only on other Open Source software 

Download

XAMPP

XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use - just download, extract and start.

The philosophy behind XAMPP is to build an easy to install distribution for developers to get into the world of Apache. To make it convenient for developers XAMPP is configured with all features turned on.

The default configuration is not good from a securtiy point of view and it's not secure enough for a production environment - please don't use XAMPP in such environment.

Since LAMPP 0.9.5 you can make your XAMPP installation secure by calling »/opt/lampp/lampp security. 

XAMPP is a compilation of free software (comparable to a Linux distribution), it's free of charge and it's free to copy under the terms of the  GNU General Public License. But it is only the compilation of XAMPP that is published under GPL. Please check every single license of the contained products to get an overview of what is, and what isn't, allowed.

Download

MonetDB

MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval. MonetDB often achieves a significant speed improvement for SQL  and XQuery over other open-source systems.

• MonetDB/SQL is relational database solution.
• MonetDB/XQuery is XML database solution.
• MonetDB Server is multi-model database server.

MonetDB achieves its goal by innovations at all layers of a DBMS, e.g. a storage model based on vertical fragmentation, a modern CPU-tuned query execution architecture, automatic and self-tuning indexes, run-time query optimization, and a modular software architecture.

Download

QuantumDB Eclipse Plugin

QuantumDB is a simple but powerful database access plug-in for the Eclipse Development Platform. QuantumDB allows you to:

• connect to databases using standard JDBC drivers
• review schemas, tables, views and sequences
• look up column, index and foreign key information
• issue ad-hoc queries or other SQL statements against the database
• manage, edit, and work with SQL files (*.sql)
• issue updates, deletes, and inserts using simple, easy-to-use wizards

QuantumDB works with any JDBC-complaint database, including:

• Adabas
• DB2
• DB2 on AS400
• HSQLDB
• Informix
• MySQL
• Oracle
• Pointbase
• PostgreSQL
• Sybase

Download

eLibrary

The eLibrary Project is an ebook organizer with tagging and search capabilities. It automatically downloads the book's cover image and info from the web, and displays them in a frienldy user interface. The book's info is downloaded using the ISBN, which you can be enter manually, or  let the application guess it. Guessing is done by either searching the book on google, amazon or (only for PDF) scanning the text for the ISBN, thus allowing you to quickly load books into the app.

More cool features:

• XML based Tag Tree which can be edit from within the UI or manually.
• Search & Sort by title, author and publisher.
• Directory monitor that scans for new books and automatically prompts to add them.
• Password pretected web access to your books from anywhere
• File Renaming of books by template

Download

SQuirreL SQL Client

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

The SQuirreL SQL client provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. A SQuirreL user can:

• easily view and edit data in any JDBC-compliant database,
• view the database’s meta-data,
• work with multiple databases on both local and remote machines,
• use a single, consistent interface to work with different database engines, and
• expand the tool’s capabilities and include DB-specific functionality using plugins.

The user can click on tables to view them and edit data, or use full SQL operations. Data can be viewed in read-only mode for safety, or in an editable mode where it may be modified by simply typing the new data into the table. All of the meta-data for the database (eg: data types, table column names, etc.) are accessible through SQuirreL. In cases where multiple types of database engines are being used (eg: Oracle, MySQL, PostgreSQL, etc.), the user does not need to learn multiple DB-management tools since SQuirreL-SQL provides a common mechanism for accessing them all. In those cases where a Database engine has nonstandard quirks, SQuirreL’s plugin architecture allows users to include DB-specific components to handle those operations. The plugin architecture also allows developers to create add-on functions that users may choose to include or not as they wish.

Download

Adminer

Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server

Features

• Connect to a database server with username and password
• Select an existing database or create a new one
• List fields, indexes, foreign keys and triggers of table
• Change name, engine, collation, auto_increment and comment of table
• Alter name, type, collation, comment and default values of columns
• Add and drop tables and columns
• Create, alter, drop and search by indexes including fulltext
• Create, alter, drop and link lists by foreign keys
• Create, alter, drop and select from views
• Create, alter, drop and call stored procedures and functions
• Create, alter and drop triggers
• List data in tables with search, aggregate, sort and limit results
• Insert new records, update and delete the existing ones
• Supports all data types, blobs through file transfer
• Execute any SQL command from a text field or a file
• Export table structure, data, views, routines, databases to SQL or CSV
• Print database schema connected by foreign keys
• Show processes and kill them
• Display users and rights and change them
• Display variables with links to documentation
• Manage events and table partitions (MySQL 5.1)
• Extensive customization options

Download

NeoDatis Object Database

NeoDatis ODB is a very simple Object Database that currently runs on the Java, .Net, Google Android, Groovy and Scala

To avoid Impedance mismatch overhead between Object and Relational worlds, give a try to Neodatis ODB. NeoDatis ODB is a new generation Object Database: a real native and transparent persistence layer for Java, .Net and Mono.

• Object because the basic persistent unit is an object, not a table.
• Native & Transparent because it directly persists objects the way they exist in the native programming language, without any conversion.
  

Using NeoDatis ODB as your persistence layer will let you focus on your business logic allowing storing and retrieving native objects in a single line of code. No more Relational to Object mapping is necessary, NeoDatis ODB just persists objects the way they are, no matter their complexity.

Download

Firebird

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

FREE LIKE A BIRD. Anyone can build a custom version of Firebird, as long as the modifications are made available, under the same IDPL licensing, for others to use and build on.

FREE LIKE FREE BEER. No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package.

The Firebird Project is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000.

Download

HSQLDB

HSQLDB is Lightweight 100% Java SQL Database Engine. HSQLDB is Java developers' best choice for development, testing and deployment of database applications. HSQLDB (HyperSQL DataBase) is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus many SQL:2008 enhancements. It offers a small, fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets) and a number of demonstration examples.

The product is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products. In its current version it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory, its flexibility and speed.

Download

phpMyAdmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Features

• Intuitive web interface
• Support for most MySQL features:

browse and drop databases, tables, views, fields and indexes

create, copy, drop, rename and alter databases, tables, fields and indexes

maintenance server, databases and tables, with proposals on server configuration

execute, edit and bookmark any SQL-statement, even batch-queries

manage MySQL users and privileges

manage stored procedures and triggers

• Import data from CSV and SQL
• Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others
• Administering multiple servers
• Creating PDF graphics of your database layout
• Creating complex queries using Query-by-example (QBE)
• Searching globally in a database or a subset of it
• Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
• And much more...

Download

KeePass Password Safe

KeePass is a free open source password manager, which helps you to manage your passwords in a secure way. You can put all your passwords in one database, which is locked with one master key or a key file. So you only have to remember one single master password or select the key file to unlock the whole database. The databases are encrypted using the best and most secure encryption algorithms currently known (AES and Twofish). KeePass is really free, and more than that: it is open source (OSI certified). You can have a look at its full source and check whether the encryption algorithms are implemented correctly. 

Features

• Strong Security
• Multiple User Keys
• Portable and No Installation Required
• Export To TXT, HTML, XML and CSV Files
• Import From Many File Formats
• Easy Database Transfer
• Support of Password Groups
• Time Fields and Entry Attachments
• Auto-Type, Global Auto-Type Hot Key and Drag&Drop
• Intuitive and Secure Clipboard Handling
• Searching and Sorting
• Multi-Language Support
• Strong Random Password Generator
• Plugin Architecture
• Open Source!

 Download