Re: [GENERAL] chosing a database name

2005-07-14 Thread Karsten Hilbert
On Thu, Jul 14, 2005 at 11:18:30AM +1000, Tim Allen wrote: > Others have given you some of the advice I would have given. One more > suggestion - does your database fit in just one "schema" in the gnumed > database? It would, for the time being, "size-wise". However, we have conceptually separat

Re: [GENERAL] chosing a database name

2005-07-14 Thread Karsten Hilbert
On Wed, Jul 13, 2005 at 04:18:34PM -0400, Vivek Khera wrote: > I concur with this advice. Just use a sequence number which happens > to correspond with your software release numbers... or not. They can > be separate, especially once you get more stable and have more > software updaes than

Re: [GENERAL] chosing a database name

2005-07-13 Thread Tim Allen
Karsten Hilbert wrote: My main concern, however, was whether the *approach* is sound, eg using a separate database name per release or IOW version. One way would be to use the database name "gnumed" regardless of release, another way would be to use "gnumedX_Y" for release X.Y. I wonder whether

Re: [GENERAL] chosing a database name

2005-07-13 Thread Richard_D_Levine
[EMAIL PROTECTED] wrote on 07/13/2005 02:59:02 PM: > On Wed, Jul 13, 2005 at 12:53:15PM -0400, Alvaro Herrera wrote: > > > > we are developing GNUmed, a medical practice management > > > application running on PostgreSQL (you want your medical > > > data to be hosted by something reliable, don't

Re: [GENERAL] chosing a database name

2005-07-13 Thread Karsten Hilbert
On Wed, Jul 13, 2005 at 01:21:01PM -0700, Philip Hallstrom wrote: > >My main concern, however, was whether the *approach* is > >sound, eg using a separate database name per release or IOW > >version. One way would be to use the database name "gnumed" > >regardless of release, another way would be

Re: [GENERAL] chosing a database name

2005-07-13 Thread Philip Hallstrom
we are developing GNUmed, a medical practice management application running on PostgreSQL (you want your medical data to be hosted by something reliable, don't you ;-) We are putting out our first release sometime in the next two weeks. The idea is to name the production database "gnumed0.1" for

Re: [GENERAL] chosing a database name

2005-07-13 Thread Vivek Khera
On Jul 13, 2005, at 1:18 PM, Berend Tober wrote: Or why bother including either? Just use sequential integers, maybe left-padded with zeros to make the name the same length for the first thousand or so releases? I concur with this advice. Just use a sequence number which happens to c

Re: [GENERAL] chosing a database name

2005-07-13 Thread Karsten Hilbert
On Wed, Jul 13, 2005 at 01:18:09PM -0400, Berend Tober wrote: > Or why bother including either? Just use sequential integers, maybe > left-padded with zeros to make the name the same length for the first > thousand or so releases? A good tip, too, thanks. Would solve the ambiguity dilemma, too.

Re: [GENERAL] chosing a database name

2005-07-13 Thread Karsten Hilbert
On Wed, Jul 13, 2005 at 12:53:15PM -0400, Alvaro Herrera wrote: > > we are developing GNUmed, a medical practice management > > application running on PostgreSQL (you want your medical > > data to be hosted by something reliable, don't you ;-) We > > are putting out our first release sometime in

Re: [GENERAL] chosing a database name

2005-07-13 Thread Berend Tober
Alvaro Herrera wrote: On Wed, Jul 13, 2005 at 05:56:03PM +0200, Karsten Hilbert wrote: we are developing GNUmed, a medical practice management application running on PostgreSQL (you want your medical data to be hosted by something reliable, don't you ;-) We are putting out our first releas

Re: [GENERAL] chosing a database name

2005-07-13 Thread Alvaro Herrera
On Wed, Jul 13, 2005 at 05:56:03PM +0200, Karsten Hilbert wrote: > we are developing GNUmed, a medical practice management > application running on PostgreSQL (you want your medical > data to be hosted by something reliable, don't you ;-) We > are putting out our first release sometime in the nex

[GENERAL] chosing a database name

2005-07-13 Thread Karsten Hilbert
Hi all, we are developing GNUmed, a medical practice management application running on PostgreSQL (you want your medical data to be hosted by something reliable, don't you ;-) We are putting out our first release sometime in the next two weeks. The idea is to name the production database "gnumed