Cloudflare Developers•3y ago

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 = onPRAGMA 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

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

Basically what I am trying to do is take a comma delimited list of sorted numbers say [1,2,4,7] and find the record most closely match [1,2,7] .

I think that I can do it by flatteing the column into fields, but It won't be simple to read nor will it be performant.

So I would take ideas

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

Actually maybe not horrible iwth SQL math

kian•10/31/23, 2:38 PM

// TODO(someday): Allow temporary tables. Creating a temporary table actually causes
//   SQLite to open a separate temporary file to place the data in. Currently, our storage
//   engine has no support for this.

// TODO(someday): Allow temporary tables. Creating a temporary table actually causes
//   SQLite to open a separate temporary file to place the data in. Currently, our storage
//   engine has no support for this.

kian•10/31/23, 2:38 PM

The new storage backend doesn't support temporary tables.

// TODO(someday): Allow temporary tables. Creating a temporary table actually causes // SQLite to open a separate temporary file to place the data in. Currently, our storage // engine has no support for this.

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

Similar Threads

Similar Threads

Similar Threads