This is the beta test site for a database support system I developed during the covid lockdown. No coding is required to provide an administration system that allows users to Create, Read, Update and Delete information
The software runds under Node.js using the Express framework. The database schema format is based on the JSON Schema standard.
This version supports several relational systems (MySQL. PostgreSQL, SQLite3) plus the MongoDB and CouchDB document databases. There is a partial database driver for Firestore. It can deal with normalised and denormalized models; and tabular or structured data. Other database management systems can be added. This test system is running on CouchDB. But you can change the database without restarting the thread.
I am a retired software engineer, and this was my project to keep my brain active and keep me up to date with modern developments. Don't bank on me for long-term support, I just had my 80th birthday. But I have no plans to check out any time soon.
I hope this is useful to maybe give you ideas, or to use in NOSQL familiarisation or just steal the code. If anyone wants to work on this with a view to taking it on and getting it in production, please contact me - bob@sudsjs.com.
Basic functions:
- Listing files, (tables or collections)* with a powerful filtering capability
- Listing individual records (row or document)* with a summary of linked records.
- Create, update an delete data.
* Terminology differs between relational and document database systems. So I have reverted to 'classic' terminology:
| Classic | Relational | Document |
|---|---|---|
| file | table | collection |
| record | row | document |
| field | column | field |
CouchDB Database V3.0.2 Updated 24th April 2023