Hacker GitHub

← All repos

aaemnnosttv/wp-sqlite-db

View on GitHub ↗ ★ 585 PHP

A single file drop-in for using a SQLite database with WordPress. Based on the original SQLite Integration plugin.

12 mentions on Hacker News by 10 people: 1 story, 11 comments · first 2021-03-25 · latest 2026-07-15

Mentions per year 12 mentions · busiest year 2022 (9)
20082026
AllStoriesComments NewestTopOldest
  1. Before they added SQLite as WP plugin, I would use https://github.com/aaemnnosttv/wp-sqlite-db/ and I would use `define('DB_DIR', '/absolute/custom/path/to/directory/for/sqlite/database/file/');` to define the database location of my…
    comment by stefanos82 · 2023-07-26 · in WordPress Core to start using SQLite
  2. …that it'll use PHP's sqlite3 extension. Edit: confirmed, it uses PHP's built-in PDO SQlite3 driver: https://github.com/aaemnnosttv/wp-sqlite-db/blob/master/src/...
    comment by notRobot · 2022-12-20 · in WordPress to support SQLite back end
  3. They basically took this implementation and just adapted it to coding standards: https://github.com/aaemnnosttv/wp-sqlite-db This has been around since some time and is itself a fork of a previous work. The interesting part is that this…
    comment by achairapart · 2022-12-20 · in WordPress to support SQLite back end
  4. This sqlite abstraction has been working well for me: https://github.com/aaemnnosttv/wp-sqlite-db it’s one file — ‘db.php’ — you swap in for the core file. From there, it’s mostly been seamless. ~20% of the 5k LOC, is “ Method to emulate…
    comment by smcnally · 2022-12-17 · in WordPress testing official SQLite Support
  5. …allows you to modify it in the current tab, but the updates are never saved back to the server. [0] https://github.com/aaemnnosttv/wp-sqlite-db
    comment by adamziel · 2022-09-26 · in WordPress WASM
  6. …1. Plugins that register their own database tables (however there already exists prior art such as https://github.com/aaemnnosttv/wp-sqlite-db for handling these cases) 2. Plugins that do direct queries against the standard database schema…
    comment by zapt02 · 2022-09-12 · in Let’s make WordPress officially support SQLite
  7. …they run regular expressions against the SQL to convert it from MySQL dialect to SQLite! https://github.com/aaemnnosttv/wp-sqlite-db/blob/9a5604cce13... I'm amazed that this works, but apparently it works really well. I would expect it to…
    comment by simonw · 2022-06-28 · in SQLite or PostgreSQL? It's Complicated
  8. …is a bit misleading. It's really just a Wordpress install with this plugin preconfigured: https://github.com/aaemnnosttv/wp-sqlite-db That plugin is where the interesting stuff happens.
    comment by simonw · 2022-05-16 · in Wp-SQLite: WordPress running on an SQLite database
  9. …which uses regular expressions to rewrite the MySQL SQL queries for compatibility with SQLite! https://github.com/aaemnnosttv/wp-sqlite-db/blob/14f9e917c55...
    comment by simonw · 2022-05-16 · in Wp-SQLite: WordPress running on an SQLite database
  10. There's an existing WP "drop-in" plugin that can be used with Composer: https://github.com/aaemnnosttv/wp-sqlite-db Using that + a WP composer package (like https://packagist.org/packages/roots/wordpress ) is much easier to maintain that a…
    comment by bretthopper · 2022-05-16 · in Wp-SQLite: WordPress running on an SQLite database
  11. …database. Edit: A single file fork (albeit 5k lines of PHP) of the plugin that looks interesting: https://github.com/aaemnnosttv/wp-sqlite-db
    comment by tyingq · 2021-03-25 · in SQLite is not a toy database