Enable SQLITE on new WordPress installation

  • Keffr3n

    (@keffr3n)


    8 months, 3 weeks ago

    Hello, one of the reasons this plugin exists is, from what i read, that a huge number of sites are just presentation/business sites with just a few pages and would be easier for those use cases not to deploy a complete f#ckin’ database management system (mysql/mariadb whatever).

    But… looks like we would still need mysql database to install wordpress and just later switch to sqlite.
    Which is f.. dumb.

    But i also read that WordPress developers are not dumb at all and probabily will look over this feature and make it useful.

    Thank you for not being dumb to the end, dear WP devs.

Viewing 3 replies - 1 through 3 (of 3 total)
  • James Osborne

    (@jamesosborne)

    8 months, 2 weeks ago

    Appreciate the feedback @keffr3n! The Performance Lab plugin, and it’s associated under the hood plugins such as this one, is where features are tested, with some features eventually migrating to WordPress core.

    At present you are correct, an existing MySQL or MariaDB database is required, as per this guide. Who knows, that may change in the future! There are also static site generator type plugins and similar that can be used for the type of sites you mentioned. Thanks again.

    MrBW

    (@mrbw)

    3 months ago

    First of all, I think it’s a wrong illusion to think that WP-sites running on SQLite should not be able handle “dynamic” sites with MANY concurrent users. I will claim that SQLite has the performance and feature to support this….it’s just a matter of how SQLite-support is implemented into WP.
    Maybe this will be the default setup for 80% of all WP sites in the future! ? 🙂

    And for SQLite support for new sites:
    Andrew Ozz mentioned it might be possible using “mu-plugin” or “drop-in”, see this thread-comment.
    Can anyone elaborate on this / provide more details?

    • This reply was modified 3 months ago by MrBW.
    MrBW

    (@mrbw)

    3 months ago

    Would it be possible to have a portable WP installation, i.e. copy/image of a clean new WP installation with the plugin installed and activated. Archive the whole WP site files/folders.
    You now have a ready-to-deploy installation with no need to first install MySQL. Just need to modify a few properties in one or more php files before you are up and running (of course also need to install PHP, Webserver etc). We could have a repo on GitHub with such a portable installation?

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.