DEV Community

Darryl Dias
Darryl Dias

Posted on • Originally published at darryldias.me on

Install Turso Limbo on Linux

#tutorials #linux #database #sqlite

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
Enter fullscreen mode Exit fullscreen mode

If the above command is successful, you can run limbo in the Terminal to access SQL shell.

limbo
Enter fullscreen mode Exit fullscreen mode

To create a database simple run

limbo <database-name>.db
Enter fullscreen mode Exit fullscreen mode

Exampe

limbo dingo.db
Enter fullscreen mode Exit fullscreen mode

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;
Enter fullscreen mode Exit fullscreen mode

That's it folks!

Top comments (0)