isitayush
isitayush
Explore posts from servers
RReactifluxTtRPCTTCTheo's Typesafe CultDTDrizzle Team
PostsComments
DTDrizzle Team
Created by isitayush on 12/5/2023 in #help
search on all `with` and `columns` fields via text (sqlite)
That helps & I'll look for it! Thank you Angelelz. 💙
14 replies
DTDrizzle Team
Created by isitayush on 12/5/2023 in #help
search on all `with` and `columns` fields via text (sqlite)
There are many way of searching through many columns. but I'm not sure it can be through several tables in the same query Maybe a concat with several column from a join?
That's interesting! Getting the data & joining is not difficult. I'm just stuck on searching (hopefully a text search) across the result: object[] of all the joins. If I may, could you point me to a few resources for many ways of searching through many columns (for sqlite!) if you're aware of any Angelelz.
How big is the content in each column?
On most of the columns, the content is almost always 1-2 words long.
14 replies
DTDrizzle Team
Created by isitayush on 12/5/2023 in #help
search on all `with` and `columns` fields via text (sqlite)
Thank you @Angelelz! (i apologize for ping!!) This is what I ended up doing. Do you think it's possible by building sql queries via drizzle instead of using the drizzle .query builder. I'm not too good at SQL so I had no choice other than using query builder for this but just wondering.
14 replies
DTDrizzle Team
Created by isitayush on 5/14/2023 in #help
I think I don't really understand migrations local sqlite.
Okay, Figured It out! It's .default(sql``) . : )
13 replies
DTDrizzle Team
Created by isitayush on 5/14/2023 in #help
I think I don't really understand migrations local sqlite.
I'm looking for it to be something like this. "id" UUID PRIMARY KEY NOT NULL DEFAULT gen_random_uuid()
13 replies
DTDrizzle Team
Created by isitayush on 5/14/2023 in #help
I think I don't really understand migrations local sqlite.
Hey @bloberenober, Just a small question. How do I set a 'gen_random_uuid()' function as a default value on a custom type? I have the following: 
const serial_uuid = customType<
    {
        data: string;
        driverData: string;
        notNull: true;
        default: true;
    }
>({
    dataType(config) {
        return 'UUID';
    },

});
const serial_uuid = customType<
    {
        data: string;
        driverData: string;
        notNull: true;
        default: true;
    }
>({
    dataType(config) {
        return 'UUID';
    },

});
& it generates a following migration, "id" UUID PRIMARY KEY NOT NULL,.
13 replies
DTDrizzle Team
Created by isitayush on 5/14/2023 in #help
I think I don't really understand migrations local sqlite.
It totally slipped from my head that I could include a script such as ensure_migrations.ts with tsc that runs before dev or start alongisde my next app. A native solution in drizzle-kit would still be awesome but this workaround seems to work too. Welp! Thank you Dan & Andrew. I hope you will bump up 'covers ~95% of the common cases' line to '99%' when db:push ships later this month. Goodluck!
13 replies
DTDrizzle Team
Created by isitayush on 5/14/2023 in #help
I think I don't really understand migrations local sqlite.
Oh, Okay. I guess until this is taken care of by drizzle-kit push:... command (something similar to what prisma does). It would be impossible to make this work with serverless frameworks (like nextjs) without manually pushing your migrations to db each time you make a change ie. generate new migrations. For now it's a deal breaker & I think I would have to fallback to using prisma but I really wish it's solved soon as would instantly take it over prisma any day. Thank you for the help though Dan!
13 replies