Skip to content
This repository has been archived by the owner on Jul 11, 2021. It is now read-only.

v0.2.0 Add transaction and documentation

Compare
Choose a tag to compare
@siscia siscia released this 16 Dec 14:23
· 489 commits to master since this release

RediSQL is a Redis module that provides SQL capabilities to Redis. It works by embedding SQLite.

The dataset of RediSQL and of Redis are completely separated.

It is possible to create tables, insert data and query them.
The databases are quite small and it is even possible to use a single one for every user of your system.

Documentation can be found here: http://redbeardlab.tech/rediSQL/

In this release, we have added the possibility to run explicitly transaction to the rediSQL engine.

This means that is now possible to run complex statements like:

BEGIN;                    -- start an explicit transaction
INSERT INTO ...           -- insert some data into some table
CASE exp WHEN             -- check some condition
    ok THEN COMMIT        -- if everything is ok commit
    not-ok THEN ROLLBACK  -- otherwise rollback
END;

When using statements is now necessary to describe the parameters using the ?NNN notation where N is a digit. It is not possible to use only the ? notation for parameters.