or, the âJOIN me for some funâ part.
i donât have too many things to comment on as far as databases go. theyâre probably my weakest area. (iâm open to suggestions!)
prisma is a simple layer to have your code interface with your db.
on the other hand, there are arguments against using ORMâs since they can add cruft to your queries. as mentioned in the JS section about using frameworks, in general, using a higher-level wrapper doesnât excuse you from learning how the underlying technologies works!
again, iâm ill-equipped to talk about dbâs. but here are some options on NoSQL to explore if youâre into that kind of thing:
(further reference on commands here.)
for when you canât use the GUI and have to use the command line.
show databases â like it says.use [database] â enter the context of a particular database.describe [table] â show the structure of a table.show create table [table] â show how a table is created. useful to get foreign key info.select * from [table] where [conditions] â select columns in a table.insert into [table] ('[column1]', '[column2]') values ('[value1]', '[value2]') â insert data into a table.delete from [table] where [conditions] â to remove rows in a table.exit â leave the program.