IRC logs of #tryton for Friday, 2021-02-05 #tryton log beginning Fri Feb 5 12:00:01 AM CET 2021
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:02
-!- thaneor( has joined #tryton02:02
-!- thaneor1( has joined #tryton02:02
-!- htgoebel( has joined #tryton04:02
-!- springwurm(~Springwur@ has joined #tryton07:02
-!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton07:02
-!- Fredia1( has joined #tryton08:02
-!- rpit( has joined #tryton09:02
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton09:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton10:02
-!- Hirschbeutel(janmittelw@gateway/shell/ has joined #tryton10:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton10:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton10:02
-!- Hirschbeutel(janmittelw@gateway/shell/ has left #tryton10:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton10:02
-!- Hirschbeutel(janmittelw@gateway/shell/ has joined #tryton10:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton10:02
-!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton11:02
-!- mariomop(~quassel@ has joined #tryton12:02
-!- rpit1( has joined #tryton12:02
Hirschbeutelcedk: going to start the migration of my shop module and would like to base it on yours - so one question: do you  think the web_shop module is finsihed in funtionality and everyting new should go to extensions? Or are you thinking about things that should be  included in the core module?13:02
cedkHirschbeutel: I have no opinion on that13:02
Hirschbeutelok - so I have to decide :)13:02
cedkHirschbeutel: I would say you can propose ;-)13:02
HirschbeutelACTION need to change nick from JanGB to Hirschbeutel because of the my matrix bridge13:02
Hirschbeutelcedk: will propose in discuss - there is one thing which is more general (attributes on products, templates, catgories) - the most of the other stuff is more or less marketing stuff and can go to a web_shop_marketing module13:02
-!- springwurm(~Springwur@ has joined #tryton14:02
-!- thaneor2( has joined #tryton14:02
-!- thaneor3( has joined #tryton14:02
pokoliHirschbeutel: how do you manage product images on webshop?14:02
HirschbeutelI have a module which stores the value of the binary to a sshfs folder. on save a couple of sizes are generated and also transformed to webp. For this I use a field.Function(field.Binary) which handles all the stuff.14:02
Hirschbeutelits a own class for Images - since in my shop you can also upload banners, advertising etc from tryton side14:02
Hirschbeutelthe images are linked to categories, templates, advertisingobjects via field Reference - finally mostly the same like attachment14:02
HirschbeutelAnd I think to switch to attachment because of the drag and drop functionallity14:02
Hirschbeutelbut - one need to divide commercial attachments from public attachments :)14:02
pokoliHirschbeutel: we have a custom module for flask web shops where we use attachments:
Hirschbeutelbetter to have this wonderful drag and drop function of attachments in the form view :)14:02
pokoliHirschbeutel: we've added a checkbox on attachments to decide if an attachment is an image or not14:02
pokoliHirschbeutel: image handling is the only part that I'm currently missing on tryton as webshop backend14:02
Hirschbeutelpokoli: yeah - good way. I think its better to say public - since there are possibly manuals as pdf14:02
Hirschbeutelpokoli: why not "if public" push it in the world after some transformations14:02
pokoliHirschbeutel: you can always publish it somewhere once you know what to publish :)14:02
pokoliHirschbeutel: even if you use some S3 compatible backend for storage they can be made public if you access it using the ID14:02
Hirschbeutel@pokoli: yes - there are a lot of ways14:02
Hirschbeutel@pokoli: I serve them by my own - so I decided to use sshfs which is served directly from a webserver14:02
pokoliHirschbeutel:your webshop and tryton services run on separate servers?14:02
pokoliHirschbeutel: on same server they can be served directly if we have the right file14:02
Hirschbeutel@pokoli: Ich habe das nur getrennt, um das Storage der Bilder von dem der Attachments zu trennen. Nun vermisse ich die coole Funktion vom attachment, die es damals noch nicht gab14:02
pokoliHirschbeutel: ich verstehe dich nicht14:02
Hirschbeutelpokoli: haha - wrong side of translater14:02
HirschbeutelI only separated this to separate the storage of the images from that of the attachments. Now I miss the cool function of the attachment, which did not exist at that time14:02
pokoligreat, now I understand14:02
pokoliHirschbeutel: indeed I like your idea of having public attachments. It can be used to share a file to anyone14:02
pokoliHirschbeutel: i do not think it will be hard to implement with the routes feature14:02
Hirschbeutel@pokoli:yes - good feature14:02
Hirschbeutelpokoli: and the shop is running on two separated servers loadbalanced and tryton very quiet on its own15:02
Hirschbeutelsame as in the vue implementation of cedk : only user management and sales needs to communicate with tryton15:02
Hirschbeutelpokoli: and in a future the search, but I'm not quite convinced yet to this :)15:02
pokoliHirschbeutel: I'm a little bit scared about how full text search will perform on translations when the ir_translation table is big15:02
pokoliHirschbeutel: but I do not think it should be an issue15:02
pokolicheck customer database with 120k products (selling T-shirts, a lot of variants) and translation table is just 83MB15:02
pokolionly using spanish for now.15:02
HirschbeutelI push a document to redisearch - this performs well and I dont need to worry about it15:02
-!- lucascastro( has joined #tryton18:02
-!- lucascastro( has joined #tryton19:02
-!- lucascastro( has joined #tryton20:02
cedkhtgoebel: please stop reverting changes on the tracker done by core developers21:02
cedkhtgoebel: we have rules and practice so respect them21:02
Hirschbeutel@pokoli: awake?21:02
Hirschbeutel * pokoli:  awake?21:02
cedkHirschbeutel: if you want to test has its search based on fulltext of PG21:02
Hirschbeutelcedk: nice - the new implementation?21:02
cedkHirschbeutel: yes, I often backport to old version the new features that I implement21:02
cedkso it runs in production even before it is committed in Tryton ;-)21:02
Hirschbeutelcedk: thats the way I do all my stuff and ist never commited to tryton :)21:02
Hirschbeutelcedk: search while typing whould be a peace of sugar to your search21:02
cedkHirschbeutel: customer has asked that for a future improvement21:02
Hirschbeutelcedk: its easy to implement via ajax (do not forget to abort the request 😉21:02
cedkHirschbeutel: it does not support websearch query because the database is too old so it is only plain query21:02
Hirschbeutelcedk: ok21:02
Hirschbeutelcedk: postgres does not have the top XX result feature?21:02
cedkHirschbeutel: do not know what it is21:02
Hirschbeutelcedk: I use this and hen I extend the length with the number of letters21:02
cedkHirschbeutel: which length?21:02
Hirschbeutelcedk: the length of the results to return21:02
cedkwhat I did:21:02
cedk* fill a full text index tsvector table with the content of the product page (higher weight for the name and lower for the description)21:02
cedk* fill a word table with the word extracted from the text index21:02
cedkfor a search request:21:02
cedk* I replace all words with similar (0.3) word found in the word table22:02
cedk* parse the string replaced as a tsquery22:02
Hirschbeutelcedk: oh - ok22:02
cedk* search by matching tsvector with tsquery and order by relevance22:02
cedkThe only problem is that it fails on query like "coco" does not find "coconut" if we also have "coco" as word22:02
cedkwhat I'm missing is prefix operator in websearch to tsquery22:02
Hirschbeutelcedk: wildcard?22:02
cedkso the tsquery for "coco" would be "coco:*"22:02
Hirschbeutelyes - what is the problem to extend it with this?22:02
cedkHirschbeutel: there is not function to change stems this way22:02
cedkI could write a tsquery directly but it is safer to use websearch/plain with external inputs22:02
cedkACTION bbl22:02
Hirschbeutelcedk: ok22:02
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton23:02

Generated by 2.16.0 by Marius Gedminas - find it at!