This lesson's interactive features are locked, please to keep using them

Turso

Turso is a cloud provider that specializes in hosting serverless SQLite-like databases (technically it's their fork, libsql). It's a great fit for Notely because it has a very generous free tier, and it's easy to use.

Assignment

Create an Account

Create an account here
Complete the onboarding process
Create your first database with the name: notely-db

Install and Configure the Turso CLI

Here's the full quickstart guide in the Turso docs, but in a nutshell:

Install the CLI:

# macOS
brew install tursodatabase/tap/turso

# Linux / WSL
curl -sSfL https://get.tur.so/install.sh | bash

Note that you may need to restart your shell to make sure the changes have taken effect.

turso auth login

Show your databases

turso db list

Connect to your database

turso db shell notely-db

Run a simple SQL query

SELECT sqlite_version();

Create a test table:

CREATE TABLE test (
  id INT,
  name TEXT
);

Show the table:

SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;

Delete the table:

DROP TABLE test;

Exit the shell with Ctrl+C.

This SQL shell is a great way to manually interact with your database for debugging purposes, but our server will of course interact with it programmatically.

Run and submit the CLI tests from the root of your repo.