Question 1

How to implement full-text search in Nitrite database?

Accepted Answer

Create a full-text index on the desired field using indexOptions(IndexType.FULL_TEXT), then query with the text() method in your where clauses, as shown in the README's query example for the 'note' field. This leverages built-in indexing for efficient text matching without external search engines.

Question 2

Nitrite vs SQLite for Java embedded storage?

Accepted Answer

Nitrite is a document-oriented, schemaless NoSQL store ideal for flexible data models and features like full-text search, while SQLite is relational with SQL support. Nitrite offers simpler Java APIs and transactions, but SQLite has wider ecosystem tooling and maturity for complex queries.

Question 3

How to handle schema migrations in Nitrite?

Accepted Answer

Use the Migration class to define instructions for changing fields, data types, and indices between schema versions, then add migrations when building the database. The README provides a detailed example with multiple migration steps, including field renames and data type conversions.

Question 4

Does Nitrite support encryption for data security?

Accepted Answer

Yes, Nitrite includes encryption support and allows securing the database with a password during initialization, as seen in the openOrCreate method with user credentials. This ensures data at rest is protected, though key management is up to the developer.

Question 5

What storage backends does Nitrite support?

Accepted Answer

Nitrite supports in-memory storage or file-based persistence using MVStore or RocksDB engines, with configurable modules for compression and file paths. This flexibility lets you optimize for performance or durability based on your app's needs.

Question 6

How to backup and restore Nitrite databases?

Accepted Answer

Use the Exporter and Importer classes to export data to JSON files and import it back, as demonstrated in the README's import/export example. This allows for manual backups, but lacks automated or incremental backup features out of the box.

Nitrite Database

What is Nitrite Database?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions