Projects

MySQL

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.

HyperSQL Database Engine

hsqldb is a relational database engine written in Java with a JDBC driver that supports a subset of ANSI SQL:1999. It offers a small, fast database engine. Embedded and server modes are available. It includes tools such as a minimal Web server, in-memory query and management tools (which can be run ... [More] as applets or servlets, too), a test framework, PHP compatibility, Eclipse and NetBeans IDE compatibility, and a number of demonstration examples. [Less]

Ingres Database

Ingres Database is the open source database management system that can reduce IT costs and time to value while providing the strength and features expected from an enterprise class database. Ingres Database is a leader in supporting business critical applications and helping manage the most ... [More] demanding enterprise applications of Fortune 500 companies. Focused on reliability, security, scalability, and ease of use, Ingres contains features demanded by the enterprise while providing the flexibility of open source. Core Ingres technology forms the foundation, not only of Ingres Database, but numerous other industry-leading RDBMS systems a [Less]

Midgard2

Midgard2 is an Open Source Content Repository. It provides an object-oriented and replicated environment for building data-intensive applications for both web and the desktop. With Midgard2 you have generic way to define your own storage objects, that can then be queried and managed using ... [More] multiple programming languages and applications. This enables writing your CMS or project management tool using a repository-oriented architecture where the Midgard2 storage system acts as the central point of integration between various tools. Midgard2 is built on the GNOME stack of libraries like GLib and libgda, and has language bindings for C, Python and PHP. Communications between applications written in the different languages happen over D-Bus. [Less]

PyReplica

Simple Python-based PostgreSQL replicator using a master plpython trigger, signals, sequences, and a python client script See http://pgfoundry.org/projects/pyreplica/ for latest news and file releases

byron

Replicated network storage system. Targeting in storage large files. Based on Twisted.

golconde

Golconde (gŏl-kŏn'də) is a queue based replication solution for PostgreSQL written in Python 2.6. It is designed to be loosely coupled and rely upon existing enterprise messaging systems that have STOMP protocol support. Designed to scale easily and with multi-data center implementations ... [More] in mind, the application and message queues for distribution live outside of the database. By decoupling Golconde from PostgreSQL it is differentiated from existing replication solutions, moving the workload from the database tier, where CPU, RAM and IO overhead can be very expensive, to a commodity layer where the operational cost for performing the data distribution work is much less expensive. In a typical Golconde target database, the PostgreSQL operational overhead is similar to the canonical database write workload. The preferred method of operation is to use one of the Golconde client classes, currently available for PHP and Python. The Golconde client classes allow you to perform write level activity such as adding, deleting, setting and updating data. Example flow diagrams and code can be found on the GolcondeExamples page. Alternatively, you may use the golconde_util.py script to generate on update/delete/insert triggers which will kick off the data distribution cycle within PostgreSQL. You can see an example of this flow on the GolcondeTrigger page. It is designed to be modular, allowing for different behaviors based upon the target database, including a 2-phase commit like behavior on failure of distribution to any node. Because it is designed for eventual consistency and loosely-coupled operation, it is most similar to BASE as described by Dan Pritchett. Here is the presentation from pgCon 2009. Golconde is named for the famous painting by René Magritte. [Less]

django-multidb

In the current state of Django, Django does not support the multiple database in it's own ORM, so we try to make the Django to support the multiple database, especially in the read-write MySQL replication environment.

mysql-replace-tables-live

Sometimes you find yourself needing to replace tables on production servers. While the ideal solution is to take the server out of rotation and replace the table properly, that's not always feasible. By default, this app replaces the table layout (.frm file), the data (.MYD file), and indexes ... [More] (.MYI file). But the simplicity of Python allows you to customize it to meet your needs. MySQL is all about freedom and flexibility. This little app lets you make the most of it. [Less]