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