cmorillas1

CMB SQLite Form is a lightweight yet powerful contact form solution designed for performance and privacy. Unlike traditional form plugins that clutter your main WordPress database, this plugin stores all submissions in a secure, local SQLite database.
It features a robust Global vs. Per-Form Settings system, allowing you to configure defaults once and override them only when needed for specific forms.
<h4>Key Features</h4>
<ul>
<li>
🚀 Zero-Overhead Storage
<ul>
<li>Uses a dedicated SQLite database file for submissions.</li>
<li>Keeps your main WordPress database clean and fast.</li>
<li>Portable data: Download the entire <code>.db</code> file for backups or migration.</li>
</ul>
</li>
<li>
🛡️ Advanced Bot Protection
<ul>
<li>Honeypot Field: Invisible field to trap bots.</li>
<li>Time Validation: Rejects submissions that are filled out too quickly (human behavior analysis).</li>
<li>Simple CAPTCHA: Lightweight text-based questions (e.g., “2 + 2 = ?”) without external dependencies.</li>
</ul>
</li>
<li>
📧 Junk Email Protection
<ul>
<li>Disposable Email Blocker: Automatically blocks temporary/throwaway email addresses.</li>
<li>Multiple Sources: Supports multiple blocklist sources with automatic deduplication.</li>
<li>Auto-Updates: Keeps your blocklist fresh with one-click updates.</li>
</ul>
</li>
<li>
🎨 Professional Styling
<ul>
<li>Pre-designed Templates: Choose from multiple professional styles (Default, Dark Mode, Minimal, etc.).</li>
<li>WordPress Customizer Ready: Fully compatible with “Additional CSS” for advanced customization.</li>
<li>Responsive Design: Forms look great on all devices automatically.</li>
</ul>
</li>
<li>
📨 Flexible Email Notifications
<ul>
<li>Dual Notifications: Send distinct emails to Admin (notification) and User (confirmation).</li>
<li>Custom SMTP Support: Built-in SMTP configuration (Host, Port, Auth, SSL/TLS) to bypass <code>wp_mail()</code> if needed.</li>
<li>Sender Customization: Customize “From Name” and “From Email” per form.</li>
</ul>
</li>
<li>
⚙️ Smart Configuration System
<ul>
<li>Global Defaults: Set your preferred settings once for the entire site.</li>
<li>Per-Form Overrides: Override ANY setting (fields, emails, styling, protection) for individual forms.</li>
<li>Modular Architecture: Enable or disable features as needed.</li>
</ul>
</li>
<li>
📊 Full Entry Management (Free)
<ul>
<li>Unlimited Submissions: No limits on the number of entries.</li>
<li>Search & Filter: Easily find specific submissions in the dashboard.</li>
<li>Export Tools: Download all your data as CSV or full DB backup (often a premium feature in other plugins).</li>
</ul>
</li>
<li>
🔒 Privacy & GDPR
<ul>
<li>Consent Checkbox: Built-in privacy policy acceptance field.</li>
<li>Data Management: Tools to export (CSV/DB) or delete data upon uninstall.</li>
<li>Local Storage: Data stays on your server, not third-party clouds.</li>
</ul>
</li>
</ul>
<h4>Perfect For</h4>
<ul>
<li>Contact Forms: Simple, fast, and secure contact pages.</li>
<li>Lead Generation: Capture leads on landing pages with minimal friction.</li>
<li>Download Gates: Deliver files (PDFs, ebooks) via email confirmation links.</li>
<li>Support Requests: Organize customer queries efficiently.</li>
<li>Event & Quote Requests: Structured data collection for business needs.</li>
<li>Feedback & Surveys: Gather user opinions without external services.</li>
<li>High-Performance Sites: Zero database overhead keeps your site fast.</li>
<li>Privacy-Focused Projects: Local storage with built-in GDPR tools.</li>
<li>Developers & Agencies: Clean architecture that keeps the main DB optimized.</li>
<li>Data Ownership: Full access to your data (view/export) without paywalls.</li>
</ul>
<h3>Configuration</h3>
<h4>Global vs. Form Settings</h4>
The plugin uses a smart inheritance system: 
1. Global Settings: Define the default behavior for ALL forms (e.g., your SMTP server, default styling, admin email). 
2. Form Settings: When editing a specific form, you can toggle “Override Global Settings” on any section to customize it just for that form.
<h4>Setting up Bot Protection</h4>
<ol>
<li>Go to Global Settings > Bot Protection.</li>
<li>Enable Honeypot (recommended).</li>
<li>Enable Time Validation (e.g., set to 3 seconds).</li>
<li>(Optional) Enable CAPTCHA for stricter forms.</li>
</ol>
<h4>Configuring Email Sending</h4>
You can choose how emails are sent: 
* WordPress Default: Uses your server’s standard PHP <code>mail()</code> function. 
* Custom SMTP: Go to Notifications > Outgoing Server to configure a specific SMTP server (Gmail, SendGrid, etc.) for reliable delivery.

