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.

The Boot.dev CLI requires you to be signed in to submit your solution!

Copy/paste one of the following commands into your terminal:

Run

bootdev run a9ea62bf-ff77-48c6-bc01-f0bc12297ef3

Submit

bootdev run a9ea62bf-ff77-48c6-bc01-f0bc12297ef3 -s

To run and submit the tests for this lesson, you must have an active Boot.dev membership

Using the Bootdev CLI

The Bootdev CLI is the only way to submit your solution for this type of lesson. We need to be able to run commands in your environment to verify your solution.

You can install it here. It's a Go program hosted on GitHub, so you'll need Go installed as well. Instructions are on the GitHub page.