4 ms·
And how many non-technical users do you know who do this?
by manicennui 3y ago
And how many non-technical users do you know who do this?
- ako 3y agoAnd how many non-technical users do you know that write good javascript/java/.net/etc code?
- camgunz 3y agoI think SWEs think of databases only as a kind of generic persistence layer and aren't super interested in a lot of the details (more than one has said to me databases are just an implementation detail) or additional capabilities, which I think is a very limited view. Databases are essentially interpreters, just like Python or Ruby. They come with access to a multiuser persistence (etc) service or engine (super handy!) but offer all the affordances of other interpreters. In fact, plpython on PostgreSQL will just use the Python packages on your system. Do you have to read about it? Sure, just like all programming languages and platforms. But, interestingly, SQL was designed for non-technical analysts, so (to your point) it's more accessible than those others.
- ttfkam 3y agoMediocre coders fixate on algorithms. Great coders concentrate on data structures. SQL schema creation and maintenance is all about choosing the right data structures for the job at hand. If you neglect attention to your data structures, no algorithms will save you, and you really only have yourself to blame. It's a still to be learned and honed like any other.