Post A0a5wPkQbI04LsGprU by pxi@bsd.network
(DIR) More posts by pxi@bsd.network
(DIR) Post #A0ZrrWtlBltzirPcJ6 by alexbuzzbee@fosstodon.org
2019-07-14T02:19:58Z
0 likes, 1 repeats
What's the worst abuse, misuse, or disuse of SQL you've ever seen?
(DIR) Post #A0ZsTxV0jh2fEBA04e by alcinnz@floss.social
2020-10-27T05:48:03Z
0 likes, 0 repeats
@alexbuzzbee I find `ORDER BY RANDOM()` very useful, does that count?
(DIR) Post #A0ZsrSztnCTPZtok08 by alexbuzzbee@fosstodon.org
2020-10-27T05:52:19Z
0 likes, 0 repeats
@alcinnz I'm afraid not; that's just a way to shuffle the output of a query. There are plenty of legitimate reasons to do that. Think crazier.
(DIR) Post #A0ZsxZ6hzOWOGTuW5w by alexbuzzbee@fosstodon.org
2020-10-27T05:53:25Z
0 likes, 0 repeats
@alcinnz The kind of stuff you might see labeled as a programming horror story.
(DIR) Post #A0Zt4BYtvcghGeFoxc by alexbuzzbee@fosstodon.org
2020-10-27T05:54:37Z
0 likes, 0 repeats
@alcinnz I can't even think of any good examples because my brain insists on thinking of the right way to do things...
(DIR) Post #A0ZtGIcPWAj4d0fjCC by alexbuzzbee@fosstodon.org
2020-10-27T05:56:48Z
0 likes, 0 repeats
@alcinnz I guess SELECT * FROM giant_table or SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED are sort of good, if boring, examples.
(DIR) Post #A0ZtIssveR0ZgZdB9k by alexbuzzbee@fosstodon.org
2020-10-27T05:57:18Z
0 likes, 0 repeats
@alcinnz Oh no I should sleep
(DIR) Post #A0Zts2Iod3RH1rV7Wi by cinebox@cybre.space
2020-10-27T06:03:37Z
0 likes, 0 repeats
@alexbuzzbee my dad using it to store JSON
(DIR) Post #A0ZtvrHFYw0XzdaiUS by zens@merveilles.town
2020-10-27T06:04:17Z
0 likes, 1 repeats
@alexbuzzbee
(DIR) Post #A0a5wPkQbI04LsGprU by pxi@bsd.network
2020-10-27T08:18:51Z
0 likes, 0 repeats
@alexbuzzbee not a query, but still crazy. I once heard someone (it might of been you!) talk about an API returning a full SQLite file with the query results inside.
(DIR) Post #A0a62XUyhDQm7zxrXM by pxi@bsd.network
2020-10-27T08:19:20Z
0 likes, 0 repeats
@alexbuzzbee not a query, but still crazy. I once heard someone (it might have been you!) talk about an API returning a full SQLite file with the query results inside.
(DIR) Post #A0aEizSRvxb4dbXESO by ekaitz_zarraga@mastodon.social
2020-10-27T09:57:17Z
0 likes, 0 repeats
@alexbuzzbee let me tag @eider here to see what she got.
(DIR) Post #A0azpjTQSOVgw6hz16 by julio@toot.ear7h.net
2020-10-27T18:45:07Z
0 likes, 1 repeats
@alexbuzzbee I think I remember reading about a db table being used as a global lock; like you'd insert a row as a "lockfile"
(DIR) Post #A0azwQhce5S4kJXgGG by alexbuzzbee@fosstodon.org
2020-10-27T18:46:21Z
0 likes, 0 repeats
@pxi I've mentioned that idea before, but only as a joke.
(DIR) Post #A0b00Bawl1YZ35D8hk by alexbuzzbee@fosstodon.org
2020-10-27T18:47:04Z
0 likes, 0 repeats
@julio Argh
(DIR) Post #A0b02a6GcQY5d50F4S by alexbuzzbee@fosstodon.org
2020-10-27T18:47:28Z
0 likes, 0 repeats
@cinebox Depends on how you do it. That can work, but...
(DIR) Post #A0bPxdT1GqJJQqwo7M by zens@merveilles.town
2020-10-27T23:37:54Z
0 likes, 0 repeats
@alexbuzzbee this one time, my partner got asked to debug an sql query that was two pages long. got really stuck until she figured out that MS Access uses a weird subdialect called jetsql
(DIR) Post #A0bQW0p0wd6hiAcxl2 by alexbuzzbee@fosstodon.org
2020-10-27T23:44:08Z
0 likes, 0 repeats
@zens The Access dialect of SQL is awful and bizarre.