Re: [Sqlgrey-users] database configuration

[Paweł M. <paw...@pr...>]

On Sun, 3 Oct 2010 22:52:07 +0200, Lionel Bouton
<lio...@bo...> wrote:
> The Sun, 03 Oct 2010 22:27:02 +0200,
> Paweł Madej <paw...@pr...> wrote:
> 
>> [...] Now if I want to use my database I
>> need to edit sqlgrey main file and add prefixes to tables.
> 
> I don't see any valid reason why an admin could not use a dedicated
> database for SQLgrey. Every officially supported DBMS (PostgreSQL,
> MySQL and SQLite) supports multiple databases, it's a core feature
> every DBA should expect and use.
> For software designed to share a common database (with a set of
> commonly used reference tables for example) I can understand prefixes.
> In SQLgrey's case it seems to me it's complexity for no good reason.
> 
> Lionel

Hello,

The reason for which I need sqlgrey with prefixed tables is that I got
set foreign keys to other mail tables which manage optin/out and so on.
This if for consistency of my mail database. Prefixes also give me
better readability of tables.

With different tables it isn't possible.
--
Greets
Pawel