Posted in Database Management Systems, Still-coding, Technology, tagged ai, ChatGPT, Database, Gemini, JSON Schema, programming, SQL on January 11, 2025| Leave a Comment »
In a previous post I showed how an AI system (ChatGPT) was an easy way of converting an SQL Schema to a JSON-Schema. It was very successful and could save hours of donkey-work when dealing with a legacy database. I am coding in TypeScript so I asked for a TypeScript schema as well. It also did that perfectly.
I asked Gemini to do the same job.
(more…)Posted in Database Management Systems, Still-coding, tagged Database, json, JSON Schema, programming, SQL, sql-server on January 9, 2025| Leave a Comment »
I have been working on my hobby project, which is a generic database updating tool. It uses an extension of the JSON-Schema standard. But how do you deal with a new database from a legacy database.
I found a really simple solution, I asked ChatGTP to produce a JSON-Schema based on a database dump – which happily is a set of SQL statements.
(more…)
Bob Browning's blog 