Share My Creation [Web][SithasoDaisy5] Low Code Generated CRUD WebApp using NoSQL CouchDB & PouchDB as Back-End (Offline Db with Sync to Server Functionality)

Hi Fam

Download Complete Deployable Project (Source Included)
  1. To run this WebApp, you will need a webserver. We use Laragon for development.
  2. You will also need BANano
  3. You will also need SithasoDaisy5, get it from this GitHub Repo
  4. This app has been developed using SithasoDaisy5 Low Code Generator
  5. You will need to install and set up CouchDB. The admin credentials I have used for the example are root and root123!
  6. The app has been built using PouchDB, we once did a demo of this as BANanoRelax. We have since rewrote the library we used to fit perfectly with SithasoDaisy5.
The env.json file stores the settings for the app should you want to change them.

1761443829598.png


What is CouchDB and its relationship to PouchDB?

CouchDB
is an open-source NoSQL database developed by the Apache Software Foundation that stores data as JSON documents. It is designed around a concept called multi-master replication, which means data can be stored, synchronized, and merged across multiple servers or devices — even when offline. CouchDB’s RESTful HTTP API makes it easy to interact with from virtually any platform or language, and its flexible schema allows developers to work with dynamic, evolving data structures without rigid database schemas. It’s particularly strong in distributed environments where reliability, replication, and conflict resolution are critical.

PouchDB, on the other hand, is a JavaScript implementation of CouchDB that runs in the browser or on mobile devices. It uses the same data model and sync protocol as CouchDB, allowing developers to build offline-first applications where data can be stored locally and automatically synchronized with a remote CouchDB (or compatible server) once a connection is available. Developers use this pair to create seamless user experiences — apps that keep working offline, reduce server load, and sync data transparently. In short, CouchDB provides the robust server-side database, while PouchDB acts as the client-side companion that brings offline capability and effortless sync to modern web and mobile apps.

In this crud project, we explain how we created it and used class modules to interface the front-end and back-end. We also show you how to run a sync script to push and also pull data to the databases. This is useful where offline functionality is paramount and then users can sync when online.

b4x Templates

This template has been added to SithasoDaisy5 b4x template collections so that you can bootstrap your own CRUD app in a second or two.

Other LowCode CRUD Examples

This code example is based on existing CRUD examples we have done. These being the following:




During your study of the source code of all these apps, you will note the 99.99% similarity in the code code, the exception being the handling of the database connection. Also the dashboards code is slightly different as in this case our DB is NOSQL so we had to build some code to group our records and handle other things.

All these code bases are build as proof-of-concept towards a fullu fledged low code builder tool that you can easily use to create low code CRUD WebApps and deploy them, using the various available databases.

Low Code Generator (FREEWARE)

This low code generator tools is discussed here.


Learning Path

In these code examples you learn the following:

1. Designing UI for forms & tables.
2. Designing Excel Templates for Reporting.
3. Designing your Back-End including different data-types
4. Designing relationships between tables and much much more including
5. Using the Designer for your own custom made UI experiences.





#Sharing the Goodness
 
Top