Derek Atkins wrote:
>Mark Johnson <[EMAIL PROTECTED]> writes:
>
>
>
>>I may be getting a bit ahead of the play here, since you are talking
>>about design still, and I am thinking about implementation of it in a
>>MySql backend.
>>
>>I was recently doing some research on storing GUIDs in MySQL.
Quoting Benoit Gregoire <[EMAIL PROTECTED]>:
>> > Fair enough, it's fixed length. But it will make for really ugly SQL for
>> > JOINS, with the only benefit of saving four bytes. I think using a
>> > varbinary is much preferable (and just as portable).
>>
>> Or a varchar(32) and the hexstring...
> > Fair enough, it's fixed length. But it will make for really ugly SQL for
> > JOINS, with the only benefit of saving four bytes. I think using a
> > varbinary is much preferable (and just as portable).
>
> Or a varchar(32) and the hexstring... Just as portable and actually
> human-readable (a
Quoting Benoit Gregoire <[EMAIL PROTECTED]>:
> On Thursday 26 October 2006 22:43, Phil Longstaff wrote:
>> 3) All object ids are (or should be) GUIDs. A GUID is represented by a
>> set of 4 int fields. I use this instead of varbinary because it isn't
>> variable length. I don't use any text ty
On Thursday 26 October 2006 22:43, Phil Longstaff wrote:
> 3) All object ids are (or should be) GUIDs. A GUID is represented by a
> set of 4 int fields. I use this instead of varbinary because it isn't
> variable length. I don't use any text type because I don't want any
> issues with 0x00 as a
I've attached an updated DDL for the proposed SQL backend. I used MySQL
to test, and it creates the tables correctly.
Some notes:
1) This only covers the core objects i.e. the DDL is based on
src/backend/file/*-v2.c.
2) The namespace for the commodities table is just a string. I'm unsure
about
Quoting Daniel Espinosa <[EMAIL PROTECTED]>:
> I'd checked the SQLite 3, and it doesn't support foreing keys, but
> triggers. Then may be in the future, after finish the SQL backend
> support in GC, we can create a "gnc-data-server" a la Evolution, in
> order to read, insert and update some record
On Thu, 2006-10-26 at 15:33 -0400, Derek Atkins wrote:
> Quoting Benoit Gregoire <[EMAIL PROTECTED]>:
> >
> > While I fully understand your feeling, sharing with other programs is
> > probably
> > the primary reason why users want a SQL in the first place. Since we KNOW
> > people will use it thi
2006/10/26, Ivars Grinbergs <[EMAIL PROTECTED]>:
Derek Atkins wrote:
> "Daniel Espinosa" <[EMAIL PROTECTED]> writes:
>
>
>>> 1) We don't need an AccountType table. AccountTypes are not data,
>>>they are encoded in the application. There's no reason to add
>>>them to the database because
Hi,
Am Donnerstag, den 26.10.2006, 18:09 +0300 schrieb Ivars Grinbergs:
> Hi,
> just got compiled GC 2.0.2 under my Win XP Pro.
>
> Have had to do slight workarounds:
>
> 1) de-installed active perl which was installed on system long before
> tring to compile GC and which was referenced in PATH
On Thursday 26 October 2006 15:51, Graham Leggett wrote:
> Benoit Gregoire wrote:
> > Yes you can (whith a "real" database). Checking that the sum of the
> > transaction's splits is 0 it trivial if all splits use the same
> > commodity, and mostly irrelevent if they don't. That's a really simple
Benoit Gregoire wrote:
Yes you can (whith a "real" database). Checking that the sum of the
transaction's splits is 0 it trivial if all splits use the same commodity,
and mostly irrelevent if they don't. That's a really simple stored
procedure.
And in the process, you restrict people to usi
> Actually, I think the primary reason users want SQL are to be able
> to run their own reports, multi-user, and automatic commits (saves
> on commit). I dont think that sharing the data read/write is high on
> the list of requirements. Also, I dont think we can depend on stored
> procedures; SQ
On Thursday 26 October 2006 10:49, Ivars Grinbergs wrote:
> Derek Atkins wrote:
> > "Daniel Espinosa" <[EMAIL PROTECTED]> writes:
> >>> 1) We don't need an AccountType table. AccountTypes are not data,
> >>>they are encoded in the application. There's no reason to add
> >>>them to the dat
On Thursday 26 October 2006 14:49, Phil Longstaff wrote:
> On Thu, 2006-26-10 at 09:53 -0400, Derek Atkins wrote:
> > Mark Johnson <[EMAIL PROTECTED]> writes:
> > > I may be getting a bit ahead of the play here, since you are talking
> > > about design still, and I am thinking about implementation
Quoting Benoit Gregoire <[EMAIL PROTECTED]>:
>> You can't get enough data integrity from the database. For example,
>> you cannot define the database in a way to enforce balanced transactions.
>
> Yes you can (whith a "real" database). Checking that the sum of the
> transaction's splits is 0 it
On Thursday 26 October 2006 10:02, Derek Atkins wrote:
> "Daniel Espinosa" <[EMAIL PROTECTED]> writes:
> >> 1) We don't need an AccountType table. AccountTypes are not data,
> >>they are encoded in the application. There's no reason to add
> >>them to the database because they are constan
On Thu, 2006-26-10 at 09:53 -0400, Derek Atkins wrote:
> Mark Johnson <[EMAIL PROTECTED]> writes:
>
> > I may be getting a bit ahead of the play here, since you are talking
> > about design still, and I am thinking about implementation of it in a
> > MySql backend.
> >
> > I was recently doing s
Quoting Phil Longstaff <[EMAIL PROTECTED]>:
> I am looking at having an int as the primary key for references to a
> table. The GUID would be stored with the row as 4 ints (guid_1, guid_2,
> guid_3 and guid_4). If we need to search a lot by GUID, we could have
> an index which spans those 4 colu
Hi,
just got compiled GC 2.0.2 under my Win XP Pro.
Have had to do slight workarounds:
1) de-installed active perl which was installed on system long before
tring to compile GC and which was referenced in PATH env variable:
without this change install failed!
2) I used old slib3a3 (when tried
Derek Atkins wrote:
> "Daniel Espinosa" <[EMAIL PROTECTED]> writes:
>
>
>>> 1) We don't need an AccountType table. AccountTypes are not data,
>>>they are encoded in the application. There's no reason to add
>>>them to the database because they are constants.
>>>
>>>
>> If useful
"Daniel Espinosa" <[EMAIL PROTECTED]> writes:
>> 1) We don't need an AccountType table. AccountTypes are not data,
>>they are encoded in the application. There's no reason to add
>>them to the database because they are constants.
>>
>
> If usefull if you want a strong data integrity done
"Daniel Espinosa" <[EMAIL PROTECTED]> writes:
> 2006/10/25, Josh Sled <[EMAIL PROTECTED]>:
>> On Wed, 2006-10-25 at 14:52 -0500, Daniel Espinosa wrote:
>> > Let me study this items, but at first, I could say that the way
>> > GnuCash handles the numeric values and representation, could be out
>> >
"Daniel Espinosa" <[EMAIL PROTECTED]> writes:
>> 1) Accounts: parent is not null. However, the top level accounts
>> (Assets, Liabilities, ...) don't have a parent. In addition, the parent
>> should be a foreign key reference back to the Accounts table.
>>
>
> parent could be set to NULL if the
Mark Johnson <[EMAIL PROTECTED]> writes:
> I may be getting a bit ahead of the play here, since you are talking
> about design still, and I am thinking about implementation of it in a
> MySql backend.
>
> I was recently doing some research on storing GUIDs in MySQL. There is
> no guid type in
Benoit Gregoire <[EMAIL PROTECTED]> writes:
>> But in recent svn versions, this architectural problem has been made
>> worse. I've seen the transactions created by the generic import
>> matcher before, but the appropriate ones would be removed upon
>> Finalize. Now, the matcher seems to finalize b
On Wednesday 25 October 2006 15:57, Phil Longstaff wrote:
> I'd be happy to look at what you have. It seems to me that there will
> be enough differences that I won't be able to use much. I assume you
> used the Qt SQL classes rather than libgda or libdbi so I can't use much
> (if anything) of yo
On Thu, October 26, 2006 10:39 am, Christof Donat wrote:
> Last time I looked at it (sca. 1/2 Jear ago) the Compiere-website stated
> that
> they need Oracle as a DB. I found a PostgreSQL-port which I didn't get to
> work in a stable way.
I also did a round of research into this, and the DB issue
Hi!
> Has anyone heard about Compiere? I learned about it from this
> LWN article: http://lwn.net/SubscriberLink/205774/b5904cbddc0c5292/
>
> It states that Compiere is mainly about ERP and CRM but
> "There is also a full business accounting package". Apart
> from that the LWN article is about a f
Hi!
Has anyone heard about Compiere? I learned about it from this
LWN article: http://lwn.net/SubscriberLink/205774/b5904cbddc0c5292/
It states that Compiere is mainly about ERP and CRM but
"There is also a full business accounting package". Apart
from that the LWN article is about a fork in Comp
30 matches
Mail list logo
