I asked on Google, but I do not read what I was searching.
The question is aboout features differences (in sharing DB between computers for example).
SQLite is local database that offers SQL access on a single machine. MariaDB is a fully fledged MySQL replacement that offers a full client / server facility.
MariaDB and MySQL use the same source code, at least for the fundamentals.
Yes, I know we are going to get lots of people saying they use SQLite on an SMB share, from multiple clients simultaneously, however, even SQLites developers say not to do this.
To quote google:
MySQL is a scalable, multi-user database management system ideal for enterprise applications, while SQLite is a lightweight, serverless database suited for embedded and single-user scenarios.
THANK you Ian, nice and informative answwer.
THIS WAS VERY CLEAR FOR ME, thus my question.
So, when I will have some time, I will explorate this with a test project (to determinr how to do that and if everything can be done in a real work environment (at the user plant with two or three machives using a cloud solution they actually work with the pdfs files available with their two computers at the same time).
Thanks
Think of it this way: SQLite is like having a Word Doc on your computer. MariaDB is like having Google Docs where your document lives on a server and many people can view/edit at once.
A search engine is not the best place to ask such a question. Try it with Gemini, e.g., and ask something like this: 'What are the differences regarding MySQL and SQLite when we talk about the syntax and language features?’ 
But as always, be careful regarding the veracity…
backup file? s-ftp? nas? cloud file share?
or do you speak about sync data?
The answer was in that paragraph:
(at the user plant with two or three machives using a cloud solution they actually work with the pdfs files available with their two computers at the same time).
USE TWO COMPUTER WITH THE SAME .db file using the same cloud folder (as they actually do with the pdfs files [see above]).
I really do not know how actually they really works since 'till now I was thinking I needed a pay version to achieve their need.
Apparently he wanted to be able to read and write the DB file from two computers (and he does not know how he is working with pdfs, etc. I suppose he have a shared folder on the cloud, so he can "see all files from both computers).
There is a Date Created Field. He asked me to be able to extract a year from the db AND save that year inside another DB file.
I am quite sure he never use that feature !
I hope this is clear now.
SQLite is actually multi-thread safe, so this simplification slightly obscures just how useful SQLite is. You can back a webservice on SQLite, especially with the way Xojo Web is concurrently threaded.
@Tim:
I do not understand now. Can I have one Database file and Add Records to it from two computers with SQLite, if so, how ?
Or may I use Maria DB ?
You would need a webservice to act as the central server.
It’s the file system locking failures that cause network drives and cloud services to corrupt the database.
Either way, SQLite or MariaDB you will be paying for a central server.
this is how cloud work
local file pc 1 user > cloud < local file pc 2 user
it means because cloud is web usually the pdf are copied local to “hard” disc
then it get edit by user and after save there is a service which copied the file back into the middle.
this make trouble if you not have a locking mechanisms.
what you could use is a named sqlite db.
peter.db
frank.db
…
collective.db
but multi user data recording very often is a database service and in web there is a middle ware between.
Don’t use SQLite files on a cloud drive. The sync can happen any time, including during a database update.
As others have mentioned, if you are going to compare, its why to use MariaDB instead of MySQL.
As for SQLite, we have SQLite implemented in Valentina Server. You can upload your SQLite files into Valentina SQLite Server, and then server handles administratively the access so you don’t have the nightmare of multiple parties writing to a single file.
We implemented SQLCipher, so you have that form of encryption available as well.
Server also has ValentinaDB and DuckDB Servers as well.
You can check this out easily with the free Valentina Studio license and the free version of Valentina Server.
Same happens when using other standard software, isn’t it ?
PS: the solution is a Desktop Application. Actually, there was no relation with Cloud nor Web.
What the customer do with other software is unrelated to what I’ve done.
Thanks all.
Someone else said cloud. I have only warned not to mix SQLite and cloud. Which is good advice
It is indeed good advice. Recently had an issue with database corruption that I was having a hard time figuring out. Turns out the user’s AppData folder was being synced to OneDrive. Awful stuff. I had just tell them that’s an unsupported configuration.