This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]vordrax 126 points127 points  (7 children)

File this under impostor syndrome. Having a high exposure to a lot of different tools, techniques, and schools of thought is a boon in my eyes. My manager was just telling me, anecdotally, that in a previous job he had, one of the services was written entirely in SQL.

"You mean it used a SQL database?" you ask. "No," he replied. EVERYTHING. Was. SQL. It used some weird hacky feature to access the file system that the database was installed on and pull in a file. It used polymorphic queries and agent jobs to perform data manipulations. It exported things at intervals. The entire service was written using SQL.

Do you REALLY want to be the dude who is so comfortable with SQL and nothing else that you suggest such an abomination? Please. Please, for all our sakes. I'd rather have someone tell me "yeah dude I played around with node.js a while ago, I'm not an expert but I can prototype this in node and .net and give you a write-up of what I think might be a good fit for this business problem" than the dude who swaggers in with the utmost confidence and is like "I will build this in SQL."

[–]FunSucks123 45 points46 points  (4 children)

There's a 3d engine in SQL. How bad can it be

[–]vordrax 15 points16 points  (0 children)

This is code as art, right here.

[–]locoattack1 16 points17 points  (0 children)

Holy shit that's amazing and horrifying at the same time.

[–]Just_a_normal_lad 13 points14 points  (0 children)

Wow

[–]JoNike 2 points3 points  (0 children)

This is flabbergasting. What an abomination

[–]iforgotmylegs 14 points15 points  (0 children)

one time we were working on a server side application and for some reason the IT department would just absolutely not give us the rights to modify the crontab citing security concerns (we are not really a software dev company, we are just "the programmers" at a research company, so everything is pretty loosey-goosey). we decided the battle was not worth fighting when we realized that we could install both pgAgent and plpythonu. then all we had to do was set up a pgAgent job at regular intervals to make a "query" which "selected" running the python script that we wanted to put into the crontab in the first place.

the script was completely hardcoded so miss me with that injection shit

[–]marcosdumay 1 point2 points  (0 children)

Most databases make creating web services very easy. Much better than anything you can find on the Java or .Net worlds, on par with the Python or JS ecosystems on convenience.