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 MySL, PostgreSQL and SQLite 3. I downloaded Oracle (XE) but it turned out to be a pain to install in Ubuntu, so I put it on the backburner.
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. I will update this post as I look at different systems.
- MySQL - works like a dream, as it always has.
- PostgreSQL - likewise
- SQLite 3 - Works fine and easy to back up because the whole database is in a single file.
- Oracle XE - struggled to install on Ubuntu; got bored. Watch this space.
- MongoDB - powerful NOSQL system and by far the biggest market share. Blog posts on this phase:
- Google Firestore - would be superb for some applications - but not this one.
- Apache Cassandra. Frankly the documentation was so obscure I lost interest. I might come back to it.
- Apache CouchDB
Watch this space for updates.