RediSQL – A Redis module that provides a functional SQL database
1–10 of 60 posts
Re: RediSQL – A Redis module that provides a functional SQL database
#2science has gone too far
Re: RediSQL – A Redis module that provides a functional SQL database
#3Author here, if you have any question please feel free to ask.
Also I have introduced the module in a blog post here: http://redbeardlab.tech/2016/12/13/redisql
Re: RediSQL – A Redis module that provides a functional SQL database
#4[deleted]
Re: RediSQL – A Redis module that provides a functional SQL database
#5Where does it save the data? Just in a blob in Redis? Does it support replication? How about persistence - - can I use standard Redis persistence? I'm kinda new to modules in Redis.
Definitely could use this for migration off SQLite to a solid DB.
Re: RediSQL – A Redis module that provides a functional SQL database
#6Where does it save the data? Just in a blob in Redis? Does it support replication? How about persistence - - can I use standard Redis persistence? I'm kinda new to modules in Redis. Definitely could use this for migration off SQLite to a solid DB.
Just update the readme.
For now it works in memory, after Saturday it will save data in a standard SQLite file.
Replication and SQL are fairly tricky beast together. What is your use case?
Re: RediSQL – A Redis module that provides a functional SQL database
#7Where does it save the data? Just in a blob in Redis? Does it support replication? How about persistence - - can I use standard Redis persistence? I'm kinda new to modules in Redis. Definitely could use this for migration off SQLite to a solid DB.
This is the source: https://github.com/RedBeardLab/rediSQL/blob/master/rediSQL.c
> Where does it save the data?
It doesn't
>> in-memory database.
> Does it support replication?
That's really, really unlikely, because you can't do that on the sqlite VFS layer.
> migration off SQLite to a solid DB.
This is SQLite (in redis).
Re: RediSQL – A Redis module that provides a functional SQL database
#8Author here, if you have any question please feel free to ask. Also I have introduced the module in a blog post here: http://redbeardlab.tech/2016/12/13/redisql
Can I use this to atomically delete thousands of existing keys? Is there a way to map the new SQL tables to existing keys? Or is this strictly for new SQL data tables?
Re: RediSQL – A Redis module that provides a functional SQL database
#9Author here, if you have any question please feel free to ask. Also I have introduced the module in a blog post here: http://redbeardlab.tech/2016/12/13/redisql
Can I use this to atomically delete thousands of existing keys? Is there a way to map the new SQL tables to existing keys? Or is this strictly for new SQL data tables?
This is a SQLite in-memory database running inside the redis service. It doesn't interface with the redis database.
Re: RediSQL – A Redis module that provides a functional SQL database
#10Where does it save the data? Just in a blob in Redis? Does it support replication? How about persistence - - can I use standard Redis persistence? I'm kinda new to modules in Redis. Definitely could use this for migration off SQLite to a solid DB.
This is the source: https://github.com/RedBeardLab/rediSQL/blob/master/rediSQL.c > Where does it save the data? It doesn't >> in-memory database. > Does it support replication? That's really, really unlikely, because you can't do that on the sqlite VFS layer. > migration off SQLite to a solid DB. This is SQLite (in redis).
Replication is always tricky do to it right.
The very first and naive solution would be to simply stream all your statements to the slaves.