sqlite server windows

[Johnny_Harris]

Yeah, I wasn’t proposing it as a solution for all. I was just sharing what I do in some cases.

[James_Dooley]

@61135:@Richard Duke

my system need to be use be able to used by one person (standalone) or a few users (server) using the same data file. With CubeSQL all i need to do is just change the indicator standalone or server. my program has already cater for both.

How about concurrency, audit trails, user access and so on. Have you designed your app as a multiuser app that happens to be able to run single user or what?

[Simon_Berridge]

Have you considered Studo Stable? This is a client/server SQLite database with multi-users.

[Alexis_Colon_Lugo]

i have Studio Stable but have some problems with speed.
i am working on it to see what is the problem.

[James_Dooley]

@61171:@Joseph Morgan

That is a possible solution but I suppose it may not be viable for some developers who want to deploy to many-many users of which I’m sure some would not want to be bothered with installing additional software. That being said all things being equal (pricing especially) I would use CubeSQL if I actually had an app to sell to the masses.

In most cases where you buy a multi user package these days it does not include the database server. And if they already have a database server, they expect to be able to use your package on it.

[Richard_Duke]

@61183:@James Dooley

How about concurrency, audit trails, user access and so on. Have you designed your app as a multiuser app that happens to be able to run single user or what?

yes… my application already cater for things like that… for my ACMS application, just one to generate both single and multiuser. if the client decide they want modification, only then create a new folder for them.