wp-sqlite-db

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

Wp-sqlite-db Alternatives

Similar projects and alternatives to wp-sqlite-db

  1. litestream

    Streaming replication for SQLite.

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. SQLAlchemy

    The Database Toolkit for Python

  4. slonik

    73 wp-sqlite-db VS slonik

    A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.

  5. spec

    The canonical spec for ulid

  6. bedrock

    WordPress boilerplate with Composer, easier configuration, and an improved folder structure

  7. marmot

    A distributed SQLite replicator built on top of NATS

  8. wordpress-playground

    Run WordPress in the browser via WebAssembly PHP

  9. Nutrient

    Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers. Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.

    Nutrient logo
  10. wordpress-seo

    Yoast SEO for WordPress

  11. wp2static

    WordPress static site generator for security, performance and cost benefits

  12. sql.js-httpvfs

    Hosting read-only SQLite databases on static file hosters like Github Pages

  13. absurd-sql

    25 wp-sqlite-db VS absurd-sql

    sqlite3 in ur indexeddb (hopefully a better backend soon)

  14. jetpack

    Security, performance, marketing, and design tools — Jetpack is made by WordPress experts to make WP sites safer and faster, and help you grow your traffic.

  15. trellis

    WordPress LEMP stack with PHP 8.2, Composer, WP-CLI and more (by roots)

  16. performance

    Performance plugin from the WordPress Performance Group, which is a collection of standalone performance modules. (by WordPress)

  17. wapm-cli

    Discontinued 📦 WebAssembly Package Manager (CLI)

  18. wp-sqlite

    WordPress running on an SQLite database

  19. core

    All of the required core code (by berlindb)

  20. simonwillisonblog-backup

    Backups of the database for simonwillison.net

  21. WordPress

    WordPress, Git-ified. This repository is just a mirror of the WordPress subversion repository. Please do not send pull requests. Submit pull requests to https://github.com/WordPress/wordpress-develop and patches to https://core.trac.wordpress.org/ instead.

  22. parser

    A MySQL Compatible SQL Parser (by pingcap)

  23. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better wp-sqlite-db alternative or higher similarity.

wp-sqlite-db discussion

Log in or Post with

wp-sqlite-db reviews and mentions

Posts with mentions or reviews of wp-sqlite-db. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-07-26.
  • WordPress Core to start using SQLite Database
    5 projects | news.ycombinator.com | 26 Jul 2023
    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 choice; I believe they would let users do the same with core support.
  • WordPress to support SQLite back end
    3 projects | news.ycombinator.com | 20 Dec 2022
    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 drop-in replacement (mostly) already works well, there are a few issues that are related to some quirks in the WordPress core itself, for example: https://github.com/aaemnnosttv/wp-sqlite-db/issues/18

    And maybe now they will be fixed.

  • WordPress testing official SQLite Support
    5 projects | news.ycombinator.com | 16 Dec 2022
  • WordPress WASM
    6 projects | news.ycombinator.com | 24 Sep 2022
    Author here, here's an in-depth writeup on how this works and why it's useful:

    https://make.wordpress.org/core/2022/09/23/client-side-webas...

    To answer your questions directly:

    WebAssembly is the magic sauce that transforms server-side code into client-side code. MySQL unfortunately is not yet supported by WebAssembly, so I applied a plugin that adds SQLite supports to WordPress [0]. The WebAssembly application has its own in-memory filesystem that lives in a specific browser tab and is scraped as soon as you close it.

    So – technically it exposes db credentials, and even the entire DB, but that you are the only user of that DB so it's okay.

    > What would the backend look like

    The only backend is a static file server where the code and the database live. Your browser downloads a copy of the database and 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

  • A proposal to officially support SQLite in WordPress
    3 projects | news.ycombinator.com | 12 Sep 2022
    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 (broadly either for invalid (bad code) or performance (valid but slim use case) reasons)

    Also, WordPress would of course keep the old query functions around and they would likely add a tag to the plugin repository so authors can mark plugins as supporting thes new ORM features.

    Great idea in my opinion!

  • SQLite or PostgreSQL? It's Complicated
    5 projects | news.ycombinator.com | 28 Jun 2022
    There's a WordPress plugin that adds support for SQLite as an alternative to MySQL.

    Apparently it works really well. The implementation is (to my) simply astonishing: they run regular expressions against the SQL to convert it from MySQL dialect to SQLite! https://github.com/aaemnnosttv/wp-sqlite-db/blob/9a5604cce13...

  • Wp-SQLite: WordPress running on an SQLite database
    9 projects | news.ycombinator.com | 16 May 2022
  • Lots of blocked attacks and probes..should I worry..
    5 projects | /r/Wordpress | 19 May 2021
    This wp-sqlite-db one. Not super active, but maintained, at least.
  • A note from our sponsor - CodeRabbit
    coderabbit.ai | 15 Mar 2025
    Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR. Learn more →

Stats

Basic wp-sqlite-db repo stats
10
573
3.1
8 months ago

Sponsored
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai