lucianofedericopereira

lucianofedericopereira / mysqlite

Public

A MySQL wire protocol server backed by SQLite. Drop-in local development replacement for MySQL — your app connects on port 3306 as usual, all data is stored in a single SQLite file.

10
0
100% credibility
Found Mar 22, 2026 at 10 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Nim
AI Summary

mysqlite provides a lightweight local server that mimics MySQL behavior while storing all data in a single simple file, perfect for testing apps like WordPress without complex setups.

How It Works

1
🔍 Discover mysqlite

You learn about a clever tool that lets apps needing a database run easily on your computer using just one simple file.

2
📥 Get the tool

You download and prepare the tool on your computer with straightforward instructions.

3
⚙️ Set preferences

You choose where to store your data and pick a username, keeping everything simple and secure.

4
🚀 Launch the server

You start the tool, and it listens for connections just like a full database would.

5
🔗 Connect your app

Your website or program links up normally, with no changes needed on your end.

6
🌐 Run your project

You test a full site like WordPress, and it works perfectly from that one file.

🎉 Success!

Now you develop and play with your apps super easily, fast, and without headaches.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 10 to 10 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is mysqlite?

mysqlite is a MySQL wire protocol server powered by SQLite, letting your apps connect to port 3306 like normal while storing everything in a single SQLite file. Built in Nim, it translates MySQL queries on the fly, handling features like ON DUPLICATE KEY UPDATE, FULLTEXT indexes, and JSON functions—no daemon or Docker needed. It's a drop-in for local dev, with tools to export/import to SQL files or real MySQL servers.

Why is it gaining traction?

Unlike mysql github docker setups or heavy mysql github server installs, mysqlite runs as a lightweight binary with zero services, perfect for mysql github codespace or mysql github actions workflows. It supports real-world tests like full WordPress installs, plus SHOW commands and INFORMATION_SCHEMA views, making it snag devs ditching sqlite download hassles for mysql wire protocol compatibility. The CLI for config, verbose logging, and sqlite db browser-friendly single files hooks those avoiding mysql password wireshark debugging pains.

Who should use this?

Backend devs building mysql github projects like FiveM or SA-MP servers needing quick local MySQL swaps without sqlite data types mismatches. WordPress tinkerers or PHP mysqli users wanting sqlite studio simplicity for mysql github pages prototypes. Python sqlite fans prototyping mysql github source code before prod deployment.

Verdict

With 10 stars and 1.0% credibility score, it's early-stage but boasts solid docs, unit tests, and WordPress e2e validation—try for low-stakes local dev if Nim builds fit your stack. Skip for production or full MySQL fidelity.

(178 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.