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 MongoDB.
You can change the database on the administration page and the system will then be running with a different database. Each test database is similar to the others, but they are not the same. This function is just for testing purposes at present. The database is changed for the thread. rather than user session, so if you did this in a serious multi-user environment this could have interesting consequences. On this test system you are unlikely to cause problems.
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.
* 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 |
Mongo Database version 3 Updated 30/2/23