djbalin Comments - Convex Community

djbalin

•Created by djbalin on 4/1/2025 in #support-community

Granular RLS (e.g. oldDoc/newDoc)

I think our solution for now is to normalize user roles completely out into its own table and then imposing strict rules for insertion and modification of that table

11 replies

CCConvex Community

•Created by djbalin on 4/1/2025 in #support-community

Granular RLS (e.g. oldDoc/newDoc)

Yeah exactly. I guess that these rules are applied at the entry point of the given function, so the change itself is not "known" at this point - contrary to triggers which run after a given function and therefore have access to the change.

11 replies

CCConvex Community

•Created by Alvi on 3/24/2025 in #support-community

paginated query with status

I am really interested in this as well. I just used query streams and they are wonderful @lee for merging a paginated query. However, I get the error Uncaught Error: Cannot union empty array of streams if the streams are empty, and it's not straightforward to handle this in the frontend. For now I put this check below in my query, but that's not a nice solution going forward:

   if (submissionStreams.length === 0) {
      return {
        page: [] as AdminProfileSubmissionEnriched[],
        isDone: true,
        continueCursor: "null",
      };
    }

   if (submissionStreams.length === 0) {
      return {
        page: [] as AdminProfileSubmissionEnriched[],
        isDone: true,
        continueCursor: "null",
      };
    }

usePaginatedQueryWithStatus would be aaaawesome!

6 replies

CCConvex Community

•Created by djbalin on 4/1/2025 in #support-community

Granular RLS (e.g. oldDoc/newDoc)

how do you format your code so nicely with colors and everything btw? 🌞

11 replies

CCConvex Community

•Created by djbalin on 4/1/2025 in #support-community

Granular RLS (e.g. oldDoc/newDoc)

Sorry maybe I wasn't clear enough: I am asking about controlling specifically which fields in a table can be modified. As far as I can tell, the example in the stack post also allows a user to patch their own role to admin (assuming that role is stored on the user schema). In pseudocode, I am asking if something like this is possible (similarly to trigger syntax, can't find it in docs or stack post):

  users: {
    modify: async ({ viewer, permissions, change }, user): Promise<boolean> => {
      // If user is already admin, allow everything
      if (viewer.role === "admin") return true;

      // If user is not admin and is trying to change their own role to admin, disallow
      if (change.oldDoc.role !== "admin" && change.newDoc.role === "admin") return false;
      ...
    },
  },

  users: {
    modify: async ({ viewer, permissions, change }, user): Promise<boolean> => {
      // If user is already admin, allow everything
      if (viewer.role === "admin") return true;

      // If user is not admin and is trying to change their own role to admin, disallow
      if (change.oldDoc.role !== "admin" && change.newDoc.role === "admin") return false;
      ...
    },
  },

11 replies

CCConvex Community

•Created by djbalin on 3/27/2025 in #support-community

[convex-helpers]: useQueryWithStatus error: "could not find Convex client"

In a monorepo setup, defining useQueryWithStatus locally in the frontend app instead of in our backend package seems to solve it for now - but shouldn't it be possible to define it in the backend package and share that one defiintion across apps? I can see that we've done that successfully in another monorepo project

4 replies

CCConvex Community

•Created by Paul Ochieng on 3/18/2025 in #support-community

unable to push deployment

I just experienced this same error when I had a circular dependency in some validators. I.e. I had imports going in both directions between two files: profile/validators.ts <---> submission/validators.ts. These particular validator files are not used for my schema definition, so maybe that's why this particular error does not show up as our old friend "api instantiation is excessively deep ..."?

7 replies

CCConvex Community

•Created by djbalin on 3/13/2025 in #support-community

How to print tablename from generic type?

yeah ok thanks, that's pretty much what AI explained to me as well! I have resorted to passing the table name in until now, and its ok (especially since i get intellisense autocompletion on the table name based on the id parameter)

4 replies

CCConvex Community

•Created by djbalin on 3/13/2025 in #support-community

How to print tablename from generic type?

4 replies

CCConvex Community

•Created by uzamaki21 on 3/10/2025 in #support-community

is there a way to see my database usage??

Dashboard --> Team Settings --> Usage URL should look like https://dashboard.convex.dev/t/YOUR_TEAM_NAME/settings/usage

14 replies

CCConvex Community

•Created by djbalin on 3/9/2025 in #support-community

`.unique()`: Better error logging

For example, in the implementation of .unique()in convex/src/server/impl/query_impl.ts, print the _ids of the two elements returned returned? Something along the lines of:

    if (first_two_array.length === 2) {
      throw new Error(`unique() query returned more than one result. First pair of results: ${first_two_array[0]._id}, ${first_two_array[1]._id}`);
    }

    if (first_two_array.length === 2) {
      throw new Error(`unique() query returned more than one result. First pair of results: ${first_two_array[0]._id}, ${first_two_array[1]._id}`);
    }

4 replies

CCConvex Community

•Created by djbalin on 2/26/2025 in #support-community

[Backup]: Stuck on "Backing up config in 'pushNotifications'"

Don't know - just relying on automatic backups for now, they seem to work 🙂 thought the team might want the bug report regardless

6 replies

CCConvex Community

•Created by djbalin on 2/26/2025 in #support-community

[Backup]: Stuck on "Backing up config in 'pushNotifications'"

Update: automatic daily backup still works fine, so apparently only manually triggered backups cause the problem

6 replies