The last time I asked Gemini to assist me with some SQL I got (inside my postgres query form):
This task cannot be accomplished
USING
standard SQL queries against the provided database schema. Replication slots
managed through PostgreSQL system views AND functions,
NOT through user-defined tables. Therefore,
I must return
Gemini weirdly messes things up, even though it seems to have the right information - something I started noticing more often recently. I'd ask it to generate a curl command to call some API, and it would describe (correctly) how to do it, and then generate the code/command, but the command would have obvious things missing like the 'https://' prefix in some case, sometimes the API path, sometimes the auth header/token - even though it mentioned all of those things correctly in the text summary it gave above the code.
I feel like this problem was far less prevalent a few months/weeks ago (before gemini-3?).
Using it for research/learning purposes has been pretty amazing though, while claude code is still best for coding based on my experience.
I feel a little bit nerd sniped - halfway through the article I wanted to cry out "but the loop!" and then they moved the loop. Nice job, I'm super excited to use this in my own code. I have a bunch of handwritten metadata about C++ classes that I'd rather ditch and use something that the language provides.
I think it's reading into a lot into OPs comment. A lot of people look somewhat fondly on dumb/slightly illegal things they did as a teen, even if they would never do such a thing as an adult (nor encourage it in current teens). The downvotes you are getting are likely due to guidelines violations (be kind, curious, not snarky, etc) not due to your actual viewpoint.
I had to set one of these up somewhat under duress to replace a poorly written scheduled query to export data to BigQuery. It’s nice to know what it’s actually doing under the hood, thanks for the info.
I had a 1971 Marshall tube amp land in my lap, for free. I'm not a guitar player, but wanted to get it fixed it up before either selling it or learning guitar. There's a lot of "magic" there - the amp guy asked if I wanted to swap the tubes for some "more authentic" tubes that were used in England at the time. Pro tip - don't ask the internet for advice for making your tube amp sound nice, you'll get every opinion possible.
Guitar amps are all about getting the right kind of harmonic distortion, so of course the guy had opinions. But tube rolling is madness, avoid it at all costs.
You don’t even need to ask! Generally speaking, you don’t want a guitar amp to sound nice, you want it to sound good, good being a function of many things.
For clean sound, use compatible radio preamp tubes and bias the power tubes conservatively.
For distorted sound, use the lowest overhead preamp tubes you can find, and bias the power tubes as hot as you dare without them breaking within the hour. You can always change them after a gig, or between sets. :-)
reply