CMB SQLite Form

A modular, high-performance SQLite-backed contact form plugin with advanced security, anti-spam features, and zero database overhead.

OllieJones

A <a href="https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins" rel="nofollow ugc">persistent object cache</a> helps your site perform well. This one uses the widely available <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> extension, and optionally the <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> and <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extensions to php. Many hosting services offer those extensions, and they are easy to install on a server you control.
<h4>What is this about?</h4>
It’s about making your site’s web server perform better. An object cache does that by reducing the workload on your MariaDB or MySQL database. This is not a <a href="https://developer.wordpress.org/advanced-administration/performance/cache/" rel="nofollow ugc">page cache</a>; these persistent objects go into a different kind of cache. These objects aren’t chunks of web pages ready for people to view in their browsers, they are data objects for use by the WordPress software.
<a href="https://en.wikipedia.org/wiki/Cache_(computing)" rel="nofollow ugc">Caches</a> are ubiquitous in computing, and WordPress has its own caching subsystem. Caches contain short-term copies of the results of expensive database lookups or computations, and allow software to use the copy rather than repeating the expensive operation. This plugin (like other object-caching plugins) extends WordPress’s caching subsystem to save those short-term copies from page view to page view. WordPress’s cache happens to be a <a href="https://en.wikipedia.org/wiki/Cache_(computing)#Memoization" rel="nofollow ugc">memoization</a> cache.
Without a persistent object cache, every WordPress page view must use your MariaDB or MySQL database server to retrieve everything about your site. When a user requests a page, WordPress starts from scratch and loads everything it needs from your database server. Only then can it deliver content to your user. With a persistent object cache, WordPress immediately loads much of the information it needs. This lightens the load on your database server and delivers content to your users faster.
<h4>Who should use this?</h4>
If your site runs on a single web server machine, and that server provides the <a href="https://www.php.net/manual/en/book.sqlite3.php" rel="nofollow ugc">SQLite3</a> and <a href="https://www.php.net/manual/en/intro.igbinary.php" rel="nofollow ugc">igbinary</a> extensions to php, this plugin will almost certainly make your site work faster. And if that server provides the <a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> extension, this plugin uses it too.
Some hosting providers offer <a href="https://redis.io/" rel="nofollow ugc">redis</a> cache servers. If your provider offers redis, it may be a good choice. You can use it via the <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin. Sites using redis have one SQL database and another non-SQL storage server: redis. Other hosting providers offer <a href="https://memcached.org/" rel="nofollow ugc">memcached</a>, which has the <a href="https://wordpress.org/plugins/memcached/" rel="ugc">Memcached Object Cache</a> plugin. And some large multipurpose cache plugins, such as the <a href="https://wordpress.org/plugins/litespeed-cache/" rel="ugc">LiteSpeed Cache</a>, also offer object caching based on one of those cache server software packages.
The cache-server approach to object caching comes into its own when you have multiple load-balanced web server machines handling your site. SQLite doesn’t work correctly in a multiple-web-server environment.
But, for single-server site configurations, SQLite, possibly assisted by APCu, performs well. And the vast majority of sites are single-server.
<h4>APCu</h4>
<a href="https://www.php.net/manual/en/book.apcu.php" rel="nofollow ugc">APCu</a> is an in-memory storage medium. It lets php programs, like WordPress, store data in shared memory so it’s very fast to retrieve when needed. If APCu is available on your host server, you can configure this plugin to use it. It reduces the typical cache lookup time to one-fifth or less of the SQLite lookup time, which is itself a few tens of microseconds. Performance counts, especially on busy web sites.
Please look at <a href="https://wordpress.org/plugins/sqlite-object-cache/#installation" rel="ugc">Installation</a> to learn how to configure this plugin to use APCu. The plugin works fast without it, and faster with it.
WP-CLI: Even if APCu is in use, caching with SQLite is necessary when your web site uses WP-CLI, because WP-CLI programs do not have access to the APCu cache. This plugin writes all cached data both to APCu and to SQLite and makes sure the two are synchronized.
<h4>WP-CLI</h4>
You can control this plugin via WP-CLI once you activate it. Please type this command into your shell for details.
<pre><code>wp help sqlite-object-cache
</code></pre>
<h4>Credits</h4>
Thanks to <a href="https://profiles.wordpress.org/tillkruess/" rel="nofollow ugc">Till Krüss</a>. His <a href="https://wordpress.org/plugins/redis-cache/" rel="ugc">Redis Object Cache</a> plugin serves as a model for this one. And thanks to <a href="https://profiles.wordpress.org/aristath/" rel="nofollow ugc">Ari Stathopoulos</a> and <a href="https://profiles.wordpress.org/spacedmonkey/" rel="nofollow ugc">Jonny Harris</a> for reviewing this. Props to Matt Jones for finding and fixing a bug that appeared on a heavily loaded system. Thanks to <a href="https://speedable.net/about-us/" rel="nofollow ugc">Massimo Villa</a> for testing help, and to <a href="https://github.com/nickchomey" rel="nofollow ugc">nickchomey</a> for a comprehensive code review. All defects are, of course, entirely the author’s responsibility.
And thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.
<h4>How can I learn more about making my WordPress site more efficient?</h4>
We offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.

