hi guys, is there any cache solution for D1 select query? With MySQL I can cache query by using Prox

hi guys, is there any cache solution for D1 select query? With MySQL I can cache query by using ProxySQL.

PohKit•3/23/24, 5:01 PM

Hi guys,

Was exploring options between D1, PlanetScale & ManagedDB by Digital Ocean.

Just wanted to check has anyone tried with D1 x PHP/Laravel with this repo:
https://github.com/renoki-co/l1

I've created a Laravel project, written some basic API.

But seems like the Latency is high eg: 1,500ms ~ 2,000ms

Just wanted to confirm that, is D1 Laravel/PHP friendly?

GitHub

GitHub - renoki-co/l1: Extend your PHP/Laravel application with Clo...

Extend your PHP/Laravel application with Cloudflare bindings. - renoki-co/l1

TTony Leung hi guys, is there any cache solution for D1 select query? With MySQL I can cache...

squareclamp•3/23/24, 11:34 PM

Not sure if there is anything out of the box, but you can look at the cache api - https://developers.cloudflare.com/workers/runtime-apis/cache/

Cloudflare Docs

Cache · Cloudflare Workers docs

Control reading and writing from the Cloudflare global network cache.

x03•3/24/24, 4:12 AM

How do I apply migrations on my production database? To apply local migrations, I just run:

bun wrangler d1 migrations apply db_preview --local

bun wrangler d1 migrations apply db_preview --local

This is a SvelteKit pages app.

x03•3/24/24, 4:13 AM

And my wrangler.toml if needed:

[[d1_databases]]
binding = "DB"
database_name = "db_preview"
database_id = "db_preview"
migrations_dir = "./drizzle"

[[d1_databases]]
binding = "DB"
database_name = "db_preview"
database_id = "db_preview"
migrations_dir = "./drizzle"

Xx03 How do I apply migrations on my production database? To apply local migrations, ...

predaytor•3/24/24, 9:49 AM

there is

--remote

--remote

flag

melodyclue•3/24/24, 2:25 PM

Hi, Is this compatible with remix+vite?　https://developers.cloudflare.com/d1/examples/d1-and-remix/

Cloudflare Docs

Query D1 from Remix · Cloudflare D1 docs

Remix is a full-stack web framework that operates on both client and server. You can query your D1 database(s) from Remix using Remix’s data loading …

mw10013•3/24/24, 3:38 PM

Yes, that works with remix+vite. I found that it’s not necessary to specify the bindings in the command line when running locally. Just let ‘remix vite:dev’ pick them up from wrangler.toml and include the local bindings in the wrangler.toml. I put together the cloudflare example for ‘remix-auth-totp’ that uses drizzle with d1 that has the local bindings in wrangler.toml. https://github.com/mw10013/remix-auth-totp-cloudflare-example

GitHub

GitHub - mw10013/remix-auth-totp-cloudflare-example

Contribute to mw10013/remix-auth-totp-cloudflare-example development by creating an account on GitHub.

F0rce•3/24/24, 6:16 PM

I thought this was fixxed some time ago :MonkaHmm: https://github.com/cloudflare/workers-sdk/issues/3160#issuecomment-2010837504

GitHub

🐛 BUG: when trying to left join 2 tables that have same name column...

Which Cloudflare product(s) does this pertain to? D1 What version of Wrangler are you using? 2.19.0 What operating system are you using? macOS Describe the Bug As per issue #555 we can see, that d1...

FF0rce I thought this was fixxed some time ago :MonkaHmm: https://github.com/cloudflare...

Matt Silverlock•3/24/24, 9:44 PM

Just a bug in local mode (unfortunately). raw() was fixed back in Feb https://developers.cloudflare.com/d1/platform/changelog/#api-changes-to-raw-all-and-run

Cloudflare Docs

Changelog · Cloudflare D1 docs

As of wrangler@3.33.0, wrangler d1 execute and wrangler d1 migrations apply now default to using a local database, to match the default behavior of …

MMatt Silverlock Just a bug in local mode (unfortunately). raw() was fixed back in Feb https://de...

F0rce•3/24/24, 9:45 PM

wait so local development and remote development (in this scenario) return different results ?

F0rce•3/24/24, 9:45 PM

i knew that it was fixxed, but I would not deploy to prod without proper testing locally.

bun•3/25/24, 2:17 AM

does count(*)count(*) consume reads on how many items there actually are counted ?

Aim Salam•3/25/24, 7:10 AM

#d1-beta is it possible cloudflare D1 will have unlimited size per database?

AAim Salam #d1-beta is it possible cloudflare D1 will have unlimited size per database?

DaniFoldi•3/25/24, 8:28 AM

unlikely in my opinion to have unlimited sizes anytime soon

AAim Salam #d1-beta is it possible cloudflare D1 will have unlimited size per database?

Max (@rozenmd)•3/25/24, 8:55 AM

D1 is built to work to the strengths of Cloudflare's network, so we can't offer extremely large databases while also loading them quickly. It's significantly easier for us to offer millions of DBs with a size limit instead.

