I can't assume, it's online mobile app and highly depends to Worker and D1. But i can say I will sta

T

Tony Leung•3/2/24, 7:32 AM

If you don't write much, like 10-20% write and 80% read then it's fine. Mine is 10% write and it's more than ok.

IimpairedFelon I can't assume, it's online mobile app and highly depends to Worker and D1. But ...

T

Tony Leung•3/2/24, 7:34 AM

Mine don't have more than 20CCU...

I

impairedFelonOP•3/2/24, 7:35 AM

Then it will fine i guess.

O

oof2win2•3/2/24, 10:22 AM

hi. so my migration just failed locally because i'm not authorized? no idea what is going on, it worked before

@oof2win2 ➜ /workspaces/fdgl/apps/server (master) $ bun wrangler d1 migrations apply fdgl-maindb --local
 ⛅️ wrangler 3.29.0 (update available 3.30.1)
-------------------------------------------------------
Migrations to be applied:
┌─────────────────────────────────────────────┐
│ name                                        │
├─────────────────────────────────────────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │
└─────────────────────────────────────────────┘
✔ About to apply 1 migration(s)
Your database may not be available to serve requests during the migration, continue? … yes
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database fdgl-maindb (fb5ec937-8f92-4532-a8c4-9d2d0abc9675) from .wrangler/state/v3/d1:
┌─────────────────────────────────────────────┬────────┐
│ name                                        │ status │
├─────────────────────────────────────────────┼────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │ ❌       │
└─────────────────────────────────────────────┴────────┘

❌ Migration 0002_change_proof_to_use_proof_id_as_id.sql failed with the following
errors:

✘ [ERROR] not authorized

@oof2win2 ➜ /workspaces/fdgl/apps/server (master) $ bun wrangler d1 migrations apply fdgl-maindb --local
 ⛅️ wrangler 3.29.0 (update available 3.30.1)
-------------------------------------------------------
Migrations to be applied:
┌─────────────────────────────────────────────┐
│ name                                        │
├─────────────────────────────────────────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │
└─────────────────────────────────────────────┘
✔ About to apply 1 migration(s)
Your database may not be available to serve requests during the migration, continue? … yes
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database fdgl-maindb (fb5ec937-8f92-4532-a8c4-9d2d0abc9675) from .wrangler/state/v3/d1:
┌─────────────────────────────────────────────┬────────┐
│ name                                        │ status │
├─────────────────────────────────────────────┼────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │ ❌       │
└─────────────────────────────────────────────┴────────┘

❌ Migration 0002_change_proof_to_use_proof_id_as_id.sql failed with the following
errors:

✘ [ERROR] not authorized

@oof2win2 ➜ /workspaces/fdgl/apps/server (master) $ bun wrangler d1 migrations apply fdgl-maindb --local
 ⛅️ wrangler 3.29.0 (update available 3.30.1)
-------------------------------------------------------
Migrations to be applied:
┌─────────────────────────────────────────────┐
│ name                                        │
├─────────────────────────────────────────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │
└─────────────────────────────────────────────┘
✔ About to apply 1 migration(s)
Your database may not be available to serve requests during the migration, continue? … yes
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database fdgl-maindb (fb5ec937-8f92-4532-a8c4-9d2d0abc9675) from .wrangler/state/v3/d1:
┌─────────────────────────────────────────────┬────────┐
│ name                                        │ status │
├─────────────────────────────────────────────┼────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │ ❌       │
└─────────────────────────────────────────────┴────────┘

❌ Migration 0002_change_proof_to_use_proof_id_as_id.sql failed with the following
errors:

✘ [ERROR] not authorized

@oof2win2 ➜ /workspaces/fdgl/apps/server (master) $ bun wrangler d1 migrations apply fdgl-maindb --local
 ⛅️ wrangler 3.29.0 (update available 3.30.1)
