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…)Posted in Still-coding, tagged Debugging, Still-coding 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…)Posted in History, Still-coding, tagged coding languages, javascript, Python 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…)Posted in Still-coding, tagged apple 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…)Posted in Still-coding, tagged Python 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…)Posted in IT Pioneers, Still-coding, tagged Coding, History, IT Pioneers, PL/1, Structured design 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…)Posted in Database Management Systems, Still-coding, Technology, tagged json-schema, NOSQL, SQL 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…)Posted in Database Management Systems, Still-coding, Technology, tagged Database, express, json, node.js, NOSQL, sailsjs, schema, SQL 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…)Posted in Still-coding, tagged cassandra, CouchDB, Firestore, MongoDB, mysql, oraclexe, postgresql, sqlite on April 20, 2023| Leave a Comment »
When we all got locked down, I needed a project to keep my brain active. (That gets important as you get older: I just had my 80th birthday). My wife is learning Spanish and I tried writing a novel (it didn’t fly). In the end I decided to do something that I was good at – software development. I wrote a generic system to update and query a database using node.js. Test system here: http://www.sudsjs.com.
The database is accessed through a driver, which initially was written and tested for MySQL, PostgreSQL and SQLite 3. Since then, I have implemented (or tried) various NOSQL systems. So here is a summary and a link to any blog posts about all of the databases I have used.
(more…)Posted in Still-coding, Technology, tagged NOSQL on February 12, 2023| Leave a Comment »
The sales manager came down to the IT department and looked around. He spotted a young developer who looked a bit bored. His name plate said ‘Luke’. “I have a small job for you if you are interested”. Luke nodded. “We get sales orders from out customers. The warehouse handles them but we can’t get access to the data. Can you write a little program to store then on a computer for me.” Luke looked at a file of sample orders. “Sure no problem.”
He turned to the jaded old database administrator (Joda) in the corner “This is a great application for a NOSQL Document database like MongoDB or CouchDB.” Joda looked up – “That is a decision, regret you will”. Luke muttered something about ‘luddite’ and went back to his desk and coded up one NOSQL document per sales order, with customer details and an embedded array of order lines. The logical way to solve the problem.
(more…)
Bob Browning's blog 