July 2012 - Koha-devel - lists.koha-community.org

[DISCUSSION] Database schema & coding guidelines
by Paul Poulain 04 Jul '12

04 Jul '12

In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an insconsistency has been noticed: primary keys column name can be: id (in authorised_values table), xxxid (cityid), xxx_id (label_id), xxxId (limitId), xxxcode (branchcode), xxxnumber (borrowernumber) => choose how to name PK and update schema accordingly The bug 7065 add a foreign key to the reserves table, so I think it's time to clearly choose how we name primary keys. The possible options are below, my opinion: 1- id alone => will result in complexity & mistakes, this option must be discarded 2- xxxxid => short option, may result in hard readability. 3- xxxxId => we haven't decided if we want UC in field names. I won't discard this option, but does not favour it. 4- xxx_id => _ still undecided in field names, I'm not sure it's much better than the xxxid one 5- xxxxnumber => number is quite long, and may result in very long field names, which is not good. I does not like this option. Let's start the discussion -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

6 12

A C4::Logger module would be useful ?
by Jonathan Druart 04 Jul '12

04 Jul '12

HI all, I have developped a logging module (based on LogLite). I think it could be useful for Koha. A new system preference controls the log level (eg. level warning for production and debug for development). It can be used by a simple script or into Koha. How it works: See Bug 8190 ( http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8190) Please have a look at that, and tell me what do you think about it. Technically, is it satisfying for you? I think it could help us to increase the code quality. Any others ideas are welcome ! ++ Jonathan

8 13

[discussion] Privacy issue (bug 3280)
by Paul Poulain 03 Jul '12

03 Jul '12

Hello Koha users & developers, The bug 3280 fixes a problem in cart sending in opac : the behaviour has changed, and for security reason, it will be possible only for logged-in users. A question has also been raised : we could also add the IP address of the sender in the mail that Koha sent. Do you think : 1- we could 2- we should 3- we shouldn't (and why) I start arguing = I think we should, and in France, I think it's a legal issue, you must be able to answer any legal request from a court (9-11, thank you :\ ) It's right we have the username, but the IP address is a good complement -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08

2 1

KohaCon 2013 Voting Open
by Nicole Engard 02 Jul '12

02 Jul '12

The voting for the KohaCon13 Conference Venue is open! http://survey.web2learning.net/limesurvey/index.php?sid=91534&lang=en Please vote for where you'd like to see KohaCon 2013. To review the full proposals please read here: http://wiki.koha-community.org/wiki/Kohacon2013 Once I know when the voting should close I'll share with you all :) But for now, get your votes in!! Thanks a bunch, Nicole C. Engard Documentation Manager

1 1