>So the denominator goes: smallest divisible unit. (amount atoms?)
>And the numerator: number of smallest divisible units
>
>or in sentence form:
> The denominator represents the divisor for the smallest countable
>unit of this currency/asset. For
>example in the United States, it is 100 for $0
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
> > tested and has proved itself. If Our algorit
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
> tested and has proved itself. If Our algorithm is already standard,
> then I just misread it; I'm human. If it's not
On Sat, Dec 16, 2000 at 12:05:42PM -0500, David Merrill wrote:
> Obviously, the current algorithm is working. So there is no reason to
> change it, but I'm doing essentially a new implementation of that
> code, so I want to make sure it is solid in all respects. Possibly
> postgres has a built-in
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 48 bit pattern entered in the config tab
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 48 bit pattern entered in the config table, or do without it
> entirely. After all...
>
> Q: How often would a
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 represent it with two
> columns in a
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 using "quantity" and "value". Quantity
>
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 represent it with two
columns in a database is just an artifact of the fact that SQL doesn't
have RATIONAL_64
Dave Peticolas <[EMAIL PROTECTED]> writes:
> GnuCash does not keep an explicit list of transactions around.
> However, it does provide an api to traverse over each one, hitting
> each transaction only once.
>
> In the db, I would imagine that the transactions will almost certainly
> have their o
Dave Peticolas <[EMAIL PROTECTED]> writes:
> My best guess is that it stands for 'debit'.
I had always thought it meant d(elta)amount.
--
Rob Browning <[EMAIL PROTECTED]> PGP=E80E0D04F521A094 532B97F5D64E3930
___
gnucash-devel mailing list
[EMAIL PR
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 using "quantity" and "value". Quantity
would indicate how much of the thing you have, and value it's value.
Though
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
> > denominator value might change based o
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
> denominator value might change based on stock splits and such, for
> example.
If you are dealing with real st
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 something you can find out.
??? Stil
David Merrill writes:
> 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
David Merrill <[EMAIL PROTECTED]> writes:
> True, security is a lot easier when everything's local.
Agreed.
> If the client accesses the server via ssh and is then logged onto the
> database using their user account on the db machine, where are the
> weaknesses? Where is it vulnerable?
To do t
Patrick Spinler <[EMAIL PROTECTED]> writes:
[snip]
> For the server and client on the same machine, this method provides a
> reasonable expectation of privacy for the database - file protections
> stop raw access to the file, and database user auth'ing stops people
> running a database engine aga
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
> > > you're listed as a valid database user, you're oka
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
> > you're listed as a valid database user, you're okay. I suggest we use
> > this method.
>
> The downside of that is the main
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Dec 13, 2000 at 02:35:30PM -0800, Gordon Oliver wrote:
>
> > Or am I thinking too much like an American, and some
> > currencies could actually be held in the amount of 3/16, for example?
>
> probably ;-)
>
> some at least used to have div
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
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 level of security ourselves, and then log into the
> database using a single userna
> Or am I thinking too much like an American, and some
> currencies could actually be held in the amount of 3/16, for example?
probably ;-)
some at least used to have divisions of 200 (for example, there used to be - and
perhaps still
is - a halfpence in Great Britain...)
Also common here ar
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'm having trouble seeing h
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'm having trouble seeing how this works.
I'm not sure what you mean by "uses". The C data type
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 "Oi! Put it in CVS you lazy slacker!"
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 "Oi! Put it in CVS you lazy slacker!" - it
was me saying "I have a CVS server if you want one" :-)
ABS
--
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 at http://www.lupercalia.net/schema
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 at http://www.lupercalia.net/schema.txt
Would you like a CVS repository to keep it in? Then other peop
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 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 need to design carefully,
> as some engine assumptions may need to
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
"Phillip Shelton" writes:
>
>
> > -Original Message-
> > > > > cleared_balance money "
> > > > > reconciled_balance money "
> > > > > share_balance money "
> > > > > share_cleared_balance money
> -Original Message-
> > > > cleared_balance money "
> > > > reconciled_balance money "
> > > > share_balance money "
> > > > share_cleared_balance money "
> > > > share_reconciled_balance
How about Security for the damount and currency for the value as that is
what we are using them for, at least for stocks.
Do the people working on the inventory have any suggestions?
> -Original Message-
> David Merrill writes:
> > On Tue, Dec 12, 2000 at 04:06:48PM -0600, Bill Gribble w
> -Original Message-
> > Um, could you explain GUIDs? I am lost.
>
> Globally Unique ID, also known as UUID or Universal Unique ID. It is a
> 32 byte value usually calculated using the machine's MAC address and
> the time, plus some random stuff, plus more stuff I don't understand.
> It
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 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 rational representation"?
> > >
> > > 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 eventual SQL back
> > > > end. I am keeping m
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 rational representation"?
> >
> > A gnc_numeric data structure; 64 bit int for each of numerator and
> > denomina
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
> denominator.
>
> > Why "d"amount?
>
> Fi
David Merrill writes:
>
> So, valid values would include 2/3? And how would this be stored, by
> the approximation 0.666? Or as the actual text value "2/3"? You
> said that *each* of damount and value is a rational number, right?
> iow, what is a "suitable rational representation"?
>
> Why "
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 eventual SQL back
> > > end. I am keeping my notes in an ASCII file, which will always be
> > > available at http://www
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
denominator.
> Why "d"amount?
Figuring that out is archaeology at this point :)
> What is the difference betwee
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: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://www.lupercalia.net/schema.txt
>
> so
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 denominator, the damont.
This isn't right. Each of 'value' and 'damou
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://www.lupercalia.net/schema.txt
some comments and suggestions.
> SPLIT
> -
> account_guidc
50 matches
Mail list logo
