Module Spindle_postgres.Session

Sessions in a table of the application's database, for a server of more than one process (Spindle.Session).

(* the table, made by a migration of the application's own, is
   Spindle_postgres.Session.schema ~table:"sessions" *)
let sessions =
  Spindle.Session.create
    ~store:(Spindle_postgres.Session.store pool ~table:"sessions")
    ~idle:Mtime.Span.(14 * day)
    ~absolute:Mtime.Span.(90 * day)
    visit_json

The table is the application's, made by a migration of its own, since migrating is a step before the server starts and never the server's; its statements are statements, for Rowtype_postgres.verify beside the application's others. Each call borrows a connection of its own and gives it back: a session is data about a visit, not a row a handler's transaction must agree with, and a store is a record of functions over a digest, which has no connection to be handed. table is a constant written in source, and one that is no lowercase identifier raises Invalid_argument, since it is written into each statement. It is written there quoted, so a word SQL reserves -- user, order -- is a table's name like any other.