@elithrar Do you guys have a date in mind when you will start allowing size limit increase?

VVictor @elithrar Do you guys have a date in mind when you will start allowing size limi...

M

Matt Silverlock•6/30/23, 5:49 PM

Not that we're sharing yet. It will coincide with the beta. We won't be doing one-off increases.

S

Sameer Ali•6/30/23, 7:25 PM

@elithrar D1 Seems pretty stable now, what's holding off beta other than metrics and time-travel?

V

VictorOP•6/30/23, 8:50 PM

In https://developers.cloudflare.com/workers/wrangler/configuration/#d1-databases, it says to use

id

id

(in line with kv format), but then the example uses

database_id

database_id

. Which one is it?

Configuration · Cloudflare Workers docs

Wrangler optionally uses a wrangler.toml configuration file to customize the development and publishing setup for a Worker.

VVictor In https://developers.cloudflare.com/workers/wrangler/configuration/#d1-database...

C

Cyb3r-Jak3•6/30/23, 8:51 PM

database_id

database_id

C

chenyh_henry•7/1/23, 9:25 AM

Hi everyone, I face an issue or not support that the

 id SERIAL PRIMARY KEY

 id SERIAL PRIMARY KEY

seems not work, I follow the doc https://developers.cloudflare.com/workers/tutorials/postgres/#5-interact-with-the-products-database, I know the condition is own host PostgreSQL but the D1 should be the same, right?

From the screenshot, the ID is always null.

Connect to a PostgreSQL database with Cloudflare Workers · Cloudfla...

In this tutorial, you will learn how to create a Cloudflare Workers application and connect it to a PostgreSQL database using TCP Sockets. The Workers …

V

vassbence•7/1/23, 9:33 AM

D1 is running on SQLite, not PostgreSQL

V

vassbence•7/1/23, 9:33 AM

try

id int primary key autoincrement

id int primary key autoincrement

C

chientrm.com•7/2/23, 7:17 AM

Does D1 has multi column primary key?

C

chientrm.com•7/2/23, 7:17 AM

I keep getting error from this

