chive is an open source & web-based MySQL management application that is built with PHP.

It can achieve the most common tasks like creating, editing & executing:

• databases
• tables
• indices, keys, triggers, views, routines
• privileges management
• import/export

The application has a built-in editor with syntax-highlighting which is nice when running complex queries & an easy-to-use interface that makes browsing fast.

chive has one major fallback (which may pr may not effect you): it only supports MySQL 5+.

AeroSQL is an open source web application, for managing MySQL databases.

It can control databases from different servers in a single, desktop-like interface where records can be easily browsed or edited within a grid.

The application displays every query executed & can run a batch of sql queries to save you time.

It is possible to select the columns to be displayed while editing a table which will help reaching the data in an organized way.

AeroSQL is built with PHP & uses ExtJS to provide the desktop-like functionality.

Almost every web developer has a favorite database that he/she feels comfortable working with as all the tricks & gimmicks are already experienced.

It can be one of the popular databases below:

• MySQL
• PostgreSQL
• MSSQL
• SQLite
• MS Access

or even simpler ones like XML, text, etc.

It is understandable why these databases are frequently used; they are well-documented, have a community behind them, integrated with most popular CMSs', easy-to-use, offered by most of the hosting companies ,etc..

But there are also many other databases which are getting popular day-by-day & may have advantages over what you're already using.

Here are 25+ open source alternative databases that you may consider using in your next project:

MongoDB

It is an open source, high-performance, scalable, schema-free & document-oriented (JSON-like data schemas) database.

There are ready to use drivers for most popular programming languages like PHP,Python, Perl, Ruby, JavaScript, C++ + more.

Hypertable

Hypertable is a high performance distributed data storage system designed to support applications requiring maximum performance, scalability, and reliability.

It is modeled after Google's BigTable and mostly focuses on large-scale datasets.

Apache CouchDB

A document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript.

CouchDB offers a RESTful JSON API which can be accessed from any environment allowing HTTP requests

Read the rest of this entry »

Sypex Dumper is an open source web application for creating instant or automated backups of MySQL databases.

It is built with PHP, has an Ajaxed interface & can restore databases as well.

The application can work with gb-level huge databases as it easily bypasses the timeout limits of PHP by pausing/starting backup jobs.

Sypex Dumper can optionally check, optimize & repair tables or automatically delete older backups to save space.

It has support for file compression (Gzip and Bzip2) & offers a multilingual interface.

DHX Quick Tables is a 1 file PHP script that enables anyone to create a customized backend for MySQL databases with 2 screens:

• for guests: just view the tables
• for administrator: view, edit, add/delete pages

The script comes with a web-based installer that guides you to define the database connection information.

After that, you can customize the fields of the database by selecting if they can be sorted, edited, in which order they will be displayed & more.

DHX Quick Tables is very functional who wants to build an instant backend for their applications or create an interface that will display a tabular data.

Crystal is a database toolkit for PHP which aims to help developers build & scale reusable, database-dependent, framework-agnostic applications.

It has 3 independent components:

• Database wrapper – for CRUD operations
• Validation module – provides a comprehensive data validation
• Database manipulation module – used for creating databases, tables, etc.

The queries written with Crystal are database-independent which currently supports MySQL & PostgreSQL (SQLite is on the way).

For anyone who is familiar with SQL, learning Crystal wouldn't take no more than 5 minutes.

And, for many developers, it can be an option against framework-specific database layers like Zend_Db and Codeigniter's active record library or complex ORM's like Doctrine.

nuBuilder is an open source web application for quickly creating web-based back-ends.

It allows you to create forms for inserting-updating data & generates reports with that data.

The back-ends are created with PHP/JavaScript & the data is stored in a MySQL database.

nuBuilder can be used to create complex applications like accounting systems or simple lists like customer phone numbers.

It  has built-in components like permissions, search screens & data validation that makes the development process faster.

The application can be expanded with modules & plugins.

nuBuilder is also a handy application for web developers who create a web-app & want to put it online as quickly as possible without spending time on building the back-end for it (at least for a while).

Sequel Pro is a free MySQL management tool for Mac OS X.

It offers full table management (including indexes), supports MySQL views, imports/exports from SQL/CSV files & compatible with MySQL 3/4/5 databases.

The application supports SSH tunnel connections besides standard local & remote connections for reaching databases behind firewalls.

It can connect to multiple databases at the same time, offers automatic syntax highlighting for your custom queries, supports ~30 different encoding options & much more.

P.S. The project is open source & you can check the source for improving it further.

While creating web applications, finding data we need can be a very difficult process. Whether it is a signup page that requires all countries/cities or a "restaurants directory" which needs the data of restaurants.

Factual is a website which can be a quick solution for reaching data. It is a free-to-use platform where anyone can share & mash open data on any subject.

There are lots of different data tables provided like:

• Video Games & Cheats
• Popular Books of the 1990s and 2000s
• Hiking Trails
• American Idol Finalists
• Beer Qualities
• & much more

It is possible to view the data in a table form, make changes, filter or export as a CSV file. Also, all data can be reached via Factual API which we’ll probably be seeing lots of applications built around it.

Mysql Ajax Table Editor is an open source web application for easily editing MySQL tables & creating admin pages almost instantly.

Besides the standard "add, edit, copy, delete, view" functionality, records can be paged, searched & exported to CSV.

It is possible to JOIN multiple tables to generate a custom view (+ apply any other functions on this view) with the help of a configuration file. Also, column names displayed can be customized for a better presentation.

MySQL Ajax Table Editor has permissions support which can be set on a per column or table basis for limiting functions.

Users can hide/show & re-order columns which is very useful when working with the data.

The application works with both PHP4 & PHP5 and comes with 5 ready-to-use languages where new ones can be created.