What is Limbo?
According to the Limbo GitHub project, “Limbo is a work-in-progress, in-process OLTP database management system” developed by Turso, compatible with SQLite. You can think of this another version of SQLite written in Rust. You can read more about Limbo here.
Installing Limbo.
To install Limbo all you need to do is run the curl command below.
curl --proto '=https' --tlsv1.2 -LsSf \
https://github.com/penberg/limbo/releases/latest/download/limbo-installer.sh | sh
Code language: JavaScript (javascript)
If the above command is successful, you can run limbo in the Terminal to access SQL shell.
limbo
To create a database simple run
limbo <database-name>.db
Code language: HTML, XML (xml)
Exampe
limbo dingo.db
Code language: CSS (css)
Here is an example of SQL commands that you can run in the SQL shell.
limbo> CREATE TABLE users (id INT PRIMARY KEY, username TEXT);
limbo> INSERT INTO users VALUES (1, 'alice');
limbo> INSERT INTO users VALUES (2, 'bob');
limbo> SELECT * FROM users;
Code language: JavaScript (javascript)
That’s it folks!