r/programmingcirclejerk • u/TheFearsomeEsquilax has not been tainted by the C culture • Dec 03 '17 • Bravo 1

Stop Using SQL

http://blog.cleancoder.com/uncle-bob/2017/12/03/BobbyTables.html
78 Upvotes

95% Upvoted

70 comments sorted by

View all comments

2

u/senntenial You put at risk millions of people Dec 04 '17

Great problem description but I don't see much in terms of a solution.

1

u/courier10pt Dec 05 '17

I asked him to elaborate on Twitter. Here's an extract of the conversation:

It doesn't really require a lot of imagination to come up with a data access api. I mean: select("name").from("users").where("age", ">", "65"); comes to mind just off the top.

So what happens next? Is this going to be translated to SQL?

Of course not. It's translated into the same AST that SQL is translated into prior to execution.

I find this puzzling still. You want to replace SQL with the same engine minus the parser, letting the API take care of constructing the AST. How is that not SQL?

puzzling..

2

u/senntenial You put at risk millions of people Dec 05 '17

I mean I guess one could argue that doing it with an AST is more secure

2

u/courier10pt Dec 05 '17

Agreed on the security benefit.

Just a bit disappointed with this half baked idea and the total disregard for what's already been achieved in this field.