Re: [sqlite] SQLLite Question regarding instances and files
Thanks for the Reply Adam and no I had not concidered your alternative. But I have considered the issues of perfomance, unexpected loss of connection, multiple connections to one database file as well as the overhead of creating a new database everytime a new test is to be run. I think cons of going with an unorthodox setup such as this out way the pros of doing something more traditional even if the up front work is more difficult. Thanks John From: Adam DeVita To: General Discussion of SQLite Database Sent: Tuesday, September 18, 2012 9:36 AM Subject: Re: [sqlite] SQLLite Question regarding instances and files Good day, You are treating the database files as test log files, correct? If you are wanting a PC to execute a program that accesses an sqlite database file on a network, it is possible. If you read through previous discussions in this mail list archive you will find numerous warnings and challenges people have while attempting to share a db on a network directory. a) Performance b) Issues handling unexpected loss of connection or media c) Issues handling multiple clients attempting to access the same database file. Have you considered creating the little local databases and then moving them to a network share when the test is done? regards, Adam On Mon, Sep 17, 2012 at 1:08 PM, Wilk, John (J.R.) wrote: > My question is that I have a client who would like to be able to have a > different database file for each group of data they are collecting (a test > involving data acquisition). The database file would be saved to a network > share that would occasionally get backed up by the network admin. The > database itself would be run locally. Every time a new test was run a new > database file would be generated and every time a test needed to be analyzed > a different database file would have to be opened. I know this is a little > unorthodox and without getting into why the client wishes to do this I was > wondering if it's even possible much less a good idea? > > Thanks > John > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- VerifEye Technologies Inc. 905-948-0015x245 151 Whitehall Dr, Unit 2 Markham ON, L3R 9T1 Canada ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLLite Question regarding instances and files
Good day, You are treating the database files as test log files, correct? If you are wanting a PC to execute a program that accesses an sqlite database file on a network, it is possible. If you read through previous discussions in this mail list archive you will find numerous warnings and challenges people have while attempting to share a db on a network directory. a) Performance b) Issues handling unexpected loss of connection or media c) Issues handling multiple clients attempting to access the same database file. Have you considered creating the little local databases and then moving them to a network share when the test is done? regards, Adam On Mon, Sep 17, 2012 at 1:08 PM, Wilk, John (J.R.) wrote: > My question is that I have a client who would like to be able to have a > different database file for each group of data they are collecting (a test > involving data acquisition). The database file would be saved to a network > share that would occasionally get backed up by the network admin. The > database itself would be run locally. Every time a new test was run a new > database file would be generated and every time a test needed to be analyzed > a different database file would have to be opened. I know this is a little > unorthodox and without getting into why the client wishes to do this I was > wondering if it's even possible much less a good idea? > > Thanks > John > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- VerifEye Technologies Inc. 905-948-0015x245 151 Whitehall Dr, Unit 2 Markham ON, L3R 9T1 Canada ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLLite Question regarding instances and files
My question is that I have a client who would like to be able to have a different database file for each group of data they are collecting (a test involving data acquisition). The database file would be saved to a network share that would occasionally get backed up by the network admin. The database itself would be run locally. Every time a new test was run a new database file would be generated and every time a test needed to be analyzed a different database file would have to be opened. I know this is a little unorthodox and without getting into why the client wishes to do this I was wondering if it's even possible much less a good idea? Thanks John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users