programster/pgsql-logger

A logger that logs to a PostgreSQL database and is compatible with PSR-3

1.0.0 2023-11-28 11:12 UTC

Requires

• php: >=8.1.0
• ext-pgsql: *
• programster/log: ^2.0
• psr/log: ^3.0
• ramsey/uuid: ^4.7

MIT

• Stuart Page

• log
• logging
• pgsql

README

A PSR-3 logger for logging to a PostgreSQL database in PHP.

Installation

composer require programster/pgsql-logger

Example Usage

# Connect to your database
$pgsqlConn = pg_connect($connectionString);

# Create the logger using your Pgsql connection.
$logger = new \Programster\PgsqlLogger\PgSqlLogger($pgsqlConn);

# Create some logs using the standard PSR-3 interface
$logger->debug("This is an info log");
$logger->notice("This is a notice log", ['name' => 'value']);
$logger->info("This is an info log", ['name' => 'value']);
$logger->warning("This is a warning log", ['name' => 'value']);
$logger->alert("This is an alert log", ['name' => 'value']);
$logger->emergency("This is an emergency log", ['name' => 'value']);
$logger->critical("This is a critical log", ['name' => 'value']);
$logger->log(\Psr\Log\LogLevel::WARNING, "This is another warning log", ['name' => 'value']);

Testing

Spin up a test database using the docker-compose.yml file, before running the main.php script that will test connecting to the database and creating some logs.