Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Craig Ringer
On 01/17/2011 11:31 PM, Jensen Somers wrote: But, from your initial reply I understood that a user can simply browse to my database installation folder (e.g.: C:/ProgramData/MyApp/data), read out and/or modify a configuration file and he can access the entire database and modify the data. And th

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Adrian Klaver
On 01/17/2011 10:21 AM, Jensen Somers wrote: The ORM framework I want to use is http://dataobjects.net/ - Jensen Hmm, sees you might have to be patient:) From the their manual: Upcoming storage providers include: * Built-in file system database (i.e. regular embedded database) Any be

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Jensen Somers
On 17/01/2011 17:26, Adrian Klaver wrote: On Monday 17 January 2011 8:11:20 am Jensen Somers wrote: On 17/01/2011 16:46, Andrew Sullivan wrote: On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote: But, from your initial reply I understood that a user can simply browse to my database

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Adrian Klaver
On Monday 17 January 2011 8:11:20 am Jensen Somers wrote: > On 17/01/2011 16:46, Andrew Sullivan wrote: > > On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote: > >> But, from your initial reply I understood that a user can simply browse > >> to my database installation folder (e.g.: C:/P

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Jensen Somers
On 17/01/2011 16:46, Andrew Sullivan wrote: On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote: But, from your initial reply I understood that a user can simply browse to my database installation folder (e.g.: C:/ProgramData/MyApp/data), read out and/or modify a configuration file a

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Andrew Sullivan
On Mon, Jan 17, 2011 at 04:31:45PM +0100, Jensen Somers wrote: > > But, from your initial reply I understood that a user can simply browse > to my database installation folder (e.g.: C:/ProgramData/MyApp/data), > read out and/or modify a configuration file and he can access the entire > datab

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Jensen Somers
Hi, On 17/01/2011 14:49, Craig Ringer wrote: On 01/17/2011 06:46 PM, Jensen Somers wrote: Once a recording session is completed the data should be locked and not modified anymore. And everything should be local on the user's PC, I can't use an external database server. Those two requirements

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Andrew Sullivan
On Mon, Jan 17, 2011 at 11:46:11AM +0100, Jensen Somers wrote: > I am migrating from a binary data format. But it's hard to maintain and > add new features. Most of the operations I need to perform on the data > is list, sort and analyze, which is why I'm interested into using a > database as

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Craig Ringer
On 01/17/2011 06:46 PM, Jensen Somers wrote: Once a recording session is completed the data should be locked and not modified anymore. And everything should be local on the user's PC, I can't use an external database server. Those two requirements are mutually exclusive, unless you're willing

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-17 Thread Jensen Somers
Hi, On 15/01/2011 14:21, Craig Ringer wrote: On 01/14/2011 03:45 PM, Jensen Somers wrote: Bundling it as part of my application is even better. I didn't knew if that would be possible, but it would solve some of the issues. Mainly data protection. The data that needs to be stored should not be

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-15 Thread Craig Ringer
Bundling it as part of my application is even better. I didn't knew if that would be possible, but it would solve some of the issues. Oh, I meant to mention: Whether bundling directly in your installer or invoking the exe installer silently, you need to consider the major version incompatib

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-15 Thread Craig Ringer
On 01/14/2011 03:45 PM, Jensen Somers wrote: Bundling it as part of my application is even better. I didn't knew if that would be possible, but it would solve some of the issues. Mainly data protection. The data that needs to be stored should not be altered by users. If they have access to the da

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-13 Thread Jensen Somers
Hi, On 14/01/2011 7:35, Craig Ringer wrote: On 01/14/2011 06:26 AM, Jensen Somers wrote: I know that some applications (Poker Tracker 3 is the first one that comes to my mind) It's not a good example, either, as demonstrated by the number of questions that pop up about it on this list, and

Re: [GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-13 Thread Craig Ringer
On 01/14/2011 06:26 AM, Jensen Somers wrote: I know that some applications (Poker Tracker 3 is the first one that comes to my mind) It's not a good example, either, as demonstrated by the number of questions that pop up about it on this list, and the incredibly ancient versions of Pg that th

[GENERAL] Install PostgreSQL as part of a desktop application, but how to coop with existing installations?

2011-01-13 Thread Jensen Somers
Hi, I am looking into using PostgreSQL as a database service in a desktop application since it's one of the support local database systems by DataObjects.net and has more features and higher limitations than SQL server express. I prefer a database versus a traditional binary data file, but I