5 ms·
Everyone should know how to query a DB, but network programming seems to me like a niche within a niche (systems programming). I have done tutorials on writing
by porknubbins 4y ago
Everyone should know how to query a DB, but network programming seems to me like a niche within a niche (systems programming). I have done tutorials on writing TCP or doing a server in C but never came anywhere close to writing that stuff in practice.
- throwaway8689 4y agoBut what do you call a query? I've seen joins described as 'advanced' in some places.
- porknubbins 4y agoI was thinking a basic SELECT X FROM Y WHERE Z Sql query that can be learned in a day by someone familiar with programming. I don’t know enough to know what qualifies as advanced.
- throwaway8689 4y agoThat's fair enough if your job is in front end or whatever and you just need to use a table or view that someone else built for you. I comment I read somewhere was that SQL goes from basic to advanced with nothing in between. It's a slippery slope of course: you start writing your own query and then you figure a more sophisticated query would be helpful and pretty soon you're having to care about optimisation and indexes.