Time Nick Message 17:05 toins bye all 17:01 hdl nice to see you back too. 16:58 kados nice chatting 16:58 kados bye 16:58 kados wow 16:58 hdl I may fly for 32 hours in a few weeks. 16:57 kados yep :-) 16:57 hdl :D 16:57 hdl Home sweet home. 16:57 kados sick of airports and hotels :-) 16:57 kados I am glad to be home 16:57 kados :-) 16:57 kados cool 16:57 hdl Congrats. 16:57 hdl (some blogs told their enthousiasm.) 16:56 hdl I saw that you did great jobs demonstrating LibLime. 16:56 kados *nod* 16:56 hdl But still many have to be done. 16:56 hdl With web installer, a step was made. 16:56 kados but he's busy working for a living now I think 16:55 kados I think thd would be willing to do it 16:55 hdl So that ppl could use Koha out of the box with only a little parameter changes. 16:55 hdl What could be nice is that we had a common framework and different mappings pre-forged. 16:54 kados :-) 16:53 hdl kados. I already know more and more MARC21. 16:48 kados much more useful than MARC21 16:48 kados it will give you the ISO code exactly! 16:48 kados hdl: wow, the 100 field in UNIMARC is really helpful w/respect to encoding 16:47 kados then you would be MARC21 experts as well as UNIMARC ;-) 16:46 kados too bad they didn't want to stay with MARC21 :( 16:46 kados Character Set (Mandatory) is 4 characters 16:46 hdl We migrated some clients from MARC21 to UNIMARC (because previous ILS was MARC21-based and library prefered UNIMARC) 16:46 kados ahh, so it's quite nice actually 16:45 hdl http://www.ifla.org/VI/3/p1996-1/uni1.htm#100 16:45 kados you have a client who wants to switch from MARC21 to UNIMARC? 16:44 hdl (paul transformed some MARC8 data into UNIMARC but encoding is not perfect) 16:44 kados what are the codes for UNIMARC 100 tag? 16:43 hdl It may be a good hint. 16:43 kados but not for UNIMARC zebra, right? 16:43 kados it's the author field 16:43 kados 100 is for MARC21 zebra 16:43 kados or sth 16:43 kados } else { 16:43 kados } elsif (leader tells encoding) { 16:43 hdl But we added 100 for zebra :( 16:43 kados if (tag 100 tells encoding) { 16:42 kados so you need to do: 16:42 kados right 16:42 hdl Because some libraries have datas from LOC(MARC8) and bnf (UNIMARC) 16:42 kados IIRC 16:42 kados and in MARC21 we have the leader 16:42 kados but in UNIMARC you have a 100 tag to tell you which encoding it is? 16:42 kados guessing encoding is really hard 16:42 hdl The main problem will be that in certain circomstances, it is quite a hard task to GUESS between ISO5426 and MARC8. 16:41 kados cool 16:41 kados ahh, ok 16:41 hdl ISO5426 is a UNIMARC standard. 16:40 kados in some client data? 16:40 kados when do you encounter ISO5426 and ISO6436 records? 16:40 hdl It is good for spanish languages, but German or French has characters not encoded. 16:40 kados *nod* 16:39 hdl But it still need some work. 16:39 hdl I used marc4j as a base. 16:39 kados encoding is hard :-) 16:39 hdl Not solved. 16:39 kados cool 16:39 hdl But I have to work on it still. 16:39 hdl Yes to fix for good ISO5426 and ISO6436 encoding problems. 16:38 kados what is an encoding package? 16:38 hdl this week. 16:38 kados an encoding package? 16:38 hdl And I trid to do an encoding package. 16:38 kados I will try to prioritize it 16:38 hdl this week end. 16:38 kados :-) 16:38 hdl Vote duty for me. 16:37 kados I know I've been very bad about that 16:37 kados yes 16:37 hdl Did paul ask you about yui ? 16:37 kados how is your week going? 16:37 kados hi hdl 16:37 hdl hi kados. 16:36 kados ok, bye 16:36 paul but now, family time for me, we will speak of that on monday. 16:35 kados maybe in 3.4 :-) 16:35 paul right. 16:35 paul time for week end. 16:35 kados paul: I remember a while ago we discussed it would be a good idea to have transactions for circ, etc. 16:30 toins http://en.wikipedia.org/wiki/Object-relational_mapping 16:30 toins slef: M for mapping i think 16:28 slef ORM=Object Relation Model? 16:28 paul ah, yes we have one with Koha NoZebra ;-) 16:28 paul I don't think so. 16:27 kados paul: do we have any transactions yet in koha? 16:25 toins and sql queries are optimized... 16:25 toins my framewrok works fine with mysql postgres sqlite firebird... 16:24 toins With a ORM sql code is very easy to write, and works on many DBMS.... 16:24 kados seems neat 16:23 kados chris just told me about catalyst 16:23 kados ahh 16:23 toins i don't know ORM for perl... (but i'm sure there are someone as catalyst use one) I have ever use python ORM for web framework developpment... 16:21 kados sorry 16:21 kados yes 16:21 toins you mean ORM ? 16:21 toins you ORM ? 16:20 slef biab 16:20 toins OML ? 16:20 kados toins: what would OML give us? 16:19 kados *nod* 16:19 slef :-/ 16:19 slef it's all fun for me with koha at the moment 16:19 kados heh 16:19 slef hell, I even broke my cvs checkout recently when trying to commit a submitted patch 16:19 slef particularly round ones 16:18 kados heh 16:18 slef kados: sure, when I get some tuits :-/ 16:18 kados slef: do you have any bandwidth to spend on cleaning that up in head? 16:18 slef unfortunately, I did some fixups ages ago and I've not followed recent changes 16:18 slef my comments from 2004 still stand: where reserved words are used unquoted or non-standard SQL is used, it's a bug 16:17 kados that's where it started :-) 16:17 kados slef: http://www.coffeecode.net/index.php?url=archives/123-Evergreen-and-the-business-case-for-choosing-an-open-source-ILS.html 16:17 kados slef: maybe you can weigh in on the SQL issue 16:17 kados heh 16:17 slef comment-prevention image, more like 16:16 slef "Enter the string from the spam-prevention image above:" 16:16 kados paul: message to koha-devel sent 16:14 toins kados: what do you think about using an ORM in koha for sql queries ? 16:12 toins i think hdl can answer easily as me to this question... 16:11 kados what do you think? 16:10 kados toins: in your opinion, can we remove koha.mysql? 16:10 dewey rumour has it the problem is that it's usually very hard to understand 16:10 toins and what's the problem ? 16:10 kados it's in misc 16:09 kados and there's a koha.mysql somewhere too 16:09 kados installer/kohastructure.sql is one 16:09 kados toins: in head I mean 16:08 kados toins: we seem to have two (or maybe more) SQL def files 16:07 toins :( 16:07 toins yep i know... 16:06 kados sorry you missed the google summer of code deadline 16:06 kados hi toins :-) 16:06 toins hi kados 16:06 kados hehe 16:06 paul (who says i'm bugguing ???) 16:05 paul but 1st, you should commit YUI stuff ;-) 16:05 kados ok, I will 16:05 paul throw a mail on koha-devel about that. 16:05 kados they seem easy enough to fix, and I'd love to post a response that we've fixed them :-) 16:04 kados I'm not sure about #1, or #3-#5 16:04 paul right 16:04 paul but not shipped in most linux distro. 16:04 kados I think we have fixed #2 already 16:04 kados 5. add SET SQL_MODE='ANSI_QUOTES' to allow using double-quotes for SQL name delimiters 16:04 kados 4. nonsensical date defaults like 0000-00-00 (why not use NULL) 16:04 kados 3. get rid of quotes around integer values 16:04 kados 2. tables shouldn't be defined with TYPE=MyISAM 16:04 kados 1. use of SQL92 keywords as field names, table names, etc. 16:04 kados so I have picked out 5 items from his comments: 16:04 kados ahh 16:03 paul which is a quite good DB and GPL as well 16:03 paul i used to work on Firebird 16:03 paul I've never setup a postgres DB ! 16:02 paul not at all ! 16:02 kados you are a postgres expert, right paul? 16:02 kados *nod* 16:02 paul fortunatly he didn't came into the "mySQL constraint" and "stored proc" war as well... 15:59 kados and dan responded 15:59 kados and chris responded 15:59 kados and dan responded 15:59 kados and I left a comment 15:59 kados yes 15:59 paul you're speaking of : Why is there so much interest in Evergreen and why aren't we hearing much about Koha? 15:57 kados *nod* 15:56 paul in june, forget any of use : hdl will be for 2 weeks in new caledonia for some business & i've 5 demos + probably 2 teachings 15:56 kados Dan has some suggestions w/respect to our db defs 15:56 kados worth reading the comments at least 15:56 kados have you seen that post? 15:56 kados paul: http://www.coffeecode.net/index.php?url=archives/123-Evergreen-and-the-business-case-for-choosing-an-open-source-ILS.html 15:56 paul great. I don't have any either, so, we should be able to work efficiently. 15:56 kados paul++ 15:56 kados cool 15:56 paul so zebra is still usefull. depends on the use the library needs 15:55 paul of course, it don't contains any z3950 server & other features zebra has 15:55 kados wow, that's impressive! 15:55 kados so I plan to spend a lot of time getting caught up 15:55 kados I have no trips planned for this month 15:55 paul it's almost as fast as zebra even for a 300 000 items catalogue. 15:55 kados paul++ 15:55 kados w00t 15:55 kados I haven't even looked at any code in a long long time :( 15:54 kados the last few weeks have been very busy 15:54 kados hehe 15:54 paul you have a library on the moon now ? 15:54 kados hi :-) 15:54 paul kados is here ! 15:54 paul yeahhhhhhhh!!!! 15:54 kados paul: ? 15:54 kados any frenchies around?