B4J Tutorial SithasoDaisy TailwindCSS UI Toolkit: Q & A

Hi there

NB: Where possible, please include a simple project that demonstrates your use case.

Do you have any questions about SithasoDaisy UI Toolkit?

You can shoot it here and we will oblige.

Thanks in advance?


Join on Telegram

SithasoDaisy

TailwindCSS WebApps using b4x

t.me

Check $5 WebApps

SithasoDaisy WebApps @ $5 Each

Hi there Disclaimer: These WebApps are hosted on Netlify and the back-end hosted on PocketHost (just for demonstration purposes). You will have to set up the SQLite Webserver on your own machine for a better experience. PocketHost is not recommended for production purposes as its slow compared...

www.b4x.com

 

[yiankos1]

Hello my friend,
I am trying my first steps with Sithaso. Before i start coding my new app, i would like to know if i can use an sqlite database (basically it is sqlitecipher) which i can use in b4j with a jdbc driver that i found. So my question is, sithaso webapp or b4j app?

It is mandatory to use this sqlitecihper database for security reasons and because b4a app using same database.

Thank you for your time.

 

[Mashiane]

i would like to know if i can use an sqlite database

Hi

Yes, one can use SQLite with SithasoDaisy. We are currently doing this with a SQLite Webserver called Pocketbase. This is an example of one of the apps we have done.

SithasoDaisy: PocketBase - Project Management Unit Source Code @ $5.00

Hi there Netlify Demo Disclaimer: This webpp is hosted on Netlify and the back-end hosted on PocketHost (just for demonstration purposes). On the download you will get the source code and a running version (inside PocketBase) which is activated by double clicking a file. No installation...

www.b4x.com

One is able to install the server and then set it up.

This can be installed on...

And has an admin interface...

This is the approach we recommend, and there is no PHP involved at all here.

sqlitecipher

We have not yet explored this.

 

[MichalK73]

Hello my friend,
I am trying my first steps with Sithaso. Before i start coding my new app, i would like to know if i can use an sqlite database (basically it is sqlitecipher) which i can use in b4j with a jdbc driver that i found. So my question is, sithaso webapp or b4j app?

It is mandatory to use this sqlitecihper database for security reasons and because b4a app using same database.

Thank you for your time.

As far as I know sqlitecipher is probably not supported in B4J only in B4A. There is a commercial SQLite for b4j but you have to pay for it and not a small amount of money.
I suggest you in the backend to the API server to use the H2 database which is described in the forum and it has full full on-the-fly AES encryption.
You must simply transfer the structure from sqlitecipher to H2 and create a connection to the H2 database. That is all.

 

[yiankos1]

As far as I know sqlitecipher is probably not supported in B4J only in B4A. There is a commercial SQLite for b4j but you have to pay for it and not a small amount of money.

It is easier than you thought to connect to SQLcipher. You can use this post in order to CRUD an encrypted sqlite database. Your's and Mashiane's solution sounds interesting. But, my question is, if i can get data using jSQL library at B4J app, can i use them with sithaso?

Sorry if my question is quite silly, but i am new to this framework. I got experience only in B4X products....

 

[MichalK73]

Shitaso is a framework that builds a web application that runs on the client side in a browser in JS. To retrieve data from the database you need to use a connection to the server written in e.g. B4J as a CRUD API. The database server is a matter of connecting to which database you want. So in Shotaso you do not use SQLite but the server side API.
You wrote that the requirement is that you have the data encrypted in the database. Pure MySql, SQLite or pocketbas (sqlite) do not have encrypted information. So if you want a fully encrypted database, you have to use a database that offers this. So there are paid connections to SQLite commercial for a fee or as I wrote you can use the H2 database which is free and has built in full encryption of data on the fly.
https://www.h2database.com/html/main.html

 

[Mashiane]

if i can get data using jSQL library at B4J app, can i use them with sithaso?

Is this data going to be called via a rest api approach? If so, yes that can be done.

I am currently testing the BANanoServer implementation with SithasoDaisy. This enables one to use any b4j library in their apps.

We have not done any db stuff yet but hope we can soon.

SithasoDaisy jSerial (Port) Communication WebApp Source Code

Hi there As it takes time to create, debug these projects, the source code for this WebApp is DonationWare. Find the PayPal link below. When donating, please indicate that it's for SithasoDaisy jSerial. https://paypal.me/anelembanga?country.x=ZA&locale.x=en_US I'm excited that this is going...

www.b4x.com

SithasoDaisy jBluetooth Communication WebApp Source Code

Hi there As it takes time to create, debug these projects, the source code for this WebApp is DonationWare. Find the PayPal link below. When donating, please indicate that it's for SithasoDaisy jBluetooth. https://www.paypal.com/paypalme/anelembanga?country.x=ZA&locale.x=en_US I'm excited...

