Challenge 3

Build a notes app with sqflite to add and list notes.

Note app with sqflite

In this challenge you build a note app with sqflite. You open the database with openDatabase, create a notes table with CREATE TABLE, add a new note with insert, and fetch all notes with query. Since each query returns a Future, the functions are async.

final db = await openDatabase('notlar.db');
await db.insert('notlar', {'baslik': 'Alışveriş', 'icerik': 'Süt'});
final liste = await db.query('notlar');

This structure provides persistent and queryable storage.

Exercise The notEkle function

Write an async function named notEkle. Open the database with openDatabase('notlar.db') and add a new note with db.insert('notlar', {'baslik': baslik, 'icerik': icerik}). Print 'hazir' in main.

Show example solution

import 'package:sqflite/sqflite.dart';

Future<void> notEkle(String baslik, String icerik) async {
  final db = await openDatabase('notlar.db');
  await db.insert('notlar', {'baslik': baslik, 'icerik': icerik});
}

void main() {
  print('hazir');
}

Exercise The notlariGetir function

Write an async function named notlariGetir. Open the database with openDatabase('notlar.db'), fetch all notes with db.query('notlar'), and return them. Print 'hazir' in main.

Show example solution

import 'package:sqflite/sqflite.dart';

Future<List<Map<String, Object?>>> notlariGetir() async {
  final db = await openDatabase('notlar.db');
  return db.query('notlar');
}

void main() {
  print('hazir');
}

Test yourself

Which method is used to add a new record in sqflite?
- db.insert
- db.update
- db.query
- db.delete
Show answer

db.insert — db.insert adds a new record. db.query reads records, db.delete deletes a record, and db.update updates an existing record; none of these add a new record.

Fetch all notes

final db = await openDatabase('notlar.db');
final liste = await db.____('notlar');

Show answer

final db = await openDatabase('notlar.db');
final liste = await db.query('notlar');

sqflite parts

openDatabase

Opening the database
CREATE TABLE

Creating a table
db.insert

Adding a record
db.query

Fetching records

Next lesson: Challenge 4

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies