Hey there! Let's figure out why your StreamBuilder is showing null data only on first launch, and starts working after an action like opening the drawer.

First, Diagnose the Exact State #

First step: add debug logs to understand what's happening with your snapshot on launch. Modify your builder function to print key details:

builder: (context, AsyncSnapshot<List<Todo>> snapshot) {
  debugPrint(
    "SB State: Connection=${snapshot.connectionState}, "
    "Data=${snapshot.data}, HasData=${snapshot.hasData}, "
    "HasError=${snapshot.hasError}"
  );
  // Rest of your code
}

This will tell you if the data is truly null, or if it's an empty list (which would cause a blank ListView but isn't null).

Likely Causes & Fixes #

1. You're Seeing an Empty List, Not Null Data

If your debug logs show Data=[] (empty list) instead of Data=null, the issue is that your database has no todos on first launch. Your current code renders a ListView with 0 items (blank screen) instead of an empty state message. Fix this by adding an empty state check:

if ((snapshot.connectionState == ConnectionState.active || snapshot.connectionState == ConnectionState.done) && snapshot.hasData) {
  final todos = snapshot.data!;
  debugPrint("SB Initialized, todos count: ${todos.length}");
  
  // Add empty state handling
  if (todos.isEmpty) {
    return const Center(
      child: Text("No todos yet! Add your first task to get started."),
    );
  }

  return ListView.builder(/* ... */);
} else {
  return const Center(child: CircularProgressIndicator());
}

2. Database/Repository Initialization is Asynchronous

If your debug logs show Data=null on first launch, it's likely your database isn't fully initialized when the StreamBuilder first listens to the stream. Drift's watch() won't emit data until the database is ready.

Fix this by ensuring your repository is only provided after the database finishes initializing, using a FutureProvider:

// In your app's root widget (e.g., main.dart)
return FutureProvider<ITodoRepository>(
  create: (context) async {
    // Initialize your database asynchronously
    final db = await AppDatabase.open();
    return TodoRepository(db);
  },
  // Optional: Provide a temporary loading state while initializing
  initialData: null,
  child: MaterialApp(/* ... */),
);

Then, in your widget, handle the uninitialized repository case:

final todoRepo = Provider.of<ITodoRepository>(context, listen: true);

// Show loading until repository is ready
if (todoRepo == null) {
  return const Center(child: CircularProgressIndicator());
}

return StreamBuilder<List<Todo>>(
  stream: todoRepo.watchTodos(),
  // ... rest of your StreamBuilder code
);

3. StreamBuilder Condition is Too Strict

Your current condition checks for ConnectionState.active || ConnectionState.done, but Drift's watch() returns a persistent stream that never enters ConnectionState.done. Simplify the condition to use snapshot.hasData and check for active state:

if (snapshot.connectionState == ConnectionState.active && snapshot.hasData) {
  // Render list with snapshot.data!
} else if (snapshot.connectionState == ConnectionState.waiting) {
  return const Center(child: CircularProgressIndicator());
} else {
  // Handle error or no data case
  return const Center(child: Text("Failed to load todos"));
}

4. Verify Your Stream Transformation

Double-check that your asTodoModel conversion isn't returning null values. If e.asTodoModel can return null, your mapped list will contain nulls, but the list itself shouldn't be null. To fix this, filter out nulls:

@override
Stream<List<Todo>> watchTodos() {
  return db.watchTodos().map((event) => 
    event.map((e) => e.asTodoModel)
      .where((todo) => todo != null) // Filter out nulls
      .cast<Todo>()
      .toList()
  );
}

Final Checks #

• Run the app with the debug logs enabled to confirm which scenario you're facing.
• Ensure your Drift database is being opened correctly (check for any errors during initialization).

内容的提问来源于stack exchange，提问作者andyVerona