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.