Re: [Koha-devel] RFC: Koha needs a logger!

2012-09-14 Thread Marc Balmer
Am 14.09.12 16:09, schrieb Kyle Hall: Hey all, I've been thinking about this for quite a while now. I feel that Koha would benefit greatly from having a traditional logger, rather than relying on warn's being written to the apache logs. This would give us many benefits. First, we would be

[Koha-devel] Disappearing test cases or did another part of MySQL just become closed source? « The MariaDB Blog

2012-08-20 Thread Marc Balmer
I stumbled over this blog entry: http://blog.mariadb.org/disappearing-test-cases/ It is this development of MySQL that make me so unhappy with the fact that Koha runs on MySQL only at the moment. Imo, Koha would be a much better product if it used PostgreSQL as the database system. -- Marc

Re: [Koha-devel] [Koha] KohaCon 13 Survey Problem

2012-07-05 Thread Marc Balmer
So lets repeat the vote, please. -- Marc Balmer micro systems, http://www.msys.ch/ Tel. +41 61 383 05 10, Fax +41 61 383 05 12 Am 05.07.2012 um 22:00 schrieb Lori Bowen Ayre lori.a...@galecia.com: I was under that impression too and would not have voted the way I did had I known otehrwise

Re: [Koha-devel] using CHI directly to use all of it's advantages

2012-06-15 Thread Marc Balmer
Am 15.06.12 11:32, schrieb Dobrica Pavlinusic: [...] P.S. If we need to replace the SQL query cache with a local cache, doesn't this mean we're doing it wrong? Sure, but it's low-hanging fruit, and this is currently a huge show-stopper if you want to have MySQL on another machine since

Re: [Koha-devel] Experimental support for MARC records as a proper datatype in the PostgreSQL database

2012-06-11 Thread Marc Balmer
could someone please paste the code of the 'marc_field() function? The marc_field() function is part of the MARC integration into PostgreSQL and can not be used separately, since it relies on the internal representation of binary MARC records in the database. The complete MARC code for

Re: [Koha-devel] [DISCUSSION] Database schema coding guidelines

2012-06-09 Thread Marc Balmer
Am 06.06.12 21:24, schrieb Kyle Hall: My favorite solution is to use DBix::Class. With the proper mappings only keys should really need to be unique. Eventually, the table classes could in theory hold much of the model code that is in various C4 modules, in an object-oriented manner. We have

Re: [Koha-devel] Signing-off a patch for a customer

2012-05-28 Thread Marc Balmer
Am 28.05.12 16:48, schrieb Paul Poulain: Hello koha-devel, I just pushed a follow-up for bug 6858. If you look at the patch, you'll see that the author is from BibLibre, as well as the sign-offer. But if you look more carefully on the patch comments, you may understand that Stephane Delaye

Re: [Koha-devel] Performance of Koha and usage of remote MySQL server

2012-04-06 Thread Marc Balmer
Am 06.04.12 09:58, schrieb Paul Poulain: Le 06/04/2012 09:43, Fridolyn SOMERS a écrit : In conclusion, I'd say that the problem should be cured at its source. I mean that the number of SQL queries and cache systems should be optimized in Koha code. +1000 = the problem shoud be cured at its

Re: [Koha-devel] [Koha] Call for Nominations: Roles for 3.10

2012-03-30 Thread Marc Balmer
Am 30.03.2012 01:02, schrieb Dobrica Pavlinušić: On Wed, Mar 28, 2012 at 22:10, BWS Johnsonabesottedphoe...@yahoo.com wrote: *cough* Marjiana or Dorbica *cough* I signed up as bug wrangler for plack, localization, UTF-8, profiling, speedups. I would also love to help PostgreSQL efforts

Re: [Koha-devel] Adding support for PostgreSQL, no new MySQLisms, please

2012-03-24 Thread Marc Balmer
Am 24.03.12 15:35, schrieb Robin Sheat: Op 25-03-12 03:19, Marc Balmer schreef: No, it does not rewrite any reports. If users enter SQL somewhere, I assume they enter proper SQL for their DB server. Which leads to a OK, so it doesn't address this (quite minor) problem. It would mean

[Koha-devel] Adding support for PostgreSQL, no new MySQLisms, please

2012-03-23 Thread Marc Balmer
contact me, I am always willing to help with database issues. And please be advised that adding MySQLisms in new code will fail in QA. Thanks for your cooperation! If all goes well, this work should be concluded in a few months (but we are not in a hurry). - Marc Balmer

Re: [Koha-devel] [Discussion tech] database table naming

2012-02-14 Thread Marc Balmer
Am 14.02.12 15:10, schrieb Paul Poulain: Le 10/02/2012 12:14, Marc Balmer a écrit : afaik, both MySQL and PostgreSQL support schemas. I couldn't find how it works on mySQL. Does anyone have a link with some explanation ? I will try to find out. Maybe a topic for discussions in Marseille

Re: [Koha-devel] [Discussion tech] database table naming

2012-02-14 Thread Marc Balmer
Am 14.02.12 20:41, schrieb Robin Sheat: Op 15-02-12 08:37, Marc Balmer schreef: Turns out that MySQL indeed has no schema support. But it supports cross-database-queries. A database in MySQL is very similar, if not the same, as a schema in PostgreSQL. Noo, not quite. I mean, they can

Re: [Koha-devel] [Discussion tech] database table naming

2012-02-10 Thread Marc Balmer
at 5:14 AM, Marc Balmer m...@msys.ch mailto:m...@msys.ch wrote: Am 10.02.12 11:44, schrieb Paul Poulain: Continuing with open discussion for the future of Koha: On the page http://wiki.koha-community.org/wiki/DB_schema_bugs, we have referenced some inconsistencies

Re: [Koha-devel] Quoting table column names (was Re: [Koha-patches] [PATCH] bug_5786: moved AllowOnShelfHolds to circ matrix (issuingrules))

2011-12-21 Thread Marc Balmer
Am 22.12.11 00:32, schrieb Owen Leonard: On Wed, Dec 21, 2011 at 9:22 AM, Marc Balmer m...@msys.ch wrote: Please stop putting column names in backquotes, it is a MySQLism and hinders my efforts to run Koha on PostgreSQL, I thought this was an issue that should be raised on the devel list