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-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 separated the

[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

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 next

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 the

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. I

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

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 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 to use

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 you ;-)

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 the