Nic
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
thanks for the discussion! learned quite a bit
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
ill look over it and revisit later, fresh eyes might help me here
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
might just not be the right fit for this one im building right now
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
im using convex for another project, and it's working amazingly
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
maybe im just not visualizing how things are being processed at runtime
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
that just hurts my brain lol
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
wouldnt that just introduce 20k queries instead?
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
so, do a collect() on table, pull the unique id thats also in the csv, process the csv to remove ones i already have saved, save the new results
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
whole table, rather
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
index wouldnt do anything, since what im selecting would just return the whole database anyway
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
so normally i'd just select distinct of the id, of 20k items
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
my function was to grab a csv i imported, check the ids in the csv for duplicates in the database (so we dont add twice)
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
just no idea how i got to 15gb, i deleted the project already because i didnt want any ghost processed to continue to do anything
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
interesting, but the table was iirc 200mb or so, just curious if you do a collect() on the whole table does that add 200mb to your bandwidth used
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
i guess that occurs on the database server (mysql for ex) not sent to the app to process?
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
selecting certain columns would have cut down greatly on the database bandwidth used too
42 replies
CCConvex Community
•Created by Nic on 4/10/2025 in #general
Really wish the database layer was a bit
select("column1", "column2") would have been great too, maybe im just misreading what convex databases are supposed to be
42 replies
CCConvex Community
•Created by Nic on 3/30/2025 in #support-community
Searching two columns
for now ill just do a read all/filter, as the tables going to be < few thousand documents
8 replies
CCConvex Community
•Created by Nic on 3/30/2025 in #support-community
Searching two columns
yeah, trigger seems like the way to go to build a computed column/index. In fact i need to do a deep dive on triggers to see where i can add it into my codebase thanks!
8 replies