Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:latest:browseablesessionbackend [2019/06/11 19:17]
maxbes [Prepare database]
documentation:latest:browseablesessionbackend [2019/06/28 14:32] (current)
Line 60: Line 60:
       ipAddr text       ipAddr text
   );   );
-  CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace);​+  CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace ​text_pattern_ops);
   CREATE INDEX s1   ON sessions (_session_kind);​   CREATE INDEX s1   ON sessions (_session_kind);​
   CREATE INDEX u1   ON sessions (_utime);   CREATE INDEX u1   ON sessions (_utime);
Line 78: Line 78:
 ^  Required parameters ​ ^^^ ^  Required parameters ​ ^^^
 ^  Name  ^  Comment ​ ^  Example ​ ^ ^  Name  ^  Comment ​ ^  Example ​ ^
-|  **DataSource** ​ | The [[https://​metacpan.org/​pod/​DBI|DBI]] string | dbi:​Pg:​database=sessions ​|+|  **DataSource** ​ | The [[https://​metacpan.org/​pod/​DBI|DBI]] string | dbi:​Pg:​database=lemonldap-ng ​|
 |  **UserName** ​ | The database username | lemonldapng | |  **UserName** ​ | The database username | lemonldapng |
 |  **Password** ​ | The database password | mysuperpassword | |  **Password** ​ | The database password | mysuperpassword |
 |  **Index** ​ | Index | _whatToTrace ipAddr _session_kind _utime _httpSessionType | |  **Index** ​ | Index | _whatToTrace ipAddr _session_kind _utime _httpSessionType |
 +|  **TableName** ​ | Table name (optional) | sessions |
  
 <note tip>​Apache::​Session::​Browseable::​MySQL doesn'​t use locks so performances are keeped. <note tip>​Apache::​Session::​Browseable::​MySQL doesn'​t use locks so performances are keeped.
Line 125: Line 126:
       _session_kind text,       _session_kind text,
       _utime bigint,       _utime bigint,
-      ​user text, +      ​_httpSessionType ​text, 
-      ipAddr ​varchar(64)+      ipAddr ​text
   );   );
   CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops);​   CREATE INDEX uid1 ON sessions USING BTREE (_whatToTrace text_pattern_ops);​
-  CREATE INDEX _s1 ON sessions (_session_kind);​ +  CREATE INDEX s1   ON sessions (_session_kind);​ 
-  CREATE INDEX _u1 ON sessions (_utime); +  CREATE INDEX u1   ON sessions (_utime); 
-  CREATE INDEX ip1 ON sessions USING BTREE (ipAddr)+  CREATE INDEX ip1  ON sessions USING BTREE (ipAddr)
 +  CREATE INDEX h1   ON sessions (_httpSessionType);​
  
 **Browseable::​MySQL**:​ **Browseable::​MySQL**:​