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

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

DahoomOP•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

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

never used it myself

DahoomOP•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?

DahoomOP•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)

DahoomOP•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

DahoomOP•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?

DahoomOP•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?

DahoomOP•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

DahoomOP•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.

DahoomOP•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

DahoomOP•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

DahoomOP•10/30/23, 2:40 PM

currently its best to lay the foundations of your system with gippity since you dont yet have an idea of what the schema should ideally look like

DDahoom currently its best to lay the foundations of your system with gippity since you ...

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

yea ill do that.

Ttforster Is there any easy way of using the locally installed D1 client from Node for run...

Cyb3r-Jak3•10/30/23, 5:18 PM

Have you looked at https://developers.cloudflare.com/d1/learning/local-development/#test-programmatically ?

Local development · Cloudflare D1 docs

D1 has fully-featured support for local development, running the same version of D1 as Cloudflare runs globally. Local development uses Wrangler, the …

Paul•10/30/23, 5:28 PM

Is there a way to disable foreign key constraints temporarily?

PPaul Is there a way to disable foreign key constraints temporarily?

Matt Silverlock•10/30/23, 8:03 PM

PRAGMA defer_foreign_keys = on

PRAGMA defer_foreign_keys = on

IIsaac McFadyen Sorry 😅

slagathor•10/30/23, 9:15 PM

Don't be sorry! You've helped me out so much!

slagathor•10/30/23, 9:16 PM

Please don't take that "buggy" comment the wrong way. I totally understand how difficult it is to maintain projects.

slagathor•10/30/23, 9:16 PM

You've truly been a lifesaver!

Sslagathor Please don't take that "buggy" comment the wrong way. I totally understand how d...

Isaac McFadyen•10/30/23, 9:55 PM

Haha, no it actually is pretty buggy, I understand that lul

Isaac McFadyen•10/30/23, 9:55 PM

Thank you though, that means a lot

Ttforster I did, but I didn't see any information on connecting to and/or using the D1 cli...

windwp•10/30/23, 11:28 PM

i use my library to unit test on local with better sqlite https://github.com/windwp/kysely-zod-sqlite

GitHub

GitHub - windwp/kysely-zod-sqlite: An flexible api for Cloudflare D...

An flexible api for Cloudflare D1 and sqlite. It has an simple api of Prisma and a powerful query with Kysely. - GitHub - windwp/kysely-zod-sqlite: An flexible api for Cloudflare D1 and sqlite. It ...

dinesh_karuppasamy•10/31/23, 12:12 AM

Can anyone help to resolve this ? I can able to migrate and push the changes to DB by using drizzle-orm. Whereas I am getting this error while pulling data through SQL query

dinesh_karuppasamy•10/31/23, 12:12 AM

[mf:err] Error: D1_ERROR: no such table: users
at D1Database._sendOrThrow (cloudflare-internal:d1-api:66:19)
at async D1PreparedStatement.raw (cloudflare-internal:d1-api:178:32)

Ddinesh_karuppasamy Can anyone help to resolve this ? I can able to migrate and push the changes to ...

Cyb3r-Jak3•10/31/23, 12:26 AM

Did you apply the migrations to either remote or local, depending on your environment

CCyb3r-Jak3 Did you apply the migrations to either remote or local, depending on your enviro...

dinesh_karuppasamy•10/31/23, 12:28 AM

Yes I applied remote. After applying migrations, table was created. But querying either select or insert is not working by using await env.DB.prepare or exec

Ddinesh_karuppasamy Yes I applied remote. After applying migrations, table was created. But querying...

Cyb3r-Jak3•10/31/23, 12:41 AM

Where are you running the exec via wrangler dev?

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

Similar Threads

Similar Threads

Similar Threads