Question 1

How to encrypt a database in Capacitor Data Storage SQLite?

Accepted Answer

Set the 'encrypted' option to true when calling openStore(), but note that encryption is only supported on iOS and Android, not on Electron or Web. You'll need to handle platform checks for consistent security.

Question 2

Capacitor Data Storage SQLite vs @capacitor/storage: which is better?

Accepted Answer

This plugin offers SQLite-backed persistence with encryption and multi-table support, ideal for robust storage needs. @capacitor/storage is simpler but uses platform-specific APIs without encryption or native SQLite reliability.

Question 3

Can I store JSON objects in Capacitor Data Storage SQLite?

Accepted Answer

Yes, but you must serialize JSON objects to strings before storage using JSON.stringify(), and deserialize with JSON.parse() on retrieval, since the plugin only handles string data directly.

Question 4

How to migrate data from localStorage to this plugin?

Accepted Answer

Use the importFromJson() method after converting localStorage data to a JSON string that matches the plugin's format. The export/import features facilitate this migration, but test on web since some methods aren't supported there.

Question 5

Is Capacitor Data Storage SQLite good for offline-first apps?

Accepted Answer

Yes, it provides reliable, persistent storage using SQLite on native platforms, making it suitable for offline data caching. However, for complex sync scenarios, you'll need to implement custom backend integration.

Question 6

What happens if I don't close the store in Capacitor Data Storage SQLite?

Accepted Answer

The Android code now keeps databases open for performance, but you must manage closing with closeStore() before opening a new one to avoid issues. Note that closeStore is not supported on Web.

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