Skip to content

Latest commit

 

History

History
156 lines (99 loc) · 2.86 KB

quickstart.mdx

File metadata and controls

156 lines (99 loc) · 2.86 KB
title description
Quickstart
Welcome to Turso! Get started with Turso in minutes.

In this quickstart you will learn how to:

  1. Install the Turso CLI
  2. # to Turso
  3. Create your first Turso Database
  4. Connect to Database Shell
  5. Replicate Database to another region

We'll be using the Turso CLI throughout this quickstart to manage databases, create replicas in other regions, and connect to the database shell.

brew install tursodatabase/tap/turso
curl -sSfL https://get.tur.so/install.sh | bash
curl -sSfL https://get.tur.so/install.sh | bash

The next command will open your browser to #:

turso auth #
turso auth login

Now create your first database in a location closest to you with the name my-db:

turso db create my-db

The Turso CLI automatically detected your closest region to create a database. It used this location to create a default "group" for your database, which you can inspect using the following command:

turso db show my-db

Congratulations, you created a database! Now connect to it with the shell command:

turso db shell my-db

Replace my-db with the name of your database if you named it differently.

Now create a table for `users` using SQL:
CREATE TABLE users (
  ID INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT
);

Then insert a row into the users table:

INSERT INTO users (name) VALUES ("Iku");
Finally, query for all `users`:
SELECT * FROM users;

When you're ready to move onto the next step, you'll want to to quit the shell:

.quit

Adding a database replica is an easy as adding another location to the "group" your database belongs to.

First, you can fetch a list of supported locations using the Turso CLI:

turso db locations

Pick a location for your database to replicate it to and pass the three-digit code to the groups locations add command:

turso group locations add default nrt

Congratulations! Your data is now replicated and closer to users in two regions.

You're now ready to connect your application to your database. Pick from one of the SDKs below to continue: