PHPackages                             l0rb/monolog-pdo-handler - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. l0rb/monolog-pdo-handler

ActiveLibrary[Database & ORM](/categories/database)

l0rb/monolog-pdo-handler
========================

A handler for Monolog that stores data via PDO driver to Database

v0.8(4y ago)0859MITPHPPHP >=5.3.0

Since Dec 7Pushed 3y agoCompare

[ Source](https://github.com/l0rb/monolog-pdo-handler)[ Packagist](https://packagist.org/packages/l0rb/monolog-pdo-handler)[ Docs](https://github.com/KarelWintersky/monolog-pdo-handler)[ RSS](/packages/l0rb-monolog-pdo-handler/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (1)Dependencies (2)Versions (5)Used By (0)

monolog.KW-PDO-Handler
======================

[](#monologkw-pdo-handler)

PDO Handler for Monolog, which allows to store log messages in a MySQL Database via PDO handler.

Handler can log text messages to a specific table and creates the table automatically if it does not exist.

Installation
============

[](#installation)

`monolog.KW-PDO-Handler`` is available via composer. Just add the following line to your required section in composer.json and do a `php composer.phar update`.

```
"karelwintersky/monolog-pdo-handler": "^0.1.0"

```

or do

```
composer require karelwintersky/monolog-pdo-handler

```

Usage
=====

[](#usage)

Just use it as any other Monolog Handler, push it to the stack of your Monolog Logger instance. The Handler however needs some parameters:

- `$pdo` - PDO Instance of your database. Pass along the PDO instantiation of your database connection with your database selected.
- `$table` - The table name where the logs should be stored.
- `$additional_fields` - associative array of additional database fields definitions. All additional columns are created automatically and the fields can later be used in the extra context section of a record. See examples below. *Default is empty array*.
- `$additional_indexes` - associative array of additional database indexes definitions. *Default is empty array*
- `$level` - The minimum logging level at which this handler will be triggered. Must be any of standard Monolog logging levels (default: Logger::DEBUG)

Default fields at logging table
===============================

[](#default-fields-at-logging-table)

- `id` - defined as `BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY`;
- `ipv4` - defined as `int(10) unsigned DEFAULT NULL`, will contain client IPv4 or 127.0.0.1 for console scripts;
- `time` - defined as `TIMESTAMP`, will contain current timestamp;
- `level` - defined as `SMALLINT`, logging level;
- `channel` - defined as `VARCHAR(64)`, channel name,
- `message` - defined as `LONGTEXT`, message

Examples
========

[](#examples)

Given that $pdo is your database instance, you could use the class as follows:

```
//Import class
use Monolog\Logger;
use KarelWintersky\Monolog;

// Create log handler
// using table `log` with additional fields
// `filename`, `filesize`, `filetime`
// and index at field `filename`
// minimum logging level is INFO.

$log_handler = new KWPDOHandler($pdo_handler, 'log', [
    'filename'  =>  'VARCHAR(32)',
    'filesize'  =>  'BIGINT(20) DEFAULT NULL',
    'filetime'  =>  'DATETIME'
], [
    'filename'  =>  'CREATE INDEX filename on `%s` (`filename`) USING HASH',
], Logger::INFO);

// Create logger
$monologger = new \Monolog\Logger($monolog_channel);

// Set handler
$monologger->pushHandler($log_handler);

// Now you can use the logger, and further attach additional information
$monologger->notice("File information", [
    'filename'  =>  $data['filename'],
    'filesize'  =>  $data['filesize'],
    'filetime'  =>  $data['filetime']
]);
```

Note: SQLite does not support 'USING method' for indexes;

ToDo
====

[](#todo)

\[ \] Check and override default field definitions \[ \] Update readme : how to write custom indexes \[ \] Update readme : about SQLite. \[ \] Implement default indexes for PostgreSQL

License
=======

[](#license)

This tool is free software and is distributed under the MIT license. Please have a look at the LICENSE file for further information.

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity51

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 72.2% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~538 days

Total

4

Last Release

1461d ago

PHP version history (2 changes)0.1PHP ^7.0

0.1.3PHP >=5.3.0

### Community

Maintainers

![](https://www.gravatar.com/avatar/7c5e3e8c3a0ab70f1c6b46036290195b81c109bd137758369dd7667fd46e879a?d=identicon)[lorb](/maintainers/lorb)

---

Top Contributors

[![KarelWintersky](https://avatars.githubusercontent.com/u/2164874?v=4)](https://github.com/KarelWintersky "KarelWintersky (13 commits)")[![l0rb](https://avatars.githubusercontent.com/u/4580051?v=4)](https://github.com/l0rb "l0rb (4 commits)")[![guru01](https://avatars.githubusercontent.com/u/5482410?v=4)](https://github.com/guru01 "guru01 (1 commits)")

---

Tags

logloggingdatabasepdomonolog

### Embed Badge

![Health badge](/badges/l0rb-monolog-pdo-handler/health.svg)

```
[![Health](https://phpackages.com/badges/l0rb-monolog-pdo-handler/health.svg)](https://phpackages.com/packages/l0rb-monolog-pdo-handler)
```

###  Alternatives

[wazaari/monolog-mysql

A handler for Monolog that sends messages to MySQL

140884.1k6](/packages/wazaari-monolog-mysql)[karelwintersky/monolog-pdo-handler

A handler for Monolog that stores data via PDO driver to Database

109.0k1](/packages/karelwintersky-monolog-pdo-handler)[bradmkjr/monolog-wordpress

A handler for Monolog that sends messages to MySQL via WordPress Functions

2817.1k](/packages/bradmkjr-monolog-wordpress)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)