meili-NG / meiliNG.js

meiliNG: Easy Identity/Login Infrastructure, Next Generation. Supports oAuth2 and OpenID Connect specifications
https://meili.ng
MIT License
21 stars 7 forks source link

Use `filterJson` prisma experimental feature #26

Closed Alex4386 closed 2 years ago

Alex4386 commented 2 years ago

Since meiling is using Prisma 3.7.0. We can now utilize Database-side implementation of JSON filtering. Which significantly improves performance than current approach (getting all, run Array.prototype.filter() on meiling)

Docs: https://www.prisma.io/docs/concepts/components/prisma-client/working-with-fields/working-with-json-fields


Requested by @Baw-Appie

Alex4386 commented 2 years ago

Implementation in progress at feature/support-json-filtering

Alex4386 commented 2 years ago

Currently optimizing internal flows (especially, Sakuya Housekeeping) with JSON filtering...

This is definitely going to take a while to finish...

Alex4386 commented 2 years ago

Deployed on staging

Stella-IT-Bot commented 2 years ago

Closing Issue. Implemented on 0.7.0