Feeds:
Posts
Comments

Posts Tagged ‘MongoDB’

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 »

Hands-on different database management systems

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

Read Full Post »

Database design – SQL vs NOSQL examples

Posted in Still-coding, Technology, tagged , , , , on September 29, 2022| Leave a Comment »

For the last 50 years there has been one and only one way of designing a database.  SQL Database management systems (DBMS) have been the uncontested standard. (A better name is ‘relational’ because SQL is just the name of the language used to access them, but we will stick with it.)
But things have changed in the last 10-15 years. Databases that disobey relational rules are coming into vogue.  The term NOSQL is used for these non-relational databases (the above chart is work in progress, but I have been looking at these systems.) 
What is the difference between classic databases and this new breed? 

(more…)

Read Full Post »

Handling data consistency in a Document Database

Posted in Still-coding, Technology, tagged , on May 17, 2022| Leave a Comment »

You know what an invoice looks like.  We have all seen thousands of them – probably too many. But invoices illustrate an interesting problem – and I am not talking about your VAT  return. I am talking about the new kids on the database block – document databases.  An example is MongoDB. These can store all the data for one invoice in a single structured record (called a ‘document’).   

(more…)

Read Full Post »

Lost in MongoDB: Learning to Aggregate

Posted in Still-coding, Technology, tagged , , on April 5, 2022| Leave a Comment »

I am getting to the end of stage one in writing a database driver for MongoDB to use in my Lockdown Project sudsjs.com. All has gone well until I get to totalling up a field in the database. I had to enter the wonderful world of aggregation, which is powerful function-rich and confusing. 

(more…)

Read Full Post »

Will NOSQ replace SQL?

Posted in Still-coding, Technology, tagged , , on March 1, 2022| Leave a Comment »


NOSQL databases like MongoDB are making a big splash in the computer industry. But are they set to replace the tried and tested technology of the past fifty years?

Here is my take on it, with a bit of history thrown in.

(more…)

Read Full Post »