Feeds:
Posts
Comments

Archive for the ‘Still-coding’ Category

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 »

Do you use AI to find bugs?

Posted in Still-coding, tagged , on November 19, 2024| Leave a Comment »

I came back to my lockdown project (which was a data maintenance program that works with several databases) and decided to port it to Windows. This is because my Unix box went belly-up. Also I needed to exercise my brain.

A couple of times now I have copied and pasted code into Microsoft’s Co-Pilot and asked what is wrong. Both times it has come back with the answer.

(more…)

Read Full Post »

My take on Python and other languages

Posted in History, Still-coding, tagged , , on February 11, 2024| Leave a Comment »

I have been using JavaScript (Node) for the last few years, but I have pretty much come to the end of my hobby project. I see that Python is very popular for server side systems., so I thought would take a look.

(more…)

Read Full Post »

What is up with Apple

Posted in Still-coding, tagged on December 3, 2023| 1 Comment »

The last Apple product I had was an Apple II back in the last century. So I don’t have a login to Apple (an Apple ID). But when I bought a PC from Currys, it came with 3 free months of Apple TV. I always wanted to see Slow Horses, so figured I would take them up on this. But I had to get an Apple ID first.

(more…)

Read Full Post »

Let’s try Python

Posted in Still-coding, tagged on October 16, 2023| Leave a Comment »

For some reason I can’t understand, Python is the second most popular language out there1 At first glance the language doesn’t look promising. One complaint about COBOL was that you could screw up a program by an unwanted period. With Python it just takes a space. But I shouldn’t condemn the language because of a brief glance at the Python website. So I thought I would give it a shot. More recently I have been experimenting with Node, so that is my baseline

Here is my progress to date.

(more…)

Read Full Post »

IT Pioneers: Structured Design (circa 1974) – the cornerstone of modern coding practice

Posted in IT Pioneers, Still-coding, tagged , , , , on August 5, 2023| Leave a Comment »

I learned to code in 1963. Things were different then.

There were some obvious things, like 24 hour turnarounds on tests, and storing code on paper tape. Oh – and the computer had about .000000001 of the processor speed on my watch, but at the time we thought it was pretty cool.

I am beginning to sound like one of the four yorkshiremen so I will move on. I want to talk about the pioneers of structured programming and structured design,

(more…)

Read Full Post »

I don’t need a schema for NOSQL, right?

Posted in Database Management Systems, Still-coding, Technology, tagged , , on July 20, 2023| Leave a Comment »

A schema means different things for an SQL and a NOSQL database management system. If you are using SQL, you have to tell the system about the format of the data before you can use – that is the schema. When it comes to NOSQL databases everything is different. You don’t need a schema, you simply present data and the system stores it in whatever format you send it.

Each document in a collection1 can be a different layout and different types of data. The flexibility of NOSQL databases suggests that data design is less important. For example I read: “… since NoSQL doesn’t necessitate the need for a schema, you avoid the expense and time of that initial design stage.”

I don’t think so

(more…)

Read Full Post »

I don’t need a schema for NOSQL, right?

Posted in Database Management Systems, Still-coding, Technology, tagged , , , , , , , on May 4, 2023| Leave a Comment »

A schema means different things for an SQL and a NOSQL database management system. If you are using SQL, you have to tell the system about the format of the data before you can use – that is the schema. When it comes to NOSQL databases everything is different. You don’t need a schema, you simply present data and the system stores it in whatever format you send it.

Each document in a collection1 can be a different layout and different types of data. The flexibility of NOSQL databases suggests that data design is less important. For example I read: “… since NoSQL doesn’t necessitate the need for a schema, you avoid the expense and time of that initial design stage.”

I don’t think so

(more…)

Read Full Post »

« Newer Posts - Older Posts »