| chat.freenode.net #tryton log beginning Mon Apr 11 00:00:01 CEST 2011 | ||
| 2011-04-11 00:35 -!- curlynostrill(~curlynost@96.57.28.108) has joined #tryton | ||
| 2011-04-11 01:25 -!- sharoon(~sharoon@173-9-190-190-miami.txt.hfc.comcastbusiness.net) has left #tryton | ||
| 2011-04-11 02:01 -!- FWiesing(~franz@mail.tryton.at) has left #tryton | ||
| 2011-04-11 02:03 -!- rhubner(~rhubner@187.112.226.244) has joined #tryton | ||
| 2011-04-11 03:35 -!- gremly(~gremly@200.106.202.91) has joined #tryton | ||
| 2011-04-11 04:34 -!- elbenfreund(~elbenfreu@89.204.153.103) has joined #tryton | ||
| 2011-04-11 05:18 -!- yangoon(~mathiasb@p54B4FEEE.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 06:12 -!- alimon(~alimon@187.156.77.238) has joined #tryton | ||
| 2011-04-11 06:21 -!- rhubner(~rhubner@187.112.226.244) has left #tryton | ||
| 2011-04-11 06:45 -!- enlightx(~enlightx@static-217-133-61-144.clienti.tiscali.it) has joined #tryton | ||
| 2011-04-11 07:04 -!- predatell(~predatell@85.198.132.141) has joined #tryton | ||
| 2011-04-11 08:17 -!- trifon(~trifon@p548C689A.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 08:22 -!- okko(~okko@62.58.29.41) has joined #tryton | ||
| 2011-04-11 08:39 -!- gavinf(~gavinf@196-210-165-231.dynamic.isadsl.co.za) has joined #tryton | ||
| 2011-04-11 08:41 -!- gavinf(~gavinf@196-210-165-231.dynamic.isadsl.co.za) has left #tryton | ||
| 2011-04-11 08:49 -!- Vladimirek(~vladimir@adsl-dyn88.91-127-104.t-com.sk) has joined #tryton | ||
| 2011-04-11 08:57 -!- hoRn(~chatzilla@dslb-094-222-142-146.pools.arcor-ip.net) has joined #tryton | ||
| 2011-04-11 08:57 <hoRn> good morning @all | ||
| 2011-04-11 09:01 <hoRn> can anybody check if my installation is broken: if i go to > Form > View Logs - i get a Exception, that list has no attribute get (Context is a list). So i checked the given context in dispatcher.py. It's a list ... | ||
| 2011-04-11 09:43 -!- bechamel(~user@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2011-04-11 10:06 -!- gavinf(~gavinf@196-210-165-231.dynamic.isadsl.co.za) has joined #tryton | ||
| 2011-04-11 10:23 -!- silverfox1971(~sysadmin0@office.delfi2000.ru) has joined #tryton | ||
| 2011-04-11 10:34 -!- gavinf(~gavinf@196-210-165-231.dynamic.isadsl.co.za) has joined #tryton | ||
| 2011-04-11 10:38 -!- gavinf(~gavinf@196-210-165-231.dynamic.isadsl.co.za) has left #tryton | ||
| 2011-04-11 10:43 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2011-04-11 10:50 -!- nicoe(~nicoe@62.58.29.41) has joined #tryton | ||
| 2011-04-11 12:13 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has joined #tryton | ||
| 2011-04-11 13:05 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has left #tryton | ||
| 2011-04-11 13:17 -!- trifon_(~trifon@p548C402E.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 13:24 <udono> anyone able to create a new database for tip? I get a deadlock: http://paste.pocoo.org/show/369553/ | ||
| 2011-04-11 13:26 <udono> maybe a local issue... | ||
| 2011-04-11 13:27 <cedk> ACTION creating new database | ||
| 2011-04-11 13:29 <udono> cedk: thanks | ||
| 2011-04-11 13:29 <cedk> udono: I can create a database | ||
| 2011-04-11 13:29 <cedk> udono: you have perhaps other process accessing the database during the installation | ||
| 2011-04-11 13:29 <udono> cedk: strange... I clone all again. | ||
| 2011-04-11 13:45 <udono> cedk: ups, I had multiprocessing twice in python-path ... database creation works again. Thanks for testing! | ||
| 2011-04-11 13:52 -!- elbenfreund(~elbenfreu@p54B942D7.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 14:13 -!- trifon__(~trifon@p548C7FB1.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 15:00 -!- gavinf(~gavinf@196.210.165.231) has joined #tryton | ||
| 2011-04-11 15:01 -!- gavinf(~gavinf@196.210.165.231) has left #tryton | ||
| 2011-04-11 15:16 <udono> cedk: issue1826: When I try to start a new transaction (this way: http://paste.pocoo.org/show/369609/ ) I always get this error: http://paste.pocoo.org/show/369610/ do you have an idea? | ||
| 2011-04-11 15:19 <cedk> udono: yes you must use new_cursor | ||
| 2011-04-11 15:20 -!- sharoon(~sharoon@173-9-190-190-miami.txt.hfc.comcastbusiness.net) has joined #tryton | ||
| 2011-04-11 15:39 <udono> cedk: thanks, easy :-) | ||
| 2011-04-11 15:40 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has joined #tryton | ||
| 2011-04-11 15:40 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has left #tryton | ||
| 2011-04-11 15:41 -!- trifon_(~trifon@p548C541F.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 16:04 -!- silverfox1971(~sysadmin0@office.delfi2000.ru) has left #tryton | ||
| 2011-04-11 16:43 <sharoon> cedk: ping | ||
| 2011-04-11 16:44 <cedk> sharoon: pong | ||
| 2011-04-11 16:44 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-04-11 16:45 <sharoon> cedk: about GSOC - is it not one student per mentor ? | ||
| 2011-04-11 16:46 <sharoon> cedk: ie. for the google terms. though the mentorship is more of a community process | ||
| 2011-04-11 16:46 <cedk> sharoon: for PSF it is one mentor per student | ||
| 2011-04-11 16:48 <sharoon> cedk: so do we have more mentors ? are we not completely allocated for now ? | ||
| 2011-04-11 16:49 <cedk> sharoon: we are but we don't know yet how much slots we will have nor which students will be choosent | ||
| 2011-04-11 16:50 <sharoon> cedk: ok, I understand | ||
| 2011-04-11 16:50 <sharoon> cedk: so should we ask the students to improve on their applications ? | ||
| 2011-04-11 16:50 <cedk> sharoon: why not | ||
| 2011-04-11 16:51 <sharoon> cedk: alright. and what about the rating of applications ? it seems to me from the GSOC mailing list that some projects have already started rating their applciations | ||
| 2011-04-11 16:55 <cedk> sharoon: I must email to Arc April 18 the list of students we want | ||
| 2011-04-11 16:55 <sharoon> cedk: ok | ||
| 2011-04-11 17:15 <sharoon> cedk: do you have a few mins to discuss about caching ? | ||
| 2011-04-11 17:18 <cedk> sharoon: ok | ||
| 2011-04-11 17:19 <sharoon> cedk from the short description that you have written, are we thinking of memoize at read method of ModelSQL ? | ||
| 2011-04-11 17:19 <sharoon> is it the same api you are thinking of for tools.cache ? | ||
| 2011-04-11 17:20 <cedk> sharoon: indeed I don't know if it is doable | ||
| 2011-04-11 17:22 <cedk> sharoon: and also I'm not sure it will improve something | ||
| 2011-04-11 17:22 <sharoon> cedk: a quick thought from my side is like this | ||
| 2011-04-11 17:24 <sharoon> cedk: the most common operation from client side i fetching (read) the first set of records for the client to display. I believe thats the place where there will be multiple queries of the same kind and i believe the result will not be more than 1 MB | ||
| 2011-04-11 17:25 <sharoon> cedk: so we could cache that based on Transaction().cursor.dbname, model._name, given ids and context | ||
| 2011-04-11 17:26 <sharoon> cedk: this combination could easily go above 250 chars and i think we will need hashing to make the key | ||
| 2011-04-11 17:26 <cedk> sharoon: but why will it be faster then postgresql? | ||
| 2011-04-11 17:27 <cedk> s/then/than/ | ||
| 2011-04-11 17:28 <bechamel> sharoon: cedk: another problem is that different user see different record (because of rules & access) | ||
| 2011-04-11 17:28 <sharoon> cedk: it will be fast ONLY if there are multiple connections on postgres | ||
| 2011-04-11 17:28 <sharoon> bechamel: then we will need to add user also to the hash | ||
| 2011-04-11 17:29 <cedk> sharoon: don't understand | ||
| 2011-04-11 17:30 <bechamel> what about cache invalidation, it seems tricky | ||
| 2011-04-11 17:30 <sharoon> cedk: for a small userbase i dont see benefits with memcached specially in caching read etc.... for expensive queries, caching the result is useful..... it becomes useful for read only when the server has exceptionally high load/frequent queries where the database will become bottle neck | ||
| 2011-04-11 17:31 <sharoon> bechamel: agree, especially when the result of the query changes with an indirect change to some other data (eg. change in rules result in change of sale orders the user can see) | ||
| 2011-04-11 17:33 <cedk> sharoon: in fact, I don't see how this could be achieve with the respect of the transaction and the modularity | ||
| 2011-04-11 17:33 <sharoon> cedk: can you explain the case | ||
| 2011-04-11 17:34 <bechamel> sharoon: cedk: what about overloading the current cache mechanism (memoize) and use a central memcache instead of using the DB to invaliddate cache of other trytond instance ? | ||
| 2011-04-11 17:34 <cedk> sharoon: you need to invalidate you cache but how can you do it? | ||
| 2011-04-11 17:36 <sharoon> cedk: i dont see a way to find out which are the cache entries that need to be invalidated on a change | ||
| 2011-04-11 17:37 <sharoon> bechamel: how does invalidation in memoize work now ? | ||
| 2011-04-11 17:39 <bechamel> sharoon: actualy i was talking about the @Cache decorator | ||
| 2011-04-11 17:40 <bechamel> sharoon: and is invalidated explicitly in the code using it | ||
| 2011-04-11 17:41 <sharoon> interesting http://bazaar.launchpad.net/~openerp/openobject-server/6.0/view/head:/bin/addons/base/ir/ir_ui_menu.py#L44 | ||
| 2011-04-11 17:44 <cedk> sharoon: cache is not very good and should be used in very specific cases | ||
| 2011-04-11 17:45 <sharoon> cedk: agree, i dont think it can be generalised as we thought it could be. It might be better to have Cache as a contrib in tryton so that it can be used when you know where it has to be used. | ||
| 2011-04-11 17:45 <cedk> sharoon: have you an example for why you want to have cache? | ||
| 2011-04-11 17:46 <cedk> sharoon: there is a bug with @Cache | ||
| 2011-04-11 17:46 <cedk> http://bugs.tryton.org/roundup/issue1825 | ||
| 2011-04-11 17:47 <sharoon> cedk: for example, results of search_read for the same set of ids, fields | ||
| 2011-04-11 17:48 <cedk> sharoon: no I mean an example where you really need to have cache | ||
| 2011-04-11 17:49 <sharoon> cedk: i want to cache product information when the e-commerce system reads it | ||
| 2011-04-11 17:49 <cedk> sharoon: why don't you cache it in your e-commerce? | ||
| 2011-04-11 17:50 <sharoon> cedk: i have a caching emcahnism already but thought it might be better to implement a level below in tryton itself | ||
| 2011-04-11 17:51 <sharoon> cedk: it looks like that wont be as easy as i "imagined" - we have the big reset case | ||
| 2011-04-11 17:52 <cedk> sharoon: I think cache should be the last answer to a problem | ||
| 2011-04-11 17:52 <cedk> sharoon: we should first try to fix what is slow | ||
| 2011-04-11 17:53 <sharoon> cedk: i agree, there is nothing slow.... the only slow part is the search which ideally must not be fixed by a cache but by the search itself.... this is just to reduce the database hits | ||
| 2011-04-11 17:54 <cedk> sharoon: database like postgresql are design to be hitted :-) | ||
| 2011-04-11 17:56 <bechamel> cedk: except for the bug, what do you think about creating a "memcache-enabled" version of @Cache ? | ||
| 2011-04-11 17:57 <cedk> bechamel: why not | ||
| 2011-04-11 17:58 <sharoon> cedk: bechamel: i think we should just generalise the Cache interface and allow the user to chose the cache backend. a config setting like | ||
| 2011-04-11 17:58 <sharoon> enable_cache = True | ||
| 2011-04-11 17:58 <sharoon> cache_backend = database # database, memcached, filesystem, memcached_appengine | ||
| 2011-04-11 17:58 <sharoon> the last one is for future ;) | ||
| 2011-04-11 18:04 <cedk> sharoon: sounds good | ||
| 2011-04-11 18:05 <sharoon> ced, nicoe: i see that you are working on pysql, is the aim something like http://www.sqlalchemy.org/docs/core/tutorial.html | ||
| 2011-04-11 18:07 <cedk> sharoon: yes except that it does (I think) introspection | ||
| 2011-04-11 18:08 <sharoon> cedk: are we avoiding sqlalchemy to avoid dependency, or why not use sqlalchemy.core itself (Not ORM) | ||
| 2011-04-11 18:08 <cedk> sharoon: also we want to be able to manipulate incomplete queries | ||
| 2011-04-11 18:09 <sharoon> cedk: incomplete? sorry dint get you | ||
| 2011-04-11 18:09 <cedk> sharoon: we are avoiding sqlalchemy because it doesn't fit our needs | ||
| 2011-04-11 18:09 <sharoon> cedk: ok | ||
| 2011-04-11 18:09 <cedk> sharoon: queries that are not complete | ||
| 2011-04-11 18:10 <cedk> sharoon: like some part of a where clause | ||
| 2011-04-11 18:10 <sharoon> cedk: can you mention an example ? | ||
| 2011-04-11 18:10 <cedk> sharoon: of pysql? | ||
| 2011-04-11 18:11 <sharoon> cedk: no queries that are not complete | ||
| 2011-04-11 18:11 <cedk> http://codereview.appspot.com/4248045/ | ||
| 2011-04-11 18:12 <cedk> sharoon: like the query_get of account.move.line | ||
| 2011-04-11 18:13 <sharoon> cedk: this is interesting | ||
| 2011-04-11 18:14 <sharoon> cedk: if designed with good modularity it will be a great addition to python - Database agnostic SQL generator with python constructs | ||
| 2011-04-11 18:18 <sharoon> ACTION brb | ||
| 2011-04-11 18:23 -!- chrue(~chrue@dyndsl-091-096-010-126.ewe-ip-backbone.de) has joined #tryton | ||
| 2011-04-11 18:41 -!- FWiesing(~franz@mail.tryton.at) has joined #tryton | ||
| 2011-04-11 18:55 -!- caravel(~caravel@1.Red-81-44-157.dynamicIP.rima-tde.net) has joined #tryton | ||
| 2011-04-11 19:04 -!- elbenfreund(~elbenfreu@p54B959D5.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 19:43 -!- elbenfreund(~elbenfreu@p54B959D5.dip.t-dialin.net) has joined #tryton | ||
| 2011-04-11 20:17 -!- Vladimirek(~vladimir@adsl-dyn88.91-127-104.t-com.sk) has joined #tryton | ||
| 2011-04-11 20:22 -!- chrue(~chrue@dyndsl-091-096-010-126.ewe-ip-backbone.de) has joined #tryton | ||
| 2011-04-11 20:29 -!- okko(~okko@dhcp-077-251-140-095.chello.nl) has joined #tryton | ||
| 2011-04-11 21:14 -!- enlightx(~enlightx@dynamic-adsl-94-34-183-252.clienti.tiscali.it) has joined #tryton | ||
| 2011-04-11 21:20 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has joined #tryton | ||
| 2011-04-11 21:28 -!- rhubner(~rhubner@200.201.111.194) has joined #tryton | ||
| 2011-04-11 21:50 -!- pjstevns(~pjstevns@helpoort.xs4all.nl) has left #tryton | ||
| 2011-04-11 22:23 <rhubner> Hi sharoon! | ||
| 2011-04-11 22:25 <rhubner> sharoon: Do you know how many slots Tryton has in gsoc? | ||
| 2011-04-11 22:29 <rhubner> sharoon: The quantity of slots was give to PSF or to each umbrella team? | ||
| 2011-04-11 22:30 <sharoon> rhubner: i dont know, cedk is the admin. you must ask him | ||
| 2011-04-11 22:31 <rhubner> sharoon: ok... Thanks :) | ||
| 2011-04-11 22:33 -!- bechamel(~user@host-85-201-144-79.brutele.be) has joined #tryton | ||
| 2011-04-11 22:39 -!- zodman(~zodman@foresight/developer/zodman) has joined #tryton | ||
| 2011-04-11 22:42 <sharoon> bechamel: is there any example on how a PostgreSQL view can be used as a Model ? | ||
| 2011-04-11 22:45 <bechamel> sharoon: let me check | ||
| 2011-04-11 22:47 <bechamel> sharoon: http://hg2.tryton.org/modules/timesheet/file/e8086794b3e0/line.py#l129 | ||
| 2011-04-11 22:47 <bechamel> sharoon: and grepping for "table_query" will give you the others | ||
| 2011-04-11 22:54 <sharoon> bechamel: thanks | ||
| 2011-04-11 23:50 -!- Vladimirek(~vladimir@adsl-dyn88.91-127-104.t-com.sk) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!