What does the meta of the D1 result give for timing?

D

Dudu•1/14/24, 12:25 AM

Heyo, I'm having an issue where the sql command I execute on console works but on the code it doesn't

D

Dudu•1/14/24, 12:26 AM

On console working

D

Dudu•1/14/24, 12:26 AM

On code, this returns nothing

C

Cyb3r-Jak3OP•1/14/24, 12:28 AM

Is this running locally via wrangler dev? If so then wrangler dev doesn't use the remote resources like the D1 database. You can run your worker with

--remote

--remote

to use the remote resources which does cost or add your data manually locally

D

Dudu•1/14/24, 12:29 AM

I'm running with dev --remote

D

Dudu•1/14/24, 12:29 AM

I double checked that, not making the same mistake again xD

D

Dudu•1/14/24, 12:30 AM

I tried deploying and using the deployed URL and nothing either

D

Dudu•1/14/24, 1:25 AM

Oh

D

Dudu•1/14/24, 1:25 AM

Let me try that

Original message was deleted

D

Dudu•1/14/24, 1:31 AM

This did it, thanks! Much appreciated

Original message was deleted

K

kw•1/14/24, 7:29 AM

will doing this result in sql injection if data is supplied by user and not sanitizing the data?

<

<Alterion.Dev>•1/14/24, 11:02 AM

What would be the easiest way to test queries on D1? I'm trying to figure out how to use the json queries, but it feels like updating a worker to be able to "evaluate" a query is a little sub-par. Is there anything like the typical db management app/service, like DB Browser for SQLite, phpmyadmin, pgadmin, etc?

<

<Alterion.Dev>•1/14/24, 11:03 AM

~~ah! https://github.com/JacobLinCool/d1-manager might be what I'm looking for~~ nope, that's too complex and also doesn't seem to work

<

<Alterion.Dev>•1/14/24, 11:40 AM

Ah, the console didn't show more than the

/help

/help

/help

/help commands and such, so it's not clear that queries can be made here

<

<Alterion.Dev>•1/14/24, 11:41 AM

I was already developing the worker locally (so not deploying changes) but it still felt sort of odd to be dealing with code this way rather than to have some actual DB interface.

<

<Alterion.Dev>•1/14/24, 11:42 AM

might be worth considering having something like a typical admin for D1, even if it's local (I'd put that on my own plate but it's really full at the moment)

<

<Alterion.Dev>•1/14/24, 11:42 AM

yeah I just tried to run that and it seems broken.

<

<Alterion.Dev>•1/14/24, 11:43 AM

I deployed it and it' sjust giving a 404. and locally it fails to install due to not being properly setup for vite 5 (or not being properly setup for the vite dep being 4.x)

<

<Alterion.Dev>•1/14/24, 12:12 PM

Is there any way to do something like this? I'm getting a syntax error, I'm not very familiar with.. "sub-queries", if that's what this is called?

SELECT json_valid(SELECT value FROM sessions WHERE key = 'test');

SELECT json_valid(SELECT value FROM sessions WHERE key = 'test');

SELECT json_valid(SELECT value FROM sessions WHERE key = 'test');

SELECT json_valid(SELECT value FROM sessions WHERE key = 'test');

<

<Alterion.Dev>•1/14/24, 12:13 PM

oh of course I find the solution 2 seconds later.

SELECT json_valid((SELECT value FROM sessions WHERE key = 'test'));

SELECT json_valid((SELECT value FROM sessions WHERE key = 'test'));

SELECT json_valid((SELECT value FROM sessions WHERE key = 'test'));

SELECT json_valid((SELECT value FROM sessions WHERE key = 'test'));

CCyb3r-Jak3 What does the meta of the D1 result give for timing?

A

Arma•1/14/24, 1:31 PM

I updated the code with more logs but did not get a cold start. I'll report later

C

C J•1/14/24, 3:05 PM

I’m trying to use D1 from a Service Worker. Is this supported or does D1 require ES Modules?