www.b4x.com

The PocketBase implementation uses a rest api approach to get the data from the server and make it accessible client side.

 

[miladfakhrizade]

Please add this possibility
Exporting DataTable to PDF & Excel (csv & xls)
tnx

 

[Mashiane]

Please add this possibility
Exporting DataTable to PDF & Excel (csv & xls)
tnx

For now you can generate ms word reports. Please see these two posts.

SithasoDocxTemplator: Creating MS Word Documents from Dynamic Templates in JavaScript

Hi the This was an interesting find: https://docxtemplater.com/, also its just so easy to use and understand. Below is my template. I am attempting to generate the API documentation for the SithasoDaisy ebook. This was easy to achieve using tables on the demo. And yes, I could fire up...

www.b4x.com

SithasoDaisy: How to create a Client List Report in MS Word

Hi By the end of this, you will be able to: 1. Get a client list from a REST API database. For this case we will use a fake REST API fom https://randomuser.me/ 2. Load this client list to a SDUITable. We will use the abstract designer & then add columns to the table. 3. Export this client list...

www.b4x.com

 

[Mashiane]

Subscribe to B4J library updates

Subscribe to this thread to be notified of B4J library updates.

www.b4x.com

 

[Mashiane]

Please add this possibility
Exporting DataTable to PDF & Excel (csv & xls)
tnx

Done!

 

[sdleidel]

SithasoDaisy the last update give the following
Error:
Compile in debug Mode give this error:

shell\src\b4j\example\sduitable_subs_0.java:9981: error: code too large for try statement
catch (Exception e) {...

 

[Mashiane]

SithasoDaisy the last update give the following
Error:
Compile in debug Mode give this error:

shell\src\b4j\example\sduitable_subs_0.java:9981: error: code too large for try statement
catch (Exception e) {...

Will look into it..

 

[giannimaione]

Compile in debug Mode give this error:

Why compile in debug mode?

 

[Mashiane]

Why compile in debug mode?

In debug mode for example you have the functionality to use live code swapping for UI design.

 

[sdleidel]

Will look into it..

Have you fix it ?

 

[sdleidel]

Next Problem.
If I add a "Select Field" to the Table and then pass a list for the "Select Field", the list is sorted.
Can you change that. I need the order from the list.

Example List
"5 woeio"
"100 cvxvxc"
"2.000 cvxvcv"

The "Select Filed" shows:
"100 cvxvxc"
"2.000 cvxvcv"
"5 woeio"

I need this change very quick )-:
Can you help me ?

 

[sdleidel]

Next Problem.
If I add a "Select Field" to the Table and then pass a list for the "Select Field", the list is sorted.
Can you change that. I need the order from the list.

Example List
"5 woeio"
"100 cvxvxc"
"2.000 cvxvcv"

The "Select Filed" shows:
"100 cvxvxc"
"2.000 cvxvcv"
"5 woeio"

I need this change very quick )-:
Can you help me ?

OK i have fix it myself...

Dim options1 As Map = SDUIShared.ListToSelectOptions(optionen_Bestellmenge.get(u))

mdlSDUITable.SetSelectMapItemsOfRow("auflagen_bestellung",u, options1)

The Problem is in SetSelectListItemsOfRow, you use SDUIShared.ListToSelectOptionsSort(options)

 

[giannimaione]

what a difference and how to use this

    SDUITable1.ClearPropertyBag
    SDUITable1.AddColumnTextBox("qta", "Quantità", False) 'edit on table
    SDUITable1.AddColumn("codice", "Codice")

and ...

    SDUITable1.SetColumnComputeValue("qta", "subqta") 'ok event "subqta"

or

    SDUITable1.SetColumnClass ("qta", "subqta") 'no event "subqta"

and how to define

sub subqta (map1 as map)
'ok only on SDUITable1.SetColumnComputeValue
'here there are ALL rows of SDUITable (!?!?!)
end sub

how to intercept event at change value on "qta ColumnTextBox" (only one rows)

 

[Mashiane]

SDUITable1.ClearPropertyBag

This is used for the propertybag ONLY, you CANNOT call any .AddColumn statement after this. The property bag works like the preference dialog here in b4x.

If you want to use a property bag, see the example and source in the demo example from your download.

Open, https://sithasodaisyui.netlify.app/, goto Tables - Designer > AD PropertyBag.

This shows you how to define a property bag (left side is the property bag) + right side is the code to create it.

 

[Mashiane]

SDUITable1.AddColumnTextBox("qta", "Quantità", False) 'edit on table

The row content for the "qta" column will be shown as a textbox.