All that was shared in here is quiet interesting, thank you for taking the time.
Though this answer has caught my attention :
With that solution I could have a LAN or Wireless network where one main computer (where the SQLite database file is located) launch the Web standalone app and then other computers could also open the web standalone app and connect to the main computer and read/write on the same database file? And all would be done in a web browser right?
Correct. No other machine requires any installation.
Is it still the case with Web Edition that every interesting event from every client makes a round trip to the server?
It’s the nature of a web app that the client (browser) and the server (web app) regularly communicate. With today’s bandwidths and powerful yet low-cost server infrastructure that is not such of a problem anymore. And the overhead of the client/server communication can be minimized to a large extent with a good application design.
Not saying web is better than native desktop. There are (dis)advantages to both. Personally, I tend to do all multi-user apps as web apps whenever possible. No extra DB server required (SQLite is just fine), no extra installations, no updates. Just a browser and an Internet connection - that’s awesome.
[quote=247126:@Alex von Siebenthal]It’s the nature of a web app that the client (browser) and the server (web app) regularly communicate.[/quote]It was (and maybe still is?) the nature of a Xojo Web Edition app to send every interesting event from every client on a round trip to the server, that’s traffic way beyond what you’d expect from a client app (be that standard single page HTML5 web app, Xojo desktop app or other) communicating with a JSON-RPC server. I would actually expect a client app + JSON-RPC server to generate less network traffic than a Xojo desktop app + db server.
There are two webinars that might be useful, “Database Communication with Xojo”, part 1 and 2
Best google for them - for some reason I can’t find them on http://developer.xojo.com/webinars
Ah, has been renamed to “REST Web services with Xojo”, so they are there.
I don’t say it doesn’t. I am just saying that there are (dis)advantages to both. Consider your requirements, weigh your options and chose the best solution for your particular case. In either instance, the overhead largely depends on how well the app is designed.
And in the face of contemporary Internet infrastructure, squeezing traffic is becoming less and less of a necessity. Like shrinking app sizes from 30 megs to 28 megs in the age of terabyte hard disks.
Omegabundle for Xojo 2016 is available right now for $399, and its got a lot more than just our Valentina products in it.
Something to consider if you are looking at our VDN solution ($599, unlimited distribution of the 5 VDB / 10 SQLite connections) is that these are unnamed connections. Connect, do your business, unconnect. In a workplace type environment, we estimate, based on user feedback, is that you can service at least x 5 the base number of connections. There are significant advantages by using VDB over SQLite, but you can use SQLite and benefit from our server infrastructure. The server, also, has reporting built right into it, and it works with the incorporated VDB and SQLite, and also any number of other databases.
Maybe Raphael wants to tell more about his project.
Yes, Valentina is truly extraordinary. If I should start again from scratch, I will use the SQL plugin from Christian or Valentina. The enormous advantage of Valentina is his native API. You querie the database with Xojo code, classes and methods, without the need to make SQL queries (but still possible). It is more flexible. The error handling is simpler. In the end, this is a huge time saving. And icing on the cake: it will be much faster than the other databases, natively, and yet much faster if the others databases using an ORM (because it is a layer, while Valentina is ORM natively).
[quote=246912:@Jean-Yves Pochez]the real bad thing about filemaker is their script system : soooo unusable
it has not evolved at all[/quote]
Thank you for the explanation.
Aren’t there licensing problems with using MySQL? I love MySQL a lot. But for commercial purposes I should find another DB, I think…
The dual license, which Oracle has been more aggressively enforcing since they bought mySQL
Maria has a similar license
PostgreSQL is simple - free for ANY use right in the first line of the license agreement
I heard the story that a regional government here is currently migrating from Oracle to PostgreSQL. Postgres has definitely a future. 
I have tried on a number of occasions to use PostGres but fail on each attempt.
I have tried the postgres.app software that just tells me that it cannot connect to the server, the log says that my user name does not exist. End of story.
I have no idea how to get the server to start or set up databases, users etc.
Simon.
I just grab the installer from Enterprise DB
It’s worked on every install I’ve done (about 60 or so now)
Then I use the pgAdmin III app to set up databases, users etc
All work I don’t mind as I’m not a full time DBA but have fulfilled that role in a past life
YMMV
If you’ve never set up PostgreSQL before it can a confusing process. I’ve done it a couple of times and know just enough to get by. Google and YouTube can be your friend in this case to figure things out.
Hi Norman, you’re selling a book called “I wish I knew how to program PostgreSQL with Xojo desktop” , written by @Eugene Dakin , which explains every single step about installing Postgres.
Yes, I think MySQL licensing is complicated, but regardless, it remains quite popular.
I will check this out.
Thanks to all.
Simon.
Yup
I’ve never needed it 