2007-02-26 GnuCash IRC logs
00:24:02 *** hampton2 has quit IRC
00:34:06 *** motin has quit IRC
00:43:38 *** hampton is now known as hampton|away
00:45:49 <mishehu> hmm... when you guys had the pgsql backend (many moons ago), how did you handle the hierarchial nature of the chart of accounts in pgsql? I've got a similar problem, and have been reading about possible solutions. was wondering what had worked for gnucash once upon a time.
00:47:11 <mishehu> hopefully somebody's even around at this hour tonight ;-)
01:05:01 *** jpeach has joined #gnucash
01:05:08 *** jpeach has left #gnucash
01:10:30 *** warlord-afk is now known as warlord
01:10:44 <warlord> mishehu: each account have a parent account.
01:12:34 <mishehu> you did the adjacent pattern?
01:13:10 <warlord> ??
01:13:22 <mishehu> hmm... sec, I thin kI have a link
01:14:03 <mishehu> http://www.dbazine.com/oracle/or-articles/tropashko4
01:14:21 <mishehu> what he refers to as the "adjacency list", but I've seen a few variants on this
01:14:33 <mishehu> basically one row has column that points back to its parent node.
01:15:02 <mishehu> the problem in sql is that you need to know how deep your tree goes in order to properly extract it.
01:15:37 <warlord> remember: the PG backend is just a data store. The engine does all the work and caches the data.
01:15:58 <warlord> So at program start time gnucash does "select * from accounts" and populates the account tree.
01:17:05 <mishehu> ah, ok, so then gnucash did all the work to reassemble it.
01:17:15 <warlord> the account table looks something like: { guid account_id; string name; ... ; guid parent_id' ... }
01:17:28 <warlord> Yeah, PG is just a data store.
01:17:44 <mishehu> I didn't know if it did any work for you at all ;-)
01:17:46 <warlord> Dont think of it as a full relational DB, because it's not used as such.
01:17:54 <mishehu> I never had used it, and it's been long removed if I'm not mistaken.
01:18:18 <mishehu> was just looking for some pointers for an app I'm working on right now.
01:18:27 <warlord> it's still there
01:18:51 <mishehu> oh it is? thought you guys removed it.
01:19:12 <warlord> Nope.
01:20:17 <mishehu> hmm... I'm thinking what I might do is have it set up as adjacency list, and maybe use a trigger or something to rebuild the nested set representation of my hierarchy.
01:20:41 <warlord> What ARE you trying to do?
01:22:23 <mishehu> trying to make an add-on to my human resources app for my employees... mostly for expense reimbursement related stuff. need to have a chart of accounts of some sort as well, so that I can easily make a report to categorize their expenses so that I can easily type it into gnucash.
01:22:43 <warlord> Ah
01:23:00 <mishehu> and the app is in php, and using the nested sets allow you to reassemble the whole hierarchy in a single query.
01:23:09 <mishehu> without knowledge of the depth of the tree.
01:24:15 <warlord> okay...
01:25:28 <mishehu> I'll just need to figure out how to use triggers, and how to appropriately regenerate the nested set...
01:29:04 <warlord> It's much easier if your application can build the tree from the data.
01:32:52 <mishehu> hmm... well, seeing as I've not actually done anything yet other than start writing that schema, I'm going to sleep on it.
01:33:01 <warlord> ok.
01:33:15 <mishehu> I might indeed just go your route.
01:34:32 <warlord> Your other option is to put the full account path name into each row, so that you dont depend on the app to build the hierarchy; the hierarchy is stored in the account names.. But that makes it a little harder to have the proper "parental" reference.
01:35:36 <mishehu> yeah, that's probably what that tropashko guy calls the "materialized path" ?
01:36:08 <warlord> could be. I honestly didn't go read that page
01:36:38 <mishehu> donno, since you guys have odne this already, and it's not like there's a lot of inserts into this type of table, I think I might just do the adjacency list like you suggest.
01:37:31 <warlord> well, gnucash has the ability to load, process, and cache the results at program startup.. (and then use notifications to detect changes from other DB clients).
01:37:53 *** jpeach has joined #gnucash
01:38:00 *** jpeach has left #gnucash
01:47:06 *** Rolf has joined #gnucash
02:59:00 *** Geot has quit IRC
03:34:08 *** gncbot_ has joined #gnucash
03:36:32 *** ErKa has joined #gnucash
03:36:50 *** gncbot has quit IRC
03:41:43 *** ceplma has joined #gnucash
04:26:54 *** warlord is now known as warlord-afk
05:46:13 *** ErKa has quit IRC
05:51:04 *** ErKa has joined #gnucash
06:09:51 *** warlord-afk has quit IRC
08:06:07 *** benoitg has quit IRC
08:13:21 *** prock has joined #gnucash
08:14:34 *** twunder has joined #gnucash
08:18:51 *** prock__ has joined #gnucash
08:22:24 *** prock_ has quit IRC
08:23:50 *** prock has quit IRC
10:07:26 *** prock__ is now known as prock
10:10:21 *** prock_ has joined #gnucash
10:11:23 *** hampton|away is now known as hampton
10:11:25 *** hampton sets mode: +o gncbot_
10:11:37 *** hampton sets mode: +oo prock prock_
10:12:40 <hampton> try traffic shaping?
10:13:11 <hampton> as a last resort you could get rid of the tenants. ;-)
10:14:07 <prock_> The easy solution is to just limit their upload speed to 2k/s, but I'd have to either buy a fancier hardware router ($$$$) or turn a whitebox into a router (fan noise).
10:14:44 *** warlord-afk has joined #gnucash
10:15:00 <hampton> I thought a linksys running sveasoft could do that.
10:15:16 * prock_ has a dlink atm
10:18:49 *** prock has quit IRC
10:22:36 *** prock_ is now known as prock
10:28:29 *** warlord-afk is now known as warlord
10:29:06 <warlord> Hmm.. I wonder if we want the logger to put logs into a YYYY/MM/ directory structure to reduce the (eventual) size of the logs directory?
10:29:58 <jsled> logs directory?
10:30:04 <jsled> Oh, the irc logs.
10:30:05 <jsled> heh.
10:30:09 <warlord> Yeah, irc logs.
10:30:19 <jsled> Probably.
10:30:39 <warlord> prock: yeah, I think the OpenWRT s/w can do traffic shaping for you. What's your current router hardware?
10:31:13 *** frank has joined #gnucash
10:31:38 *** ErKa has quit IRC
10:34:17 <prock> warlord: dlink di-624
10:39:08 <warlord> Hm. Not sure if that can run an openWRT platform.
10:39:29 <prock> do you run openwrt?
10:40:44 <prock> any recommendations for hardware?
10:51:22 <mishehu> don't the linksys -GL devices support openwrt?
10:55:54 <warlord> no, I dont run openwrt. I've got a cisco.
10:59:49 *** jpeach has joined #gnucash
11:00:10 *** jpeach has left #gnucash
11:23:36 *** Geot has joined #gnucash
11:23:43 <warlord> BIAB. Heading to the office..
11:23:53 *** warlord has quit IRC
11:25:31 *** Demitar has quit IRC
11:37:16 *** Demitar has joined #gnucash
12:17:04 *** warlord has joined #gnucash
12:17:04 *** gncbot_ sets mode: +o warlord
12:20:16 *** ceplma has quit IRC
12:25:52 *** franz has joined #gnucash
13:04:15 *** andi5 has joined #gnucash
13:05:05 <andi5> @op
13:05:05 *** gncbot_ sets mode: +o andi5
13:37:04 *** franz has quit IRC
13:39:57 *** franz has joined #gnucash
13:44:03 *** hampton has left #gnucash
13:44:10 *** hampton has joined #gnucash
13:44:10 *** gncbot_ sets mode: +o hampton
13:55:16 <warlord> hampton: I've noticed that your backup server hasn't been pulling data down.
13:56:04 <hampton> umm, yeah. Its at the old apartment and been turned off. I need to set up a machine here to pull.
13:56:51 <hampton> Or I could set up svk. Doesn't that mirror the whole repo?
13:58:05 <warlord> Yes
13:58:17 <warlord> Or as much of the repo as you 'svk mirror'
13:58:57 <warlord> but there IS a tool to rebuild an SVN repo from an svk mirror. However I only mirror /repo/gnucash, not /repo
13:59:39 <hampton> I can mirror /repo. Shouldn't be too much extra storage involved.
13:59:54 <warlord> Nah, not really.
14:04:09 <hampton> svk is written in perl?
14:04:24 <andi5> yes, it is slow..
14:06:05 <hampton> and I need 20 perl modules to install it
14:06:58 <andi5> is there no subversion backup solution?
14:07:38 <jsled> wow, indeed. I (would) need "43 packages (7 upgrades, 36 new)".
14:07:51 <warlord> andi5: Oh, i do a nightly svn repo hotcopy
14:07:57 <warlord> (and retain 7 days)
14:08:11 <warlord> Same thing with trac and wiki.
14:09:06 *** MrN has joined #gnucash
14:10:39 <MrN> hi
14:11:36 <warlord> low
14:11:41 <andi5> warlord: does hampton want to backup something different? or is it a matter of transfer bandwidth
14:12:29 <warlord> I dont know. I think it's mostly a matter of an offsite backup of the repo.
14:14:19 <jsled> hampton: have you disabled -Wno-unused on your builds? Selectively?
14:14:31 <jsled> It appears that it was added by chris when the swig branch landed.
14:20:26 <chris> FWIW, I have -Wno-unused removed locally, so I see the same warnings hampton does.
14:20:43 <chris> It only makes sense to remove with the newer swig, though.
14:20:53 <jsled> newer=1.31?
14:21:09 <jsled> er. 1.3.31
14:21:41 <chris> yeah, 1.3.31 should generate warning-free code.
14:26:23 <hampton> I disabled it selectively. There are a couple of things I didn't fix last night. ~5 instances of the log_module variable, and an unused function in gnc-html.c?
14:26:33 <hampton> The rest of gnucash compiled cleanly
14:28:41 <hampton> andi5: I was using rsync to back up the repository nightly.
14:29:00 <andi5> ah, i see
14:30:11 <warlord> [warlord@cliodev ~]$ rpm -q swig
14:30:11 <warlord> swig-1.3.31-0.fc5
14:30:30 <warlord> (even FC5 ships a recent-enough swig, so...)
14:34:14 <chris> that had to be an update.
14:35:16 <warlord> Yeah... Dec 2006
14:38:25 <warlord> Early Dec, 2006, in fact. Built 12/11, installed 12/14
14:40:07 <hampton> fc4 still has 1.3.24-2
14:40:33 <warlord> Which is too old for us anyways.
14:40:51 <warlord> We require at least 1.3.28
14:57:06 *** |gunni| has joined #gnucash
14:57:23 *** |gunni| has joined #gnucash
14:58:14 *** warlord has quit IRC
15:01:46 *** nomeata has joined #gnucash
15:02:02 *** andi5 is now known as andi5|afk
15:20:32 *** nomeata has quit IRC
15:27:23 *** ErKa has joined #gnucash
15:52:30 *** |gunni| has quit IRC
16:05:34 *** franz has quit IRC
16:07:18 *** andi5|afk is now known as andi5
16:08:38 *** franz has joined #gnucash
16:10:37 *** warlord has joined #gnucash
16:10:38 *** gncbot_ sets mode: +o warlord
16:15:31 *** minDwarpd has joined #gnucash
16:21:18 *** minDscrm has quit IRC
16:30:18 *** conrad has quit IRC
16:31:10 <warlord> Well, that was fun.
16:32:00 <jsled> oh?
16:32:42 <warlord> my system crashed (and I've been having issues where it wouldn't want to go into suspend mode). So I decided to take all the outstanding FC5 updates..
16:32:47 <warlord> ... which brought in a 2.6.19 kernel..
16:32:56 <warlord> .. which wouldn't work with vmware or the madwifi driver I had..
16:33:49 <warlord> So I had to go download a newer madwifi driver (which STILL doesn't work properly with networkmanager on unencrypted, hidden-ssid networks)..
16:33:57 <warlord> and I had to download a newer vmware-any-any update..
16:35:14 <warlord> So.. It's now all updated.. But I haven't tested suspend, yet.
16:35:24 <warlord> (it wasn't properly shutting down a bunch of kernel threads)
16:49:21 *** Rolf has left #gnucash
16:54:23 *** MrN has quit IRC
17:00:09 *** ErKa has quit IRC
17:04:41 *** egsavage has joined #gnucash
17:21:15 *** twunder has quit IRC
17:40:33 *** franz has quit IRC
17:41:40 *** franz has joined #gnucash
17:48:33 *** jpeach has joined #gnucash
17:48:36 *** jpeach has left #gnucash
17:59:03 *** andi5 has quit IRC
18:19:32 *** ural0 has joined #gnucash
18:59:14 *** jpeach has joined #gnucash
19:01:47 *** jpeach has left #gnucash
19:15:20 *** ural0 has quit IRC
19:49:09 *** jpeach has joined #gnucash
19:49:18 *** jpeach has left #gnucash
20:13:55 *** franz has quit IRC
20:25:01 *** franz has joined #gnucash
20:27:44 *** franz has quit IRC
20:39:25 *** sjc has joined #gnucash
21:04:35 *** sjc has quit IRC
21:18:03 *** warlord has quit IRC
21:37:25 *** warlord has joined #gnucash
21:37:25 *** gncbot_ sets mode: +o warlord
21:47:37 *** warlord is now known as warlord-afk
21:48:21 <jsled> hampton: I'm going to apply the patch in <http://bugzilla.gnome.org/show_bug.cgi?id=412442>, unless you're already on it...?
21:49:22 <hampton> go for it
23:12:58 *** egsavage has left #gnucash
23:55:23 <hampton> night all
23:55:26 *** hampton is now known as hampton|away