lets just hope "workers for platforms" works on pages too once i get 50k paying users π
lets just hope "workers for platforms" works on pages too once i get 50k paying users 
TYou can sharding your database by username or date of birth or registered month, btw 300k+ db is a crazy large amount of db to manage
TIt would be nice if they add logpush support for pages function, i think that's more important than
RYea was wondering if they are going to do pages for platforms or something similar for hosting your users frontend pages
FPages and workers are going to be unified, how much and when we dont know, but its coming 
TI'm out of the loop, what is worker/pages for platform?
RCloudflare Docs
This guide will instruct you on setting up Workers for Platforms. You will configure a dispatch namespace, a dynamic dispatch Worker and a user Worker β¦
RPages for platforms doesn't exist afaik
MWorkers for Platforms + Pages + SSL for SaaS covers a lot of potential "Pages for Platforms" use cases tbh
Mlike if you offered some sort of hosted blog service, you'd have a single Pages app connected to a DB and use SSL for SaaS to configure the custom domains, maybe Workers for Platforms for custom logic on top
Rya I use SSL for sass now on my domain so customers can point their custom domains
LHello guys i just wondering whichh orm lib you guys are using with d1?
Rdrizzle
LI use drizzle too but i like some things like typeorm :v
Rtbh I've been usin "nuxt hub" which has all the cloudflare stuff baked in and it was super easy to setup https://hub.nuxt.com/docs/getting-started
BMorning guys, is it possible to create a multi tenant database with D1? Do you have some article or demo on github with this approach? Thanks!
Tis there anyway to perform spatial queries in D1? Considering a switch from Postgres for a new project but worried I won't be able to perform a common query:
Find a row that is closest to the user's positionOh i get it, it's like aws outpost
MWith the initial support for Python + Workers (https://blog.cloudflare.com/python-workers), we've put together a brief example on how to query D1 from Python: https://developers.cloudflare.com/d1/examples/query-d1-from-python-workers/
Cloudflare Docs
The Cloudflare Workers platform supports multiple languages, including TypeScript, JavaScript, Rust and Python.
MNot yet, but looking into supporting: https://vxtwitter.com/elithrar/status/1774819539261255950?s=20
vxTwitter / fixvxTwitter
@ipsumhh @Cloudflare D1 already supports full-text search: you can use the SQLite FTS5 extension out-of-the-box: https://www.sqlite.org/fts5.html
0
- which also has a trigram tokenizer.
0
EI mean they've got RPC which works fine for transactions.
EI'll admit at being disappointed seeing that requirement if you need to go above 50k instances, depending on the use case 50k instances is quite easy to reach (eg something with a freemium model), I wouldn't mind paying for the involved read/writes/storage, but enterprise contracts are pricey and would put me off switching to D1 even when dynamic bindings are available due to that, it's just too much unknown price wise to commit to that kind of vendor lock in.
EBut congrats on reaching GA! I know it's been a lot of work getting here and I'm excited to see how D1 continues to grow over the next year :MeowHeartCloudflare:
THonestly how can you reach 50k db? I'm just curious
Rif 1 user getting their own db , 50k users
THi, I am looking to migrate from Neon to D1 so that I can bind Pages functions to them directly. My database stores a lot of texts (which is auto compressed by Postgres). Does D1 supports auto compression?
MFYI: Prisma ORM support for D1 in preview: https://vxtwitter.com/prisma/status/1775170363791425667?s=46
vxTwitter / fixvxTwitter
Prisma ORM v5.12.0 just dropped!
Here's what's new:
Cloudflare D1 Support (Preview)
https://github.com/prisma/prisma/releases/tag/5.12.0
57 
6
Prisma ORM v5.12.0 just dropped!Here's what's new:
Cloudflare D1 Support (Preview) createMany()https://github.com/prisma/prisma/releases/tag/5.12.0
57 6TI will not sharding like that tho..., i will shard it by date of birth, date of registration or anything like that (i used to do that in dynamo db to reduce costs), but in another way i usually split the app into many small business logic and create a database for each of them.
TBtw while designing the system i will try to store data as much as possible in s3 (sacrifice a bit of convenient) to make the db light and fast
TOnly metadata are stored and query in db
TMight not be the brightest idea but it saves me a lot of money on aws
EYeah pretty much what rob said, eg my service has a free tier, so those users are low revenue, but also low read/write/storage, so a traditional monolithic db is generally fine, just need to upgrade the size when necessary. D1 would be significantly better though for auto-scaling and data separation concerns (once dynamic binding and tooling is in place to manage the schema of that many instances).
RWorkers for platforms ups the limits , maybe reach out to someone and see what the requirments are to get that enabled
EThere's workarounds I could do to use D1 today, like sharing dbs between users as you said, but I'm using postgres right now and rely on RLS to keep data separate, I'd rather have a guarantee of data separation rather than refactor everything to make sure data is separate (alongside the risk of developer error in the future potentially leaking data), but that's my personal preference.
EIt's the kind of thing where once I'd be fine signing up for an ent contract I'll consider it, but by that point it becomes even more work to migrate over to D1 that I'll likely have higher priorities unless I was facing technical issues with my current setup.
FOr skip freemium, i only have 5usd users, Meaning 250k mrr.. im sure i can affiord enterprise once the limit is reached.
.. waiting on dynamic binding
.. waiting on dynamic binding
BNot d1 related much but how do you guys deal with dates those that use drizzle? Simple createdAt column with CURRENT_TIMESTAMP as default doesnβt work for me
BIt gives βInvalid dateβ upon data retrieval
MDrizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
Bty worked
VAre you able to use the limit request form to get increased per database now? Iβm happy with no replicas as a tradeoff, just want to be future proof with more storage.
MAll existing databases (if you have a paid Workers plan) can grow to 10GB each - https://developers.cloudflare.com/d1/platform/changelog/#d1-is-generally-available
Cloudflare Docs
D1 is now generally available and production ready. Read the blog post for more details on new features in GA and to learn more about the upcoming D1 β¦
VAre you able to request a limit beyond that or is it still a hard-coded value like in the beta?
MWe donβt currently increase that limit - itβs not that itβs hard coded, itβs that we have a very (very) high bar for performance & cold starts.
Weβre continuing to work on raising it over time - and as we do itβll just work. But also unlikely a single D1 DB will be 100GB (which is a large transactional DB by any standard)
Weβre continuing to work on raising it over time - and as we do itβll just work. But also unlikely a single D1 DB will be 100GB (which is a large transactional DB by any standard)
MKeep in mind that a 10GB database storing user records @ 1KB per row = 10M users.
VThat's fair yeah, we're considering a serverless migration at work and our current DB is 108GB (we can't split by user with our use case) so size is the issue
Tdoes SQLite View improve query speed? I'm not planning to join view with anything else
RSame here. I tried specify a region and it works.
