Local Database
sqflite, CRUD operations, migrations, transactions, relationships, query performance
1Which package is most commonly used to implement a SQLite database in a Flutter application?
Which package is most commonly used to implement a SQLite database in a Flutter application?
답변
The sqflite package is the de facto standard for SQLite in Flutter. It provides an asynchronous API to interact with SQLite, supporting CRUD operations, transactions, and raw SQL queries. It is maintained by the Flutter team and offers optimal compatibility with Android and iOS.
2Which sqflite function opens a database and creates it if it doesn't exist?
Which sqflite function opens a database and creates it if it doesn't exist?
답변
The openDatabase function is the main method to initialize a sqflite database. It accepts a file path and an onCreate callback that is only called if the database doesn't exist yet. This allows defining the initial schema with the required tables.
3Which complementary package is typically used with sqflite to get the application's documents directory path?
Which complementary package is typically used with sqflite to get the application's documents directory path?
답변
The path_provider package provides paths to system directories like documents or cache. Combined with sqflite, it allows determining where to store the database file. The getApplicationDocumentsDirectory function returns a persistent directory accessible only by the application.
Which sqflite method inserts a new row into a table and returns the inserted row's ID?
Which sqflite method retrieves multiple rows from a table as a List<Map<String, dynamic>>?
+19 면접 질문