I’m getting an error “D1 bindings require module-format [object Object]” while attempting to deploy, and Service Worker vs ES Modules is my best guess as to the cause. I’m using a Service Worker, following the Kotlin example

K

kian•1/14/24, 3:05 PM

does D1 require ES Modules?

Yep

C

C J•1/14/24, 3:06 PM

Thank you! I couldn’t find that requirement in the documentation.

S

Spuckwaffel•1/14/24, 8:25 PM

hey there, is there any way to check after creating a table that any column i created is specified as a primary key?

G

Gagan Suie•1/15/24, 4:15 AM

Hi, is there a way to grant devs access to remote dev DB without them registering to cloudflare and login via cli?

M

mian.m.arslan•1/15/24, 6:46 AM

Hi, I am using drizzle Orm and create migration using drizzle-kit.
Can anyone tell me how can i run this to remove D1. Because for now D1 dosent show me that table.

<<Alterion.Dev>Ah, the console didn't show more than the `/help` commands and such, so it's not...

M

Max (@rozenmd)•1/15/24, 8:30 AM

this is useful feedback, will fix

C

cojo•1/15/24, 8:14 PM

Is there an easy way to confirm the SQLite version underneath D1? I couldn’t find anything on the docs. I ask because I’m curious how up to date it is kept.
In particular I’m curious if the new addition of JSONB support in today’s release can be expected to be integrated into D1 in a reasonable timeframe, or if we should expect it to lag by quarters / halves / years, if ever.

K

kian•1/15/24, 8:18 PM

It was 3.40.0 for a long time and it got bumped to 3.44.0 around November

K

kian•1/15/24, 8:20 PM

It was around 7-8 months for that bump to happen, but that's a sample size of 1 since it was introduced into the runtime as 3.40.0.

GGagan Suie Hi, is there a way to grant devs access to remote dev DB without them registerin...

G

Gagan Suie•1/15/24, 8:35 PM

nevermind. just going to use local.

npx wrangler d1 execute deebee --local --file=./schema.sql

npx wrangler d1 execute deebee --local --file=./schema.sql

npx wrangler d1 execute deebee --local --file=./schema.sql

npx wrangler d1 execute deebee --local --file=./schema.sql

A

Arturo•1/16/24, 12:39 AM

Hey guys, I'm trying to setup D1 on my wrangler on an existing proxy worker that I have this:

main = "worker.ts"
account_id = "123" # Cloudflare account id
compatibility_date = "2023-10-13"

[env.prod]
name = "road2crypto-router-prod"
routes = [
    { pattern = "api.road2crypto.com", custom_domain = true }
]

[env.dev]
name = "road2crypto-router-dev"
routes = [
    { pattern = "api.dev.road2crypto.com", custom_domain = true }
]

main = "worker.ts"
account_id = "123" # Cloudflare account id
compatibility_date = "2023-10-13"

[env.prod]
name = "road2crypto-router-prod"
routes = [
    { pattern = "api.road2crypto.com", custom_domain = true }
]

[env.dev]
name = "road2crypto-router-dev"
routes = [
    { pattern = "api.dev.road2crypto.com", custom_domain = true }
]

main = "worker.ts"
account_id = "123" # Cloudflare account id
compatibility_date = "2023-10-13"

[env.prod]
name = "road2crypto-router-prod"
routes = [
    { pattern = "api.road2crypto.com", custom_domain = true }
]

[env.dev]
name = "road2crypto-router-dev"
routes = [
    { pattern = "api.dev.road2crypto.com", custom_domain = true }
]

main = "worker.ts"
account_id = "123" # Cloudflare account id
compatibility_date = "2023-10-13"

[env.prod]
name = "road2crypto-router-prod"
routes = [
    { pattern = "api.road2crypto.com", custom_domain = true }
]

[env.dev]
name = "road2crypto-router-dev"
routes = [
    { pattern = "api.dev.road2crypto.com", custom_domain = true }
]

I tried adding this in a new line:

