NoSQL embedded database with data change notification callback

Question

I am using SQLite embedded in a .Net Desktop application developed with WPF.

SQLite provides a callback for any write operation performed to the database (within the same connection) ref

In this callback, it provides the following which leads to the records being affected

Event (Insert /Update/Delete)
Table Name
Row Id

I am looking for a NoSQL alternative that also provides such callback and could be embedded in a desktop application targeting .Net Framework 4.8

I like the lightweight LiteDB but couldn't find data changes callback support

MongoDB please check this article mongodb.github.io/mongo-csharp-driver/2.9/reference/driver/… — Moheman Tariq
– Moheman Tariq, Commented Aug 31, 2021 at 14:24
Thanks, @MohemanTariq, It is a client application, distributing MongoDB with the app will be a huge dependency. I was looking for a lightweight solution like LiteDB, which could maintain data in just a single file — mhsarosh
– mhsarosh, Commented Aug 31, 2021 at 14:33

mhsarosh · Accepted Answer · 2021-09-11 16:54:52Z

1

I ended up using the Realm Database.
Realm lets register a notification handler on a specific collection. The handler receives a description of changes since the last notification. Specifically, this description consists of three lists of indices:

The indices of the objects that were deleted.
The indices of the objects that were inserted.
The indices of the objects that were modified.

Another plus point of Realm over SQLite is that these change notifications are NOT limited to changes from the same connection.

answered Sep 11, 2021 at 16:54

mhsarosh

3082 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NoSQL embedded database with data change notification callback

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related