Web server Log file

[rebred]

We would like to know who visited each page and at what time (statistics). Is there a way to access this SQLpage server info or write it to a DB ?

[lovasoa]

Hi !

SQLPage write detailed access logs to stderr by default.

But if you need to compute statistics, and you do not have very high traffic, then I'd advise writing the info to your database.

CREATE TABLE page_visits (
    page varchar(255),
    variables JSONB,
    headers JSONB,
    ip_address INET,
    visited_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

tracker.sql

insert into page_visits
  (page, variables, headers, ip_address)
values
  (sqlpage.path(), sqlpage.variables('get'), sqlpage.headers(), sqlpage.client_ip());

then include it from other pages using https://sql-page.com/functions.sql?function=run%5Fsql

[rebred]

that's great I'll update the pages so I can write stats directly to the DB !!!!!

Are standard streams the messages appearing in the linux shell after SQLpage is lunched ?

they just appear if I launch it and leave the terminal open but I think they are not saved anywhere (or they are saved?)

[lovasoa]

Are standard streams the messages appearing in the linux shell after SQLpage is lunched ?

yes 👍

they just appear if I launch it and leave the terminal open but I think they are not saved anywhere (or they are saved?)

You can redirect them to a file: https://www.gnu.org/software/bash/manual/html_node/Redirections.html