Lazarus

Programming => General => Topic started by: lawman on January 27, 2020, 03:38:22 pm

Title: Alternative to shortcut
Post by: lawman on January 27, 2020, 03:38:22 pm
I want to keep a windows app and sqlite db on a mapped network drive, to be accessed by multiple users.

I'm hoping this removes the need to keep the app on each user's local pc, as updating becomes an issue.

Tried creating a shortcut link, but running that always gives security warning that network app creator is unknown.   Can still press continue and run file.

Instead of a shortlink, I'd like to create a small pascal exe which simply runs the network stored exe app, then shut itself down.

Whats the best way to do this?

thanks
Title: Re: Alternative to shortcut
Post by: marcov on January 27, 2020, 04:12:42 pm
Migrate to a client server solution as quick as possible and dump sqlite?

Running multiuser file based databases in combination with networking requires all kinds of locking issues.
Title: Re: Alternative to shortcut
Post by: ASBzone on January 27, 2020, 05:26:06 pm
Migrate to a client server solution as quick as possible and dump sqlite?

Running multiuser file based databases in combination with networking requires all kinds of locking issues.
;D
Title: Re: Alternative to shortcut
Post by: lawman on January 27, 2020, 06:30:15 pm
Lol

dB concurrency aside, what's best way for app 1 to run app 2.

Then either close or continue depending on separate issues

Thx
Title: Re: Alternative to shortcut
Post by: garlar27 on January 27, 2020, 07:22:34 pm
Lol

dB concurrency aside, what's best way for app 1 to run app 2.

Then either close or continue depending on separate issues

Thx

What marcov said is the best way to go.

If not the only thing I can think of is is a Client and a Server app where the server handles the writings so they donĀ“t overlap SQLite is not prepared for simultaneous writing.
TinyPortal © 2005-2018