| # |
May 29th 2017, 13:06 |
HenriqueMachado |
Hello! What is wrog with my models? When i trie to save a "follow" a new user is added: https://pastebin.com/nvQzch2G |
| # |
May 29th 2017, 12:59 |
hmic |
thats the whole point of database sessions after all (well, you can have a simple *small* loadbalancer setup with multiple frontend webservers and a central (session) database too, but it's not a good thing to scale out further and usually not fast anyways. still you would keep the sessiondatabase server separated from your application database server in this kind of setup) |
| # |
May 29th 2017, 12:57 |
hmic |
all the data will be loaded from the database at each and every request! |
| # |
May 29th 2017, 12:57 |
hmic |
chris-andre: with database sessions you do not need to care at all! |
| # |
May 29th 2017, 12:55 |
slackebot |
bad approach? :P So, how would I flag it, and how shall I look for that flag? |
| # |
May 29th 2017, 12:55 |
 chris-andre |
But okay. So critical data should be updated. Admin need to "find the session" of the logged in user if he's logged in, right? To do that I will need a join table. And to let the currently logged in user "know" that critical updates are made by admin, I have to flag it some way, and I thought SessionsUsers.flag_update (bool) could do that. And again, to make sure I don't miss that flag, I will have to query that table upon every request. |
| # |
May 29th 2017, 12:50 |
TVSET |
the print_r prints an empty array ... any idea on what I'm doing wrong? |
| # |
May 29th 2017, 12:50 |
chris-andre |
So if an admin changes a users first_name, you would care about updating. Thats not critical and can wait until next login. |
| # |
May 29th 2017, 12:50 |
TVSET |
I have a weird issue with CakePHP 3 Hash ... here's the pastebin: https://pastebin.com/RkZpyKqj |
| # |
May 29th 2017, 12:49 |
TVSET |
hello :) |
| # |
May 29th 2017, 12:49 |
inoas |
just put them on an SSD :p |
| # |
May 29th 2017, 12:49 |
chris-andre |
I use db sessions. |
| # |
May 29th 2017, 12:48 |
inoas |
if you need to query the database anyway, database sessions ftw |
| # |
May 29th 2017, 12:48 |
hmic |
if you use database sessions, it's just that. no need to care or worry |
| # |
May 29th 2017, 12:48 |
inoas |
if that is not ciritical, not updateing saves queries |
| # |
May 29th 2017, 12:48 |
inoas |
if it is critical that for instance is_active or is_admin are always up to date, then yes |
| # |
May 29th 2017, 12:47 |
inoas |
depends |
| # |
May 29th 2017, 12:47 |
chris-andre |
Okay. One thing first then: Do you agree that session data should match the current user data in db? |
| # |
May 29th 2017, 12:45 |
hmic |
point beeing: he should rather trigger an event to reload database data into the session, or go with database sessions from the start, which solves the problem in one go. i'd prefer memcache over sql sessions still, easy to invalidate on update and repopulate and way better suited for the task |
| # |
May 29th 2017, 12:45 |
chris-andre |
Hmm.. Brain is boiling now :P |
| # |
May 29th 2017, 12:44 |
dereuromark |
as long as it is safe ;) |
| # |
May 29th 2017, 12:44 |
hmic |
:p |
| # |
May 29th 2017, 12:44 |
dereuromark |
who are we to judge |
| # |
May 29th 2017, 12:43 |
hmic |
still, its a bad idea to do so. |
| # |
May 29th 2017, 12:43 |
dereuromark |
maybe he doesnt have to :slightly_smiling_face: |
| # |
May 29th 2017, 12:43 |
hmic |
you will not be able to scale *at all* with this approach |
| # |
May 29th 2017, 12:43 |
hmic |
chris-andre: this is a bad idea. very bad! |
| # |
May 29th 2017, 12:43 |
chris-andre |
I'm going back to the "original idea", using join table. The purpose is that the user sessions always shall be updated with currently saved data in database. |
| # |
May 29th 2017, 12:41 |
chris-andre |
Right. I will always take his advice ;) |
| # |
May 29th 2017, 12:41 |
inoas |
maybe there is something that fits your bill already - or something you can learn from |
| # |
May 29th 2017, 12:40 |
inoas |
also take a look at awesome cakephp |
| # |
May 29th 2017, 12:40 |
inoas |
just create real foreign key constraints and a join table if necessary |
| # |
May 29th 2017, 12:40 |
inoas |
and can use the cakephp database backed sessions |
| # |
May 29th 2017, 12:40 |
inoas |
if you do not need anything particular about sessions |
| # |
May 29th 2017, 12:40 |
inoas |
I think dereuromark is spot on |
| # |
May 29th 2017, 12:36 |
chris-andre |
So far, when logging in, I use a component to create a record in sessions_users. Beforefilter, in appController I use `$this->UpdateAuth->checkFlag()`. Seems ok? |
| # |
May 29th 2017, 12:35 |
chris-andre |
I will continue working on what you said yesterday. |
| # |
May 29th 2017, 12:34 |
chris-andre |
Allright. Get it. |
| # |
May 29th 2017, 12:34 |
dereuromark |
well, you are starting to hack ugly things now when trying to parse that string and alike. it will only poke holes into everything on the lower levels, not sure thats worth it |
| # |
May 29th 2017, 12:33 |
chris-andre |
Right @dereuromark I have already been working on it with a sessions_users table. But I thought I could rather have a custom handler. But you say No? If so, I'll take your advice. |
| # |
May 29th 2017, 12:31 |
dereuromark |
I was telling you about a pivot table the other day, to make the matching between session and user, by not touching the session handling more then necessary |