Feeds:
Posts
Comments

Posts Tagged ‘programming’

Converting a database from CouchDB to Mongodb

Posted in Database Management Systems, Still-coding, tagged , , , , , , , , , on August 28, 2025| Leave a Comment »

When I began the project I am currently working on (more details will be provided next month – probably), it was initially intended as a small test to determine the capabilities of AI.  Over the last six months it has turned into something that we might take further. 

But I hit a problem. As a little hobby project I chose the database I really really like – CouchBD.  CouchDB is elegant, simple yet very functional and efficient. Close to the perfect database management system (DBMS).  But to take it further I need to involve other developers and it turs out that CouchDB skills are few and far between. Truly it is the Betamax of DBMSs.

(more…)

Read Full Post »

More adventures with AI

Posted in ai, Still-coding, tagged , , , , , on January 20, 2025| Leave a Comment »

My previous blog post outlines my success in converting a data structure definition from one format to another. Both ChatGTP and Gemini had a really good stab at it. The result was mainly accurate and extra information had been added for me. ChatGTP managed to make a mistake on the second attempt at the task, and when I asked it why, it used a completely made-up (and incorrect) rule about SQL Databases as an excuse. So Turing Test passed!

I gave it another task. Convert a routine from using the SQLite3 data base management system, to the higher performance MySQL. This is a straightforward, if tedious task. How did it do?

(more…)

Read Full Post »

AI to the rescue – Part 2.

Posted in Database Management Systems, Still-coding, Technology, tagged , , , , , , 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…)

Read Full Post »

AI to the rescue

Posted in Database Management Systems, Still-coding, tagged , , , , , 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…)

Read Full Post »