Alchemy Database: A Hybrid Relational-Database/NOSQL-Datastore
RELEASE: 0.2_rc1

Project Home Page: http://code.google.com/p/alchemydatabase/

Alchemy Database is a full RDBMS and a full NOSQL datastore in a single server
Alchemy Database is a lightweight OLTP SQL server w/ full support for redis data-structures/commands. Datastore-side-scripting is provided by embedding Lua. Alchemy Database is also blazingly fast and extremely memory efficient.

  Speed is achieved by being an event driven network server that stores ALL data in RAM and achieves disk persistence by using a spare cpu-core to periodically log data changes (i.e. no threads, no locks, no undo-logs, no disk-seeks, serving data over a network at RAM speed)
  Storage data structures w/ very low memory overhead and data compression, via algorithms w/ insignificant performance hits, greatly increase the amount of data you can fit in RAM
  Optimising to the SQL statements most commonly used in OLTP workloads yields a lightweight SQL server designed for low latency at high concurrency (i.e. mindblowing speed).

QUICK HOW TO
BUILD:
1,) git clone git://github.com/JakSprats/Alchemy-Database.git
2.) cd Alchemy-Database
3.) make
RUN:
1.)  cd redis/src
2.) ./alchemy-server ../redis.conf
EXPERIMENT (run from command line, some characters '(',')','*' must be escaped)
./alchemy-cli CREATE TABLE test "(id int primary key, field TEXT, name TEXT)"
OK
./alchemy-cli INSERT INTO test VALUES "(1,'field1','name1')"
OK
./alchemy-cli INSERT INTO test VALUES "(2,'field2','name2')"
OK
./alchemy-cli SELECT "*" FROM test WHERE id BETWEEN 1 AND 2
1) "1,'field1','name1'"
2) "2,'field2','name2'"

Many examples can be found here: https://github.com/JakSprats/Alchemy-Database/blob/master/redis_unstable/src/bash_functions.sh

AGPL License

Copyright (c) 2010-2011 Russell Sullivan <jaksprats AT gmail DOT com>
ALL RIGHTS RESERVED 

   This file is part of ALCHEMY_DATABASE

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU Affero General Public License as
    published by the Free Software Foundation, either version 3 of the
    License, or (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU Affero General Public License for more details.

    You should have received a copy of the GNU Affero General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.