Mick
Mick
Explore posts from servers
DTDrizzle Team
Created by Mick on 2/27/2024 in #help
How to reuse values within update().set() ? How to increment int?
The docs really need some reorganizing. Constantly cant find stuff. The "update" page is basically empty: https://orm.drizzle.team/docs/update
4 replies
DTDrizzle Team
Created by Mick on 2/27/2024 in #help
How to reuse values within update().set() ? How to increment int?
await db
.update(table)
.set({
counter: sql`${table.counter} - 1`,
})
.where(eq(table.id, 1));
await db
.update(table)
.set({
counter: sql`${table.counter} - 1`,
})
.where(eq(table.id, 1));
4 replies
DTDrizzle Team
Created by Mick on 2/27/2024 in #help
How to reuse values within update().set() ? How to increment int?
I found it in the "learn" page:
4 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
For now as Fresh doesnt support SCSS and KV doesnt abstract enough I will need to go back to Node, Nuxt and DynamoDB or MongoDB
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
For me it sounds like that with Deno runtime, Fresh, KV, Deploy, etc. they want to give the world an all in one solution to develop all kinds of applications. I guess they provide all features to make KV be usable easy and reliable for everyone and any usecase but I didnt read anything about exact the future.
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
Still everything I want to query I need to create a secondary index for and I can never forget to update on of those secondary indexes
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
Ok you got me on this one too
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
But what about "Give me all X in the time beween date A and date B". It is not possible to let this operation be done by the database. I need to filter on my app which means I first need to retrieve 1 million values before I can do so.
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
Ah true, I checked the wrong fn
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
From what I see I cannot even set the order asc/desc when using .get()
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
And I wonder if there are plans to add those features in the future
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
In one Youtube video Luca was telling how a high level API for KV could look like and something like this is missing for sure. But from what I see (handling indexes, missing querys and filters) KV needs a full second layer not just a "Mongoose".
27 replies
DDeno
Created by Mick on 10/27/2023 in #help
KV - Not possible to maintain in real world?
I will use DynamoDB for sure but it seemed to me that Deno KV wants to be the go-to solution (together with the whole other eco system). But right now it is not maintainable at all.
27 replies