Cloudflare Developers•3y ago

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?

CCyb3r-Jak3 Where are you running the exec via wrangler dev?

dinesh_karuppasamy•10/31/23, 1:05 AM

yes running via wrangler dev

Ddinesh_karuppasamy yes running via wrangler dev

Cyb3r-Jak3•10/31/23, 1:13 AM

Did the you also apply the migrations locally? Wrangler dev by default uses local mode which doesn’t use any remote data.

CCyb3r-Jak3 Did the you also apply the migrations locally? Wrangler dev by default uses loca...

dinesh_karuppasamy•10/31/23, 1:16 AM

okay thanks. Let me check again.

Paul Shriner•10/31/23, 12:10 PM

D1 question and I think that I know the answer, I would like to sort by similarity of two strings. In a traditional enviornment I think I would use editdist3 which seems like the goto in SQLite, but I don't see it support in D1... Did I miss something?

kian•10/31/23, 12:18 PM

The spellfix1 virtual table is not included in the SQLite amalgamation and is not a part of any standard SQLite build. It is a loadable extension.

kian•10/31/23, 12:18 PM

It's a non-standard extension so it won't be included in D1 currently.

Paul Shriner•10/31/23, 12:24 PM

that is what I figured, but was hoping

yes

Similar Threads