Storing generated audio file doesn't work in action. Same code works fine in HTTP action.
Getting: "store() expects a Blob. If you are trying to store a Request,
await request.blob() will give you the correct input." error but I am sure that I pass blob.
```
try {
const ttsResponse = await openaiTTS(botText);
console.log('ttsResponse', ttsResponse.status, ttsResponse.statusText);...COPPA compliance?
One of my projects is for the large private school I work at. I would need to store student data. COPPA (basically the student version of HIPPA) would be a factor. Would I want to use the open source convex and host onsite? When I was looking at Supabase they said that they needed some extra configuration if a project needed to be HIPPA compliant. Anything like that with Convex?
Using pagination in convex vs something like TanStack Tables?
I discovered convex via TanStack. I have a playground project where I got TanStack Tables working with pagination, sorting, and filtering all in one go. Benefits/drawbacks on using that over more hands-on coding with convex pagination and other coding to get the same results (dynamic filtering, sorting, address bar syncing and browser history consistency)?
structuredClone ✨
Last week the Vercel AI SDK casually added a structuredClone call to the generateText functionality, causing it to now fail in the Convex runtime as it doesn't seem to be implemented. https://github.com/vercel/ai/commit/00114c5d0c606ea01ca614606e2b6499666e52d1#diff-479910b2e8ffb3ce9d79aca7bd77eb6972087a2137b71b1d098a2528e7fce454R499
Following the advice here https://discord.com/channels/1019350475847499849/1153313759440408627/1153355495483125810, I added the polyfill for structuredClone and it works! But, it would be cool to not have to do this, or
use node. I imagine a lot of people will be hitting this in the coming weeks as our industry is now solely dedicated to building apps with AI™...Join tables query / paginate
An important limitation in Convex that affects how we need to structure queries, especially for paginated results with joins. Let me explain the problem and show hacky workarounds:
The Problem
In my current code, i am trying to:...
How to tell the query to include specific fields
Instead of returning ALL of the fields in a document I want the query to only include specific fields. When I asked AI to help it said to put a .map function after the .query but when I do that I get a .map is not a function error.
Ideally I want to specify the fields in the query, not in the return. Akin to select firstname, lastname from people where... as opposed to what is happening now which is select * from people where...
What I tried based on AI....
Suggestions on schema best practice?
Bringin my data from postgres, this is one model I've been using and I'm wondering if this would not be better in convex as arrays. I'm coming from an SQL background with the usually weight on normalization.
I have a people table, a phone_number_types table, and a person_numbers table linking the two with fireign keys (what is convex-speak for primary and foreign keys? same thing? Convex doesn't specificy foreign keys in their tables, right?). This allows for a given person to have one or more phone numbers attached to them with different types. Some people will only have one number, others will have several. I didn't want my people table to have fields for 5 possible types of numbers most of which would be empty for most people. I also have the same structure for email addresses and physical addresses.
I'm wondering, from a convex perspective, is it better to store these kinds of things in array fields in the people table? It would mean far fewer relational joins, but I read in one of the docs it is better to not have too deeply nested of array fields. The array might look like
{phone_numbers: {home: xxxxxxxxxx},{mobile: yyyyyyyyyy}}...gemini
import { GoogleGenerativeAI } from '@google/generative-ai';
import { action } from './_generated/server';
export const generateResponse = action({
args: {},...
React-Native / Jest / Convex-test setup issue
Setting up convex-test (0.0.35) in a near fresh RN Expo sdk 52 app
Basic test file
```Typescript
import { describe, expect, test } from '@jest/globals'...
Joining related tables help
There is a rough example of a join function in the convex docs that looks like this.
`export const eventAttendees = query({
args: { eventId: v.id("events") },
handler: async (ctx, args) => {
const event = await ctx.db.get(args.eventId);...
aggregate component query is using a lot of bandwidth (exceeding 300gb after first week implement)
i need support on this one. i admit that i have many fields/metric that im currently aggregating (just to get count). but i dont expect that it'd be this much
convex auth user creation
For what I saw in some videos, the user should get created automatically when using convex auth. But in my case its not happening, does anyone know why it could be?
filter index based on multiple possible values?
consider the following query, where we want to select all posts made by a user, with a particular status of
pending. due to lots of users, and lots of posts per user, we have an index set up to index posts by ["userId", "status"]. therefore, we query like so:
``` const userPosts = await ctx.db
.query("posts")
.withIndex("by_userId_status", (q) => q.eq("userId", user?._id).eq('status', 'pending')...Problem posting an image to Convex storage. Please help me!!!!
Hiii, I'm building an expo app and I'm stuck in the user profile data form because there is a problem posting an image to Convex storage.
When trying to post the image to the previously generated url the return status code is 400 and no logs generaterd (convex dashboard). I've trying every single possibility (from AI and from the web) and nothing solves the problem😩 . Aprecciate anyone can help me!🙏...
Convex Auth catching different type of error on sign in/sign up
I want to be able to display the right message to user for example.
on sign up
- user already sign in
- password is not secure enough...
[ConvexAuth] Doc<'users'> don't update from default authTables
I have extended the users table in my schema to include more attribute required for my project. However, when I want to get the type from Doc, it believes my users table is the one from authTables, and not my updated version.
I'm having problems integrating launch darkly
```
// convex/convex.config.ts
import { defineApp } from "convex/server";
import launchdarkly from "@convex-dev/launchdarkly/convex.config";
...
convex swift with clerk
I checked the convex demo with swift
https://github.com/get-convex/ios-convex-workout/blob/main/WorkoutTracker/WorkoutTrackerApp.swift
I saw the authProvider is for Auth0, so does it support Clerk?...
I need to rekey my tables after importing
I'm used to a database-first development approach (only an SQL background) meaning that any modifications to the structure of my data/tables/relations, I have always managed directly in the database via SQL statements. I'm fully on-bard with Convex's mission and position on SQL, but I'm still in the early stages of the Mt Everest of learning curves for me.
I've started small, imorting a primary table, some secondary tables (my terms) and a few many-to-many tables that link them. Since convex generates new unique row IDs, I would like to update/replace the values that make up all of the relationships in the many-to-many linking tables. What is the convex/JS way to do this, updating foreign keys based on new primary keys?...