A Capacitor plugin for native and Electron SQLite databases with optional encryption.
@capacitor-community/sqlite is a Capacitor plugin that provides native SQLite database access for iOS, Android, Electron, and Web applications. It solves the problem of inconsistent local storage APIs across platforms by offering a unified interface with support for encrypted databases, transactions, and migrations. Developers can build cross-platform apps with reliable, performant local data persistence.
Mobile and desktop app developers using Capacitor with frameworks like Ionic, Angular, React, Vue, or SvelteKit who need robust local database functionality. It's particularly valuable for teams building applications that must work offline or handle sensitive data requiring encryption.
Developers choose this plugin because it delivers true native SQLite performance on mobile and desktop, includes built-in encryption via SQLCipher, and maintains API consistency across all supported platforms. Its active maintenance, extensive documentation, and integration with popular ORMs like TypeORM reduce development time and complexity.
⚡Capacitor plugin for native & electron SQLite databases.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Offers a unified SQLite API across iOS, Android, Electron, and Web, with most core methods supported on all platforms as shown in the methods table.
Uses SQLCipher for native platforms and better-sqlite3-multiple-ciphers for Electron, providing robust security for sensitive data without extra plugins.
Includes advanced capabilities like transactions, migrations, JSON import/export, and TypeORM integration, detailed in extensive documentation pages.
Maintained by a dedicated team with regular updates, a large contributor base, and clear maintenance badges indicating ongoing support.
Requires platform-specific configurations, such as Android build adjustments, Electron dependency version locks, and manual file copying for Web, increasing initial setup time.
Lacks full feature parity, including no encrypted database support and missing methods like read-only connections, which can limit functionality for web-only apps.
Documentation is split across multiple markdown files (API.md, Web-Usage.md, etc.), which can make it challenging to find specific information quickly.