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 sqlzoo.com as a reference yor the sql stuff.
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.
A lot of these tutorials start from the position of selecting stuff.
None of them show you how to get around.
ls of the SQL.
I need that sweet visibility.