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.
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.
- 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 I like it a lot
Watch this space for updates.
Bob Browning's blog 
Leave a comment