Database

Tubely's architecture is simple. We're using:

Golang to write the application
SQLite as a database. SQLite is a traditional relational database that works out of a single flat file, meaning it doesn't need a separate server process to run.
Later, we'll also use the filesystem and S3 to store large files

However, small structured data, like user records, will always live in the SQLite database.

Assignment

With the server running, create a Tubely account by entering the following email and password and clicking "sign up":

Email: admin@tubely.com
Password: password

We'll use these credentials for the entire course!

Install SQLite 3. The application is already set up to use SQLite, I just want you to be able to use the CLI to manually inspect the database.

# linux
sudo apt update
sudo apt install sqlite3

# mac
brew update
brew install sqlite3

Run sqlite3 tubely.db to open the database file (that should have been created automatically by the server when you started it). Run a select * from users; to see the users table. You should see yourself in there!
Type .exit to exit the SQLite CLI.

Run and submit the CLI tests.

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 967db7bd-f506-4f8b-acc3-e14ee24ff00c

Submit

bootdev run 967db7bd-f506-4f8b-acc3-e14ee24ff00c -s

Run the CLI commands to test your solution.

ls tubely.db
- Expecting exit code: 0
- Expecting stdout to contain all of:
  - tubely.db
sqlite3 --version
- Expecting exit code: 0

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.