Turso

Create an Account

• Create an account here
• Complete the onboarding process
• Create a group in any location
• 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:

1. Install the CLI:

# macOS
brew install tursodatabase/tap/turso

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

2. Login

turso auth login

3. Show your databases

turso db list

4. Connect to your database

turso db shell notely-db

5. Run a simple SQL query

SELECT sqlite_version();

6. Create a test table:

CREATE TABLE test (
  id INT,
  name TEXT
);

7. Show the table:

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

8. Delete the table:

DROP TABLE test;

9. 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.