| chat.freenode.net #tryton log beginning Fri Feb 5 12:00:01 AM CET 2021 | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 00:37 | |
| -!- thaneor(~ldlc6@r167-61-165-139.dialup.adsl.anteldata.net.uy) has joined #tryton | 01:26 | |
| -!- thaneor1(~acer8@r167-61-165-139.dialup.adsl.anteldata.net.uy) has joined #tryton | 01:27 | |
| -!- htgoebel(~hartmut@ppp-188-174-60-247.dynamic.mnet-online.de) has joined #tryton | 03:17 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 06:08 | |
| -!- mrichez(~Maxime@2a02:a03f:c2e8:f900:ed77:85ea:af2b:ba6e) has joined #tryton | 06:09 | |
| -!- Fredia1(~Sadie@titan.pathogen.is) has joined #tryton | 07:57 | |
| -!- rpit(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton | 08:17 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 08:26 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton | 08:35 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton | 09:10 | |
| -!- Hirschbeutel(janmittelw@gateway/shell/matrix.org/x-lsxxtefkslqjjtgx) has joined #tryton | 09:25 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton | 09:26 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton | 09:27 | |
| -!- Hirschbeutel(janmittelw@gateway/shell/matrix.org/x-lsxxtefkslqjjtgx) has left #tryton | 09:32 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton | 09:39 | |
| -!- Hirschbeutel(janmittelw@gateway/shell/matrix.org/x-lsxxtefkslqjjtgx) has joined #tryton | 09:40 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has left #tryton | 09:43 | |
| -!- JanGB(~jan@2a02:810a:1440:64da:6257:18ff:fe9c:c3a9) has joined #tryton | 10:42 | |
| -!- mariomop(~quassel@181.29.189.235) has joined #tryton | 11:02 | |
| -!- rpit1(~rpit@p200300c88f0235001c42215a17f33f55.dip0.t-ipconnect.de) has joined #tryton | 11:27 | |
| Hirschbeutel | Hello | 11:38 |
|---|---|---|
| Hirschbeutel | cedk: 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? | 12:27 |
| cedk | Hirschbeutel: I have no opinion on that | 12:28 |
| Hirschbeutel | ok - so I have to decide :) | 12:31 |
| cedk | Hirschbeutel: I would say you can propose ;-) | 12:32 |
| Hirschbeutel | ACTION need to change nick from JanGB to Hirschbeutel because of the my matrix bridge | 12:33 |
| Hirschbeutel | cedk: 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 module | 12:35 |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 13:04 | |
| -!- thaneor2(~acer8@r167-61-12-145.dialup.adsl.anteldata.net.uy) has joined #tryton | 13:29 | |
| -!- thaneor3(~ldlc6@r167-61-12-145.dialup.adsl.anteldata.net.uy) has joined #tryton | 13:30 | |
| pokoli | Hirschbeutel: how do you manage product images on webshop? | 13:36 |
| Hirschbeutel | I 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. | 13:39 |
| Hirschbeutel | its a own class for Images - since in my shop you can also upload banners, advertising etc from tryton side | 13:40 |
| Hirschbeutel | the images are linked to categories, templates, advertisingobjects via field Reference - finally mostly the same like attachment | 13:43 |
| Hirschbeutel | And I think to switch to attachment because of the drag and drop functionallity | 13:43 |
| Hirschbeutel | but - one need to divide commercial attachments from public attachments :) | 13:44 |
| pokoli | Hirschbeutel: we have a custom module for flask web shops where we use attachments: https://gitlab.com/kopen/web_shop_flask/-/blob/master/product.py#L17 | 13:45 |
| Hirschbeutel | better to have this wonderful drag and drop function of attachments in the form view :) | 13:45 |
| pokoli | Hirschbeutel: we've added a checkbox on attachments to decide if an attachment is an image or not | 13:46 |
| pokoli | Hirschbeutel: image handling is the only part that I'm currently missing on tryton as webshop backend | 13:46 |
| Hirschbeutel | pokoli: yeah - good way. I think its better to say public - since there are possibly manuals as pdf | 13:47 |
| Hirschbeutel | pokoli: why not "if public" push it in the world after some transformations | 13:48 |
| pokoli | Hirschbeutel: you can always publish it somewhere once you know what to publish :) | 13:49 |
| pokoli | Hirschbeutel: even if you use some S3 compatible backend for storage they can be made public if you access it using the ID | 13:50 |
| Hirschbeutel | @pokoli: yes - there are a lot of ways | 13:50 |
| Hirschbeutel | @pokoli: I serve them by my own - so I decided to use sshfs which is served directly from a webserver | 13:52 |
| pokoli | Hirschbeutel:your webshop and tryton services run on separate servers? | 13:54 |
| pokoli | Hirschbeutel: on same server they can be served directly if we have the right file | 13:55 |
| 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 gab | 13:55 |
| pokoli | Hirschbeutel: ich verstehe dich nicht | 13:56 |
| Hirschbeutel | pokoli: haha - wrong side of translater | 13:56 |
| Hirschbeutel | I 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 time | 13:56 |
| pokoli | great, now I understand | 13:57 |
| pokoli | Hirschbeutel: indeed I like your idea of having public attachments. It can be used to share a file to anyone | 13:57 |
| pokoli | Hirschbeutel: i do not think it will be hard to implement with the routes feature | 13:58 |
| Hirschbeutel | @pokoli:yes - good feature | 13:58 |
| Hirschbeutel | pokoli: and the shop is running on two separated servers loadbalanced and tryton very quiet on its own | 14:00 |
| Hirschbeutel | same as in the vue implementation of cedk : only user management and sales needs to communicate with tryton | 14:01 |
| Hirschbeutel | pokoli: and in a future the search, but I'm not quite convinced yet to this :) | 14:03 |
| pokoli | Hirschbeutel: I'm a little bit scared about how full text search will perform on translations when the ir_translation table is big | 14:06 |
| pokoli | Hirschbeutel: but I do not think it should be an issue | 14:07 |
| pokoli | check customer database with 120k products (selling T-shirts, a lot of variants) and translation table is just 83MB | 14:08 |
| pokoli | only using spanish for now. | 14:09 |
| Hirschbeutel | I push a document to redisearch - this performs well and I dont need to worry about it | 14:10 |
| -!- lucascastro(~lucascast@177-185-131-162.corp.isotelco.net.br) has joined #tryton | 17:58 | |
| -!- lucascastro(~lucascast@177-185-131-162.corp.isotelco.net.br) has joined #tryton | 18:18 | |
| -!- lucascastro(~lucascast@177-185-133-183.dynamic.isotelco.net.br) has joined #tryton | 19:03 | |
| cedk | htgoebel: please stop reverting changes on the tracker done by core developers | 20:26 |
| cedk | htgoebel: we have rules and practice so respect them | 20:27 |
| Hirschbeutel | @pokoli: awake? | 20:40 |
| Hirschbeutel | * pokoli: awake? | 20:40 |
| cedk | Hirschbeutel: if you want to test https://www.jurassicfruit.com/ has its search based on fulltext of PG | 20:42 |
| Hirschbeutel | cedk: nice - the new implementation? | 20:46 |
| cedk | Hirschbeutel: yes, I often backport to old version the new features that I implement | 20:46 |
| cedk | so it runs in production even before it is committed in Tryton ;-) | 20:47 |
| Hirschbeutel | cedk: thats the way I do all my stuff and ist never commited to tryton :) | 20:47 |
| Hirschbeutel | cedk: search while typing whould be a peace of sugar to your search | 20:48 |
| cedk | Hirschbeutel: customer has asked that for a future improvement | 20:51 |
| Hirschbeutel | cedk: its easy to implement via ajax (do not forget to abort the request 😉 | 20:51 |
| cedk | Hirschbeutel: it does not support websearch query because the database is too old so it is only plain query | 20:53 |
| Hirschbeutel | cedk: ok | 20:54 |
| Hirschbeutel | cedk: postgres does not have the top XX result feature? | 20:54 |
| cedk | Hirschbeutel: do not know what it is | 20:56 |
| Hirschbeutel | cedk: I use this and hen I extend the length with the number of letters | 20:56 |
| cedk | Hirschbeutel: which length? | 20:57 |
| Hirschbeutel | cedk: the length of the results to return | 20:57 |
| cedk | what I did: | 20:58 |
| 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) | 20:59 |
| cedk | * fill a word table with the word extracted from the text index | 20:59 |
| cedk | for a search request: | 20:59 |
| cedk | * I replace all words with similar (0.3) word found in the word table | 21:00 |
| cedk | * parse the string replaced as a tsquery | 21:00 |
| Hirschbeutel | cedk: oh - ok | 21:00 |
| cedk | * search by matching tsvector with tsquery and order by relevance | 21:00 |
| cedk | The only problem is that it fails on query like "coco" does not find "coconut" if we also have "coco" as word | 21:02 |
| cedk | what I'm missing is prefix operator in websearch to tsquery | 21:03 |
| Hirschbeutel | cedk: wildcard? | 21:04 |
| cedk | so the tsquery for "coco" would be "coco:*" | 21:04 |
| Hirschbeutel | yes - what is the problem to extend it with this? | 21:05 |
| cedk | Hirschbeutel: there is not function to change stems this way | 21:05 |
| cedk | I could write a tsquery directly but it is safer to use websearch/plain with external inputs | 21:06 |
| cedk | ACTION bbl | 21:07 |
| Hirschbeutel | cedk: ok | 21:07 |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 22:09 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!