| # |
Jul 10th 2018, 10:34 |
 josbeir |
haven't done/need that |
| # |
Jul 10th 2018, 10:34 |
josbeir |
altho, you can query multiple ES indexes, i'm not sure how this would translate using php api's |
| # |
Jul 10th 2018, 10:34 |
james.phillips |
I get you..on one side the results need to be merge and on another part by resource type...so its 50-50 |
| # |
Jul 10th 2018, 10:33 |
josbeir |
for instance, when you have an autocomplete field and want to show results for all stuff by a keyword across all indexes you would need to execute 3 queries and join the results, then serve it to the user |
| # |
Jul 10th 2018, 10:32 |
josbeir |
your results would not be merged too |
| # |
Jul 10th 2018, 10:32 |
josbeir |
@james.phillips thats up to you but you would need to execute queries against all your indexes |
| # |
Jul 10th 2018, 10:32 |
neon1024 |
Ooh, I should check the test suite |
| # |
Jul 10th 2018, 10:31 |
neon1024 |
Loving the use of inheritDoc here, when the class has no inheritance :face_with_rolling_eyes: |
| # |
Jul 10th 2018, 10:31 |
neon1024 |
Soo what is the return type of `first()`? Especially if the collection is empty https://github.com/cakephp/collection/blob/master/CollectionTrait.php#L365-L374 |
| # |
Jul 10th 2018, 10:28 |
james.phillips |
where are u from? |
| # |
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 |