php session using atk4 data handler

3.1.0 2022-01-29 10:27 UTC


License Maintainability Maintainability Technical Debt Test Coverage PHP version

Session handler for Atk4\Data (@see


composer require abbadon1334/atk4-session

Initialize without atk4\ui

// autoload
include '../vendor/autoload.php';

// create pesistence
$db = \Atk4\data\Persistence::connect('mysql://root:password@localhost/atk4');

// init session handler
new \Atk4\ATK4DBSession\SessionHandler($p, [/* session options */]);

Create session table using atk4\schema

(new \Atk4\Data\Schema\Migrator(new \atk4\ATK4DBSession\SessionModel($p)))->create();


Create session table with SQL query

CREATE TABLE `session` (
  `id` bigint() NOT NULL AUTO_INCREMENT,
  `session_id` varbinary(255) DEFAULT NULL,
  `data` blob,
  `created_on` datetime(6) NULL DEFAULT NULL,
  `updated_on` datetime(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `session_id` (`session_id`)

Session GC

if you use InnoDB deletes are slow, so the best option for huge request application is to set a cronjob which run every 2 minutes, you can find an example in : demos/example/cronjob.example.php. When you instantiate the SessionHandler, if you use the crojob, set the gc_probability option to 0 to disable automatic triggering of gc.

Why i need to replace the default PHP Session Handler with this?

Because of file locking ( here a good article about the argument link)

Every call that use sessions read a file and set a lock on it until release or output, to prevent race conditions.

It's clearly a shame to have file locking on things that are usually static, like nowadays sessions.

Using an alternative you'll have for sure race conditions, BUT what race condition can be if you, usually, have only an ID in $_SESSION and that is nearly immutable from login to logout.

SessionHandler will substitute SessionHandler class in PHP and will store session data in database using atk4\data instead of using files.

In atk4\ui where async calls are massively used, this problem is much more evident.

You can add it without breaking your project, it already works, but is still in development and need a strong review for security issue.