Title: support sqlite
Last modified: May 27, 2023

---

# support sqlite

 *  Resolved [danchoi37](https://wordpress.org/support/users/danchoi37/)
 * (@danchoi37)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/support-sqlite/)
 * Dear author,
 * I am currently using a plugin in my application that only supports MySQL and 
   MariaDB databases. However, I would like to request your assistance in adding
   support for SQLite to enhance the flexibility and compatibility of the plugin.

Viewing 1 replies (of 1 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [3 years, 2 months ago](https://wordpress.org/support/topic/support-sqlite/#post-16773340)
 * Thanks for this suggestion, and for pioneering SQLite and WordPress. I must reject
   your suggestion. Here’s some background.
 * Ari Stathopoulos’s (with other contributors including a bit from me)[ SQLite Database Integration Plugin](https://wordpress.org/plugins/sqlite-database-integration/)
   is still rolling out. Experience with database bottlenecks hasn’t been accumulated
   yet.
 * Because SQLite’s indexing challenges are so different (and soooo much less hassle)
   than MariaDB / MySQL’s, it doesn’t make sense to extend this plugin to cover 
   them. (No prefix indexes and no silly 191-character limit, for one thing.)
 * SQLite does have one problematic feature, however. InnoDB tables can get their
   clustered indexes replaced with ones on different columns without repopulating
   the tables. `DROP PRIMARY KEY; ADD PRIMARY KEY (post_id, meta_key, meta_id);`
   does the trick. But SQLite has some NOROWID mischegoss required to accomplish
   the same thing.
 * If it looks like SQLite-backed WordPress needs indexing beyond the WordPress 
   standard, another plugin, or maybe just a wp-cli script, is the way to go. I’ll
   stay on top of it.
 * If you have SQLite performance data or other experience please let me know by
   posting here or by posting an [issue on the Github repo](https://github.com/OllieJones/index-wp-mysql-for-speed/issues).

Viewing 1 replies (of 1 total)

The topic ‘support sqlite’ is closed to new replies.

 * ![](https://ps.w.org/index-wp-mysql-for-speed/assets/icon-128x128.png?rev=2652667)
 * [Index WP MySQL For Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/index-wp-mysql-for-speed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/)
 * [Active Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [3 years, 2 months ago](https://wordpress.org/support/topic/support-sqlite/#post-16773340)
 * Status: resolved