[[env.dev.d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "road2crypto-db"
database_id = "123"

[[env.dev.d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "road2crypto-db"
database_id = "123"

[[env.dev.d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "road2crypto-db"
database_id = "123"

[[env.dev.d1_databases]]
binding = "DB" # i.e. available in your Worker on env.DB
database_name = "road2crypto-db"
database_id = "123"

but it says:

✘ [ERROR] A request to the Cloudflare API (/accounts/123/workers/scripts/road2crypto-router-dev) failed.

  D1 bindings require module-format workers. [code: 10021]

✘ [ERROR] A request to the Cloudflare API (/accounts/123/workers/scripts/road2crypto-router-dev) failed.

  D1 bindings require module-format workers. [code: 10021]

✘ [ERROR] A request to the Cloudflare API (/accounts/123/workers/scripts/road2crypto-router-dev) failed.

  D1 bindings require module-format workers. [code: 10021]

✘ [ERROR] A request to the Cloudflare API (/accounts/123/workers/scripts/road2crypto-router-dev) failed.

  D1 bindings require module-format workers. [code: 10021]

How can I bind it?
Thanks

K

kian•1/16/24, 12:40 AM

Is

worker.ts

worker.ts

using

addEventListener

addEventListener

or

export default

export default

?

A

Arturo•1/16/24, 12:40 AM

worker.ts

A

Arturo•1/16/24, 12:43 AM

If I add the name like this

[[d1_databases]]

[[d1_databases]]

[[d1_databases]]

[[d1_databases]] it then displayes a warning saying that I have to attach

env.dev

env.dev

env.dev

env.dev to it, but it doesn't bind it anyway

A

Arturo•1/16/24, 12:53 AM

ah excuse my ignorance lol, it would be event listener:

addEventListener("fetch", (event: FetchEvent) => {
    event.respondWith(handleRequest(event.request));
});

async function handleRequest(request: Request): Promise<Response> {
    

    return handleResponse(request);
}

addEventListener("fetch", (event: FetchEvent) => {
    event.respondWith(handleRequest(event.request));
});

async function handleRequest(request: Request): Promise<Response> {
    

    return handleResponse(request);
}

addEventListener("fetch", (event: FetchEvent) => {
    event.respondWith(handleRequest(event.request));
});

async function handleRequest(request: Request): Promise<Response> {
    

    return handleResponse(request);
}

addEventListener("fetch", (event: FetchEvent) => {
    event.respondWith(handleRequest(event.request));
});

async function handleRequest(request: Request): Promise<Response> {
    

    return handleResponse(request);
}

A

Arturo•1/16/24, 12:53 AM

This is a proxy I use for my other api requests I was hoping to reuse it and just add another path for the D1

P

Patrick•1/16/24, 1:09 AM

Just migrated my pages function storage from KV to D1, looking dope y'all, love it

Original message was deleted

A

Arturo•1/16/24, 1:22 AM

thanks, I think I'm going to have to create a new worker for D1 interaction because the ES module syntax is breaking some changes of the proxy such as retrieving secrets.
Thanks for the help, I'll give the tutorial a try
Update: I was able to connect it to a new worker, it's a shame I couldn't reuse the old one without overhead :/

V

villainy•1/16/24, 12:47 PM

has anyone tried inserting a very large table into D1? i just get stuck in this stage:

V

villainy•1/16/24, 12:48 PM

its been like this for 20 or so min

V

villainy•1/16/24, 12:48 PM

cant really tell if its stuck or doing something

V

villainy•1/16/24, 12:48 PM

would love some more logging.

sql file is 400mb for context

V

villainy•1/16/24, 1:41 PM

nvm found the limits:
https://developers.cloudflare.com/d1/platform/limits/

V

villainy•1/16/24, 1:41 PM

guess il switch to Turso

D

disaster.js•1/16/24, 2:23 PM

Is spellfix1 unsupported? I'm getting 'not authorized' error message

What does the meta of the D1 result give for timing?

Similar Threads

Similar Threads

Similar Threads