Question 1

How to set up encryption with capacitor-data-storage-sqlite?

Accepted Answer

Encryption is only supported on iOS and Android. Set the 'encrypted' option to true when calling openStore, but note this feature is unavailable for Web or Electron, as per the compatibility table.

Question 2

Capacitor-data-storage-sqlite vs Capacitor Preferences plugin

Accepted Answer

Data Storage SQLite offers persistent, encrypted storage with SQLite backing for larger datasets, while Preferences is for simple, unencrypted key-value pairs. Choose based on your need for security and data durability.

Question 3

Can I store JSON objects in capacitor-data-storage-sqlite?

Accepted Answer

Yes, but you must serialize JSON to strings using JSON.stringify() before storing, and parse it back with JSON.parse() on retrieval, since the plugin only handles string data types.

Question 4

How to migrate from AsyncStorage to capacitor-data-storage-sqlite?

Accepted Answer

Export your data from AsyncStorage as JSON, then use the importFromJson method provided by the plugin. Ensure the JSON structure matches the expected format with tables and string values.

Question 5

Does capacitor-data-storage-sqlite work with older Capacitor versions?

Accepted Answer

Only the latest major version is actively maintained, as stated in the compatibility table. Older versions like v5 or v6 are not supported, so upgrade your Capacitor installation if possible.

Question 6

What are the performance implications for large datasets?

Accepted Answer

Performance is generally good on native platforms due to SQLite, but on Web using IndexedDB, operations might slow with very large datasets. Test with your specific data volume to assess impact.

Data Storage SQLite

What is Data Storage SQLite?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions