top | item 33216895 (no title) honzajde | 3 years 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 discuss order hn newest b3morales|3 years ago SQLite calls this an "update hook": https://www.sqlite.org/c3ref/update_hook.html hilti|3 years ago 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|3 years ago SQLDelight had neat built in support for thishttps://cashapp.github.io/sqldelight/
b3morales|3 years ago SQLite calls this an "update hook": https://www.sqlite.org/c3ref/update_hook.html hilti|3 years ago 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|3 years ago SQLDelight had neat built in support for thishttps://cashapp.github.io/sqldelight/
hilti|3 years ago 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|3 years ago SQLDelight had neat built in support for thishttps://cashapp.github.io/sqldelight/
b3morales|3 years ago
hilti|3 years ago
rockwotj|3 years ago
https://cashapp.github.io/sqldelight/