@siscia siscia released this Sep 24, 2018 · 6 commits to master since this release

Assets 6

This release adds a new command, the COPY command.

COPY overwrite a database into another.

It makes possible to easily save in-memory databases into disk or load disk-based databases into memory.

It is also quite useful for backups and to restore, not to mention that allow to initialize a database with a status.

@siscia siscia released this Jul 25, 2018 · 30 commits to master since this release

Assets 6

Now the SQL statements and queries have access to the Redis context,
which is necessary to invoke regular, redis command like HGET or SCAN.

These capabilities have been immediately exploited and we create a
virtual table that read redis hash(es).

The name of the virtual table is REDISQL_TABLES_BRUTE_HASH

Assets 6

This release does not introduce any new features but it does improve the performances significantly.

Moreover we are releasing for multiple platforms, notably for ARMv7 (Rasberry PI), for CentOS7 (Linux AMI on AWS) and of course for linux generic.

Finally we introduce also the TRIAL executable which can be freely downloaded and used, it provides all the functionality of the PRO version but it is limited for evaluation purposes, after ~2 hours it will shut down itself.

As always is possible to buy the commercial PRO version on our shop

@siscia siscia released this Apr 9, 2018 · 77 commits to master since this release

Assets 4

This is the first version to provide also the PRO packages.

This github release will not include executables that can be downloaded
from plasso1

This version comes with several improvements.

The API is still backwards compatible but we added two new commands:
REDISQL.QUERY and REDISQL.QUERY_STATEMENT

These commands behave exactly like REDISQL.EXEC and
REDISQL.EXEC_STATEMENT, but they accept readonly statements. A statement
that modifies the data is rejected by these new commands.

This allows us to mark those commands as readonly and to use them against
replicas/slave.

The PRO version includes:

  • blocking commands, just add the suffix .NOW
  • replication, allow AOF and master/slaves (cluster) support.

Also, several improvements to the internals have been made, and now the
code is cleaner and more maintainable.

Mar 19, 2018
Assets 5

Release v0.3.1, it enable by default foreign key support, fix a bug
in the management of errors and now we support 32 bit architectures.

@siscia siscia released this Dec 23, 2017 · 113 commits to master since this release

Assets 3

RediSQL is a module for Redis that embed a completely functional SQLite database.
RediSQL enables new paradigm where is possible to have several smaller decentralized databases instead of a single giant one.

In this release, we enable support for several SQLite modules, in particular: JSON1 and FTS{3/4/5} that greatly enhance the capabilities of RediSQL and of Redis.

Is now possible to manage JSON document in a native and very fast way, similar is possible to execute full-text searches.

A simple use of the JSON module is provided here: Build a small analytics system using RediSQL

As always is possible to download the compiled module here in binary form or to compile the overall module using cargo.

If you checkout this tag, you can compile with cargo build --features=community --release.
This is the last commit where you will need to use the --features options, from now on it will be automatic.

From now on we are also going to provide dockers images in the docker hub, the docker name is siscia/redisql:v0.3.0

@siscia siscia released this Dec 16, 2017 · 120 commits to master since this release

Assets 3

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.

@siscia siscia released this May 10, 2017 · 172 commits to master since this release

Assets 3

This release is the first one with real support for multi thread.