This is the beta test site for a database support system I developed during the covid lockdown. No coding is required to allow users to Create, Read, Update and Delete information.  SUDSjs gives you a quick start to creating your database and giving your back office an administration function. They can get to work on building the database while you develop the fancy customer-facing application. 

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.  I have no plans to check out any time soon (I just turned 80 yrs) but don't bank on me for long-term support. .

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.

Bob Browning

Basic functions:

Please take the tour


* 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.1 Updated  30th March  2023