connormcd
Re:Ask HN: It's 2023, how do you choose between MySQL and Postgres?
on Thursday May 11, 2023 @11:47PM (#35911644)
(Full disclosure, I work for Oracle)
Anyone who says no investment has been into MySQL I suspect never took the time to read the features/release notes for MySQL 8
Re:Server side rendering is now good idea?
on Saturday January 07, 2023 @12:23AM (#34285488)
Check out APEX (apex.oracle.com).
Its been doing server side rendering for 20 years. If you got vaxxed in the USA, there's a good chance you used APEX to book your appointment.
Re:Ask HN: Do you use foreign keys in relational databases?
on Tuesday September 06, 2022 @07:37PM (#32744567)
What kind of lock contention is that? (In Oracle) you'd have to be (a) manipulating the values of a primary key and (b) choosing not to index the child FK column.
Even without (b) I'd be asking "Why are you altering primary keys?" because it pretty much aint a primary key anymore if you're doing that :-)
Re:Ask HN: Do you use foreign keys in relational databases?
on Tuesday September 06, 2022 @04:06AM (#32734318)
If you've got a bit of time to spare, here's a 30min walk through of physical design in the database. https://youtu.be/x0P4zAptTiA
In this talk, we start at 10,000 transactions per second, and just by altering the design we get to 20,000 transactions per second... all on a 5 year old laptop.
And at no time did we ditch any constraints (primary or foreign). The claim that you can't get performance with constraints on a database is a myth