Cloudflare Developers•16mo ago

This isn’t necessary, prepared statements in your Worker are just a JS class.

kianOP•9/15/24, 12:24 PM

(calling prepare never talks to your DB yet, only when you run it)

kianOP•9/15/24, 12:25 PM

All of the statement reuse is handled by D1 itself.

Ephemeros•9/15/24, 12:51 PM

what's the standard way of initializing a database's values? would that be in a migration sql?

Ephemeros•9/15/24, 12:51 PM

like, i want to seed some default admin user etc

Deep•9/15/24, 2:40 PM

hi is there anyway to sync a local sqlite db for a desktop app with D1?

Kkian This isn’t necessary, prepared statements in your Worker are just a JS class.

yeeet•9/15/24, 2:54 PM

Thanks

cosbgn•9/15/24, 4:55 PM

Has cloudflare ever thought about allowing https://github.com/asg017/sqlite-vec on D1?

I know about vectorize, but having everything as simple as SQLITE would be unbeatable. I know turso does it and it seems to work very well.

cosbgn•9/15/24, 4:56 PM

it would allow for much better metadata filtering etc having the whole power of SQL

cosbgn•9/15/24, 5:05 PM

Can I get it to work simply using: npm:sqlite-vecnpm:sqlite-vec?
Like on this: https://alexgarcia.xyz/sqlite-vec/js.html

Ccosbgn Can I get it to work simply using: `npm:sqlite-vec`? Like on this: https://alexg...

kianOP•9/15/24, 5:20 PM

On Workers? No, you won't be able to use that package.

Vijin•9/16/24, 5:29 AM

Hi, i am new to D1, i would like to use D1 for my production application. Can you guys please give a clarification on the below doubts
1. Is D1 Production Ready?
2. Saw that D1 has a maximum size limit of 10GB per Database in paid plan. Can we upgrade that?

Dinfer•9/16/24, 8:17 AM

Is transaction supported in future?

DDinfer Is transaction supported in future?

oof2win2•9/16/24, 9:37 AM

it's on the roadmap. the intention is that transactions are ran next to the db https://blog.cloudflare.com/whats-new-with-d1/

VVijin Hi, i am new to D1, i would like to use D1 for my production application. Can yo...

Isaac McFadyen•9/16/24, 11:14 AM

Production ready: yes, D1 is Generally Available.
Maximum limit: no, cannot be raised. The intention is that you use multiple smaller DBs (i.e. one per customer) instead of one large one, as the infrastructire is designed for many smaller individual DBs.

0x146231489231923•9/16/24, 11:32 AM

can i connect to d1 from any client?

00x146231489231923 can i connect to d1 from any client?

Isaac McFadyen•9/16/24, 12:01 PM

You can either use a Worker or the Cloudflare REST API (which is rate-limited and slower than a Worker binding). There's no "connection string" or similar though, because SQLite doesn't have a standardized connection protocol. You'll need to write anything that connects to D1 outside a Worker yourself.

0x146231489231923•9/16/24, 2:39 PM

so the best scenario is query inside worker?

IIsaac McFadyen Production ready: yes, D1 is Generally Available. Maximum limit: no, cannot be r...

boop•9/16/24, 3:21 PM

Dynamic bindings when

Deep•9/16/24, 3:23 PM

hi is there anyway to sync a local sqlite db for a desktop app with D1?

Bboop Dynamic bindings when 😭

�

𝓈𝒽𝓎•9/16/24, 3:27 PM

:NotLikeThis:

Bboop Dynamic bindings when 😭

oof2win2•9/16/24, 4:10 PM

i bet on cf birthday week

oof2win2•9/16/24, 5:56 PM

once

oof2win2•9/16/24, 5:56 PM

also probably use r2 for logs

Original message was deleted

oof2win2•9/16/24, 5:58 PM

the reason theres a limit and you will be forced to use dynamic bindings is just filesize. its not practical to load a 10gb file for a database for every request

oof2win2•9/16/24, 5:59 PM

you wouldnt load all 10 at once

oof2win2•9/16/24, 5:59 PM

then yes i guess lol

�

𝓈𝒽𝓎•9/17/24, 10:42 AM

is anyone already sharding? I'm interested on how would that work what if I had to query customer's info that lived in two separate db's

神

神龙出海•9/17/24, 2:42 PM

Error: D1_ERROR: Network connection lost.

神

神龙出海•9/17/24, 2:43 PM

神

神龙出海•9/17/24, 2:44 PM

The database is not connected again: 339c818f-a6d1-44c7-b860-32cfb8564809

davey•9/17/24, 8:02 PM

is there a roadmap for dynamic bindings?

davey•9/17/24, 8:04 PM

bc otherwise unsure how to get around db limit

Ddavey is there a roadmap for dynamic bindings?

o7•9/17/24, 8:25 PM

I'm waiting for birthday week where they mighttttt announce it

Acе•9/19/24, 12:15 PM

Looks like we’re getting embedded D1 in Durable Objects very soon

Acе•9/19/24, 12:16 PM

https://github.com/cloudflare/cloudflare-docs/pull/16903

Mas Inis•9/20/24, 1:31 AM

Since each D1 database is limited to 10gb. Is there any recommendation to architect our data from cloudflare guys?

IIsaac McFadyen Production ready: yes, D1 is Generally Available. Maximum limit: no, cannot be r...

Mas Inis•9/20/24, 1:38 AM

Hi Isaac, since you are recommending multiple smaller DBs. Is there any guidance to do multiple DBs migration? Also can we bind D1 database dynamically now?

o7•9/20/24, 5:48 AM

Would D1's future implementation of transactions be similar to Durable Object's Transactional Storage API?

I.e. increasing a count a hundred times in a second ensures the count will be at 100.

Jadugar_Jaggu•9/20/24, 10:15 AM

Is there anyone facing some issues with D1 ?

my D1 throwing 1200 error code

Jadugar_Jaggu•9/20/24, 10:17 AM

JJadugar_Jaggu Click to see attachment

boop•9/20/24, 1:50 PM

The error message does say that you are providing an invalid JSON object

Isaac McFadyen•9/20/24, 5:44 PM

Are you inserting JSON into D1 yourself or is that error from D1's internal binding?

Robin Genz•9/21/24, 9:16 AM

Hey

Quick question: Is there an easy way to find the most „expensive“ (most reads/writes) queries in my code (e.g. a list in the Cloudflare dashboard) without manually checking the meta data of every single query?

RRobin Genz Hey 👋🏻 Quick question: Is there an easy way to find the most „expensive“ (most...

boop•9/21/24, 10:10 AM

https://developers.cloudflare.com/d1/observability/metrics-analytics/#query-insights

Cloudflare Docs

Metrics and analytics | Cloudflare D1 docs

D1 exposes database analytics that allow you to inspect query volume, query latency, and storage size across all and/or each database in your account.

naourass•9/23/24, 2:58 AM

Hi all, I'm using Astro.build with the Cloudflare integration and I'm trying to add a staging and a prod database beside the local dev one. Anyone has an idea for how to achieve that so the api endpoints would pick the local db when in dev environment, and the staging or prod db when in the staging or prod db respectively? I've added a different db binding under each environment in

wrangler.toml

wrangler.toml

, but I have no idea and can't find any info for how to make the api endpoint pick the right db on each environment (using locals.runtime.env.DBlocals.runtime.env.DB).

This isn’t necessary, prepared statements in your Worker are just a JS class.

Similar Threads

Similar Threads

Similar Threads