Anyone know of any simple ORMs that are compatible with D1?

MMurder Chicken Anyone know of any simple ORMs that are compatible with D1?

M

meyer•6/4/23, 8:51 PM

documentation: https://developers.cloudflare.com/d1/platform/community-projects/

During D1’s alpha period, members of the Cloudflare developer community have made some valuable contributions to the D1 ecosystem. Below are some …

Mmeyer documentation: https://developers.cloudflare.com/d1/platform/community-projects/

M

Murder ChickenOP•6/4/23, 8:55 PM

Thank you! Super-helpful!

Ssteida Inconsistent unit of size in Cloudflare dashboard. KB and kB actually have diffe...

M

Matt Silverlock•6/4/23, 9:55 PM

We should be consistent, but kB and KB are the same. KiB (kibibyte) is the different unit

Ssteida ChatGPT told me it's 1000 vs 1024, but it's well-known liar so... 😅

L

Leon338•6/4/23, 11:58 PM

It deppends on the capitalized B. A small kb is 1000 Bit and a big kB is 8000 Bit. You can ignore the K

U

Unsmart•6/5/23, 12:16 AM

Afaik kb and KB are exactly the same its only KiB that is different... KB = 1000 KiB = 1024

U

Unsmart•6/5/23, 12:18 AM

Ah yup can be confirmed here: https://physics.nist.gov/cuu/Units/binary.html

UUnsmart Ah yup can be confirmed here: https://physics.nist.gov/cuu/Units/binary.html

H

Hello, I’m Allie!•6/5/23, 10:04 AM

Just make it simple, and write out the number of bits

N

nejc•6/5/23, 10:22 AM

Sharing if someone else is trying to figure out why worker deployment via API is not working for D1. Not sure for what reason, but you need to add

__D1_BETA__

__D1_BETA__

__D1_BETA__

__D1_BETA__ infront of your binding name. Something like this:

metadata.bindings.push({
      name: `__D1_BETA__${db.name}`,
      type: 'd1',
      id: db.id,
})

metadata.bindings.push({
      name: `__D1_BETA__${db.name}`,
      type: 'd1',
      id: db.id,
})

metadata.bindings.push({
      name: `__D1_BETA__${db.name}`,
      type: 'd1',
      id: db.id,
})

metadata.bindings.push({
      name: `__D1_BETA__${db.name}`,
      type: 'd1',
      id: db.id,
})

then you can call PUT

/accounts/${accountId}/workers/scripts/${scriptName}

/accounts/${accountId}/workers/scripts/${scriptName}

/accounts/${accountId}/workers/scripts/${scriptName}

/accounts/${accountId}/workers/scripts/${scriptName} and D1 will be successfully bind

N

nejc•6/5/23, 10:22 AM

hope that it helps to someone

N

nejc•6/5/23, 10:25 AM

@skye_31 thank you. Managed to figure it out how to deploy d1 e2e with the API, so looking good

Original message was deleted

M

Matt Silverlock•6/5/23, 12:27 PM

This is highly (highly) likely to break very soon, as Skye points out.

N

nejc•6/5/23, 12:49 PM

@elithrar that is ok

I will fix it, want to do MVP with what it's possible e2e

N

nejc•6/5/23, 1:07 PM

@elithrar when this change will come there will be some release notes/blog right?

Nnejc @elithrar when this change will come there will be some release notes/blog right...

M

Matt Silverlock•6/5/23, 1:10 PM

In the changelog (only). Not a blog — we're in alpha and using this to make the changes we need.

MMatt Silverlock In the changelog (only). Not a blog — we're in alpha and using this to make the ...

N

nejc•6/5/23, 1:12 PM