-------------------------------------------------------
Migrations to be applied:
┌─────────────────────────────────────────────┐
│ name                                        │
├─────────────────────────────────────────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │
└─────────────────────────────────────────────┘
✔ About to apply 1 migration(s)
Your database may not be available to serve requests during the migration, continue? … yes
🌀 Mapping SQL input into an array of statements
🌀 Executing on local database fdgl-maindb (fb5ec937-8f92-4532-a8c4-9d2d0abc9675) from .wrangler/state/v3/d1:
┌─────────────────────────────────────────────┬────────┐
│ name                                        │ status │
├─────────────────────────────────────────────┼────────┤
│ 0002_change_proof_to_use_proof_id_as_id.sql │ ❌       │
└─────────────────────────────────────────────┴────────┘

❌ Migration 0002_change_proof_to_use_proof_id_as_id.sql failed with the following
errors:

✘ [ERROR] not authorized

O

oof2win2•3/2/24, 10:25 AM

when running against remote it additionally gives a code 7500

VVy Right now, we're not evaluating per-database limit increases. But we're actively...

A

Advany•3/2/24, 10:55 AM

You guys are awesome!!!

I

impairedFelonOP•3/2/24, 11:52 AM

Can we make join | query with using 2 different D1 database?

Original message was deleted

T

Tony Leung•3/2/24, 3:54 PM

it's fairly cheap for them I guess. SQLite does not need a running server like mysql and it's basically useless if there is no worker included.

Original message was deleted

T

Tony Leung•3/2/24, 3:58 PM

I guess that SQLite is cheaper to manage. KV is smth like RocksDB, needs an active runtime server to host, unlike SQLite, don't really need that to run.

Original message was deleted

O

oof2win2•3/2/24, 4:41 PM

ah my bad. prisma generated a migration including pragma stuff

Original message was deleted

T

Tony Leung•3/2/24, 4:54 PM

it's cheap so it can be given away for free and it's also cf's strategy to attract new users.

O

oof2win2•3/2/24, 7:55 PM

whats the pricing on reading with an index? say i have users in groups and i want to select all users from a group and have an index on groups, do i get billed only for the users that are in the group?

K

kian•3/2/24, 7:59 PM

https://developers.cloudflare.com/d1/build-databases/use-indexes/

K

kian•3/2/24, 8:00 PM

D1 prices on rows_read and rows_written, index or not - the index just reduces how many rows need to be read.

O

oof2win2•3/2/24, 8:01 PM

okay thanks

G

gbaranski•3/3/24, 12:05 AM

how can I use Cloudflare D1 during SvelteKit development?

G

gbaranski•3/3/24, 12:05 AM

that's one thing that I feel like is really lacking right now

G

gbaranski•3/3/24, 12:05 AM

or at least i haven't found any solution to that

G

gbaranski•3/3/24, 12:06 AM

and that sucks to do

pnpm build

pnpm build

and then

wrangler pages dev .svelte-kit/cloudflare

wrangler pages dev .svelte-kit/cloudflare

wrangler pages dev .svelte-kit/cloudflare

wrangler pages dev .svelte-kit/cloudflare every time

G

gbaranski•3/3/24, 12:06 AM

HMR is a thing

G

Gagan Suie•3/3/24, 9:23 AM

Is there a way to listen to table changes and trigger webhooks?

Ggbaranski how can I use Cloudflare D1 during SvelteKit development?

S

Steved•3/3/24, 3:20 PM

I use the miniflare/wrangler emulation for local development with Sveltekit, and that allows me to use

npm run dev

npm run dev

and get the lightning fast reloads you're after. Take a look at: https://github.com/sdarnell/cf-svelte for a working example.

GitHub

GitHub - sdarnell/cf-svelte: A basic starter project for working lo...

A basic starter project for working locally in sveltekit on Cloudflare - sdarnell/cf-svelte

GGagan Suie Is there a way to listen to table changes and trigger webhooks?

T

Tony Leung•3/3/24, 6:22 PM

i don't think there is and old-school sql database has that feature. Only in my experience, only dynamodb can capture that event and put them in dynamo stream

U

Unsmart•3/3/24, 6:30 PM