CREATE TABLE Love(
    uid integer NOT NULL,
    ideaId integer NOT NULL,
    PRIMARY KEY (uid, ideaId),
    createdAt datetime DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE Love(
    uid integer NOT NULL,
    ideaId integer NOT NULL,
    PRIMARY KEY (uid, ideaId),
    createdAt datetime DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE Love(
    uid integer NOT NULL,
    ideaId integer NOT NULL,
    PRIMARY KEY (uid, ideaId),
    createdAt datetime DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE Love(
    uid integer NOT NULL,
    ideaId integer NOT NULL,
    PRIMARY KEY (uid, ideaId),
    createdAt datetime DEFAULT CURRENT_TIMESTAMP
);

C

chientrm.com•7/2/23, 7:17 AM

The error

ERROR 9009: SQL prepare error: near "createdAt": syntax error in CREATE TABLE Love( uid integer NOT NULL, ideaId integer NOT NULL, PRIMARY KEY (uid, ideaId), createdAt datetime DEFAULT CURRENT_TIMESTAMP ); at offset 109

ERROR 9009: SQL prepare error: near "createdAt": syntax error in CREATE TABLE Love( uid integer NOT NULL, ideaId integer NOT NULL, PRIMARY KEY (uid, ideaId), createdAt datetime DEFAULT CURRENT_TIMESTAMP ); at offset 109

ERROR 9009: SQL prepare error: near "createdAt": syntax error in CREATE TABLE Love( uid integer NOT NULL, ideaId integer NOT NULL, PRIMARY KEY (uid, ideaId), createdAt datetime DEFAULT CURRENT_TIMESTAMP ); at offset 109

ERROR 9009: SQL prepare error: near "createdAt": syntax error in CREATE TABLE Love( uid integer NOT NULL, ideaId integer NOT NULL, PRIMARY KEY (uid, ideaId), createdAt datetime DEFAULT CURRENT_TIMESTAMP ); at offset 109

T

TigersWay•7/2/23, 7:19 AM

@chientrm I believe

PRIMARY KEY

PRIMARY KEY

need to be the last "field", so after createdAt

TTigersWay @chientrm I believe `PRIMARY KEY` need to be the last "field", so after createdA...

C

chientrm.com•7/2/23, 7:19 AM

wow!

C

chientrm.com•7/2/23, 7:19 AM

Thank you so much

C

chientrm.com•7/2/23, 4:32 PM

I run wrangler dev --remote when dev.
When dev, the error message is

D1_ERROR: Error: ERROR 9007: SQL execute error: UNIQUE constraint failed: User.email

D1_ERROR: Error: ERROR 9007: SQL execute error: UNIQUE constraint failed: User.email

But in production, it's just

D1_ERROR: Error

D1_ERROR: Error

so that I can't detect existed email

C

chientrm.com•7/2/23, 4:33 PM

On web console, the error is returned correctly:

ERROR 9015: SQL engine error: query error: Error code 2067: A UNIQUE constraint failed (UNIQUE constraint failed: User.email)

ERROR 9015: SQL engine error: query error: Error code 2067: A UNIQUE constraint failed (UNIQUE constraint failed: User.email)

C

chientrm.com•7/2/23, 4:55 PM

Oke I figured it out, on production the error message is at

error.cause?.message

error.cause?.message

M

MetalGear•7/2/23, 6:58 PM

Is anyone using d1 currently for a service they’re selling

MMetalGear Is anyone using d1 currently for a service they’re selling

C

chientrm.com•7/2/23, 10:13 PM

Just use it, it's sqlite

MMetalGear Is anyone using d1 currently for a service they’re selling

A

Adi•7/3/23, 4:12 AM

It's definitely a bit of a risk to use it right now, given it's alpha state there is a possibility for unexpected errors. That being said, from my experience D1 is mostly quite stable.
It's been said a few times before in this channel, but once backups are available for the new D1 backend, the risk for using this in production is much lower.

M

matt•7/3/23, 9:21 AM

hi all, is there anywhere to follow along with the D1 roadmap? Looking for updates on read replication

I

itsmatteomanf•7/3/23, 1:10 PM

That changelog not being date ordered is not nice NotLikeThis

let me PR that lul

I

itsmatteomanf•7/3/23, 1:11 PM

https://github.com/cloudflare/cloudflare-docs/pull/9702

GitHub

Fix Order of D1 `changelog.md` by Date by itsmatteomanf · Pull Requ...

I

itsmatteomanf•7/3/23, 1:11 PM

M

MetalGear•7/3/23, 3:16 PM

That would be a interesting solution. Only thing I wonder for something like d1 is say I use it to store e-commerce orders for my saas. What happens when I have over 100gb of data and ex hit the db size limits? Is there spread the data across multiple d1 databases at that point?

U

Unsmart•7/3/23, 3:20 PM

We dont even know what the limits of production ready D1 will be yet so we cant really give any advice for that yet

M

micromashor•7/3/23, 3:22 PM

is there a limit to the size of queries you can run with

wrangler d1 execute

wrangler d1 execute

?

Mmicromashor is there a limit to the size of queries you can run with `wrangler d1 execute`?

U

Unsmart•7/3/23, 3:23 PM

yes: https://developers.cloudflare.com/d1/platform/limits/

Limits · Cloudflare D1 docs

Many of these limits will increase during D1’s public alpha. Join the #d1-open-alpha channel in the Cloudflare Developer Discord to keep up to date …

M

micromashor•7/3/23, 3:23 PM

hmmmm, I've managed to lock up the dashboard console with a large query still well under 100k, probably just the browser not being able to handle pasting that much data into a single input field lol

Vvvarp hey, I am researching on how well D1 suits my use case, and I wonder if it will ...

U

Unsmart•7/3/23, 9:15 PM

d1-database

CCole Xemi I see that there is now metrics for D1 yet I am not seeing the metrics tab for m...

A

Adi•7/4/23, 1:22 AM

It's possible that your database is using the old backend? My understanding is that metrics are currently only available for databases using the new experimental backend for D1.

Mmicromashor hmmmm, I've managed to lock up the dashboard console with a large query still we...

M

Max (@rozenmd)•7/4/23, 8:40 AM

i've pasted multi-MB files into the text field and had them go through (the UI completely crashed, but the query went through lul

)

M

Max (@rozenmd)•7/4/23, 8:40 AM

but yeah it's not (yet) designed for large amounts of data

B

bkyerv•7/4/23, 8:57 AM

hello everyone. is there any way to check if connection to d1 is successful? I am facing an error that the table I am querying doesn't exist but in the ui dashboard I see the table (i.e. it does exist) now I want to see if connection has been properly established. what is the best way to check it?

Bbkyerv hello everyone. is there any way to check if connection to d1 is successful? I a...

M

Max (@rozenmd)•7/4/23, 10:14 AM

you're likely talking to D1 locally rather than remotely, see https://developers.cloudflare.com/d1/learning/local-development/#start-a-local-development-session

MMax (@rozenmd)you're likely talking to D1 locally rather than remotely, see https://developers...

B

bkyerv•7/4/23, 11:06 AM

thank you. that was the reason

C

Colin•7/4/23, 3:45 PM

Hi Everyone. I'm new to this Discord. I am planning to use D1 for my new website. Cloudflare says they don't recommend it for production. I will have a simple interface (about 5 tables). I will be maintaining data about my clients permission to login, some client data stored as JSON strings, and some other basic stuff. Should I be concerned about the stabilithy of D1 in a production website?

U

Unsmart•7/4/23, 3:47 PM

It is an alpha product so breaking changes can happen and while it probably will work fine you probably shouldnt use it for production.

TTechist Created a D1 database via Web and created bindings. Unable to write to it, fro...

M

Matt Silverlock•7/4/23, 7:50 PM

If you are using Pages, have you followed the docs? https://developers.cloudflare.com/pages/platform/functions/bindings/#d1-databases

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 …

TTechist Created a D1 database via Web and created bindings. Unable to write to it, fro...

M

Matt Silverlock•7/4/23, 7:51 PM

It will not be on

env

env

but instead

context.env

context.env

per the linked docs

M

Matt Silverlock•7/4/23, 7:51 PM

interface Env {
  YOUR_DB: D1Database;
}

export const onRequest: PagesFunction<Env> = async (context) => {
  // Create a prepared statement with our query
  const ps = context.env.YOUR_DB.prepare('SELECT * from users');
  const data = await ps.first();

  return Response.json(data);
}

interface Env {
  YOUR_DB: D1Database;
}

export const onRequest: PagesFunction<Env> = async (context) => {
  // Create a prepared statement with our query
  const ps = context.env.YOUR_DB.prepare('SELECT * from users');
  const data = await ps.first();

  return Response.json(data);
}

interface Env {
  YOUR_DB: D1Database;
}

export const onRequest: PagesFunction<Env> = async (context) => {
  // Create a prepared statement with our query
  const ps = context.env.YOUR_DB.prepare('SELECT * from users');
  const data = await ps.first();

  return Response.json(data);
}

interface Env {
  YOUR_DB: D1Database;
}

export const onRequest: PagesFunction<Env> = async (context) => {
  // Create a prepared statement with our query
  const ps = context.env.YOUR_DB.prepare('SELECT * from users');
  const data = await ps.first();

  return Response.json(data);
}

TTechist Do I need to have this? Haven't seen this in the documentation. interface En...

M

Matt Silverlock•7/4/23, 8:33 PM

If you use TypeScript, yes. Read the docs there - follow each step! And show your code

C

Catt0s•7/4/23, 9:29 PM

Not sure what I'm doing wrong, and I'm not experienced with JS or SQL, but
1) the console works fine
2) invalid query throw errors
but...
3) valid queries return nothing?

console.log(query);
result = context.env.db.prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);

console.log(query);
result = context.env.db.prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);

console.log(query);
result = context.env.db.prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);

console.log(query);
result = context.env.db.prepare(query).bind(value);
const res = await result.raw();
console.log("RESULT: "+res);

p.s. - please leave ping on for replies (ping me after if your forget)

CCatt0s Not sure what I'm doing wrong, and I'm not experienced with JS or SQL, but 1) t...

M

Matt Silverlock•7/4/23, 11:51 PM

Share all of your code. Does your query return anything at all? Are you sure? If your bound values are null they may not match any rows.

CCatt0s Not sure what I'm doing wrong, and I'm not experienced with JS or SQL, but 1) t...

M

Matt Silverlock•7/4/23, 11:52 PM

You should log your values BEFORE you run the query to ensure they are not null

@elithrar Do you guys have a date in mind when you will start allowing size limit increase?

Similar Threads

Similar Threads

Similar Threads