Re: [sqlite] SQLLite Question regarding instances and files

[John Wilk]

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 <adev...@verifeye.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org> 
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.) <jwil...@ford.com> 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

[Adam DeVita]

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

[Wilk, John (J.R.)]

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