AWS Aurora has the feature and is an SQL database so it’s not exclusively NoSQL

T

Tony Leung•3/3/24, 6:32 PM

I think AWS Aurora is a NewSQL, mysql, mariadb and postgres does not have that feature tho

T

Tony Leung•3/3/24, 6:34 PM

actually SQL Server can achieve that by using

xp_cmdshell

xp_cmdshell

xp_cmdshell

xp_cmdshell but it's not recommended to be turned on (according to OWASP)

U

Unsmart•3/3/24, 6:53 PM

aws aurora is mysql and postgres

UUnsmart aws aurora is mysql and postgres

T

Tony Leung•3/3/24, 7:19 PM

my bad, MySQL procedure can send webhook request by using

curl

curl

Original message was deleted

U

Unsmart•3/3/24, 7:21 PM

It will have read replicas soon but not sure if it will be multi-region

C

chientrm.com•3/4/24, 2:33 AM

I'm looking for a way to bulk import data into D1

C

chientrm.com•3/4/24, 2:36 AM

is to avoid the written count to D1

Cchientrm.com is to avoid the written count to D1 😗

I

Isaac McFadyen•3/4/24, 3:09 AM

Any way to write data to D1 will incur charges for writing.

I

Isaac McFadyen•3/4/24, 3:09 AM

There's no way to import data without incurring rows written, unfortunately

Nnoman hello, could someone please tell me how to create an FTS5 table in D1? I've trie...

C

Chaika•3/4/24, 4:13 AM

lowercase fts

CREATE VIRTUAL TABLE words_fts USING fts5 (episode, title, description, words);

CREATE VIRTUAL TABLE words_fts USING fts5 (episode, title, description, words);

CREATE VIRTUAL TABLE words_fts USING fts5 (episode, title, description, words);

CREATE VIRTUAL TABLE words_fts USING fts5 (episode, title, description, words);

S

Sandro•3/4/24, 6:24 AM

Hey

I'm a bit confused about the storage limit in D1.

The limits say: Maximum database size: 2GB Paid / 500 MB Free <- Is this a hard limit?

The pricing page says: Storage: You are only billed for storage above the included limits of your plan.

From the pricing page it sounds like its not a limit just the free tier.
But from the limit page it sounds like it.

IIsaac McFadyen Any way to write data to D1 will incur charges for writing.

C

chientrm.com•3/4/24, 6:44 AM

imma just use

Miniflare.getBindings()

Miniflare.getBindings()

Miniflare.getBindings()

Miniflare.getBindings() for my production on a NodeJS server

SSandro Hey 👋🏽 I'm a bit confused about the storage limit in D1. The limits say: *M...

D

daniel-supalang•3/4/24, 6:48 AM

Yes, that's a hard limit for now. They have a plan to increase the limit to 10GB this year, but I don't think they will increase the limit by much due to performance issues. If you want more storage, they recommend sharding the database MANUALLY right now.

SSteved I use the miniflare/wrangler emulation for local development with Sveltekit, and...

G

gbaranski•3/4/24, 9:41 AM

looks great, thanks :)

Original message was deleted

G

gbaranski•3/4/24, 9:42 AM

i can't seem to use that create-cloudflare

G

gbaranski•3/4/24, 9:42 AM

i mean it generates something weird

G

gbaranski•3/4/24, 9:42 AM

which exact template are u using to get the code you sent?

G

gbaranski•3/4/24, 10:09 AM

okay nevermind, i got everything solved

G

gbaranski•3/4/24, 10:09 AM

that works really great

G

gbaranski•3/4/24, 10:09 AM

it should be in the docs

G

gbaranski•3/4/24, 10:09 AM

and btw, have u managed to get drizzle studio to work with such local D1?

X

Xazu•3/4/24, 10:51 AM

Hi! How to move out whole remote D1 to local D1?

I can't assume, it's online mobile app and highly depends to Worker and D1. But i can say I will sta

Similar Threads

Similar Threads

Similar Threads