| # |
Jan 7th 2020, 20:14 |
 ricksaccous |
I think in your options you can set an alternative field to have the hashid rather than the id field itself |
| # |
Jan 7th 2020, 20:13 |
jslamka5685 |
When I am trying to add a FK condition on a pagination query, the associated keys are being returned as hashids. This is causing an issue as the FK field is int but the hashids are not int |
| # |
Jan 7th 2020, 20:12 |
jslamka5685 |
I figured they should be only be for display/hiding internal IDs |
| # |
Jan 7th 2020, 20:10 |
ricksaccous |
i didn't really bother to benchmark it |
| # |
Jan 7th 2020, 20:10 |
ricksaccous |
so they are only hit in an api request rather than a page load and my test data is so small i'm not sure |
| # |
Jan 7th 2020, 20:09 |
ricksaccous |
i use them as an alternative identifier |
| # |
Jan 7th 2020, 20:09 |
ricksaccous |
i don't use them in the traditional sense |
| # |
Jan 7th 2020, 20:09 |
admad |
hashids shouldn't be used for anything expect URLs / display purpose |
| # |
Jan 7th 2020, 20:08 |
jslamka5685 |
Also, are you FK storing the original PK value or does it store the hashed id? |
| # |
Jan 7th 2020, 20:06 |
jslamka5685 |
do you feel the hashid is adding overhead to page loads? |
| # |
Jan 7th 2020, 20:06 |
jslamka5685 |
I imagine UUID being a much longer string has to take more time |
| # |
Jan 7th 2020, 20:06 |
ricksaccous |
I think there might be an option to though? |
| # |
Jan 7th 2020, 20:06 |
ricksaccous |
and no you don't store the hash_id in the db |
| # |
Jan 7th 2020, 20:06 |
ricksaccous |
i'm not sure how it compares speed-wise to uuid |
| # |
Jan 7th 2020, 20:06 |
jslamka5685 |
Do you store the hash_id in the DB? |
| # |
Jan 7th 2020, 20:05 |
ricksaccous |
before i had to deal* |
| # |
Jan 7th 2020, 20:05 |
ricksaccous |
i used it because i was facing a limit of 16 characters for a reference and wanted millions more possible records in before i deal with the limitation |
| # |
Jan 7th 2020, 20:04 |
jslamka5685 |
I was planning to use UUID but after reading, it seems the overhead on queries once the DB grows is a huge downside of UUID. I was thinking of switching the PK over INT(11) and then using the cakephp-hashid as well |
| # |
Jan 7th 2020, 20:03 |
ricksaccous |
yeah i do |
| # |
Jan 7th 2020, 20:02 |
jslamka5685 |
Anyone have experience using the cakephp-hashid plugin? |
| # |
Jan 7th 2020, 19:48 |
admad |
x) |
| # |
Jan 7th 2020, 19:41 |
ndm |
@admad It's *Eichhörnchen*, but quite obviously, that Hörnchen right there is pretty gangster! |
| # |
Jan 7th 2020, 19:39 |
challgren |
Could MR plugin write a plugin to check the composer file? |
| # |
Jan 7th 2020, 19:39 |
challgren |
Bah!! |
| # |
Jan 7th 2020, 19:38 |
admad |
@challgren so make a PR. I ain't going go about checking every package listed there to see if they made a cake 4 compatible release :) |
| # |
Jan 7th 2020, 19:37 |
admad |
the german word for squirrel is gangsterhörnchen? |
| # |
Jan 7th 2020, 19:17 |
ndm |
oh well, guess slack fake localizes it, now it's only 20% funny |
| # |
Jan 7th 2020, 19:15 |
ricksaccous |
i see squirrel as well |
| # |
Jan 7th 2020, 19:15 |
ndm |
double disappointment |
| # |
Jan 7th 2020, 19:14 |
this.impetus |
(and I just see squirrel) |
| # |
Jan 7th 2020, 19:14 |
this.impetus |
uhh sorry guy phone's ringing I'll get back to you :P |
| # |
Jan 7th 2020, 19:13 |
ndm |
OMG, is that emoji called *gangsterhörnchen* for everyone else too? :D |
| # |
Jan 7th 2020, 19:12 |
ndm |
Well, I could write you an invoice if that would make you feel better :squirrel: |
| # |
Jan 7th 2020, 19:07 |
this.impetus |
and they pay me for this loloolololol |
| # |
Jan 7th 2020, 19:06 |
this.impetus |
..... I had an extra bracket in name attribute on the field.... :( |
| # |
Jan 7th 2020, 19:05 |
ndm |
I was about to say you were missing `'id' => xyz`? |
| # |
Jan 7th 2020, 19:04 |
this.impetus |
thanks ndm, the thing about understanding so little about what's under the hood in cake is that I often don't know where to look for the problem, but we got there lol. cheers! |
| # |
Jan 7th 2020, 19:03 |
this.impetus |
*got it |
| # |
Jan 7th 2020, 19:03 |
slackebot |
!!!! got |
| # |
Jan 7th 2020, 19:03 |
slackebot |
Command sent from Slack by this.impetus: |
| # |
Jan 7th 2020, 19:00 |
this.impetus |
Because there are literally hundreds of Authors, I'm generating the form inputs from a JS script as they're selected, rather than creating n-hundred x 4 fields that 99% of which would go unused |