B4J Question CRUD db module for server web app

[peacemaker]

HI, All

How to make an interface for web-app that uses 2-3 tables from database ?
Say, one main table, one depending table (updated when 1st table row clicked) and 1-2 images from these tables.
And possibility to edit texts of each selected row of these tables in browser.

Ubuntu linux is planned to use as a server.

 

[Harris]

What framework are you using for the web app? What is the flavor of database (ie. MySQL) ?
A good hint on images... don't store them IN the table. Store the url in the table (path and image name) and save images as files on disk (in a folder for example).

 

[peacemaker]

No framework now, just pure B4J server app with the handlers. SQlite DB, but i think about MySQL. Yes, images are in files, in the table just file names.
And for the operator it's needed the work interface to work with 2 tables comparing 2 images manually editing the DB.