*** SachaAway has quit IRC
*** johannesV has joined #gnuenterprise
<johannesV> good morning
*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
<btami> good morning
<johannesV> good morning btami
*** kilo has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
<reinhard> good morning everybody
<kilo> good morning
<SachaS> morning
*** johannesV_ has joined #gnuenterprise
*** johannesV has quit IRC
*** johannesV_ has quit IRC
*** johannesV has joined #gnuenterprise
*** lupo__ has quit IRC
*** btami has quit IRC
*** kilo has quit IRC
*** kilo has joined #gnuenterprise
*** jamest_ has joined #gnuenterprise
<reinhard> good morning jamest_
<jamest_> morning
<reinhard> we've got a mail with some script and an URL that would give us the complete zipcode data for all US cities
<reinhard> and the sender proposed we add the data to the zipcode sample
<reinhard> would you consider that a good idea?
<reinhard> it's 42741 records
<kilo> why not
<jamest_> if it's public domain info i think it would be
<reinhard> ok
<reinhard> This database is provided free to anyone who wants it with the request that anyone who benefits from it please drop me a quick email and let me know how you're using it.
<reinhard> sounds like acceptable terms, doesn't it? :-)
<kilo> it is almost like gpl v8 :D
<jamest_> yip
<kilo> or v0.1 instead...
<reinhard> ok, so now I'm curious how long it takes to import 42000 records with gnue-schema...
<kilo> hmmm interesting question indeed
*** kilo has quit IRC
*** SachaS has quit IRC
<reinhard> hmmm.... 10 minutes and still *parsing* the XML file, not even started with sending SQL to the backend
<johannesV> reinhard: we knew that building the xml-tree is an expensive operation
<johannesV> maybe we could improve on that later so one might write an entry into roundup
* johannesV again waiting for an svn-connect to get it's obligate network timeout
<johannesV> that broken svn-thing to svn.gnuenterprise.org is really an anoying one
<reinhard> johannesV: yes, I remember we already found out that gnue-schema is slow for large amounts of data
<reinhard> I will write an entry into roundup later, I have set my computer into an unusable state for the next few minutes...
<johannesV> :)
*** SachaS has joined #gnuenterprise
<jamest_> johannesV: yes, it is
<johannesV> so, jamest, you haven't found a reason for that neither ... ?
<jamest_> no
<jamest_> i still fight it at work as well
<jamest_> i get in the habbit of logging in (well trying to) then doing something else for a while
<jamest_> as it seems after the initial failure I'm good for logins for the rest of the night
<johannesV> yep, same procedure as here ...
<johannesV> :)
*** deke has joined #gnuenterprise
*** johannesV has quit IRC
*** johannesV has joined #gnuenterprise
<reinhard> hmm....
<reinhard> 2 hours and still parsing...
<reinhard> I think there are *serious* arguments against replacing our zipcode sample data with a full city list :-)
*** lupo__ has joined #gnuenterprise
<reinhard> ok
<reinhard> after roughly 4 hours and still not even finished with parsing the XML file, I cancelled gnue-schema...
<jamest_> why not add a <csv> data load tag?
<jamest_> so those 40K items become 1
<reinhard> we *have* do find some solution for reading larger amounts of data
<reinhard> s/do/to/
<reinhard> might be integrator
<reinhard> gnue-schema actually was never designed to read data, its purpose was to read a schema
<johannesV> that's right
*** deke has quit IRC
*** derek has joined #gnuenterprise
<reinhard> good night all
*** reinhard has quit IRC
*** johannesV has quit IRC
*** jamest_ has left #gnuenterprise
*** kilo has joined #gnuenterprise
*** jamest has left #gnuenterprise
*** Annirak has joined #gnuenterprise
*** Annirak has left #gnuenterprise
*** Annirak has joined #gnuenterprise
*** jamest has joined #gnuenterprise
<Annirak> Does anyne know if the SCM package for GNUe is available yet?
<derek> no
<derek> it is not
<Annirak> Know of any other OSS SCM solutions that run on MySQL?
<derek> if you find one that runs on MySQL run away
<derek> MySQL is NOT a suitable platform for SCM
<derek> imho
<kilo> if SCM==strategic cruise missile, then it is definitely not :)
<nickr> is mysql a suitable platform for anything?
<derek> nickr: organizing your recipes?
<nickr> sqlite seems more appropriate :)
<Annirak> Not strategic cruise missile, Supply Chain Management.
<Annirak> Why is MySQL not an appropriate platform for SCM?
*** kilo has quit IRC
*** wendall911 has joined #gnuenterprise
<wendall911> jamest: ping
<wendall911> or any other dev for that matter...quickie question
<jamest> i'll try and help
<jamest> but it's been years since I could be called a gnue "dev"
<wendall911> :)
<wendall911> heya jamest
*** klasstek has joined #gnuenterprise
<wendall911> how's university life?
<jamest> i left there about 2 yrs ago :)
<wendall911> Anyhow, phpWebSite core has been rewritten, and we're working on some RCs for 1.0
<wendall911> jamest: tells you how much I'm in the loop then ;)
<jamest> :)
<wendall911> I would very much like to have support for gnue on the backend and am wondering how much interest there would be for a cms frontend to be available.
<wendall911> OO php, which I know is everyone's favorite....;)
<jamest> lol
<wendall911> I know plone is probably a better candidate, but I am not a dev for that project ;)
<jamest> :)
<jamest> um, when you say a gnue backend what do you mean?
<jamest> as we're still mainly in the tools, not any specific ERP pieces (yeah, we're slow :)
<wendall911> well, since our database api is fixed, I was thinking more just a driver for the app server interaction
<wendall911> jamest: one of my needs would be to get the data from the cms accessible to the app server
<jamest> btw, i'll be a little choppy in responses as I'm in the middle of rewiring part of my house
<jamest> had some foundation work done last spring and the guys cut through the wiring to my garage
<jamest> about time the fix was more than a few wire nuts, some tape, and two wires pulled way too tight for their own good :)
<wendall911> jamest: not sure what the best method would be, and it's been so long since I talked to reinhard about it, I've forgotten what he said
<jamest> reinhard and johannes would still be the best bet as they are heavy involved in all of gnue
<wendall911> ok, no problem, I'll try and catch reinhard in the next couple days
<jamest> i'm little more than a (sigh) user now wrt gnue
<jamest> i'd love to see it myself simply for the exposure of the code, but i can't give a clue on the best way to go about it
<wendall911> jamest: well...I did some research just today
<wendall911> gnue is far in the lead in terms of speed/stability
<wendall911> there are several projects with many more features, but they are typically java based and extremely slow
<wendall911> which always leads me back here
<jamest> that's good to hear
<jamest> gnue should be fairly stable as I use it extensively at work
<wendall911> oh, super
<jamest> though now I am a bit behind svn head
<wendall911> yeah, I used to have it installed...but just not atm
<jamest> on compatibility
<wendall911> the gentoo ebuilds work quite well, so I can add it quite easily
<jamest> but I use gnue-common exclusively for all my custom apps
<jamest> fairly recent copies
<wendall911> nice
<jamest> so if gnue breaks we no longer make money :)
<jamest> as I can't ship, receive, or invoice w/o it :)
<wendall911> well, I plan on an ecommerce package in the near future...so I would like to tie POS and financial into the works
<wendall911> as well as shiping, etc
<wendall911> It's a huge need for our current client, and there just isn't much out there that doesn't require bailing wire
<wendall911> hmm, ebuilds need updated...will get to that tomorrow
<wendall911> thanks jamest....will ttyl
*** wendall911 has left #gnuenterprise
*** klasstek_ has joined #gnuenterprise
*** klasstek__ has joined #gnuenterprise
*** klasstek has quit IRC
*** klasstek_ has quit IRC
*** klasstek__ has quit IRC
*** derek has quit IRC
*** deke has joined #gnuenterprise