static as non changing? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Dahoom

D

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

Hearse

HHearse static as non changing?

Dahoom

D

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

yes

Hearse

H

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

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

Hearse

H

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

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

Hearse

H

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

H

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

for example the user can have no devices

Dahoom

D

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

thats no problem, just leave it null

Hearse

H

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

or an array of emails that is empty

Hearse

H

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

okay great.

Dahoom

D

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

H

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

got it, and that would be fields such as email

Paul

P

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

H

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

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

Dahoom

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

Hearse

H

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

D

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

ask gippity to make you a schema

Hearse

H

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

o yea

Hearse

H

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

i always forget i got gpt

Dahoom

D

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

Dahoom

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

Hearse

H

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

yea ill do that.

tforster

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

Cyb3r-Jak3

C

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

P

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

Is there a way to disable foreign key constraints temporarily?

Paul

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

Matt Silverlock

M

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

PRAGMA defer_foreign_keys = on

PRAGMA defer_foreign_keys = on

Isaac McFadyen

IIsaac McFadyen Sorry 😅

slagathor

S

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

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

slagathor

S

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

S

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

You've truly been a lifesaver!

slagathor

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

Isaac McFadyen

I

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

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

lul

Isaac McFadyen

I

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

Thank you though, that means a lot

tforster

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

windwp

W

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

D

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

D

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)

dinesh_karuppasamy

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

Cyb3r-Jak3

C

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

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

Cyb3r-Jak3

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

dinesh_karuppasamy

D

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

dinesh_karuppasamy

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

Cyb3r-Jak3

C

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

Where are you running the exec via wrangler dev?

Cyb3r-Jak3

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

dinesh_karuppasamy

D

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

yes running via wrangler dev

dinesh_karuppasamy

Ddinesh_karuppasamy yes running via wrangler dev

Cyb3r-Jak3

C

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.

Cyb3r-Jak3

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

dinesh_karuppasamy

D

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

okay thanks. Let me check again.

Paul Shriner

P

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

K

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

K

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

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

Paul Shriner

P

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

that is what I figured, but was hoping

Paul Shriner

P

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

P

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

Actually maybe not horrible iwth SQL math

kian

K

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

K

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.

// 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.