AlchemyDB is now Aerospike - visit us at http://www.aerospike.com

Alchemy Database: A Hybrid Relational-Database/NOSQL-Datastore

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

Latest Release Candidate: Feb 28, 2012: release_0.2_rc1: https://github.com/JakSprats/Alchemy-Database/tree/release_0.2_rc1

Alchemy Database is a low-latency high-TPS NewSQL RDBMS embedded in the NOSQL datastore redis. Extensive datastore-side-scripting is provided via deeply embedded Lua. Unstructured data, can also be stored, as there are no limits on #tables, #indexes, #columns, and sparsely populated rows use minimal memory.

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