ADO.udf / EZmySql.au3 / mysql.au3 / SQLite.au3

[Resiak1811]

Hi,

long story short, I was using SQLite for nearly 4 years now as a standalone (local single-user) application (using a DB of course..) but now,

I need to switch to something else for a multi-user environment (2 warehouses .. maybe 2 local-users, 3-4 external-users) :

for the local users : I will create a server on my computer and sharing the DB over the network

for the external users : a external server for hosting the DB (with a few update(backup) here and there so no-realtime DB)

 

My question is ..since SQLite is a local single-user environment, which UDF should I use ?

I just start using EZmySql.au3 but I don't know if its a good choice ?

 

thank for your advice !

[argumentum]

...make a script that will listen on TCP, get the SQL and return the answer ?
Or use switch to MariaDB or the like ?

How many requests a second do you make ?

29 minutes ago, Resiak1811 said:

I need to switch to something else for a multi-user environment (2 warehouses .. maybe 2 local-users, 3-4 external-users) :

 

Code it as an API web sites make and return a JSON ?
For the SSL part use Apache ?

[Resiak1811]

Quote

How many requests a second do you make ?

not much ... the application is for locating the item in the warehouse ...

(a lot of items)  / knowing the qty we have / I use the app. to add order (with the item who left the warehouse) ...

don't know if you understand ?

[argumentum]

6 minutes ago, Resiak1811 said:

don't know if you understand ?

I don't have to understand other than how often requests get and if a single threaded program ( AutoIt ) can handle it. 
The rest is up to you. What do you wanna have. The link I gave you is what I would use.

[Resiak1811]

thank you