Scripting News: Monday, January 6, 2025
Monday, January 6, 2025 The great thing about using a system like MySQL (or any SQL for that matter) is that it's been around for so long that if you can think of something that would be nice to have, you can be sure it's there somewhere. They've had enough time not only to hit all the walls, but to try out different approaches and settle on one. Maybe at times there were competing ways to do things, like the way Bluesky and ActivityPub, and probably Threads, and certainly Facebook and Twitter insist on reinventing RSS . But when I ask ChatGPT "can you do this in MySQL" it gives me one or two ways to do it, but usually just one. These are things I never would have found in the old Google-search way of finding answers. An example, I wanted to find out if there was a MySQL way to query a value inside a JSON object, and the answer is (of course) yes. And you can create an index on such a value. I didn't even ask for it, ChatGPT volunteered, guessin...
