faisal / redisql Goto Github PK

NOTE The Redisql project's documentation has been moved to http://code.google.com/p/alchemydatabase/

Redisql: A Hybrid Relational-Database/NOSQL-Datastore

Redisql is a full RDBMS and a full NOSQL datastore combined into one server
In Redisql, SQL Tables, Statements, and Data-types are supported. Redisql is built on top of the NOSQL datastore redis, supports all redis data-structures and commands and supports (de)normalisation of these data structures (lists,sets,hash-tables) to/from SQL tables. Redisql can also easily import/export tables to/from Mysql. Redisql is more than a data storage Swiss Army Knife, it is also extremely fast and extremely efficient w/ memory.

NOTE The Redisql project's documentation has been moved to http://code.google.com/p/alchemydatabase/

The code will still reside in github, but the documentation and issue tracking will be done in google code

QUICK HOW TO
BUILD:
1,) git clone git://github.com/JakSprats/Redisql.git
2.) cd Redisql
3.) make platform # platform can be "aix ansi bsd freebsd generic linux macosx mingw posix solaris"
RUN:
1.) ./redisql-server
EXPERIMENT (run from command line, some characters '(',')','*' must be escaped)
./redisql-cli CREATE TABLE test \(id int primary key, field TEXT, name TEXT\)
OK
./redisql-cli INSERT INTO test VALUES "(1,field1,name1)"
OK
./redisql-cli INSERT INTO test VALUES "(2,field2,name2)"
OK
./redisql-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/Redisql/blob/master/bash_functions.sh

GPL License

Copyright (c) 2010 Russell Sullivan <jaksprats AT gmail DOT com>

   This file is part of AlchemyDatabase

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

    AlchemyDatabase 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 General Public License for more details.

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

Dislaimer: this project is in no way affiliated w/ the "redis" project. The name RediSQL was used to illustrate that this project effectively combines "redis" and "SQL"
This project is being renamed "AlchemyDatabase" to avoid any confusion.
The renaming process will take some time to propagate through the various github repositories, website, blog, mailing-list, etc...