Greetings everyone,
I have been using gnucash for awhile now, and I'm interested in
helping with the development. I've been following your conversation on
rdbms, and I think I can help with that module.
I do Oracle programming and I'm pretty good with SQL and database
design in general. I can re
On Fri, Dec 08, 2000 at 05:37:12PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I have been using gnucash for awhile now, and I'm interested in
> > helping with the development. I've been following your conversation
> > on
On Sat, Dec 09, 2000 at 11:56:20AM +1100, Robert Graham Merkel wrote:
> Rob Browning writes:
> > [EMAIL PROTECTED] (Bill Gribble) writes:
> >
> > > jody suggested that the gnumeric folks might be receptive to an
> > > app-neutral refactoring of the financial stuff in gnumeric. If we can
> >
There is some code in /src/engine/sql that says it is broken. How bad
is it? Should it be thrown away? Is there something salvageable?
--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project[EMAIL PROTECTED]
Collection Editor & Coordinato
On Sat, Dec 09, 2000 at 05:14:47PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > Oh, is that similar to ODBC in that it abstracts the database behind
> > an API through which you pass SQL? Maybe that answers my questions
> > abo
On Sat, Dec 09, 2000 at 05:00:20PM -0600, Rob Browning wrote:
> Steve Greenland <[EMAIL PROTECTED]> writes:
>
> > I'm not trying to start a religious war, but at the moment, MySQL
> > doesn't support transactions, which I see as one of the big gains in
> > moving from (or supporting in addition t
On Sun, Dec 10, 2000 at 01:50:02PM -0500, Derek Atkins wrote:
> One of my personal requirements is strong security. This implies data
> encryption, data integrity, and cryptographic user authentication
> between the GnuCash engine and the Database datastore (especially if
> they are on different
I said I would work on the database schema today, but my partner and I
decided it was time to put our tree up, before Yule was past. :-)
So no schema. I'll try to do some work on it tomorrow night.
--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project
On Sun, Dec 10, 2000 at 10:40:03PM -0600, Christopher Browne wrote:
> On Mon, 11 Dec 2000 11:32:49 +1000, the world broke into rejoicing as
> "Phillip Shelton" <[EMAIL PROTECTED]> said:
> > How does all of this affect the `closing the books'. If the books are
> > `close-able' then maybe we do no
On Mon, Dec 11, 2000 at 03:12:12PM -0600, Steve Greenland wrote:
> On 11-Dec-00, 14:43 (CST), Phillip J Shelton <[EMAIL PROTECTED]> wrote:
> > Sorry to be dense. Isn't there some way to have the DB store the current
> > balance with each record? That way the current balence would just be the
>
On Tue, Dec 12, 2000 at 06:43:17AM +1000, Phillip J Shelton wrote:
> Sorry to be dense. Isn't there some way to have the DB store the current
> balance with each record? That way the current balence would just be the
> current balence from the last record.
>
> Or is that more expensive than I r
On Tue, Dec 12, 2000 at 05:16:19AM +, Al Snell wrote:
> On Mon, 11 Dec 2000, David Merrill wrote:
>
> > So that means you would retrieve the current balance, and then work
> > *backwards* from there to calculate running balances in the ledger?
> > That sounds like
On Tue, Dec 12, 2000 at 12:35:45PM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> [snip]
>
> > But I do take issue with the argument that period closing, and the
> > transfer of the account balance, is the way to accomplish this. It
I'm beginning to work on the database schema for an eventual SQL back
end. I am keeping my notes in an ASCII file, which will always be
available at http://www.lupercalia.net/schema.txt
You can view this document at any time to see my progress. Right now
it is extremely sparse but will grow as I
On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote:
> David Merrill wrote:
>
> > I'm beginning to work on the database schema for an eventual SQL back
> > end. I am keeping my notes in an ASCII file, which will always be
> > available at http://
On Tue, Dec 12, 2000 at 03:02:15PM -0600, Bill Gribble wrote:
> On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote:
> > It is the smallest amount that this account can change by. GnuCash is
> > now using a variation on rational numbers which have a numerator, the
> > value, and a d
On Wed, Dec 13, 2000 at 06:08:46AM +1000, Phillip J Shelton wrote:
> Derek Atkins wrote:
>
> > David Merrill <[EMAIL PROTECTED]> writes:
> >
> > > aisb, I consider the issue of closing the books and making all
> > > transactions prior to that im
On Tue, Dec 12, 2000 at 01:09:22PM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > aisb, I consider the issue of closing the books and making all
> > transactions prior to that immutable to be completely orthogonal to how
> > the run
On Tue, Dec 12, 2000 at 02:33:55PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble wrote:
> > > On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote:
> > > > iow, what is a "suitable ratio
On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble wrote:
> On Tue, Dec 12, 2000 at 04:53:51PM -0500, David Merrill wrote:
> > iow, what is a "suitable rational representation"?
>
> A gnc_numeric data structure; 64 bit int for each of numerator and
> denom
On Tue, Dec 12, 2000 at 04:27:21PM -0800, Dave Peticolas wrote:
> "Phillip Shelton" writes:
>
> In the db, I would imagine that the transactions will almost certainly
> have their own table, so there will be an 'explicit' list of them.
That's the plan, yes.
--
Dr. David C. Merrill
On Tue, Dec 12, 2000 at 03:02:15PM -0600, Bill Gribble wrote:
> On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote:
> > It is the smallest amount that this account can change by. GnuCash is
> > now using a variation on rational numbers which have a numerator, the
> > value, and a d
On Tue, Dec 12, 2000 at 09:22:44PM -0600, Christopher Browne wrote:
> On Tue, 12 Dec 2000 15:22:15 EST, the world broke into rejoicing as
> Consider two cases:
[snipped all over]
> a) Someone who generates an average of ten transactions per month.
>120 transactions; 12 checkpoints; no perfor
On Wed, Dec 13, 2000 at 06:18:30AM +1000, Phillip J Shelton wrote:
> David Merrill wrote:
>
> > Question: What if you really *need* to go back and correct data in the
> > prior year?
>
> If the change is to the money amount then the book I own says that you make a
&g
On Tue, Dec 12, 2000 at 02:09:17PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > On Wed, Dec 13, 2000 at 06:42:04AM +1000, Phillip J Shelton wrote:
> > > David Merrill wrote:
> > >
> > > > I'm beginning to work on the database schema for an
Please take a look at the latest revision of my design document and
give me some feedback.
Some of the issues I'm dealing with:
1. Architecture: A big, fuzzy cloud right now.
2. Security: Lots of questions, few answers. Among the questions,
encryption over the wire, locking down the db itself (d
On Wed, Dec 13, 2000 at 10:15:06AM -0600, Bill Gribble wrote:
> On Tue, Dec 12, 2000 at 06:04:08PM -0500, David Merrill wrote:
> > Would you please give me an example that uses both numerator and
> > denominator in each field? Or a set of example, if that is easier?
> > I&#x
On Wed, Dec 13, 2000 at 05:31:55PM -0600, Patrick Spinler wrote:
> David Merrill wrote:
> >
> > > Most database support auth'ing database users against the OS's auth
> > > method. Essentially, once you've logged into the system, as long as
> >
On Thu, Dec 14, 2000 at 12:08:24PM +1000, Phillip Shelton wrote:
>
>
> > -Original Message-
> > Please take a look at the latest revision of my design document and
> > give me some feedback.
> >
> > Some of the issues I'm dealing with:
> >
> > 3. Table Schemas: Gaping holes.
> > I have
On Wed, Dec 13, 2000 at 06:47:04PM -0800, Dave Peticolas wrote:
> Paul Fenwick writes:
> >
> > The good news is that I'm giving up the day-job to go back to
> > consulting, which should hopefully leave me with much more time
> > for open-source development and other things I enjoy. :) The
> > r
On Wed, Dec 13, 2000 at 11:13:54AM -0500, David Merrill wrote:
> I'm going to make a note that we may want to use a separate table. I'm
> not entirely sure yet, but it sounds better than my scheme.
Changed my mind; rewrote that section to incorporate your idea.
--
Dr.
On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote:
> So the denominator goes: smallest divisible unit. (amount atoms?)
> And the numerator: number of smallest divisible units
Got it now, thanks. The numerator value is in terms of the smallest
unit of measure for the item. Pennies in t
On Wed, Dec 13, 2000 at 09:54:37AM -0600, Patrick Spinler wrote:
> David Merrill wrote:
> >
> > Some of the issues I'm dealing with:
> >
> > 4. Auditing mechanism needs to be established. I wrote a proposal.
>
> David:
>
> I use an auditing method v
On Wed, Dec 13, 2000 at 01:41:41AM +, Al Snell wrote:
> On Tue, 12 Dec 2000, Dave Peticolas wrote:
>
> > Yes, if possible, we should store numbers as 64-bit ints. It is also
> > possible that in the db we can just dispense with the denominators
> > in splits all together. This is something we
On Wed, Dec 13, 2000 at 03:07:35PM +, Al Snell wrote:
> On Tue, 12 Dec 2000, David Merrill wrote:
>
> > I'm beginning to work on the database schema for an eventual SQL back
> > end. I am keeping my notes in an ASCII file, which will always be
> > available
On Wed, Dec 13, 2000 at 06:14:31PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > Please take a look at the latest revision of my design document and
> > give me some feedback.
> >
> > Some of the issues I'm dealing with:
> >
> > 1. Archi
On Wed, Dec 13, 2000 at 06:41:34PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > On Thu, Dec 14, 2000 at 12:08:24PM +1000, Phillip Shelton wrote:
> > >
> > >
> > > > -Original Message-
> > > > Please take a look at the latest
On Wed, Dec 13, 2000 at 10:02:35PM -0500, Roland Roberts wrote:
> >>>>> "dm" == David Merrill <[EMAIL PROTECTED]> writes:
>
> dm> On Wed, Dec 13, 2000 at 06:41:34PM -0800, Dave Peticolas wrote:
> >> David Merrill writes:
>
On Thu, Dec 14, 2000 at 12:11:35PM -0600, Bill Gribble wrote:
> On Thu, Dec 14, 2000 at 12:47:08PM -0500, David Merrill wrote:
> > Well this is a good time. As soon as I understand how they work
> > together I'll see how it might be achieved in the db.
>
> It probably w
On Thu, Dec 14, 2000 at 03:46:01PM -0800, Dave Peticolas wrote:
>
> That's definitely a good approach to take.
>
> Absolutely.
Okay, so I'm preaching to the choir. :-)
I'm used to working with incompetents. I do windows development
during the day quite a bit, although I also do the back end DB
On Thu, Dec 14, 2000 at 03:02:08PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > On Thu, Dec 14, 2000 at 12:11:35PM -0600, Bill Gribble wrote:
> > > On Thu, Dec 14, 2000 at 12:47:08PM -0500, David Merrill wrote:
> > > > Well this is a good time. As soon
On Thu, Dec 14, 2000 at 09:57:38AM -0600, Bill Gribble wrote:
> On Thu, Dec 14, 2000 at 09:27:07AM -0500, David Merrill wrote:
> > So currency means the unit of measure, e.g., 'USD'? But only world
> > currencies, not anything else (bonds, whatever)? Because they alway
On Wed, Dec 13, 2000 at 03:28:11PM +, Al Snell wrote:
> On Wed, 13 Dec 2000, David Merrill wrote:
>
> > Do you think people feel less able to contribute because I'm doing
> > this? If so, then by all means put it in cvs!
>
> No, no, this wasn't me saying &
On Wed, Dec 13, 2000 at 11:32:21PM -0800, Dave Peticolas wrote:
>
> security: units of what is currently called 'damount' in splits
> that belong to this account
>
> currency: units of 'value' in splits that belong to this account
>
> Neither currency or security should be stored as 3
On Wed, Dec 13, 2000 at 11:37:00PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > And, what do these quantities represent when storing a stock?
>
> Generally, the precision with which your brokerage allows you to
> buy stock. This may not always be somethin
On Wed, Dec 13, 2000 at 04:51:03PM -0600, Patrick Spinler wrote:
>
> Other thoughts:
>
> In your SECURITY section:
>
> > Are we going to configure the database to use a separate login for each
> > user (individual username and pw for the database *itself*), or are we
> > going to handle that le
On Wed, Dec 13, 2000 at 11:45:33AM -0600, Steve Greenland wrote:
> On 13-Dec-00, 08:00 (CST), David Merrill <[EMAIL PROTECTED]> wrote:
> > 2. Security: Lots of questions, few answers. Among the questions,
> > encryption over the wire, locking down the db itself (depend
On Fri, Dec 15, 2000 at 02:10:37PM -0600, Bill Gribble wrote:
> On Fri, Dec 15, 2000 at 01:58:22PM -0600, Steve Greenland wrote:
> > All of the above may look like I'm trying to create problems for the
> > GnuCash project,but I'm actually trying to prevent them. If you don't
> > consider these iss
On Fri, Dec 15, 2000 at 09:51:28AM -0600, Patrick Spinler wrote:
> David Merrill wrote:
> >
> > On Thu, Dec 14, 2000 at 09:54:44AM -0600, Patrick Spinler wrote:
> > > In short, if you plan on having updatable data, use varchar() columns,
> > > for which most d
On Fri, Dec 15, 2000 at 01:58:22PM -0600, Steve Greenland wrote:
> On 14-Dec-00, 16:06 (CST), Derek Atkins <[EMAIL PROTECTED]> wrote:
> > Steve Greenland <[EMAIL PROTECTED]> writes:
> >
> > > I don't think you can't use OpenSSL - tbe license is not compatible with
> > > the GPL. Whether distribu
On Thu, Dec 14, 2000 at 09:54:44AM -0600, Patrick Spinler wrote:
> David Merrill wrote:
> >
> > You can't avoid having a limit on text fields, but you can make them
> > very large.
>
> In short, if you plan on having updatable data, use varchar() columns,
> f
On Thu, Dec 14, 2000 at 05:11:57PM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I *still* don't think I understand how the rational numbers work when
> > working with stocks. An example or two would help. It seems that the
> > d
On Sat, Dec 16, 2000 at 08:26:24AM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I'd recommend we use the standard GUID including MAC where it is
> > available. If there is no MAC, then we could fallback to some
> > arbitrary 4
On Sat, Dec 16, 2000 at 08:17:22AM -0500, Jean-David Beyer wrote:
> David Merrill wrote:
> >
> > On Sat, Dec 16, 2000 at 02:15:21AM -0500, James LewisMoss wrote:
> > > >>>>> On Thu, 14 Dec 2000 13:23:55 -0500, David Merrill
><[EMAIL PROTECTED]> s
On Sat, Dec 16, 2000 at 09:18:39AM -0600, Rob Browning wrote:
> Dave Peticolas <[EMAIL PROTECTED]> writes:
>
> > Anyway we can avoid putting arbitrary limits on the lengths of text
> > fields like account names & such? Currently gnucash imposes no such
> > limits and I think it would be good to k
On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > Please take a look at the latest revision of my design document and
> > give me some feedback.
Cool.
> Finally got a chance to glance at it and
On Sat, Dec 16, 2000 at 12:29:54PM -0500, Jean-David Beyer wrote:
> I imagine in an open-source context, management details are even more
> difficult to achieve, since there is no enlightened CEO who can decree
> that the decisions of the principal architect are law. It seems to have
> worked with
On Sat, Dec 16, 2000 at 03:19:48PM -0500, Jean-David Beyer wrote:
> David Merrill wrote (in part):
> >
> > On Sat, Dec 16, 2000 at 09:52:14AM -0600, Rob Browning wrote:
> > > David Merrill <[EMAIL PROTECTED]> writes:
> > >
> > > > Please take
On Sun, Dec 17, 2000 at 10:18:02AM -0600, Bill Gribble wrote:
> On Sat, Dec 16, 2000 at 12:29:50PM -0500, David Merrill wrote:
> > Unfortunately, however, allowing *very* large text fields has serious
> > drawbacks in databases that it does not have in XML. You pay a price
> >
On Sun, Dec 17, 2000 at 11:41:10AM -0600, Christopher Browne wrote:
> On Sun, 17 Dec 2000 10:09:04 CST, the world broke into rejoicing as
> [EMAIL PROTECTED] (Bill Gribble) said:
> > On Sat, Dec 16, 2000 at 12:05:42PM -0500, David Merrill wrote:
> > > Obviously, the current
On Sun, Dec 17, 2000 at 05:04:49PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > When I looked at the code the algorithm seemed nonstandard to me,
> > and I want to make sure I use a standard GUID algorithm. It's well
> > t
On Sun, Dec 17, 2000 at 08:49:02PM -0500, Jean-David Beyer wrote:
> Christopher Browne wrote (in part):
> >
> > This is something that is indeed appropriately generated in the "engine,"
> > not in the DB; the relevance to the DB is to ask whether it can use the
> > GUID as one of its keys, and wh
On Sun, Dec 17, 2000 at 05:21:27PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > > We need to be more specific about what we need in terms of query
> > > efficiency. It may make sense to use one storage/indexing strategy
> > &g
On Sun, Dec 17, 2000 at 05:43:57PM -0600, Rob Browning wrote:
> Jean-David Beyer <[EMAIL PROTECTED]> writes:
>
> At this point, as I've said, I now tend to think that we should just
> plan to handle encryption/authentication directly by having a
> server-side gnucash daemon.
I think so, too.
>
On Sun, Dec 17, 2000 at 09:54:32PM -0500, Jean-David Beyer wrote:
> David Merrill wrote:
> >
> > On Sun, Dec 17, 2000 at 08:49:02PM -0500, Jean-David Beyer wrote:
> > > Christopher Browne wrote (in part):
> > > >
> > > > This is something that
On Sun, Dec 17, 2000 at 09:43:48PM -0600, Christopher Browne wrote:
>
> And the issue is _quite_ to the point, irrespective of anything
> having to do with MySQL.
>
> The examination of DB schema has thus far concentrated on what the
> field types need to be; that is important enough, but only g
On Mon, Dec 18, 2000 at 07:11:46AM -0500, Jean-David Beyer wrote:
> Christopher Browne wrote (in part):
> >
> > [snip]
> > > >
> > > > Just that the primary place a GUID is used is as a primary key, and
> > > > foreign keys in those tables' child tables.
> > > >
> > > So of course an rdbms would
On Mon, Dec 18, 2000 at 11:53:22AM +1000, Phillip Shelton wrote:
> (Taken from David M's schema.txt)
>
> The scu is used as the denominator in splits against this account. It is
> enforced by the engine. Why do we not just use what is defined for the
> commodity?
>
>
> Dave P has answered this
On Mon, Dec 18, 2000 at 12:56:58PM -0500, Derek Atkins wrote:
> Rob Browning <[EMAIL PROTECTED]> writes:
>
> > "Phillip Shelton" <[EMAIL PROTECTED]> writes:
> >
> > > Then, as a lazy programmer, how much of this can we legally steal
> > > from other server-proxies?
> >
> > Dunno, but if we go t
On Tue, Dec 19, 2000 at 12:21:52AM -0800, Dave Peticolas wrote:
> "Phillip Shelton" writes:
> > (Taken from David M's schema.txt)
> > SPLIT
> > -
> > account_guidchar32 ->account.account_guid
> > transaction_guidchar
> > ->transaction.transact
On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote:
>
> ACCOUNT_GROUP
> -
> group_guid char32
> group_name textname of the group of accounts
> notes textany notes the user wishes to make
>
> An accou
On Tue, Dec 19, 2000 at 06:57:34PM -0800, Dave Peticolas wrote:
> "Phillip Shelton" writes:
> >
> > ACCOUNT_GROUP
> > -
> > group_guid char32
> > group_name textname of the group of accounts
> > notes textany note
On Wed, Dec 20, 2000 at 12:05:29PM +1000, Phillip Shelton wrote:
> You will possibly need to keep a checkpoint on the share_* values as well.
>
> These are, I assume, the balances for the damounts in the splits?
Yes. I corrected it.
--
Dr. David C. Merrill http://www.luperc
On Wed, Dec 20, 2000 at 03:09:50PM +1000, Phillip Shelton wrote:
> Depends on how you use groupings. Are we going to allow someone to have an
> account that is part of credit and part of clothes, part of sport, part of
> hobbies ...
>
> There was a question some time ago about being able to get a
On Wed, Dec 20, 2000 at 08:43:18AM -0600, Bill Gribble wrote:
> On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote:
> > An account group is just what it sounds like, a group of accounts.
> >
> > All accounts in an account group must be denominated in the same commodity.
>
> I know t
On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote:
> On Wed, Dec 20, 2000 at 08:43:18AM -0600, Bill Gribble wrote:
> > On Wed, Dec 20, 2000 at 11:57:47AM +1000, Phillip Shelton wrote:
> > > An account group is just what it sounds like, a group of accounts.
> >
On Wed, Dec 20, 2000 at 10:18:01AM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I'm going to use lots of GUIDs.
>
> A GUID is just a unique index into a table, right? So an account_guid
> would be an index to a particular accoun
On Wed, Dec 20, 2000 at 10:21:30AM -0600, Bill Gribble wrote:
> On Wed, Dec 20, 2000 at 09:58:25AM -0500, David Merrill wrote:
> > So an account group can belong to another account group? The current
> > schema doesn't provide for that. Should it? If it does, then we have
>
On Wed, Dec 20, 2000 at 11:03:13PM -0800, Dave Peticolas wrote:
> "Phillip Shelton" writes:
> >
> > ACCOUNT
> > ---
> > account_guidchar32
> > parent_account_guid char32 -> account.account_guid
> > group_guid char32 ->
On Wed, Dec 20, 2000 at 08:55:34PM -0600, [EMAIL PROTECTED] wrote:
>
> OK, here's the dope:
>
> I don't think rob is entirely aware of the possibilities that his XML
> file format opens up. Some of the readers of this mailing list may
> also not be aware of what demos grib has done with embedd
I am now building tables in pg and I've made the build scripts
available at http://www.lupercalia.net/createschema.sql.
The table schema in the design doc are out of date slightly, and will
become more so. I am leaving them there for the time being so I can
make notes and refer to them to see why
On Wed, Dec 20, 2000 at 08:55:34PM -0600, [EMAIL PROTECTED] wrote:
>
> OK, here's the dope:
>
> I don't think rob is entirely aware of the possibilities that his XML
> file format opens up. Some of the readers of this mailing list may
> also not be aware of what demos grib has done with embedd
On Thu, Dec 21, 2000 at 01:13:02PM -0500, Derek Atkins wrote:
> <[EMAIL PROTECTED]> writes:
>
> > Lets reanalyse the requirements. You want security. Why? to run over
> > the open internet? If you're running over the open internet, then
>
> Not exactly. It's just that I don't trust the network
On Thu, Dec 21, 2000 at 02:03:13PM -0500, Derek Atkins wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > I think the SQL code should not be marshalled over the wire. Keep SQL
> > on the server side entirely.
>
> Oh, I agree. I would rather marshall reques
In light of the discussions we have been having over whether the
account group mechanism should be strictly hierarchical or whether an
account should be allowed to exist within more than one group, I am
considering providing both capabilities in the database.
First, the group table would define g
On Thu, Dec 21, 2000 at 04:34:00PM -0800, Dave Peticolas wrote:
> David Merrill writes:
> > In light of the discussions we have been having over whether the
> > account group mechanism should be strictly hierarchical or whether an
> > account should be allowed to exist withi
On Thu, Dec 21, 2000 at 04:45:07PM -0600, [EMAIL PROTECTED] wrote:
> It's been rumoured that David Merrill said:
> >
> > Does this mean you are envisioning a server which can handle more than
> > one set of accounts and more than one set of transactions?
>
> Ye
On Thu, Dec 21, 2000 at 04:51:44PM -0600, [EMAIL PROTECTED] wrote:
> It's been rumoured that David Merrill said:
> > I'll also mention that psql spits out its tables in customizable html,
> > and can be run via cgi scripts. You can write shell scripts or perl
> >
On Fri, Dec 22, 2000 at 01:09:10PM -0600, [EMAIL PROTECTED] wrote:
> Can't say I'd know what it takes to do this with postgres, but ther
> is discussion in the postgres community about 'embedded' postgres,
> that would allow multiple applications & users on the same machine to
> get thier own trul
All right, now, you have to promise not to laugh before you read any
further. Promise? Okay.
I rm'ed my schema.txt like an idiot. If anyone has a copy they've
downloaded, please email it to me privately. Luckily, I have already
started creating db scripts, so I have all of the table schema, just
On Fri, Dec 15, 2000 at 07:29:30PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > Ugh! That is a completely meaningless name. *Every* numeric field is
> > a "quantity". Of WHAT is it a quantity?
>
> Well, we had talked about
On Fri, Dec 15, 2000 at 07:35:09PM -0600, Rob Browning wrote:
> David Merrill <[EMAIL PROTECTED]> writes:
>
> > It really *is* just a rational number expressed as integer numerator
> > over integer denominator.
>
> Right. The fact that we'll probably have to
won't donate my time to make one of them. If you
want me to work on software that is not *completely* free, you gotta
pay me. That's the deal.
> I'll take a look at other security solutions, but I will insist that
> security be linked into "networked-GnuCash", regardless of
On Sat, Dec 16, 2000 at 02:15:21AM -0500, James LewisMoss wrote:
> >>>>> On Thu, 14 Dec 2000 13:23:55 -0500, David Merrill <[EMAIL PROTECTED]>
>said:
>
> David> On Thu, Dec 14, 2000 at 12:11:35PM -0600, Bill Gribble wrote:
> >> On Thu, Dec 14,
On Wed, Dec 27, 2000 at 10:13:58AM -0500, Derek Atkins wrote:
> It is unclear that the security server and the engine need to be on
> the same machine; so long as the security server is associated with
> the datastore, it should suffice. E.g., if you don't have access to
> data, you wont be able
On Wed, Dec 27, 2000 at 11:55:11AM -0500, James LewisMoss wrote:
> > On Fri, 22 Dec 2000 19:25:03 + (GMT), "Al B. Snell"
><[EMAIL PROTECTED]> said:
>
> Al> I would suggest making good use of RPC over UDP - the connection
> Al> should start off with UDP, and only make TCP connections wh
On Fri, Dec 29, 2000 at 02:12:07PM +1100, Robert Graham Merkel wrote:
> Eugene Tyurin writes:
> >
>
> > Is this really something a casual user who wants to balance his
> > checkbook and know how much he spends on beer can bear?
>
> Unless it's totally transparent to them, no. Basic
On Fri, Dec 29, 2000 at 02:46:51AM -0600, [EMAIL PROTECTED] wrote:
> It's been rumoured that [EMAIL PROTECTED] said:
> >
> > It should be clear why Transaction engine and DB engine should stay close;
> > they will need to communicate quite a lot of data in order to negotiate
> > the parts that ar
On Fri, Dec 29, 2000 at 03:09:46AM -0600, [EMAIL PROTECTED] wrote:
> (btw, in 'real' accounting systems, the actual balance is stored,
> and is not computed on the fly by totalling up all transactions.
> In gnucash, we total it on the fly because that was the easier thing
> to do at the time.)
On Fri, Dec 29, 2000 at 12:23:41AM -0600, [EMAIL PROTECTED] wrote:
> > >
>
> Can we not flame?
Yes, please!
> Id like to hear someone give a technical overview of how SOAP handles
> events.
I spent last night reading the w3c's SOAP 1.1 spec. Ugh. (Not an
editorial comment, just that reading s
1 - 100 of 150 matches
Mail list logo
