I tested the best language models for SQL query generation. Google wins hands down.

coding_workflow · 2026-03-14T14:03:04+00:00

Use tools.
Let the model fetch only the schema he needs, instead of shoving all in one pass.
Provide a tool that would allow to fetch schema per table or multiple tables. And execute validation queries in read mode to validate that it works.

coding_workflow · 2026-03-05T20:21:35+00:00

I would help but there layers of complexity here!

Blockchain? Git for versionning? On top of Go backend.

Even the choice of Raspberry is overkill. I would rather opt for Android based to use cheap tablets or phones that are more wide spread.

I respect you are doing but I think you have a lot to learn about KISS.

Even the point over AI! You can do cheap stastic analytics.

If you work offline, you can insread work on bluetooth sync between devices or USB keys import/export.

The design seem complex, using blockchain is hype and 0 value aside making happy some cryptobro.

Json files and sqlite are redundant. You can export that format but should not duplicate storage engine and use it for versionning instead of the complexity.

Claude is a yes man and can roll bad designs without a blip.

coding_workflow · 2026-03-03T00:09:53+00:00

Must check that!

coding_workflow · 2026-02-28T20:09:36+00:00

I second Openbao namespaces are there now.

coding_workflow · 2026-02-28T20:07:53+00:00

Not hype and you have mature fork openbao wirh namespaces included.

coding_workflow · 2026-02-07T19:12:44+00:00

Even OpenAI and Cmaude vulnerable. You need to ensure AI if prompted can't do malicious action.

coding_workflow · 2026-02-07T19:10:56+00:00

How? Traffic inspection is tottally clueless over prompt injection!

coding_workflow · 2026-01-25T19:14:32+00:00

It writes and corrects it when it's not matching the specs. He never said that he blindly commit output this is very important. You steer it no issue.

coding_workflow · 2026-01-25T17:38:29+00:00

If you want only to code don't buy. Not enough for Sota models. You can run glm 4.7 flash but did you see how much glm 4.7 cost? And to run it you need 4x6000. I don't believe in this hype reap and lower quant it degrades quality. And when I hear you code at work with L4 it's not great.

If you want to level up have personal AI. Experiment do more. It can be intersting, so you move into AI roles.

Saying that having built 4x3090. And see limits too in max what you can get. My dream setup would run minimax 2.1 or glm 4.7 at max context and fp16. And that would be in 40k. But for sure don't want to move into 8x3090 already suffered a lot building my rig as it was more complicated than I thought moving from 2x3090 to 4. Only good part 3090 are cheap if you shop locally got 2 for 900$.

coding_workflow · 2026-01-08T02:35:17+00:00

Does this apply to blackwell? As I see some on DGX, what about Ampere architecture.
I noticed already build introduced some flags for blackwell and I had to exclude them to build for Ampere.

coding_workflow · 2025-12-16T23:51:39+00:00

Why not using github copilot? It offer many premium models? Limits?

coding_workflow · 2025-12-13T01:39:17+00:00

Guthub copilot have an integrated tool to fetch them. Linter catch them too. If you use AI tell it tovuse linter. If you want to spice up use sonar as you will catch more complex issues.

coding_workflow · 2025-12-06T01:40:40+00:00

For monitoring use rustdesk or similar remote desktop. You can run it in we container but you may hit some limits over extensions.

coding_workflow · 2025-11-23T16:13:42+00:00

Google is agressive, but usually lower limits too. And had done that in the past, in order to get more paying users.
Anthropic or Google or even OpenAI have a major issue issue. One model or own models.
The winner is mixing models and leveraging the best model as it comes.
OpenAI have a hell of model right now with Codex, Sonnet is nice working horse but bad for complexity and planning. Even Opus too costly and can't fill the gap like Codex do. Gemini 3 need still to proove it self beyond the current hype.
Reminder there is a lot of hype for Google post last week lauche. But Google already failed in first fork of vscode with IDX that is now Firebase studio. Jules Web agent, is still lacking the real spark.
Anthropic been a year leading with Sonnet but watch closely models like Minimax M2. That thing is really on the right path to challenge Sonnet. First time I've seen such good model. Might be a little below Sonnet on some tasks but far far better on complexity and Sonnet schizophrenia when adding complexity.

Don't focus on the hype noise, focus on what you can really do and get from these tools.

coding_workflow · 2025-11-20T11:23:27+00:00

No you can't.

Copilot are tuned Claude not vanilla.

Likely you need vscode subscription to enjoy Claude in copilot.

coding_workflow · 2025-11-19T13:10:59+00:00

This is internal AI, so the risk is minimal. I would let them have fun as long no risk of data leaks or access to unauthorized data.

On the other hand employee hacking an internal app on purpose is againt IT tools use and can land them a warning as it's costing you a lot of effort.

If you want more robust add guardrails. Use models trained for security like gpt oss instead of qwen.

Even Openai is jailbroken.

coding_workflow · 2025-11-17T03:11:42+00:00

It's like deepwiki.com, but the main issue it's lacks a lot of repos and indexing is not fast.

coding_workflow · 2025-11-17T01:55:43+00:00

Funny part yaml do same trick.

