PHPackages                             karelwintersky/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. karelwintersky/monolog-pdo-handler

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

karelwintersky/monolog-pdo-handler
==================================

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

0.7(1y ago)109.0k↓27.8%5[2 issues](https://github.com/KarelWintersky/monolog-pdo-handler/issues)1MITPHPPHP >=7.1

Since Dec 7Pushed 1y ago2 watchersCompare

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

READMEChangelog (8)Dependencies (1)Versions (9)Used By (1)

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)

`karelwintersky/monolog-pdo-handler` is available via composer.

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

```

Minimum PHP version is 7.1

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\KWPDOHandler;

// 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

37

—

LowBetter than 83% of packages

Maintenance36

Infrequent updates — may be unmaintained

Popularity32

Limited adoption so far

Community18

Small or concentrated contributor base

Maturity53

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 82.6% 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 ~353 days

Recently: every ~429 days

Total

8

Last Release

606d ago

PHP version history (3 changes)0.1PHP ^7.0

0.1.3PHP >=5.3.0

0.4PHP >=7.1

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/2164874?v=4)[Karel Wintersky](/maintainers/KarelWintersky)[@KarelWintersky](https://github.com/KarelWintersky)

---

Top Contributors

[![KarelWintersky](https://avatars.githubusercontent.com/u/2164874?v=4)](https://github.com/KarelWintersky "KarelWintersky (19 commits)")[![guru01](https://avatars.githubusercontent.com/u/5482410?v=4)](https://github.com/guru01 "guru01 (1 commits)")[![jharder](https://avatars.githubusercontent.com/u/76728?v=4)](https://github.com/jharder "jharder (1 commits)")[![petroutassos](https://avatars.githubusercontent.com/u/31442651?v=4)](https://github.com/petroutassos "petroutassos (1 commits)")[![stevevance](https://avatars.githubusercontent.com/u/1330459?v=4)](https://github.com/stevevance "stevevance (1 commits)")

---

Tags

databaselogginglogloggingdatabasepdomonolog

### Embed Badge

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

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

###  Alternatives

[wazaari/monolog-mysql

A handler for Monolog that sends messages to MySQL

140884.1k6](/packages/wazaari-monolog-mysql)[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)