SQLite with sqflite package in Flutter - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the sqflite package used for in Flutter?

The sqflite package is used to work with SQLite databases in Flutter apps. It allows you to store, query, update, and delete data locally on the device.

beginner

How do you open or create a database using sqflite?

You use the openDatabase() function from sqflite. It opens an existing database or creates a new one if it doesn't exist, and you can provide a path and version.

intermediate

What is the purpose of the onCreate callback in openDatabase?

The onCreate callback runs when the database is created for the first time. It is used to create tables and set up the initial database structure.

beginner

How do you insert data into a SQLite table using sqflite?

You use the insert() method on the database object, passing the table name and a map of column names to values.

intermediate

What is the difference between rawQuery() and query() methods in sqflite?

rawQuery() lets you write SQL statements as strings for complex queries, while query() provides a simpler, structured way to query tables without writing raw SQL.

Which function is used to open or create a SQLite database in Flutter with sqflite?

A initDatabase()

B createDatabase()

C openDatabase()

D startDatabase()

openDatabase() is the correct function to open or create a database using sqflite.

What does the onCreate callback do when opening a database?

A Creates tables and initializes the database

B Updates the database version

C Closes the database

D Deletes the database

onCreate is called only once when the database is first created to set up tables and initial data.

How do you insert a new row into a table using sqflite?

A db.insert('table', dataMap)

B db.add('table', dataMap)

C db.create('table', dataMap)

D db.put('table', dataMap)

The insert() method is used to add new rows to a table.

Which method allows you to run raw SQL queries in sqflite?

A execute()

B rawQuery()

C query()

D runSQL()

rawQuery() lets you run raw SQL statements as strings.

What type of data structure is used to represent a row when inserting data with sqflite?

A List

B String

C Set

D Map

A Map with column names as keys and values as data is used to represent a row.

Explain the steps to create and open a SQLite database using the sqflite package in Flutter.

Think about how you tell sqflite where the database is and what to do when it is new.

Describe how to insert and query data from a SQLite database using sqflite.

Consider how you add data and then get it back in a Flutter app.