What tools and technologies do you use for interacting with databases in your practice?

In Flutter, the following tools and technologies are often used for interacting with databases:

• sqflite — a plugin for working with SQLite, suitable for local storage of structured data.
• moor (Drift) — an ORM library on top of SQLite, simplifying database operations through code generation and support for reactive streams.
• Hive — a fast and lightweight NoSQL solution for local storage, does not require SQL.
• Firebase Firestore — a cloud NoSQL database, often used for real-time data synchronization.

The choice depends on the project requirements: if a local relational database is needed — sqflite or moor; if a simple and fast NoSQL is needed — Hive; for cloud solutions — Firebase.

Example of using sqflite:

final database = await openDatabase('my_db.db');
await database.insert('users', {'id': 1, 'name': 'Alice'});
final users = await database.query('users');