| # |
Jul 10th 2018, 10:28 |
 james.phillips |
:money_mouth_face: |
| # |
Jul 10th 2018, 10:28 |
james.phillips |
wudnt a index per "resource" type make more sense? In one way it needs to search everything but wouldn't matching it all back to the correct tables be a pain? |
| # |
Jul 10th 2018, 10:27 |
josbeir |
but maybe i'll get back to work now |
| # |
Jul 10th 2018, 10:26 |
josbeir |
np np i like to share my ES knowledge |
| # |
Jul 10th 2018, 10:26 |
josbeir |
:) i'll send you an invoice |
| # |
Jul 10th 2018, 10:26 |
james.phillips |
i feel like a leech...draining you of all your knowledge |
| # |
Jul 10th 2018, 10:25 |
josbeir |
but in maybe, in your case i'm thinking about typing out a universal document schema and use 1 index to store all your stuff |
| # |
Jul 10th 2018, 10:24 |
josbeir |
there's no specific way or 'good' way to do the indexing |
| # |
Jul 10th 2018, 10:24 |
josbeir |
uhu |
| # |
Jul 10th 2018, 10:23 |
james.phillips |
I have events, publications, podcasts etc so i wanna be able to put them in ES do keyword searches on them and match that result set back to the mysql tables |
| # |
Jul 10th 2018, 10:23 |
josbeir |
well.. maybe not a blob :) |
| # |
Jul 10th 2018, 10:23 |
josbeir |
can be an integer, a string, whatever |
| # |
Jul 10th 2018, 10:23 |
josbeir |
no real 'rules' of the type |
| # |
Jul 10th 2018, 10:23 |
josbeir |
an _id in ES must be something unique, it can be your database PK or something other |
| # |
Jul 10th 2018, 10:22 |
james.phillips |
I get u |
| # |
Jul 10th 2018, 10:22 |
josbeir |
if you add them to it :slightly_smiling_face: |
| # |
Jul 10th 2018, 10:22 |
josbeir |
sure |
| # |
Jul 10th 2018, 10:22 |
james.phillips |
and those documents can have the ID that relates to the primary key of my tables? |
| # |
Jul 10th 2018, 10:22 |
josbeir |
you can use aggregations to do more complex grouping, facetting, that sort of stuff |
| # |
Jul 10th 2018, 10:22 |
josbeir |
it returns documents you queried for |
| # |
Jul 10th 2018, 10:21 |
josbeir |
if you want it to ? :) |
| # |
Jul 10th 2018, 10:21 |
josbeir |
what do you mean? |
| # |
Jul 10th 2018, 10:21 |
james.phillips |
does the ES plugin return a list of matching Ids? |
| # |
Jul 10th 2018, 10:20 |
james.phillips |
thanks Josbier I will try get some time booked in to do it.. very helpful to get a rough time line cheers |
| # |
Jul 10th 2018, 10:20 |
josbeir |
ecommerce platform |
| # |
Jul 10th 2018, 10:20 |
josbeir |
medium sized project |
| # |
Jul 10th 2018, 10:20 |
josbeir |
i did a migration a few weeks ago from 3.5 to 3.6 and it took me less then a day to get it production ready |
| # |
Jul 10th 2018, 10:20 |
james.phillips |
I can keep my existing codebase and then for keyword searches search against ES? |
| # |
Jul 10th 2018, 10:18 |
james.phillips |
in thery thou using https://github.com/cakephp/elastic-search is easy rite? I can do what i need? |
| # |
Jul 10th 2018, 10:18 |
Martin` |
I still need to do that :P |
| # |
Jul 10th 2018, 10:17 |
james.phillips |
thanks all |
| # |
Jul 10th 2018, 10:17 |
james.phillips |
nothing is ever easy... |
| # |
Jul 10th 2018, 10:17 |
james.phillips |
cheers |
| # |
Jul 10th 2018, 10:17 |
james.phillips |
unfortunally not.. I will look at https://book.cakephp.org/3.0/en/appendices/3-6-migration-guide.html |
| # |
Jul 10th 2018, 10:16 |
lorenzo |
no, it will take you more than that. Unless you are just starting with your roject |
| # |
Jul 10th 2018, 10:16 |
james.phillips |
is updating 3.5 to 3.6 a five min job? |
| # |
Jul 10th 2018, 10:14 |
james.phillips |
I agree stupid there time to do some afterwards but not before....Guess I will suggest two options.... |
| # |
Jul 10th 2018, 10:14 |
josbeir |
:rocket: @lorenzo |
| # |
Jul 10th 2018, 10:14 |
lorenzo |
@josbeir added to the readme |
| # |
Jul 10th 2018, 10:13 |
Martin` |
Hmm I've a tree, I created an index with just sorting tree bij de lft, and making a nice tree, but now I have a problem with the search plugin. I want to always show all folders. how can I do this? I already tried adding ->orWhere(['folder' => 1]) to the query, but then it only finds folders :( |
| # |
Jul 10th 2018, 10:13 |
josbeir |
randd on such things should be a bigger part of the budget then ;) |