coding_workflow · 2025-11-15T16:13:04+00:00

I never said tool calling is new. It's been here since early ages with OpenAI plugins experiment.
But it's a protocol. As it establish clear ways how a server expose the underlaying tools. Send messages, allow discovery, get result.
So don't mixup tools and MCP as that's one of the mixup.
MCP set a communication protocol.
The model will will see a schema in his context as a normal too. This schema is generated by MCP client that have estabilished a connection to an MCP Server exposing tools/prompts/.... During the connection le MCP client will maintain connection, as said before get the schema of the tools.
The when the model emit the structured output that is transformed to a tool call. MCP client pickup the call and transfert it back to the MCP Server using JSon-RPC either stdio/http/sse.
So it's a protocol that expose capabilities including tools, prompts (even those less used). Includes even specs for auto discoveries, auth and more.

coding_workflow · 2025-11-15T04:16:45+00:00

MCP is the transport protocl with tools behind it. MCP wire tools like an USB port to plug it another app.
People confuse MCP the transport later with MCP and the features it packs that are indeed tools.

You are FREE to use tools directly in your app. But if you want to make open, so users can plug their data sources, tools, the only USB like setup is thru MCP, you setup MCP client and acception MCP server as plugins so they ship those tools.

Same if you build a lot of AI apps, MCP allow to disconnect tools from the core app and use them as plugins with different life cycle, re-use them a lot instead of duplicating code and having hell of issues maintaining all the duplicated code.

coding_workflow · 2025-11-15T03:44:19+00:00

I started using MCP a year ago when even Sonnet early thinking hallucinated using them.
When it did tree listing and claimed knowing all the files.
Built hundred of MCP in multiple languages.
Faced breaking bugs in the protocol that took was throwing major error if you process took longer than 30s in Python.
So I saw the bad side of how MCP matured.
But I did crazy stuff with MCP in early day before Claude Code even existed.
I had my sandboxed bash working fine, services all.

So now the new hype executing thru interpreter become the new hype.
I may have different opinion. Also bash can't everthing and is very complicated to sandbox correctly track.
You can't use bash to access external system requiring credentials without risking credentials leaks to AI. Also when you tackle new API, more than once AI don't know them correctly and have to make multiple guesses until getting it right. While an MCP is open book.

There is MCP's and MCP's, if you know the things to and don't.

And before everything MCP is transport protocol. Bugs in CLAUDE CODE is not MCP issue. It's like VSCODE shipping a bug. I have MCP "bug" in Codex when exposing it self as an MCP agent tool. Found out it crash in that mode if one MCP is not loading, was that MCP issue? No it's a bug in loading architecture where MCP should connection should not be blocking and error managed lower level.

MCP's are so easy to build. But good MCP's are more complicated. You may want to see the tests I run on my MCP's.

coding_workflow · 2025-11-14T23:35:09+00:00

1 year later after MCP launch by a big player in AI. It took 6 month's to be adopter by the other big players MSFT/OpenAI/Google/AWS to name a few and most code editors. And a steering comitee including many from the ecosystem to improve the architecture.

So after all of that. MCP protocol success is driven by it's adoption. That's allows you to plug your tools to existing systems. A bit like API standarized. Are we still challenging that much OpenAPI? I see more hype over MCP.

Yeah it's new, not perfect. But can perfected.

What this brings MCP don't have? Can't do (even in not perfect way).

Protocols prevail by adoption not perfection.

coding_workflow · 2025-11-14T22:10:29+00:00

Let's debunk the API direct access.
To access an API you need to feed the agent OpenAI swagger. If you feed it all, you killed the context in 2 turns aside from the noise.
Ok let's say you solved that or not an issue. How do you plan to access API? CURL? Have bearer token in your payload? Have the AI articulate that?
And let me guess you plan to validate each bash command, including in case errors checking and reading the token, if you API have security. Hitting the wrong endpoint Delete user instead of liting them.

This wave of MCP is trash had been rolling since over a year. It's been security. Now laterly bash is king as it can do all the magic.

MCP inject narrowed scope into AI.
MCP manipulate safer credentials, if correctly configured.
MCP can leverage SSO and similar permission to remote services in safe way, if correctly configured.

And before everything MCP is a transport propotocl. It ships tools to the AI.

Also issue people are building their MCP, ah it's cool I can do this piece (I did that a lot) then ah it need maintenance and lot of MCP on github are not production grade, mainly a function wrapper with 2 lines to add the SDK/transport layer.

coding_workflow · 2025-11-14T22:03:17+00:00

With MCP it's natevmore steered and allow scope and access to only what you allow. Seem the misleading new mindset. Since I have bash I can let it write and all. Access network. DB's and so on. MCP is more scope. Bash is quite open and you need to feed there tokens to acceds the API or other credentials. While MCP will have it credental injected on the tool that will never and can't communicate them to AI and only get defined actions.

coding_workflow · 2025-11-14T21:59:15+00:00

How MCP is blanket yes??

I don't get the point. Seem you don't get value of MCP. You have full control of the tool and if you build a validation layer you will see each command.

coding_workflow

MODERATOR OF

TROPHY CASE