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

EnriqueGonzalez

Well-Known Member

Licensed User

Longtime User

• Sep 7, 2023

• #2

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

 

Upvote 0

virpalacios

Active Member

Licensed User

Longtime User

• Sep 8, 2023

• #3

Hi, Mysql, you get php support very easly.

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Sep 8, 2023

• #4

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

 

Upvote 0

amorosik

Expert

Licensed User

• Sep 8, 2023

• #5

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?

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Sep 8, 2023

• #6

amorosik said:

MySql can be used for free even on commercial projects

Click to expand...

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

 

Upvote 0

EnriqueGonzalez

Well-Known Member

Licensed User

Longtime User

• Sep 8, 2023

• #7

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

 

Upvote 0

peacemaker

Expert

Licensed User

Longtime User

• Sep 8, 2023

• #8

Velocity

Click to expand...

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

 

Upvote 0

amorosik

Expert

Licensed User

• Sep 8, 2023

• #9

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

 

Upvote 0

KMatle

Expert

Licensed User

Longtime User

• Sep 8, 2023

• #10

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.

 

Upvote 0

EnriqueGonzalez

Well-Known Member

Licensed User

Longtime User

• Sep 8, 2023

• #11

peacemaker said:

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

Click to expand...

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

 

Upvote 0