great, will this be in workers change logs (https://developers.cloudflare.com/workers/platform/changelog/) or somewhere else?

Changelog · Cloudflare Workers docs

Review recent changes to Cloudflare Workers.

J

Jacob Wright•6/5/23, 2:21 PM

I'm getting "not authorized to use function" with timestamp functions (e.g. SELECT CURRENT_TIMESTAMP; fails). I'm using the new backend. Is this a known issue?

K

kian•6/5/23, 2:25 PM

Known issue that'll be fixed in the next release

K

kian•6/5/23, 2:25 PM

https://github.com/cloudflare/workerd/pull/723

J

Jacob Wright•6/5/23, 2:25 PM

Thank you

S

Sly•6/6/23, 4:36 AM

Are there still known errors in conjunction with drizzle?

BBhadoo I really need more storage. Why Cloudflare isn't responding to requests. I've be...

C

Cyb3r-Jak3•6/6/23, 4:37 AM

They did announce during dev week they will be increasing the size of paid plan size to 1GB soontm

BBhadoo For paid plan it says 5 GB at beginning. For free it'll be 1 GB. I'm talking ab...

C

Cyb3r-Jak3•6/6/23, 4:54 AM

I don’t believe the 100 MB limit was raised anywhere due to technical limitations

SSly Are there still known errors in conjunction with drizzle?

A

Adi•6/6/23, 8:29 AM

Drizzle works fine most of the time. Joins are a bit bugged due to downstream errors - https://github.com/drizzle-team/drizzle-orm/issues/528

AAdi Drizzle works fine most of the time. Joins are a bit bugged due to downstream er...

S

Sly•6/6/23, 8:33 AM

Okay, asking as I had some troubles yesterday mentioning prepare even though not using prepared statements. Will take a look after being back from vacation

M

Mozzy•6/6/23, 9:24 AM

Started getting a bunch of these again at 3AM CEST

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

{
  "message": "D1_ERROR",
  "cause": "Error: D1 storage operation exceeded timeout which caused object to be reset."
}

BBhadoo I really need more storage. Why Cloudflare isn't responding to requests. I've be...

M

Matt Silverlock•6/6/23, 10:34 AM

We can increase some limits during the alpha — storage isn’t one of them. From the Limits page:

Note that not all limits can be increased.

The original prototype backend just doesn’t perform well above 100MB. It’s pointless to increase it.

MMozzy Started getting a bunch of these again at 3AM CEST ```json { "message": "D1_ER...

M

Matt Silverlock•6/6/23, 10:34 AM

Which backend?

MMatt Silverlock Which backend?

M

Mozzy•6/6/23, 10:35 AM

Experimental

MMozzy Experimental

M

Matt Silverlock•6/6/23, 10:35 AM

Gonna need more details than that. DB ID? What were you trying to do?

MMatt Silverlock Gonna need more details than that. DB ID? What were you trying to do?

M

Mozzy•6/6/23, 10:37 AM

ID:

e68dccd4-7bf7-4860-ba18-17978966ec10

e68dccd4-7bf7-4860-ba18-17978966ec10

Error comes from first two POSTs here: https://github.com/leonlarsson/bfstats-api/blob/main/handlers/D1Handler.ts#L105
I'll try try dig up more info

MMozzy ID: `e68dccd4-7bf7-4860-ba18-17978966ec10` Error comes from first two POSTs here...

M

Matt Silverlock•6/6/23, 10:40 AM

Query looks pretty basic. Is this 100% of the time? 50%?

M

Mozzy•6/6/23, 10:40 AM

Much much less

M

Mozzy•6/6/23, 10:40 AM

Maybe 2%

M

Mozzy•6/6/23, 10:40 AM

Looking into if it's happening due to the username

M

Mozzy•6/6/23, 10:43 AM

Nope, nothing weird with the data. Just regular latin characters and short strings

M

Mozzy•6/6/23, 10:45 AM

Actually seeing errors from https://github.com/leonlarsson/bfstats-api/blob/main/handlers/D1Handler.ts#L152 as well, which the simplest query imaginable

M

Mozzy•6/6/23, 11:00 AM

Just got the errors again on POST /d1/users and /d1/outputs

Bbennycondon I'm running the command: ``` wrangler d1 execute DB --file=./migrations/16739100...

M

mukhtharcm•6/6/23, 12:14 PM

Did you got any solution?

Mmukhtharcm Did you got any solution?

M

Matt Silverlock•6/6/23, 12:20 PM

You should update to the latest wrangler first, especially if you’re not on v3+

MMozzy Nope, nothing weird with the data. Just regular latin characters and short strin...

M

Matt Silverlock•6/6/23, 12:23 PM

It won’t be the queries. Yours are trivial. Likely a bug on our side. The new storage subsystem is still, well, new

BBhadoo Also can i bind more than one database in wrangler.toml file and if yes, then ho...

A

Adi•6/6/23, 12:50 PM

Yes, this is how I've done it

[[ d1_databases ]]
binding = "__D1_BETA__DB_ONE"
database_name = "db-one"
database_id = "<someID>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-one"


[[ d1_databases ]]
binding = "__D1_BETA__DB_TWO"
database_name = "db-two"
database_id = "<someId>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-two"

[[ d1_databases ]]
binding = "__D1_BETA__DB_ONE"
database_name = "db-one"
database_id = "<someID>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-one"


[[ d1_databases ]]
binding = "__D1_BETA__DB_TWO"
database_name = "db-two"
database_id = "<someId>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-two"

[[ d1_databases ]]
binding = "__D1_BETA__DB_ONE"
database_name = "db-one"
database_id = "<someID>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-one"


[[ d1_databases ]]
binding = "__D1_BETA__DB_TWO"
database_name = "db-two"
database_id = "<someId>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-two"

[[ d1_databases ]]
binding = "__D1_BETA__DB_ONE"
database_name = "db-one"
database_id = "<someID>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-one"


[[ d1_databases ]]
binding = "__D1_BETA__DB_TWO"
database_name = "db-two"
database_id = "<someId>"
migrations_table = "d1_migrations"
migrations_dir = "d1_migrations/db-two"

Anyone know of any simple ORMs that are compatible with D1?

Similar Threads