/ posts

SQL Stuff (WIP)

🌱 This post is in the growth phase. It may still be useful as it grows up.


So, at the moment, I’m most interested in PlanetScale. So, this will be from the perspective of their CLI. But I expect to learn a lot of things general to SQL.

I found as a reference yor the sql stuff.

Basec setup

  • pscale auth login
  • pscale database create trash-fire

ok. i can only have one db on my free account. cool. but it can have 3 branches. so lets try to do some exploration in a branch.

  • pscale branch list chantastic
  • pscale branch create chantastic trash-fire

ok. let’s add like a first name or something.

  • create table names (id int not null primary key, name varchar(40));
  • pscale shell chantastic trash-fire
  • insert into names(id,name) values(1, "Michael");
  • select * from names


What’s the whole browser DB thing? IndexedDB

SQLite is on the mac by default. > sqlite3

Some things:

SQLite stuff


A lot of these tutorials start from the position of selecting stuff. None of them show you how to get around. The cd and ls of the SQL.

I need that sweet visibility.