IRC logs of #tryton for Monday, 2011-04-11

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/!