peacemaker Expert Licensed User Longtime User Apr 12, 2023 #1 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. Last edited: Apr 12, 2023
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 Expert Licensed User Longtime User Apr 12, 2023 #2 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). Upvote 0
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 Expert Licensed User Longtime User Apr 13, 2023 #3 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. Upvote 0
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.
