Return-Path: 
 <users-return-16090-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 98998 invoked from network); 10 Sep 2010 09:19:18 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 10 Sep 2010 09:19:18 -0000
Received: (qmail 90142 invoked by uid 500); 10 Sep 2010 09:19:17 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 89977 invoked by uid 500); 10 Sep 2010 09:19:15 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 89959 invoked by uid 99); 10 Sep 2010 09:19:13 -0000
Received: from Unknown (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Sep 2010 09:19:13 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of mkhatrijava@gmail.com
 designates 74.125.82.50 as permitted sender)
Received: from [74.125.82.50] (HELO mail-ww0-f50.google.com) (74.125.82.50)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Sep 2010 09:18:51 +0000
Received: by wwb18 with SMTP id 18so2853941wwb.19
        for <users@jackrabbit.apache.org>;
 Fri, 10 Sep 2010 02:18:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:received:in-reply-to
         :references:date:message-id:subject:from:to:content-type;
        bh=WvBecdPpN6PBi+wZOrLJlBSrmw3Q7JSaLT5x/2hNTeg=;
        b=G1gSrcIIUHC5L8CqEdsjAAch7G944DYouhT+XbNau06Hf0f6g4HBYxZBNJZ2vSqDrk
         JImKn63+uCKb7CMzYrdLxjzVE6Q6Z1WMZd7cJ2m8CP4qGKP9vf2E4dxpwsJP92MKThw7
         cxRyPb5O5TsggmYAalFGlF/grDCCYFmy095wc=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=Oft+qN648flmcMQXqhAYrD02yF0G8wfC2p64EgFzkGtKWKB4wQQ+gWsX/Tsa+PVnVt
         GcGux+sReGrflAU3OSfVYmTcQ9kEmZvl14fDAU+MX1Ld28DpIilezGmTsn/alvkjmNYr
         8o2PufcpjsdKTq2JkP6Dv2ybAoa5bPckI8AtI=
MIME-Version: 1.0
Received: by 10.227.135.18 with SMTP id l18mr726474wbt.120.1284110310439; Fri,
 10 Sep 2010 02:18:30 -0700 (PDT)
Received: by 10.227.135.80 with HTTP; Fri, 10 Sep 2010 02:18:30 -0700 (PDT)
In-Reply-To: <AANLkTin4VeAhQ7eqD8w1iAq2r7vfzCsOHAsep=ymu6U-@mail.gmail.com>
References: <AANLkTin4VeAhQ7eqD8w1iAq2r7vfzCsOHAsep=ymu6U-@mail.gmail.com>
Date: Fri, 10 Sep 2010 11:18:30 +0200
Message-ID: <AANLkTinb9pXN0QLDSKt=h48f2jm-64fAoaPbxHPmXYGb@mail.gmail.com>
Subject: Re: naming conventions to name the tables for workspace and version
From: Meenakshi Khatri <mkhatrijava@gmail.com>
To: users@jackrabbit.apache.org
Content-Type: multipart/alternative; boundary=0016e6567da0e7fd6a048fe43a15
X-Virus-Checked: Checked by ClamAV on apache.org

--0016e6567da0e7fd6a048fe43a15
Content-Type: text/plain; charset=ISO-8859-1

Hello everyone,

Has anyone have experience in maintaining 2 seperates databases in
Postgres? One for Workspace and One for Versioning?

Is it beneficial to save both the details in one database?

Thanks and Regards,
Meenakshi

On Fri, Sep 3, 2010 at 4:25 PM, Meenakshi Khatri <mkhatrijava@gmail.com>wrote:

> Hello everyone,
>
> Could  you please tell me what is the most preffered naming convention to
> be followed while naming workspace tables and version tables?
>
> For my workspace: I am using:
> <param name="schemaObjectPrefix" value="${wsp.name}_"/>
>
> For my version: I am using:
> <param name="schemaObjectPrefix" value="fs_ver_"/>
>
> Also, I want to know if its a good idea to keep workspace and version
> tables in one database or create 2 databases, one to handle workspace tables
> and other to handle versioning.
>
> Please let me know as soon as possible.
>
> Thanks in advance,
> Meenakshi
>
>

--0016e6567da0e7fd6a048fe43a15--