SQL is 43 years old – Here’s why we still use it today

Re:SQL is 43 years old – Here’s why we still use it today by cwyers on Tuesday May 02, 2017 @11:46AM (#14247334)

I don't really get this. ALTER TABLE ADD COLUMN X is a cheap operation when your database is small, at least on decent hardware. It's when you get up to scale that it starts being a burden. During the rapidly-evolving stage is when it should be the easiest to alter database schemas, because you shouldn't have accumulated all that much data yet.

[ Parent | on HN ]

Re:SQL is 43 years old – Here’s why we still use it today by PhineasRex on Tuesday May 02, 2017 @07:17PM (#14251583)

I work at a company with multi-gigabyte tables and ALTER TABLE is still easy to pull off, we just use tools the community has built for larger tables. It's one of the most unfounded fears I've heard in the industry.

[ Parent | on HN ]

Re:SQL is 43 years old – Here’s why we still use it today by batmansmk on Tuesday May 02, 2017 @11:56AM (#14247453)

And... if you accumulate a lot of data,you may mostly access it in an aggregated way, such as GROUP BY. where ALTER TABLE ADD COLUMN X is free.

[ Parent | on HN ]