Mick Comments - Answer Overflow

Topics

Mick

Explore posts from servers

NNuxt DDeno 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

•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

•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

•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

•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

•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

•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

•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

•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

•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

•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

•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

•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