Devart Forums

Hi All,
I am developing and client database which needs to be accessed my multiple users.
are their any demo applications etc. on how to do it and also how each machine can get the current data.
The version I am developing with has the database on a networked drive.

also which product should I be using for my MySql delevopment. I am using Delphi 7 to write the software.

Tom

Hello,

To work with MySQL server, you can use MyDAC. There is MyDACDemo project that is supplied with MyDAC. You can take this project, copy it to several machines (or run several instances of the project on a machine) and connect to the same MySQL server. This way, you can simulate having multiple connections from different users.

oops, I mucked up. I meanr to say Sqlite not Mysql.
Sorry about that.
Have been working with two different applications.
This one for clients would be hard to setup mySql since they don't have a server, more like a networked drive. Which is why Sqlite3 seems to be the way.
The original version was writeen using Volga Database, but the new version will need to work with Android as well.

Tom

Once again, so sorry about that.

To work with SQLite, you should use UniDAC ( http://www.devart.com/unidac ). UniDAC has a demo project as well, so you can use it in the ways I described in my previous post.

Just to make sure.
With the Standard version could I.
1. Connect multiple machines to the same database
2. Just using a mapped network drive
3. Have an easy way to update the other machines when an update is done.
4. be nice and quick. 10 tables with up to 10,000 records on a couple of the tables.
5. Easy for me to do. lol

Tom

The SQLite provider is not included in the Standart edition of UniDAC. To work with SQLite using UniDAC, you should use the UniDAC Professional edition. You can find more information about the UniDAC editions at http://www.devart.com/unidac/editions.html
Using UniDAC you will be able to connect multiple computers to one database that is located on the network drive. To have the latest updates that were made in the database by other users, you have to refresh datasets in your application (because there is no notifications in SQLite). UniDAC has high performance, so your application that use UniDAC will work with an SQLite database fast.