5 ms·
How would you handle "db-notifications" with sqlite - to my knowledge this is a reason why you would need postgresql with its' (pg) NOTIFY
by honzajde 4y ago
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 4y agoSQLite calls this an "update hook": https://www.sqlite.org/c3ref/update_hook.html https://www.sqlite.org/c3ref/update_hook.html
- rockwotj 4y agoSQLDelight had neat built in support for this https://cashapp.github.io/sqldelight/ https://cashapp.github.io/sqldelight/
- hilti 4y agoExactly! 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.