Cloudflare Developers•2y ago

Use ?1 and ?2

布

布鲁诺普雷托OP•7/10/24, 4:48 PM

Also on a console log check the type of each variable

布

布鲁诺普雷托OP•7/10/24, 4:48 PM

It has to be string

VVikash What is `D1_ERROR: Failed to parse body as JSON` i get randomly on my query ```...

布

布鲁诺普雷托OP•7/10/24, 4:48 PM

Perhaps you missed a JSON.parse()

布

布鲁诺普雷托OP•7/10/24, 4:52 PM

Yo cloudflare people, is there any limitation in just using the D1 that comes with Cloudflare, I mean instead of using posgress or wtv... I've just been using env.db.prepare(query) is it enough for most of SQL queries?

布布鲁诺普雷托 Use ?1 and ?2

Vikash•7/10/24, 5:18 PM

The same query is working in production, so no issue in code. I just see 3-4 such errors on global error handler out of 200k requests daily

Vikash•7/10/24, 5:19 PM

The error is D1 type and not in my code

布

布鲁诺普雷托OP•7/10/24, 6:15 PM

MERGE INTO pt_player_tribe AS target
USING (SELECT ?1 AS player_id, ?2 AS tribe_id, ?3 AS world) AS source
ON (target.player_id = source.player_id AND target.world = source.world)
WHEN MATCHED AND target.tribe_id <> source.tribe_id THEN
    UPDATE SET tribe_id = source.tribe_id
WHEN NOT MATCHED THEN
    INSERT (player_id, world, tribe_id)
    VALUES (source.player_id, source.world, source.tribe_id);

MERGE INTO pt_player_tribe AS target
USING (SELECT ?1 AS player_id, ?2 AS tribe_id, ?3 AS world) AS source
ON (target.player_id = source.player_id AND target.world = source.world)
WHEN MATCHED AND target.tribe_id <> source.tribe_id THEN
    UPDATE SET tribe_id = source.tribe_id
WHEN NOT MATCHED THEN
    INSERT (player_id, world, tribe_id)
    VALUES (source.player_id, source.world, source.tribe_id);

Is this ok to run or the Values should also be with "?" ?

Codename_A•7/10/24, 9:21 PM

D1 export is not working. X [ERROR] near "index": syntax error at offset 7

I am confused as the d1 worker is functional so it doesn't make sense that there should be an error when exporting

Ppeshakoo How will read replication work in the future with important atomic/transactional...

Max (@rozenmd)•7/11/24, 5:27 AM

any breaking functionality will be strictly opt-in. code that works today will continue to work tomorrow by default

Ppeshakoo That's cool, as I'd like to opt-in 2/3 of my databases in the future. Any exampl...

Max (@rozenmd)•7/11/24, 5:30 AM

Yeah, we wrote about what we're building here: https://blog.cloudflare.com/building-d1-a-global-database

The Cloudflare Blog

Building D1: a Global Database

D1, Cloudflare’s SQL database, is now generally available. With new support for 10GB databases, data export, and enhanced query debugging, we empower developers to build production-ready applications with D1 to meet all their relational SQL needs

Tarnadas•7/11/24, 7:37 PM

Hey, I've been trying to understand the limitations of D1 when it comes to big integers, but I'm a bit clueless. I have to handle up to 16 byte integers in my application and to my understanding SQLite/D1 only supports 8 byte integer and there is no bigint type. However I've been storing values larger than the max value that can be represented via integer and it didn't throw an error.
How is this possible?

TTarnadas Hey, I've been trying to understand the limitations of D1 when it comes to big i...

i40west•7/11/24, 8:44 PM

If the value doesn't fit in a 64-bit integer it is converted to a REAL type, which is a 64-bit IEEE floating point value. This can precisely represent integers up to 2^53 and -2^53. Beyond that you will lose precision

i40west•7/11/24, 8:46 PM

You can store big integers as text or blob types, in which case the database won't be able to do calculations with them.

Ii40west If the value doesn't fit in a 64-bit integer it is converted to a REAL type, whi...

Tarnadas•7/12/24, 4:14 AM

thx, yeah I think this is happening

RRahul Is there any trigger function in Cloudflare worker when data changes in D1? like...

kraustifer•7/12/24, 5:32 AM

Not currently. They did mention this was a possibility in the future, though

RRahul @kraustifer is there any alternative way to achieve?

森

森@VerseLink (RW)•7/12/24, 6:24 AM

a good workaround might be to have a worker trigger that function when writing to D1 using that worker

Kkraustifer Not currently. They did mention this was a possibility in the future, though

Max (@rozenmd)•7/12/24, 7:58 AM

Yeah it's on the roadmap

RRahul @森@VerseLink Please refer to any docs, I want to trigger the API endpoint when i...

Max (@rozenmd)•7/12/24, 7:59 AM

call your API endpoint directly when your business logic calls your function to create a new item?

Max (@rozenmd)•7/12/24, 7:59 AM

though that doesn't help if you're letting folks use the dashboard to directly edit the DB

RRahul Is there any trigger function in Cloudflare worker when data changes in D1? like...

Matt Silverlock•7/12/24, 10:30 AM

D1 does support SQL based triggers right now, to be clear.

Matt Silverlock•7/12/24, 10:30 AM

CREATE TRIGGERCREATE TRIGGER statements work.

MMax (@rozenmd)call your API endpoint directly when your business logic calls your function to ...

森

森@VerseLink (RW)•7/12/24, 11:19 AM

yeh that's what i had in mind as a suggestion for rahul too
it's more cumbersome but it can work for now

Sam•7/12/24, 3:16 PM

Why is the location not shown within the dashboard? Would be cool to have an easy way to confirm where the D1 is running, and the data is already available in the api.

SSam Why is the location not shown within the dashboard? Would be cool to have an eas...

Max (@rozenmd)•7/12/24, 4:48 PM

good idea, we'll add it

Max (@rozenmd)•7/12/24, 4:48 PM

not everything has an explicit reason btw, sometimes we miss things

森

森@VerseLink (RW)•7/12/24, 9:44 PM

Is there a roadmap of when we can get to Sessions API for D1? As in could we expect it to be released soon, or would it take a while?

Cory•7/13/24, 12:14 AM

Are there any plans to add realtime sync to D1?

Cory•7/13/24, 12:15 AM

Recently ran into https://www.triplit.dev/ which looks very cool

Vijay•7/13/24, 8:43 AM

@Cloudflare (Dev) why there is no rename option for files in my r2 buckets? any specific reasons, I need to rename few files?

VVijay @Cloudflare (Dev) why there is no rename option for files in my r2 buckets? any ...

Hello, I’m Allie!•7/13/24, 9:01 AM

Try #r2

RRahul For example, using a Firebase function, when new user data is saved in Firebase ...

Isaac McFadyen•7/13/24, 3:59 PM

So I think they're suggesting that you just call your API endpoint when creating a new user.

Isaac McFadyen•7/13/24, 3:59 PM

In your example, rather than creating user in the Function -> firebase calls your endpoint, you just create user and then call your endpoint from the same Function.

ZZiga Zajc Any estimates on when the feature to dynamically create multiple databases would...

Hello, I’m Allie!•7/13/24, 7:11 PM

:soontm:

MMax (@rozenmd)good idea, we'll add it

Sam•7/13/24, 7:47 PM

Also — and sorry for mentioning you, it would also be really cool if we could add descriptions to the D1’s. So team members can see what the D1 is exactly for.

Same for R2, queue’s and a single Worker.

森森@VerseLink (RW)Is there a roadmap of when we can get to Sessions API for D1? As in could we exp...

murzin•7/13/24, 8:44 PM

Any updates on this? Would be insanely dope to have replicas for D1

MERGE INTO pt_player_tribe AS target USING (SELECT ?1 AS player_id, ?2 AS tribe_id, ?3 AS world) AS source ON (target.player_id = source.player_id AND target.world = source.world) WHEN MATCHED AND target.tribe_id <> source.tribe_id THEN UPDATE SET tribe_id = source.tribe_id WHEN NOT MATCHED THEN INSERT (player_id, world, tribe_id) VALUES (source.player_id, source.world, source.tribe_id);

Use ?1 and ?2

Similar Threads

Similar Threads

Similar Threads