SQLite Object Cache


This is the plugin, the community of shared-hosting users have waited for without even knowing it.



Thanks to @ollijones the plugin author for making this possible and also for tagging it a community-plugin and doing friendly support here on the forum as well.



Great!


Great Plugin & friendly and fast support


Thanks Ollie for this great plugin!



I use this in conjunction with your other plugin Index WP MySQL For Speed and have installed these on quite a lot of websites with great success. Each and every one has increased speed.



It is faster and it feels faster and that's all the client cares about 🎉


5 star plugin. Speed increasement does not go unnoticed.


Honestly I was skeptical at first because of the low number of installs, but given the lack of options for object caching on a lot of shared hosting services that I cant control with a lot of client sites I decided to give it a shot on a few.  



This plugin is amazing, it helped turn a 15 second load on back end page edits into 3-4 seconds on a plugin heavy site running on an overpopulated shared host that I wont name here, but it was honestly awful, one of the worst I've ever used and a surprisingly big name.  I was brought in to try and optimize a monster on this occasion and it helped me turn it into some form of a workhorse again for my client, with almost no setup, toggled a checkbox or two and clicked save.   



This plugin needs more downloads, there are so many sites running on garbage hosting that could use this to make the back end a working environment again.



I will be using this on any site where I do not have redis or memcache available from here on out, cheers to the developer, you are an true WP Wizard.


Absolutely Brilliant


When no Memcached, no Redis available, this is the obvious solution.


Just what I was looking for

Amazing

great project!

A fast persistent object cache backend for the rest of us, powered by SQLite and accelerated by APCu

CMB SQLite Form vs SQLite Object Cache