[honzajde]

How would you handle "db-notifications" with sqlite - to my knowledge this is a reason why you would need postgresql with its' (pg) NOTIFY

[b3morales]

SQLite calls this an "update hook": https://www.sqlite.org/c3ref/update_hook.html

[hilti]

Exactly! Or in some cases I create a view - for example a highscore list - that is queried by a simple server-side script and sends the data as JSON to the client.

[rockwotj]

SQLDelight had neat built in support for this

https://cashapp.github.io/sqldelight/