Cloudflare Developers•3y ago

or run sql

RRex or run sql

Dahoom•10/28/23, 7:30 PM

https://developers.cloudflare.com/workers/wrangler/commands/#execute

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

RexOP•10/28/23, 7:31 PM

Thank you

EvanPiro•10/28/23, 7:32 PM

When running migrations that create temp tables, copy data, drop the original tables, and rename the new tables, how much memory do I have to perform this operation?

EvanPiro•10/28/23, 7:33 PM

For instance sqlite doesn't support adding a foreign key column to an existing table, so you need to create a new table and migrate.

DDahoom https://developers.cloudflare.com/workers/wrangler/commands/#execute

RexOP•10/28/23, 8:04 PM

Trying to run commands read on page but it just says syntac error

Dahoom•10/28/23, 8:04 PM

that means your command is incorrect

Dahoom•10/28/23, 8:04 PM

use gippity to form your command

Dahoom•10/28/23, 8:05 PM

some people mistake the understandable mistake of using regular sql syntax with sqlite

RexOP•10/28/23, 8:07 PM

whats the command to execute sql i made?

Dahoom•10/28/23, 8:08 PM

RexOP•10/28/23, 8:08 PM

like how can i inject my sql into the databvase

Dahoom•10/28/23, 8:10 PM

Its been a while since i've done it but its something similar to wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"

RexOP•10/28/23, 8:11 PM

right

RexOP•10/28/23, 8:11 PM

still having issues but its fine for now

kian•10/29/23, 11:02 AM

How have you checked that the database doesn’t update?

IdkWhatever69•10/29/23, 5:21 PM

hi guys

IdkWhatever69•10/29/23, 5:22 PM

hows the d1 latency?

Original message was deleted

IdkWhatever69•10/29/23, 7:44 PM

doesnt d1 automatically spawn replicas?

IdkWhatever69•10/29/23, 9:03 PM

does D1 also have the write constrains of sqlite? (max ~1-10k row writes/s)

VViper Is it possible to insert the data into a table and read it through the same func...

omar4289•10/30/23, 6:42 AM

add returning * just before ; in your insert

omar4289•10/30/23, 6:42 AM

insert into .. values .. returning *;

IdkWhatever69•10/30/23, 6:48 AM

does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s)

kian•10/30/23, 7:04 AM

I imagine you're going to hit the constraints of D1/Durable Objects before hitting the constraints of SQLite.

IIdkWhatever69 does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s...

Matt Silverlock•10/30/23, 10:02 AM

You can write (depending on the query complexity, tables, indexes) far more than 1-2k rows per second.

MMatt Silverlock You can write (depending on the query complexity, tables, indexes) far more than...

omar4289•10/30/23, 10:03 AM

Do we have exact metrics on how many are possible/how many was used to test the load of d1

Oomar4289 Do we have exact metrics on how many are possible/how many was used to test the ...

Matt Silverlock•10/30/23, 10:05 AM

No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. You can write millions of rows per second in many, many cases.

MMatt Silverlock No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. Yo...

omar4289•10/30/23, 10:06 AM

I know, but just wondering if you could share the results you have, even if it is for simple queries

omar4289•10/30/23, 10:07 AM

Currently, I am always using simple insert queries in my d1 and delegating complex queries to supabase

Sslagathor Right now I'm using DataGrip with https://github.com/isaac-mcfadyen/d1-jdbc-driv...

Isaac McFadyen•10/30/23, 12:04 PM

Sorry

Isaac McFadyen•10/30/23, 12:04 PM

I've had very little time to maintain it with school being so busy - I'll try to fix some of the outstanding issues if I get the chance sometime soon

JustinNoel•10/30/23, 12:25 PM

Thanks so much to @Isaac McFadyen | YYZ01 for his awesome d1-consoled1-console.

If you're not familiar with it, it lets you query your Cloudflare D1 database from your command line.

https://github.com/isaac-mcfadyen/d1-console

GitHub

GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudf...

A full query console for Cloudflare's D1 database product. - GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudflare's D1 database product.

VViper Like this? ```ts const { results } = await DB.prepare('INSERT INTO users (id, na...

omar4289•10/30/23, 12:43 PM

Should be, if all() does not work, then use run() instead

kian•10/30/23, 1:33 PM

JSONB was in the draft release log for 3.44.0 but isn't in that one, so I imagine it was pulled from that release.

Hearse•10/30/23, 1:54 PM

i am currently using mongodb to store user and their device data, is it a good idea to switch d1?

Dahoom•10/30/23, 1:55 PM

d1 is in beta and has a 2GB per database limit currently

Hearse•10/30/23, 1:55 PM

i am not familiar with sql databases so i am kind of on the fence.

DDahoom d1 is in beta and has a 2GB per database limit currently

Hearse•10/30/23, 1:55 PM

i only have a couple thousand users. The db size is around 600kb in mongodb

Hearse•10/30/23, 1:55 PM

its not much

Hearse•10/30/23, 1:56 PM

i am using the mongodb free tier

Dahoom•10/30/23, 1:57 PM

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

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

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

never used it myself

or run sql

Similar Threads

Similar Threads

Similar Threads