is it possible implement php session handler with arangodb

Question

I 'v posted my question some days ago in the official arangodb website , but no lucks no people answer it . so i come to here . below is my question:

just want to know if use arangoDb as a php sessionHandler , how can i delete the session data that expired !

if use the mogodb or mysql to store the session data, we can use such statement to remove the expired data: db.session.remove( { expire: { $gt :} } ) or the sql : delete from tbl_session where expire<:expire

I just want to know how this can be implemented in arangodb . :)

Where did you originally post the question? Can you send us a link, so we can find out why we did not get a notification. The official forum is at groups.google.com/forum/#!forum/arangodb the issue tracker at github.com/triAGENS/ArangoDB/issues?state=open — fceller
– fceller, Commented Feb 24, 2014 at 8:39
may be i posted in a wrong place (it will be better there have an irc channel for discussing arangoDb , do you have any plan this?) : arangodb.org/2013/03/15/… — yiqing
– yiqing, Commented Feb 28, 2014 at 9:21

mchacki · Accepted Answer · 2014-02-24 08:53:39Z

3

We do not yet support modifying AQLs. So you need to execute a bit of code:

var q = db._query("FOR s in session filter s.expire < 1393231738788 return s");
while (q.hasNext()) {
  db.session.remove(q.next());
}

answered Feb 24, 2014 at 8:53

mchacki

3,26716 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

13abylon · Accepted Answer · 2015-04-10 14:18:34Z

1

mchacki's answer is correct till ArangoDB 2.2.

Since 2.2 we do have modified queries so the new query for our Database would look like this:

FOR s IN sessions
  FILTER s.expire < DATE_NOW()-86400000
  REMOVE s IN sessions

With this example one day old sessions would be deleted.

answered Apr 10, 2015 at 14:18

13abylon

5502 silver badges13 bronze badges

Collectives™ on Stack Overflow

is it possible implement php session handler with arangodb

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related