
And since it is open source you can choose from many tools to interact with it. The benefit of sqlite is it is a single file. I haven't used it on Windows.Īn alternative I recommend would be SQLite (the database engine) and a GUI to sqlite. In my case I will be using TablePlus, but you can use other database management. Now that the database is created let's connect to it.

While there is no command in order to query the selected database in the current connection, the CLIENT LIST output shows, for each client, the currently selected database.Développer une API Rest avec NodeJS, Express et MongoDB: #5 MongoDB et Mongoose

Since the currently selected database is a property of the connection, clients should track the currently selected database and re-select it on reconnection. Commands operating atomically on a single database would not be possible with the Redis Cluster design and goals. In the case of a Redis Cluster, having multiple databases would be useless and an unnecessary source of complexity. When using Redis Cluster, the SELECT command cannot be used, since Redis Cluster only supports database zero. In practical terms, Redis databases should be used to separate different keys belonging to the same application (if needed), and not to use a single Redis instance for multiple unrelated applications.

However different databases can have keys with the same name, and commands like FLUSHDB, SWAPDB or RANDOMKEY work on specific databases. Selectable Redis databases are a form of namespacing: all databases are still persisted in the same RDB / AOF file. New connections always use the database 0.

Select the Redis logical database having the specified zero-based numeric index. Syntax SELECT index Available since: 1.0.0 Time complexity: O(1) ACL categories:, ,
