| # |
Apr 1st 2019, 11:17 |
 berarma |
Mmmm, I'l look up what that means. |
| # |
Apr 1st 2019, 11:17 |
berarma |
Ok, so it would be best to use the string as index. |
| # |
Apr 1st 2019, 11:17 |
dereuromark |
if you set up the index correctly |
| # |
Apr 1st 2019, 11:16 |
dereuromark |
they optimize the lookup through their own index, faster than most other things you could come up with |
| # |
Apr 1st 2019, 11:15 |
berarma |
So they already use a hash for string indexes? |
| # |
Apr 1st 2019, 11:13 |
dereuromark |
again: thats what DBs do with indexes |
| # |
Apr 1st 2019, 11:11 |
berarma |
Strings don't have a natural primary key. They are just strings. So denormalizing would mean looking for the string, in my case I preferred an integer hash. |
| # |
Apr 1st 2019, 11:08 |
dereuromark |
what you are doing indeed doesnt seem to make sense |
| # |
Apr 1st 2019, 11:07 |
dereuromark |
usually people would normalize and leverage the primary key aiid. |
| # |
Apr 1st 2019, 11:07 |
slackebot2 |
<neon1024> |
| # |
Apr 1st 2019, 11:06 |
berarma |
It's really simple instead. Not something I'd like to do if it wasn't because I have to store a large number of strings and a lot of them are duplicated. So tables would be growing really fast forever if I don't deduplicate the strings. |
| # |
Apr 1st 2019, 11:04 |
neon1024 |
What is the purpose of this hash? |
| # |
Apr 1st 2019, 11:04 |
neon1024 |
This all sounds incredibly overengineered |
| # |
Apr 1st 2019, 10:59 |
dereuromark |
why not letting the DB handle this using real indexes? |
| # |
Apr 1st 2019, 10:57 |
berarma |
I do a select to get the rows with the hash, then check all the results for the one that is the same string. I can't see anything wrong there. I don't think the === could fail if the string is in the results and the hash is the same. And I don't know why the select might not return the existing hashes. |
| # |
Apr 1st 2019, 10:55 |
berarma |
It's a non-primary key. I'm checking for collisions and that wouldn't duplicate strings, it would cause other problems though. |
| # |
Apr 1st 2019, 10:47 |
neon1024 |
Is this hash set as the primary key of the entity? |
| # |
Apr 1st 2019, 10:45 |
dereuromark |
a hash is often not collision free |
| # |
Apr 1st 2019, 10:43 |
berarma |
Hi. I use a table with strings to avoid duplication of data. The strings are stored with an integer hash value to Query them faster. I add new rows to this table from the beforeSave of some models. First I look for the hash of the new string in the table, if it doesn't exist I add it to the table. In some cases I'm creating rows for strings that are already in the table with the same hash. Do you know what could be happening? |
| # |
Apr 1st 2019, 10:35 |
patox44 |
I fixed my problem |
| # |
Apr 1st 2019, 09:55 |
birdy247 |
morning @neon1024 |
| # |
Apr 1st 2019, 09:12 |
patox44 |
how can I false check ssl when I create new client? This one doesn't work: `$http = new Client(['ssl_verify_peer' => false]);`. I know isn't recommended, but I got test api where ssl not works |
| # |
Apr 1st 2019, 08:53 |
challgren |
Morning @neon1024 |
| # |
Apr 1st 2019, 08:51 |
neon1024 |
Morning all :wave: |
| # |
Apr 1st 2019, 08:22 |
roel |
Hello everyone, Currently I am using the Translate Behavior to save translations for my entities. When ever I save an entity which has no translations (yet), it will save that record with a `NULL` value in my "default" table and it will set the actual value in the translationsTable. I would like the value to be stored in the "default" table and only the translations in the translations table. Thanks in advance. |
| # |
Apr 1st 2019, 03:16 |
hola |
hola |
| # |
Mar 31st 2019, 20:47 |
challgren |
https://book.cakephp.org/3.0/en/plugins.html#loading-a-plugin |
| # |
Mar 31st 2019, 20:38 |
challgren |
Use this->addPlugin in you're application.php |
| # |
Mar 31st 2019, 20:21 |
abdualelah.mdy |
it shows Class 'Application' not found |
| # |
Mar 31st 2019, 20:20 |
abdualelah.mdy |
i am using Application::addPlugin('AdminLTE', ['bootstrap' => true, 'routes' => true]); |
| # |
Mar 31st 2019, 20:00 |
abdualelah.mdy |
no problem. anytime |
| # |
Mar 31st 2019, 19:59 |
adithya |
will do, thanks for the heads up! |
| # |
Mar 31st 2019, 19:57 |
abdualelah.mdy |
in your php file |
| # |
Mar 31st 2019, 19:57 |
abdualelah.mdy |
included this line |
| # |
Mar 31st 2019, 19:57 |
abdualelah.mdy |
use Cake\Auth\DefaultPasswordHasher; |
| # |
Mar 31st 2019, 19:56 |
adithya |
thank you, yes im hashing them :slightly_smiling_face: |
| # |
Mar 31st 2019, 19:55 |
abdualelah.mdy |
if((new DefaultPasswordHasher)->check(password from request,hashed password in table)){ |
| # |
Mar 31st 2019, 19:53 |
abdualelah.mdy |
Are you hashing them? |
| # |
Mar 31st 2019, 19:53 |
adithya |
I'm getting my email and password in an api, how do i check if they match? |
| # |
Mar 31st 2019, 19:53 |
abdualelah.mdy |
Property _transportConfig does not exist |
| # |
Mar 31st 2019, 19:52 |
abdualelah.mdy |
more problem unfortunately |