Cloudflare Developers•3y ago

does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s)

kian•10/30/23, 7:04 AM

I imagine you're going to hit the constraints of D1/Durable Objects before hitting the constraints of SQLite.

IIdkWhatever69 does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s...

Matt Silverlock•10/30/23, 10:02 AM

You can write (depending on the query complexity, tables, indexes) far more than 1-2k rows per second.

MMatt Silverlock You can write (depending on the query complexity, tables, indexes) far more than...

omar4289•10/30/23, 10:03 AM

Do we have exact metrics on how many are possible/how many was used to test the load of d1

Oomar4289 Do we have exact metrics on how many are possible/how many was used to test the ...

Matt Silverlock•10/30/23, 10:05 AM

No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. You can write millions of rows per second in many, many cases.

MMatt Silverlock No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. Yo...

omar4289•10/30/23, 10:06 AM

I know, but just wondering if you could share the results you have, even if it is for simple queries

omar4289•10/30/23, 10:07 AM

Currently, I am always using simple insert queries in my d1 and delegating complex queries to supabase

Sslagathor Right now I'm using DataGrip with https://github.com/isaac-mcfadyen/d1-jdbc-driv...

Isaac McFadyen•10/30/23, 12:04 PM

Sorry

Isaac McFadyen•10/30/23, 12:04 PM

I've had very little time to maintain it with school being so busy - I'll try to fix some of the outstanding issues if I get the chance sometime soon

JustinNoel•10/30/23, 12:25 PM

Thanks so much to @Isaac McFadyen | YYZ01 for his awesome d1-consoled1-console.

If you're not familiar with it, it lets you query your Cloudflare D1 database from your command line.

https://github.com/isaac-mcfadyen/d1-console

GitHub

GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudf...

A full query console for Cloudflare's D1 database product. - GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudflare's D1 database product.

VViper Like this? ```ts const { results } = await DB.prepare('INSERT INTO users (id, na...

omar4289•10/30/23, 12:43 PM

Should be, if all() does not work, then use run() instead

kian•10/30/23, 1:33 PM

JSONB was in the draft release log for 3.44.0 but isn't in that one, so I imagine it was pulled from that release.

Hearse•10/30/23, 1:54 PM

i am currently using mongodb to store user and their device data, is it a good idea to switch d1?

Dahoom•10/30/23, 1:55 PM

d1 is in beta and has a 2GB per database limit currently

Hearse•10/30/23, 1:55 PM

i am not familiar with sql databases so i am kind of on the fence.

DDahoom d1 is in beta and has a 2GB per database limit currently

Hearse•10/30/23, 1:55 PM

i only have a couple thousand users. The db size is around 600kb in mongodb

Hearse•10/30/23, 1:55 PM

its not much

Hearse•10/30/23, 1:56 PM

i am using the mongodb free tier

Dahoom•10/30/23, 1:57 PM

unless you can somehow horizontally scale it with mutiple d1 dbs, d1 will not be as scalable + there is no replication yet

Dahoom•10/30/23, 1:57 PM

turso has replication and higher size limits

DDahoom unless you can somehow horizontally scale it with mutiple d1 dbs, d1 will not be...

Hearse•10/30/23, 1:58 PM

is there another option i can use, thats not d1 but will be faster than mongo atlas. since i am on the free tier. i would literally have to connect to it in oregon

Hearse•10/30/23, 1:58 PM

i was told by someone i could use hyperdrive or warpdrive i forgot

Dahoom•10/30/23, 1:58 PM

never used it myself

Dahoom•10/30/23, 1:59 PM

but again, turso is sqlite aswell, has a good free tier and you can choose where your DBs are located

DDahoom but again, turso is sqlite aswell, has a good free tier and you can choose where...

Hearse•10/30/23, 1:59 PM

is it edge hosted?

Dahoom•10/30/23, 2:00 PM

yes

DDahoom yes

Hearse•10/30/23, 2:02 PM

ill look into turso and hyperdrive and see whats the best option

Hearse•10/30/23, 2:02 PM

thank you brother

DDahoom but again, turso is sqlite aswell, has a good free tier and you can choose where...

Hearse•10/30/23, 2:28 PM

Sorry not that familiar with dbs, this is a very close example to what the data i store on monogdb looks like, do you think it would translate well with turso? I feel like non-relational dbs might be best for my usecase, what do you think? I do not have any experience with any other db than mongodb. I have not used sql (but that is not a big deal as i am willing to learn if it is acceptable for my use case)

Dahoom•10/30/23, 2:29 PM

you can just create a table with device_name and ios_version column with the device_uuid as the foreign key

Dahoom•10/30/23, 2:30 PM

its a static schema as far as I can tell so it woulkd probably work best in a relational db

DDahoom its a static schema as far as I can tell so it woulkd probably work best in a re...

Hearse•10/30/23, 2:31 PM

static as non changing?

Dahoom•10/30/23, 2:31 PM

but you would have to learn how an relational db works and create a optimized schema for this proccess

HHearse static as non changing?

Dahoom•10/30/23, 2:32 PM

yes

Hearse•10/30/23, 2:32 PM

i constantly have to update devices, and devices can be empty

Hearse•10/30/23, 2:32 PM

if a user connects with a new device, i must append it.

Hearse•10/30/23, 2:34 PM

that shouldnt matter, as far as the fields go. you are right, there are no specific fields that will be added. but there are fields that can be empty for certain users

Hearse•10/30/23, 2:34 PM

for example the user can have no devices

Dahoom•10/30/23, 2:34 PM

thats no problem, just leave it null

Hearse•10/30/23, 2:34 PM

or an array of emails that is empty

Hearse•10/30/23, 2:34 PM

okay great.

Dahoom•10/30/23, 2:35 PM

if you want something to never be null you have to place NOT NULL after the name when creating the column

Hearse•10/30/23, 2:35 PM

got it, and that would be fields such as email

Paul•10/30/23, 2:35 PM

I’m using cloudflare d1 in production and having a great time. I’m a bit nervous though we will hit the storage limit… is there an eta on raising the limit ? Can we just get like 10GB instead of 2GB? that’ll hold us over

Hearse•10/30/23, 2:36 PM

thats all i wanted to know, ill work on converting my mongodb database to curso or d1

DDahoom if you want something to never be null you have to place NOT NULL after the name...

Hearse•10/30/23, 2:37 PM

if u have any tips for doing the above ^ that would be helpful. i saw youtube videos using studio 3t

Dahoom•10/30/23, 2:38 PM

ask gippity to make you a schema

Hearse•10/30/23, 2:38 PM

o yea

Hearse•10/30/23, 2:39 PM

i always forget i got gpt

does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s)

Similar Threads

Similar Threads

Similar Threads