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.

Download

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

Download

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

Download

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.

Download

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.

Download

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:

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

Download

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.

Download

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.

Download

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.

Download

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.

Download

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.

Download