Free Software - Projects [Database]: 2009

SQLTools for Oracle

SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of sql utilities. You can use it for dial-up connection and it will work as fast as SQLPlus. It is small and not required an installation so SQLTools will help you anywhere because it is small enough for floppy and available for downloading on the Web. SQLTools is free and probably going to be a public source project.

SQLTools is:

Powerful editor (actually it'll be more powerful in the next release), which supports drag & drop, syntax highlighting, code template expansion, etc. It is possible to find a database object under cursor and get its description. Context sensitive help provides information about the current sql statement.
SQL console, which is embedded in the editor. It supports DML & DDL statements and provides additional information about database statistics and timing.
Object Browser is designed for getting any object DDL definition. One of useful features is support group operations, for example, you can select and disable a set of constraints in one operation.
Extract Schema utility, which loads all objects definition and stores on local disk.

Druid: The Database Manager

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate:

HTML documentation: for all tables, with browsing facilities
PDF documentation: for all tables
Java classes: (one class for each table) that contain tables' constants (such as fields size) plus java code added by the user
A data dictionarythat contains all tables and fields present in the database
SQL script which contains all table definitions that can be piped to the DBMS
And much more info...

SQLiteManager

SQLiteManager is a multilingual web based tool to manage SQLite database.

All features:

Management of several databases (Creation, access or upload)
Management of the attached databases
Create, edit and delete tables and indexes.
Insert, edit, delete records in these tables
Management of the View, possibilities of creating a view from a SELECT
Management of Trigger
Management of the users defined functions, these functions are in continuation usable in the requests manual, as in the form of insertion/modification of data
Manual request and from file, it is possible of defined the format of the requests, sqlite or MySQL; a conversion is doing in order to directly import a MySQL base in SQLite.
Importing of records from a formatted text file
Export of the structure and the data
Choice of several displau skin

DataVision

DataVision is an Open Source reporting tool similar to Crystal Reports. Reports can be designed using a drag-and-drop GUI. They may be run, viewed, and printed from the application or exported as HTML, XML, PDF, Excel, LaTeX2e, DocBook, or tab- or comma-delimited text files. The output files produced by LaTeX2e and DocBook can in turn be used to produce PDF, text, HTML, PostScript, and more.

DataVision is written in Java and runs almost anywhere. It can generate reports from databases or text data files. Any database with an available JDBC driver should work: Oracle, PostgreSQL, MySQL, Informix, hsqldb, Microsoft Access, Progress, and more. Columns read from text files can be separated by any character.

Report descriptions are stored as XML files. This means you can not only use the DataVision GUI but you may also edit reports using your favorite text editor.

iSQL-Viewer

iSQL-Viewer is an open-source JDBC 2/3 compliant database front end written in Java. It implements across multiple platforms features of the JDBC API. It does everything through a single interface.

iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix. iSQL-Viewer provides a variety of tools and features to carry out common database tasks. It includes:

A friendly SQL console for executing SQL statements

Database and schema viewing and browsing
Compatible with major database vendors
SQL Bookmarks to store SQL commands you commonly use
SQL History to see and retrieve SQL commans previously executed
Enhanced user interface support across platforms

iSQL-Viewer is designed to meet the needs of JDBC Driver developers and database developers who work in single or multi-platform environments.

Middlegen

Are you tired of the headaches involved with editing deployment descriptors and entity bean source code? Middlegen is a free general-purpose database-driven code generation engine based on JDBC, Velocity, Ant and XDoclet. If you already have a database, you can use Middlegen to generate.

Persistance layer with EJB (CMP 2.0)
Persistance layer with JDO
Persistance layer with Hibernate
Persistance layer with Torque
Database GUI with JSP/Struts

Developping database-driven applications with Middlegen is easy:

Create the database with your preferred database modeler tool
Configure Middlegen to access the database and read the database schema
Run Middlegen from Ant, and (optional) with the GUI tool, rename tables and columns, tune relationships and type-mappings
Generate your source code with Middlegen
Run XDoclet to generate the additional files like EJB homes and interfaces, and deployment descriptors
Compile and deploy your application

eXist-db

eXist-db is an open source database management system built using XML technology. It stores XML data according to the XML data model and features efficient, index-based XQuery processing.

eXist-db supports many (web) technology standards making it an excellent platform for developing web based applications:

XQuery 1.0 / XPath 2.0 / XSLT 1.0 (using Apache Xalan) or XSLT 2.0 (optional with Saxon)
HTTP interfaces: REST, WebDAV, SOAP, XMLRPC, Atom Publishing Protocol
XML database specific: XMLDB, XUpdate, XQuery update extensions (to be aligned with the new XQuery Update Facility 1.0)

The 1.4 version adds a new full text index based on Apache Lucene, a lightweight URL rewriting and MVC framework as well as support for XProc. Most important, the XQuery engine has seen a major redesign, resulting in improved performance.

eXist-db is highly compliant with the XQuery standard (current XQTS score is 99.4%). The query engine is extensible and features a large collection of XQuery Function Modules.

eXist-db provides a powerful environment for the development of web applications based on XQuery and related standards. Entire web applications can be written in XQuery, using XSLT, XHTML, CSS and Javascript (for AJAX functionality). XQuery server pages can be executed from the filesystem or stored in the database.

Sequel Pro

Sequel Pro is a database management app for MySQL databases. Sequel Pro supports importing and exporting data from popular files including CSV and XML. Sequel Pro started as a fork of the abandoned CocoaMySQL project, with future plans to expand to other database engines including SQLite and PostgreSQL.

Pilot-DB

Pilot-DB is a freeware (OpenSource) database program for the Palm OS (any version and any hardware) and compares with the best commercial programs available. It supports the field types string, boolean, integer, float, calculated, date, time, note, list and link. Plug-Ins are available for Mobile-DB and JFile databases, for access to the built-in DateBook, for external memory card access and for customizable colours. Overlays are available for various occidental and oriental languages.

There are various third-party tools to create, edit, and export PilotDB-files or to import various formats such as CSV, Excel, ASCII files and Staroffice files on the desktop.

MySQL Connectors

MySQL provides standards-based drivers for JDBC, ODBC, and .Net enabling developers to build database applications in their language of choice. In addition, a native C library allows developers to embed MySQL directly into their applications.

MAMP

The abbreviation "MAMP" stands for: Macintosh, Apache, Mysql and PHP. With just a few mouse-clicks, you can install Apache, PHP and MySQL for Mac OS X!

MAMP installs a local server environment in a matter of seconds on your Mac OS X computer, be it PowerBook or iMac. Like similar packages from the Windows- and Linux-world, MAMP comes free of charge.

MAMP is installed in the typical Mac fashion: very easily. MAMP will not compromise any existing Apache installation already running with your OS X. You can install Apache, PHP and MySQL without starting a script or having to change any configuration files!

Furthermore, if MAMP is no longer needed, it is sufficient to delete the MAMP folder and everything returns to its original status (i.e. MAMP does not modify any of the "normal" OS X).

MAMP is a combination of free software and thus it is offered free of charge. MAMP is released under the GNU General Public License and may thereby be distributed freely within the boundaries of this license.

HeidiSQL

HeidiSQL is a free MySQL front-end. It is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface.

HeidiSQL now uses a more lightweight database layer to access MySQL servers. This completely new written layer consists of just two units and replaces the big ZeosDBO package - which worked well over the years, but I felt that here and there developping new features regarding the libmysql API was a pain.

VertrigoServ

VertrigoServ has been developed as a highly professional, easy to install package consisting of Apache (HTTP web server), PHP (reflective programming language), MySQL (multithreaded, multi-user, SQL Database Management System), SQLite (ACID-compliant relational database management system), SQLiteManager (multilingual web based tool to manage SQLite database), PhpMyAdmin (tool written in PHP intended to handle the administration of MySQL) and Zend Optimizer (which increases runtime performance up to 40%) for Windows platform. With a convenient all-in-one installer, all components are installed in a single directory and can be used immediately after the installation process has completed. An uninstaller allows you to remove the VertrigoServ from hard disc. It is designed to be as small and flexible as possible and is therefore highly suitable for internet distribution. VertrigoServ is excellent both for beginners and for advanced users.

Uniform Server

The Uniform Server is a WAMP package that allows you to run a server on any MS Windows OS based computer. It is small and mobile to download or move around and can also be used or setup as a production/live server. Developers also use The Uniform Server to test their applications made with either PHP, MySQL, Perl, or the Apache HTTPd Server.

The Uniform Server is a lightweigt server solution for running a web server under the WindowsOS. 8.78MiB! It includes the latest versions of Apache2, Perl5, PHP5, MySQL5, phpMyAdmin and ... NO INSTALLATION REQUIRED! NO REGISTRY DUST! Just UNPACK and RUN!

TOra

TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.

In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.

ZeosLib

The ZeosLib is a set of database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite for Delphi, FreePascal/Lazarus, Kylix and C++ Builder.

MySQL

The MySQL database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use. It's used on every continent -- Yes, even Antarctica! -- by individual Web developers as well as many of the world's largest and fastest-growing organizations to save time and money powering their high-volume Web sites, business-critical systems and packaged software -- including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, and Zappos.com.

Not only is MySQL the world's most popular open source database, it's also become the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.) MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving you the kind of flexibility that puts you in control.

Whether you're new to database technology or an experienced developer or DBA, MySQL offers a comprehensive range of certified software, support, training and consulting to make you successful.

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

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.

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.

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

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

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.

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

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.

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.

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.

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...

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!

Subscribe to: Posts (Atom)