Re: [GENERAL] managing tablespaces like files?

2010-03-09 Thread Sam Carleton
n Graf wrote: > On 3/9/2010 12:45 PM, Sam Carleton wrote: > > On Tue, Mar 9, 2010 at 10:06 AM, Justin Graf wrote: > >> >> > Justin, > > Thank you for the reply. My application uses two databases at one time: > system db and the "event" db. The

Re: [GENERAL] managing tablespaces like files?

2010-03-08 Thread Sam Carleton
I would like to thank both John and Scott for the help. It is very clear to me that PostgreSQL isn't the ideal solution for my current model. The conversation has gotten me thinking of ways the model could be modified to work with PostgrSQL (and other client/server RDBM). Thus I will return to t

Re: [GENERAL] managing tablespaces like files?

2010-03-08 Thread Sam Carleton
On Mon, Mar 8, 2010 at 5:46 PM, John R Pierce wrote: > >> I hear you, but I am not willing to throw in the towel, just yet... >> Generally speaking, is there a lot of metadata that would need to be >> exported? As I think about this, I am thinking I would have to read in ALL >> the system table

Re: [GENERAL] managing tablespaces like files?

2010-03-08 Thread Sam Carleton
On Mon, Mar 8, 2010 at 4:07 PM, John R Pierce wrote: > > and what happens if someone copies your directory without shutting down the > instance? > Well, that is an issue right now, the current SQLite DB is locked by the app and cannot currently be copied while the app is running. Or at least I

Re: [GENERAL] managing tablespaces like files?

2010-03-08 Thread Sam Carleton
ime I am simply better off with Firebird.) Sam Carleton Developer of Photo Parata <http://www.miltonstreet.com>

[GENERAL] managing tablespaces like files?

2010-03-08 Thread Sam Carleton
The server of my client/server program is currently using SQLite, an embedded file based SQL engine. I am looking for a client/server based RDBM and have narrowed it down to either PosgreSQL or Firebird. I would prefer to use PosgreSQL, but the management of the physical files are concerning me.