Watching a single cell for changes?

[Kirsdarkenvaar]

Hello! I'm trying to find a way to watch a single cell for changes. I wrote the following code:

Stream<String> watchCharacterName({required String characterId}) {
   final character = (database.select(database.characters)
         ..where((character) => character.id.equals(characterId)))
       .watchSingle();

   return character.map((character) => character.name).distinct();
 }

The problem with this code is that when I modify a different column of the same Character row (e.g. age), an update is pushed to the stream with the value of the name column, even though the name column has not changed. I tried adding distinct() at the end to see if that would ignore the same value, but that doesn't seem to do anything in this instance.

Is there a way to only watch a specific column of a specific row in the character table for changes?

[dickermoshe]

SQlite currently doesn't support only watching a single row.

You can use distictUnique from rxdart to filter out these events.