Hi, i am using sqldelight to get data from database as flow, however the flow is not being collected whenever a new item is added

val players: Flow<List<HockeyPlayer>> = 
  playerQueries.selectAll()
    .asFlow()
    .mapToList()

players,collect{
   // i am not getting new list when item is added, i only receive data once
}

What could i be doing that is not right ?

I suppose it depends on how SqlDelight has implemented the

asFlow()

function. Given that flows are 'cold', not 'hot' like channels, it's likely that the flow terminates once the first iteration of data is collected. https://elizarov.medium.com/cold-flows-hot-channels-d74769805f9

i am checking `

onCompletion {}

` but it never fires

Hi! Can you show the whole snippet where you’re calling players.collect?

@Tiago Nunes i am definitely reading and update from two different database instances, let me fix it to see

When you call asFlow, it registers a query listener in the database instance. When there are updates, all registered listeners in the database instance are notified. It needs to be the same db instance to trigger the flow

@Tiago Nunes thanks i just got it working, you are right, i was using different instances. Thanks a lot