PHPackages                             shiyan/file-to-sqlite - 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. shiyan/file-to-sqlite

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

shiyan/file-to-sqlite
=====================

Copies data from a file to an SQLite database using regular expressions.

0.4.0(8y ago)051MITPHPPHP ^7.1

Since Mar 16Pushed 8y ago1 watchersCompare

[ Source](https://github.com/mikeshiyan/file-to-sqlite)[ Packagist](https://packagist.org/packages/shiyan/file-to-sqlite)[ RSS](/packages/shiyan-file-to-sqlite/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependencies (5)Versions (5)Used By (0)

File to SQLite
==============

[](#file-to-sqlite)

A command-line utility for copying data from a file to an SQLite database file using regular expressions.

Perfect for converting automatic log files, reports, etc.

Requirements
------------

[](#requirements)

- PHP ≥ 7.1
- [Composer](https://getcomposer.org)

Installation
------------

[](#installation)

```
composer global require --optimize-autoloader shiyan/file-to-sqlite

```

Make sure that the `COMPOSER_HOME/vendor/bin` dir is in your `PATH` env var. More info in the composer help: `composer global -h`

If you have the [CGR](https://github.com/consolidation/cgr) installed, then run the following command instead of the one above:

```
cgr -o shiyan/file-to-sqlite

```

Usage
-----

[](#usage)

```
file-to-sqlite [options] [--]

```

##### Arguments:

[](#arguments)

```
source                 Path to the source file.
destination            Path to the SQLite database file. If not exists, it will
                       be created.
pattern                Regular expression pattern with named subpatterns.

```

##### Options:

[](#options)

```
-t, --table=TABLE      Table name. By default, the source file name is used.
-i, --integer=INTEGER  List of integer fields. (multiple values allowed)
    --blob=BLOB        List of blob fields. (multiple values allowed)
    --real=REAL        List of real fields. (multiple values allowed)
    --numeric=NUMERIC  List of numeric fields. (multiple values allowed)
-p, --primary=PRIMARY  Primary key(s). (multiple values allowed)
-a, --append           If the table exists, this option allows to insert into it
                       anyway.

```

###  Health Score

23

—

LowBetter than 26% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity5

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity51

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% 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 ~9 days

Total

4

Last Release

3000d ago

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/3637657?v=4)[Mike Shiyan](/maintainers/mikeshiyan)[@mikeshiyan](https://github.com/mikeshiyan)

---

Top Contributors

[![mikeshiyan](https://avatars.githubusercontent.com/u/3637657?v=4)](https://github.com/mikeshiyan "mikeshiyan (1 commits)")

---

Tags

composerconsolefileoopphpregexsqlitephpconsolesqlitefileregexOOP

### Embed Badge

![Health badge](/badges/shiyan-file-to-sqlite/health.svg)

```
[![Health](https://phpackages.com/badges/shiyan-file-to-sqlite/health.svg)](https://phpackages.com/packages/shiyan-file-to-sqlite)
```

###  Alternatives

[friendsoftypo3/content-blocks

TYPO3 CMS Content Blocks - Content Types API | Define reusable components via YAML

103519.9k48](/packages/friendsoftypo3-content-blocks)[drupal/core

Drupal is an open source content management platform powering millions of websites and applications.

21866.0M1.7k](/packages/drupal-core)[rector/rector-src

Instant Upgrade and Automated Refactoring of any PHP code

136406.3k14](/packages/rector-rector-src)[ssch/typo3-rector

Instant fixes for your TYPO3 PHP code by using Rector.

2603.2M403](/packages/ssch-typo3-rector)[api-platform/openapi

Models to build and serialize an OpenAPI specification.

404.8M86](/packages/api-platform-openapi)[drupal/core-recommended

Locked core dependencies; require this project INSTEAD OF drupal/core.

6942.5M406](/packages/drupal-core-recommended)

PHPackages © 2026

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