This is the beta test site for a database support system I have developed. 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. Modified 4/12
I am a retired software engineer, and this was my project in COVID lockdown to keep my brain active and keep me up to date with modern developments. I think the result is pretty neat. I just turned 80. Don't bank on me for long-term support - 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 |
V2.1.2