Timeline for Is SQL declarative?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 24, 2021 at 15:00 | history | tweeted | twitter.com/StackSoftEng/status/1418949107406843914 | ||
| Jul 24, 2021 at 12:34 | answer | added | JacquesB | timelinescore: 4 | |
| Nov 7, 2016 at 17:58 | comment | added | David Aldridge | "Is it the case that their is somewhere an ideal SQL DB that is much more declarative than all the rest but because it is that good one doesn't hear about it?" If there is something that gets close to this, then I suspect it is what some would call a "Truly Relational DBMS", which does not use SQL but instead has a more predicate calculus-based access language. | |
| Nov 6, 2016 at 17:15 | comment | added | gardenhead | There is no clear definition of a declarative programming language, and so it's meaningless to talk about. Some languages are higher-level than others, that's all. | |
| Nov 6, 2016 at 14:01 | answer | added | Insac | timelinescore: 10 | |
| Jun 17, 2013 at 12:56 | audit | Close votes | |||
| Jun 17, 2013 at 12:57 | |||||
| Jun 5, 2013 at 8:08 | vote | accept | Paddy3118 | ||
| Jun 4, 2013 at 12:34 | comment | added | Paddy3118 | @JustinC, it seems to be more than a detail given the preponderance of performance oriented SQL questions and tips for a supposedly declarative language? | |
| Jun 4, 2013 at 7:06 | comment | added | JustinC | Performance is an implementation detail. The performance of nearly any IN implementation could be comparable or better than EXISTS and JOIN if the query processor developers felt it was a priority. | |
| Jun 3, 2013 at 21:27 | history | edited | Paddy3118 | CC BY-SA 3.0 | Add Indices |
| Jun 3, 2013 at 21:16 | comment | added | Paddy3118 | Using similar reasoning I guess regular expressions are a more declarative method of expression as I rarely see performance questions answered by "you should write it this way to get better performance". I am wracking my brains and can half remember some question to do with negative look-behind or ahead assertions in a slow regexp where the answer was to rewrite the regexp in a different way to do the same in less time. | |
| Jun 3, 2013 at 20:47 | comment | added | Mason Wheeler | @FrustratedWithFormsDesigner: I know exactly what that means. select whatever from sometable where FKValue in (select FKValue from sometable_2 where other_value = :param). It should be trivial to see how to restate that with an exists or a join. | |
| Jun 3, 2013 at 20:46 | answer | added | Mason Wheeler | timelinescore: 31 | |
| Jun 3, 2013 at 20:34 | history | asked | Paddy3118 | CC BY-SA 3.0 |
