B4J Question what DB better to use for HTTP data exchanging apps ?

[peacemaker]

HI, All

If there are several Java apps on different IP-hosts inside a single VPN network need to work with a _single_ database - what are better to use for B4J ?
More fast over HTTP ?
More secure ?

 

[EnriqueGonzalez]

I did not fully understand the question. DB is independent of the http request. Any server database that could be sharable among those services is okey. Say MySQL, SQL server, postgres, and so an so fort

 

[virpalacios]

Hi, Mysql, you get php support very easly.

 

[peacemaker]

I read now about Postgres in whole and on this forum... and want just old good MySQL

 

[amorosik]

Do you know if MySql can be used for free even on commercial projects that are sold?
I ask this because it seems that everyone considers it free, but every time I have tried to verify it from the manufacturer's documentation, or rather the current owner's, I have never been able to find a definitive answer to this question
And so the question is: is there an official document from the manufacturer/owner where the free use of the db server is also described for use in commercial projects?

 

[peacemaker]

MySql can be used for free even on commercial projects

Hmmm, interesting question indeed...
Linux hosters allow installation of MySQL 8 for free...
So, maybe MariaDB as MySQL substitute to be used better ?

 

[EnriqueGonzalez]

There is already a good one here

[B4X] Velocity

A wrap of Apache Velocity Engine library for B4A and B4J What is Velocity? Velocity is a Java-based template engine. It permits anyone to use a simple yet powerful template language to reference objects defined in Java code. Source: https://velocity.apache.org/ Download additional libraries...

www.b4x.com

 

[peacemaker]

Velocity

But topic is about the remotely accessed server's DB...

 

[amorosik]

No, not other db, I'm talking about MySql

 

[KMatle]

Remote = App -> https -> server -> php -> MySql

I prefer php as it is supported on any (even cheap hosted solutions) and has many functions (user authentication/encryption, etc.). See my examples. Quite easy to communicate from B4x to php. You can use almost any DB which the provider supports.

 

[EnriqueGonzalez]

But topic is about the remotely accessed server's DB..

Sorry that was meant for this one:

HTMX

Hi, All Who knows what https://htmx.org/ technology is? As i could understand it's something like ABMaterial...

www.b4x.com