search

radicalplatforms / shafa

A wardrobe logging, composition, and organization app
https://shafa.app
Mozilla Public License 2.0
0 stars 0 forks source link

feat: add and refresh materialized view for items table and requests #104

Closed vincentdo1 closed 5 months ago

vincentdo1 commented 6 months ago

Closes https://github.com/radicalplatforms/shafa/issues/91.

github-actions[bot] commented 6 months ago

Successfully Deployed to Staging Environment Cloudflare Staging URL :rocket: https://shafa-hono-stage-104.radicalplatforms.workers.dev Neon Branch :elephant: https://console.neon.tech/app/projects/old-wave-86470546/branches/br-autumn-sea-a5j9fefe

github-actions[bot] commented 6 months ago

Successfully Deployed to Staging Environment Cloudflare Staging URL :rocket: https://shafa-hono-stage-104.radicalplatforms.workers.dev Neon Branch :elephant: https://console.neon.tech/app/projects/old-wave-86470546/branches/br-autumn-sea-a5j9fefe

github-actions[bot] commented 6 months ago

Successfully Deployed to Staging Environment Cloudflare Staging URL :rocket: https://shafa-hono-stage-104.radicalplatforms.workers.dev Neon Branch :elephant: https://console.neon.tech/app/projects/old-wave-86470546/branches/br-autumn-sea-a5j9fefe

EvanCarlson commented 6 months ago

Another idea you could look at is concurrently refreshing your materialized views if you continue to use them. This way the call and other queries aren't blocked by the view refreshing. Queries will simply hit the old view until the new one is ready.

This works if you care more about availability than consistency.

rak3rman commented 5 months ago

Marking this PR as closed for now since the scope and assignees of work has changed dramatically. Will open as a new PR once the branch is in a stable state.