Lazarus
Programming => General => Topic started by: iamtheatorres2408 on February 09, 2019, 08:49:59 am
-
Good day,
how can i share the application i build with sqlite to other computers. i tried creating a shortcut file but and error "can't open database", appeared..what else can i do to let my workmates use the application i created. thank you so much in advance..
-
are you using a network.
then get the physical address of your database instead of your local one
-
good day,
im going to save the whole file of the system in a server, where can i get the physical address of my database?
-
Might depend exactly what you mean by "share" ?
Do you want your workmates to be able to see and make changes to the data in your sqlite database ? From memory, sqlite is not really intended as a multiuser system, there is no database server as such, just a file that contains the data, your app has the code to work with the data file. So, if you put that file on a shared drive for example, sooner or later you will have locking problems as two people change it at the same time.
If the other people just need to read the data, you could give them a copy of both your binary and your database file. And maybe you'd need to send them an updated version from time to time.
Or, maybe you want to give them the app and let them create and manage their own dataset ? Thats easy too.
Maybe, sorry to have to say this, but maybe you need a multiuser database .....
Davo
-
how can i share the application i build with sqlite to other computers. i tried creating a shortcut file but and error "can't open database", appeared..what else can i do to let my workmates use the application i created. thank you so much in advance..
Might depend exactly what you mean by "share" ?
Do you want your workmates to be able to see and make changes to the data in your sqlite database ? From memory, sqlite is not really intended as a multiuser system, there is no database server as such, just a file that contains the data, your app has the code to work with the data file. So, if you put that file on a shared drive for example, sooner or later you will have locking problems as two people change it at the same time.
If the other people just need to read the data, you could give them a copy of both your binary and your database file. And maybe you'd need to send them an updated version from time to time.
Or, maybe you want to give them the app and let them create and manage their own dataset ? Thats easy too.
Maybe, sorry to have to say this, but maybe you need a multiuser database .....
+1
Why don't you try real database servers such as Firebird, PostgreSQL, MariaDB etc?
-
thanks for the suggestions guys, im new in pascal so i dont know how to use other database ..but ill try yous suggestions guys..thank you very much :D :D :D