Skip to content

Query a SQLite database as read-only over MySQL protocol

License

Notifications You must be signed in to change notification settings

metallkopf/mysqlite

Folders and files

NameName
Last commit message
Last commit date

Latest commit

82dbfa4 · Apr 9, 2020

History

25 Commits
Apr 9, 2020
Feb 15, 2020
Apr 9, 2020
Feb 15, 2020
Mar 5, 2020
Apr 9, 2020
Mar 5, 2020
Apr 9, 2020
Apr 9, 2020

Repository files navigation

MySQLite

MySQLite is an application that exposes a SQLite database as read-only over MySQL Protocol 4.1

WARNING: the server accepts all connections, there is not authentication method implemented, handle with care

Install

# From source
pipenv install git+https://github.com/metallkopf/mysqlite.git@master#egg=mysqlite

# Wheels
pipenv install https://github.com/metallkopf/mysqlite/releases/download/0.1.0/mysqlite-0.1.0-py3-none-any.whl

Run

pipenv run mysqlite --filename DATABASE.SQLITE

Usage

mysqlite --help
usage: mysqlite [--filename FILENAME] [--address ADDRESS] [--port PORT] [--debug] [--version] [--help]

optional arguments:
  --filename FILENAME  Path of the SQLite database
  --address ADDRESS    IP address to bind to (default: localhost)
  --port PORT          Port number to use for connections (default: 3306)
  --debug              Print packets payload (default: False)
  --version            Version information
  --help               This help

TODO (in no particular order)

  • improve command support
  • return more accurate data types
  • implement authentication?
  • multiples databases?

License

GPLv2

About

Query a SQLite database as read-only over MySQL protocol

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages