With the GA announcement ^, is there an update on the "group bindings"? Interested for multi tenancy

VVictor With the GA announcement ^, is there an update on the "group bindings"? Interest...

M

Matt Silverlock•1/18/24, 6:39 PM

No update yet (and we announced the GA timeline back in Sept 2023, for what it's worth!)

M

Max (@rozenmd)•1/18/24, 7:07 PM

you'll find early april is at the end of Q1

U

Unsmart•1/18/24, 7:07 PM

big if true

G

Gagan Suie•1/18/24, 10:50 PM

Reporting a VERY weird bug. Anytime we add the word "What" then the remaining text turns into an object:
The topic column has TEXT: "What is your favorite clip?"

const result = await env.DB.prepare(
            SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1
        )
            .bind(weekNumber)
            .first()

const result = await env.DB.prepare(
            SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1
        )
            .bind(weekNumber)
            .first()

const result = await env.DB.prepare(
            SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1
        )
            .bind(weekNumber)
            .first()

const result = await env.DB.prepare(
            SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1
        )
            .bind(weekNumber)
            .first()

result {"_id":1,"weekNumber":3,"topic":"What [object Object]

G

Gagan Suie•1/18/24, 10:54 PM

row was added via the "Add data" button in cloudflare D1 dashboard.

G

Gagan Suie•1/18/24, 10:56 PM

const result = await env.DB.prepare(
            `SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1`
        )
            .bind(weekNumber)
            .first()
        console.log('result', JSON.stringify(result))

const result = await env.DB.prepare(
            `SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1`
        )
            .bind(weekNumber)
            .first()
        console.log('result', JSON.stringify(result))

const result = await env.DB.prepare(
            `SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1`
        )
            .bind(weekNumber)
            .first()
        console.log('result', JSON.stringify(result))

const result = await env.DB.prepare(
            `SELECT * 
            FROM weekly 
            WHERE weekNumber = ?1`
        )
            .bind(weekNumber)
            .first()
        console.log('result', JSON.stringify(result))

U

Unsmart•1/18/24, 10:57 PM

you can use 3 backticks:

```js
// my code

```js
// my code

```

U

Unsmart•1/18/24, 10:59 PM

Oh this is the wrangler issue... if your log has the word "at" everything after becomes [object Object]

G

Gagan Suie•1/18/24, 11:00 PM

result {"type":"table","name":"weekly","tbl_name":"weekly","rootpage":7,"sql":"CREATE TABLE weekly (\r\n    _id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n    weekNumber INTEGER NOT NULL,\r\n    topic TEXT NOT NULL\r\n)"}

result {"type":"table","name":"weekly","tbl_name":"weekly","rootpage":7,"sql":"CREATE TABLE weekly (\r\n    _id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n    weekNumber INTEGER NOT NULL,\r\n    topic TEXT NOT NULL\r\n)"}

result {"type":"table","name":"weekly","tbl_name":"weekly","rootpage":7,"sql":"CREATE TABLE weekly (\r\n    _id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n    weekNumber INTEGER NOT NULL,\r\n    topic TEXT NOT NULL\r\n)"}

result {"type":"table","name":"weekly","tbl_name":"weekly","rootpage":7,"sql":"CREATE TABLE weekly (\r\n    _id INTEGER PRIMARY KEY AUTOINCREMENT,\r\n    weekNumber INTEGER NOT NULL,\r\n    topic TEXT NOT NULL\r\n)"}

U

Unsmart•1/18/24, 11:00 PM

https://github.com/cloudflare/workers-sdk/pull/4683
was merged already so maybe update your wrangler version?

G

Gagan Suie•1/18/24, 11:01 PM

ill try that now. i appreciate you guys.

G

Gagan Suie•1/18/24, 11:03 PM

brilliant! it worked!

A

anthony•1/19/24, 7:33 AM

Hi, i have around 50,000 rows i want to insert into D1 database regularly, if i do a sqlite database dump with wrangler like this:

wrangler d1 execute MYDB --file=MYFILE.sql

wrangler d1 execute MYDB --file=MYFILE.sql

it is suuperr fast,
But when I want to insert them via Workers with

.prepare(..).bind(..).run(..)

.prepare(..).bind(..).run(..)

, it takes on average 20 rows/second which is very slow.
Is there a way I can insert them via Workers as fast as

wrangler

wrangler

?

A

anthony•1/19/24, 7:42 AM

Oh damn, I just realised while writing that question i was not reusing prepared statements... it is now suuper fast

K

kian•1/19/24, 7:42 AM

Wrangler uses the batch API https://developers.cloudflare.com/d1/how-to/query-databases/#batch-statements

A

anthony•1/19/24, 7:47 AM

Ohh thank you, I didn't see this EDIT: works perfectly ty

T

TRSC325•1/19/24, 10:31 PM

there is a securty risk for d1 if used for user data hosting as that would require a set of rules to prevent such a thing . which is not found in d1

T

TRSC325•1/19/24, 11:11 PM

I just have a concern as if a program was to read from a database in d1 it could get some form. of data like passwords and i can't controll what data they see when they log in

T

TRSC325•1/19/24, 11:26 PM

thinks but do you know any why for my to regulate who sees what and edits what like the user can edit there acount but not others.

N

Nikil•1/20/24, 12:32 AM

https://developers.cloudflare.com/pages/functions/bindings/#d1-databases Is NORTHWIND_DB just the example of the name of the DB in the environment variable or is it always called that?

Bindings · Cloudflare Pages docs

A binding enables your Pages Functions to interact with resources on the Cloudflare developer platform. Use bindings to integrate your Pages Functions …

K

kian•1/20/24, 12:32 AM

Just an example, the binding is whatever name you give it.

K

kian•1/20/24, 12:32 AM

Give your binding a name under Variable name.

N

Nikil•1/20/24, 12:33 AM

Okay. They really should update the doc to make that slightly clearer. It should say "For example, if your binding is NORTHIND_DB"

TTRSC325 thinks but do you know any why for my to regulate who sees what and edits what l...

U

Unsmart•1/20/24, 12:48 AM

you just do that with your code you dont give anyone direct access to the db

R

Rubi•1/20/24, 10:56 AM

hello, is this best practice?

R

Rubi•1/20/24, 10:57 AM

I see

R

Rubi•1/20/24, 10:57 AM

what the best practice in D1 ?

R

Rubi•1/20/24, 11:00 AM

so it's REAL type, not FLOAT

A

ajgeiss0702•1/20/24, 9:32 PM

Any idea why the js api would be returning 0 results for a query, but doing the same query in the console on the dashboard returns the correct results?

In the pages function, i am doing this

await db.prepare("select * from notifications where ? = 1")
      .bind(name)
      .all()

await db.prepare("select * from notifications where ? = 1")
      .bind(name)
      .all()

await db.prepare("select * from notifications where ? = 1")
      .bind(name)
      .all()

await db.prepare("select * from notifications where ? = 1")
      .bind(name)
      .all()

(where

name

name

is

imminent

imminent

)

which returns 0 results. However if I do this in the dashboard:

select * from notifications where imminent = 1

select * from notifications where imminent = 1

select * from notifications where imminent = 1

select * from notifications where imminent = 1

it returns the expected rows

please ping me if you reply

A

ajgeiss0702•1/20/24, 9:34 PM

deployed

A

ajgeiss0702•1/20/24, 9:36 PM

oh, cant believe i didnt think of that. let me change that

M

Muhammad•1/20/24, 10:14 PM

I prepared a SQL file to import my existing db data to D1, based on the documentation found here: https://developers.cloudflare.com/d1/how-to/importing-data/

However, I encountered an error every time I ran the execution command. The error message states: "near '��C': syntax error at offset 0 [code: 7500]".

I have attached an example database file below. Although the actual file contains 8900 entries, the syntax remains the same. Unfortunately, neither the example file nor the actual file is importing successfully.

Could you please assist me in resolving this bug? I have also included a screenshot of the problem for reference.

newdb.sql18.39KB

Importing data · Cloudflare D1 docs

D1 allows you to import existing SQLite tables and their data directly, enabling you to migrate existing data into D1 quickly and easily. This can be …

K

kian•1/20/24, 10:25 PM

Your file is UTF-16, save it with UTF-8

A

Arturo•1/21/24, 12:14 AM

Does D1 supports some kind of webhook or something that when I update 1 table another one gets updated automatically?

AArturo Does D1 supports some kind of webhook or something that when I update 1 table an...

M

Matt Silverlock•1/21/24, 12:32 AM

Use SQLite triggers: https://www.sqlite.org/lang_createtrigger.html

A

Arturo•1/21/24, 12:33 AM

cool, thanks

J

JUNO•1/21/24, 6:51 AM

how to fix this sir

U

Unsmart•1/21/24, 6:53 AM

#cloudflare-status

UUnsmart #cloudflare-status

J

JUNO•1/21/24, 6:54 AM

thankyou sir

Oom Is this expected? I am trying to download the db from cloudflare and test it loc...

C

Chaika•1/21/24, 8:03 AM

Only Alpha DBs support the built in backups (Experimental/Betas support time travelling for data restoring/backups, not full backups)

C

Chaika•1/21/24, 8:03 AM

You can try https://github.com/nora-soderlund/cloudflare-d1-backups by a community member instead for that purpose on beta DBs

GitHub

GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a ...

A package to dump a copy of your experimental D1 database through a worker. - GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a copy of your experimental D1 database through a worker.

Oom I read the docs it supports the time travel method.. how to manually create one?...

C

Chaika•1/21/24, 8:09 AM

Docs for time travel are here: https://developers.cloudflare.com/d1/reference/time-travel/#terminology
You don't need to create any, there's no frequency, you can just restore back to a specific point in time, limit by:

You can restore a database back to a point in time up to 30 days in the past (Workers Paid plan) or 7 days (Workers Free plan). Refer to Limits for details on Time Travel’s limits.

Migration docs are here:
https://developers.cloudflare.com/d1/reference/migrations/#migrations

If you want to pull down the remote db, you'd have to use the utlity above

C

chientrm.com•1/21/24, 11:33 AM

uhm, is there an app to browse my D1 database without coding?

Original message was deleted

C

chientrm.com•1/21/24, 1:39 PM

the dashboard is good tbh but a bit distractive to me. Cuz I want to mainly focus on monitoring my individual apps.

With the GA announcement ^, is there an update on the "group bindings"? Interested for multi tenancy

Similar Threads