The limit is currently 2GB and we're working towards making it 10GB - but D1 will require a change in how you think about your project's data if you're looking to build a big platform. Instead of storing all of your data in a single DB, you would store each customer's data in their own DB (and we're building tooling to make it easier to dynamically access multiple DBs in a single Worker without redeploying)

MMax (@rozenmd)D1 is built to work to the strengths of Cloudflare's network, so we can't offer ...

Aim Salam•3/25/24, 8:58 AM

Thank you for the response. I'm very excited what D1 can do in the future. I'm looking forward to it

Max (@rozenmd)•3/25/24, 8:59 AM

also if you want to stick to the old model (one single big db), we have Hyperdrive for that: https://developers.cloudflare.com/hyperdrive/

Revan•3/25/24, 9:01 AM

hi, does cf d1 support/implement the generate_seriesgenerate_series function of sqlite?

RRevan hi, does cf d1 support/implement the `generate_series` function of sqlite?

Max (@rozenmd)•3/25/24, 9:06 AM

doesn't look like we've enabled that extension yet, if you file a feature request for it here, that'd be awesome: https://github.com/cloudflare/workerd/issues

Revan•3/25/24, 9:11 AM

sure, will do

Revan•3/25/24, 9:21 AM

I made the issue here: https://github.com/cloudflare/workerd/issues/1888

wasnt really sure what to write

RRevan I made the issue here: https://github.com/cloudflare/workerd/issues/1888 wasnt ...

Max (@rozenmd)•3/25/24, 9:53 AM

perfect, thank you!

sabin•3/25/24, 1:42 PM

how does d1 compare to turso?

sabin•3/25/24, 1:42 PM

couldnt find anything online abt it

AAaronO Could you elaborate a little on the eager load proportional to DB size ? As an ...

Max (@rozenmd)•3/25/24, 5:55 PM

Probably a better question for @kenton (when they're around)

MMax (@rozenmd)D1 is built to work to the strengths of Cloudflare's network, so we can't offer ...

itsmatteomanf•3/25/24, 5:58 PM

The biggest limit here (but I know you are working on it, so hopefully soon it gets fixed) is that you can't dynamically connect to a database.
If I have millions of users, how can I configure a database per user (if I can work around the limits that cross-user queries are impossible, at the moment) and reach it via Workers?

AAaronO Could you elaborate a little on the eager load proportional to DB size ? As an ...

kenton•3/25/24, 6:10 PM

The way you are imagining it works is the way D1 v1 and v2 worked... which turned out to be way too slow. In v3 we pull the full database down to local disk upfront.

AAaronO Did v1 and v2 use the local disk as cache too ? In the limit, eagerly pulling th...

kenton•3/25/24, 6:19 PM

I believe pages were actually cached in RAM (which is why the database size limit was 100MB). I wasn't closely involved with v1 or v2 though so can't comment in that much detail.

kenton•3/25/24, 6:20 PM

v3 is based on a new storage engine which I described a bit here: https://twitter.com/KentonVarda/status/1659551757796515846

Kenton Varda (@KentonVarda) on X

So I've spent the last ~three months writing a new distributed storage engine based on SQLite and it has been FUN!

https://t.co/NVorwS46x8

Twitter

•

5/19/23, 1:29 PM

kenton•3/25/24, 6:20 PM

(still haven't actually published the alluded blog post, sorry)

dave•3/25/24, 7:21 PM

is there a way to skip to the end of a table in the Cloudflare Dashboard?

dave•3/25/24, 7:22 PM

I have a ton of rows and it's a huge pain

AAaronO Thanks, I'll look forward to the blog post

Isaac McFadyen•3/26/24, 2:27 AM

~~I believe the blog post was already published here: https://blog.cloudflare.com/d1-turning-it-up-to-11~~ Missed the fact that was referencing a yet-unpublished, longer blog post.

Kartoffel🟢🟡🔴•3/26/24, 3:54 PM

Kartoffel🟢🟡🔴•3/26/24, 3:54 PM

cannot load d1

Original message was deleted

Kartoffel🟢🟡🔴•3/26/24, 3:55 PM

thanks

KKartoffel🟢🟡🔴Click to see attachment

Max (@rozenmd)•3/26/24, 4:13 PM

it's back

Jan Piotrowski (janpio)•3/26/24, 10:10 PM

Is there a suggested way to "export" the schema of a remote D1 database to use it locally?

JJan Piotrowski (janpio)Is there a suggested way to "export" the schema of a remote D1 database to use i...

Max (@rozenmd)•3/27/24, 5:22 AM

natively, there will be soon - until then there's https://github.com/nora-soderlund/cloudflare-d1-backups

MMax (@rozenmd)natively, there will be soon - until then there's https://github.com/nora-soderl...

Jan Piotrowski (janpio)•3/27/24, 9:05 AM

Cool!
Can you share the approach the native solution will be going? CLI command? Library method?

JJan Piotrowski (janpio)Cool! Can you share the approach the native solution will be going? CLI command?...

Matt Silverlock•3/27/24, 1:19 PM

To confirm: do you mean the DB and contents, or just the schema?

MMax (@rozenmd)D1 is built to work to the strengths of Cloudflare's network, so we can't offer ...

RexNormous•3/27/24, 3:18 PM

This DB-per-user vision is very exciting to me and very relevant to my application. I know D1 GA had been mentioned to be coming up soon (this or next month). Is this "sharding" of databases further out than that, and not something we should bank on anytime soon?

I'm actively working on migrating my application to D1 and wondering if sharding is something I can be planning for now as I migrate.

RRexNormous This DB-per-user vision is very exciting to me and very relevant to my applicati...

Max (@rozenmd)•3/27/24, 3:30 PM

We have folks using it already via a rather clunky user asks for a db -> create a new d1 db via api -> update worker script bindings via apiuser asks for a db -> create a new d1 db via api -> update worker script bindings via api workflow, but we'll be streamlining that as much as possible over the coming weeks/months

hi guys, is there any cache solution for D1 select query? With MySQL I can cache query by using Prox

Similar Threads

Similar Threads

Similar Threads