3 ms·
If you don't use UPDATE or DELETE, then you're treating SQL as a static-single-assignment language. This is pretty much what I do at work; we have massive quan
by sethg 18y ago
If you don't use UPDATE or DELETE, then you're treating SQL as a static-single-assignment language.
This is pretty much what I do at work; we have massive quantities of geographic and linguistic data that we have to translate to [REDACTED], and we do this by uploading it all into PostgreSQL and then running through a long sequence of "CREATE TABLE foo AS SELECT hairy_expression FROM bar;" statements.
- time_management 18y agoGood point. For the time it was written (1970s, I believe) the SQL language was way ahead of the curve compared to the languages being used in enterprise.