News for hackers. Stuff that matters.
Re:Your database skills are not 'good to have' by cogman10 on Monday April 01, 2024 @11:05AM (#39894900)
Wait... why?

Admittedly I'm mostly using MSSQL, but joining multiple tables seems a pretty natural thing to do (assuming you are joining on well indexed tables).

Re:Your database skills are not 'good to have' by Izkata on Monday April 01, 2024 @11:30AM (#39895197)
Table locks.

This is specific to the default MyISAM engine, where it locks all tables used in a query for the duration of the query. So two queries that touch the same table can't run concurrently.

You may never hit this as a problem if your queries are fast enough, but it is something to be aware of.

Re:Your database skills are not 'good to have' by cogman10 on Monday April 01, 2024 @11:35AM (#39895271)
Didn't MySQL switch to InnoDB as the default engine a long time ago (my googling says 2010)? Does InnoDB have the same limitations?
Re:Your database skills are not 'good to have' by Izkata on Monday April 01, 2024 @11:39AM (#39895331)
I actually didn't realize they switched (we're still on an ancient version and unable to upgrade for now).

InnoDB uses row-level locks, so it's extremely unlikely to cause such issues.

Re:Your database skills are not 'good to have' by erik_seaberg on Monday April 01, 2024 @03:42PM (#39898278)
InnoDB also supports transactions.