We're going to let folks write Workers that act as custom sqlite extensions eventually

DDr. Koti Reddy . Saripalli We have migrated a MacroMeta driven NoSQL to D1 and making the needed data model...

E

Epailes•5/3/23, 11:39 AM

You're unlikely to get an employee recommending you use their beta product for production, there will likely still be bugs/issues and I don't think there is any kind of SLA for those to be resolved.

If you do use it and encounter issues you can help it get to a stable GA by reporting them, but obviously that comes at the expense of your Dev time debugging issues

J

Jokcy•5/3/23, 1:14 PM

Hi team, I try to develop d1 at local with command:

wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local

wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local

wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local

wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local, and a slqite3 file with path

.wrangler/state/d1/TEST_DB.sqlite3

.wrangler/state/d1/TEST_DB.sqlite3

.wrangler/state/d1/TEST_DB.sqlite3

.wrangler/state/d1/TEST_DB.sqlite3 was created. When I try to quey with d1 I got error:

handle request
Error: D1_ERROR
    at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    ... 7 lines matching cause stack trace ...
    at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15) {
  [cause]: Error: Error: SqliteError: file is not a database
      at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at processTicksAndRejections (node:internal/process/task_queues:95:5)
      at D1PreparedStatement.raw (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:248:7)
      at callRouteLoaderRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4292:16)
      at callLoaderOrAction (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3531:16)
      at async Promise.all (index 0)
      at loadRouteData (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3303:19)
      at queryImpl (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3184:20)
      at Object.query (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3136:18)
      at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15)

handle request
Error: D1_ERROR
    at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    ... 7 lines matching cause stack trace ...
    at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15) {
  [cause]: Error: Error: SqliteError: file is not a database
      at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at processTicksAndRejections (node:internal/process/task_queues:95:5)
      at D1PreparedStatement.raw (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:248:7)
      at callRouteLoaderRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4292:16)
      at callLoaderOrAction (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3531:16)
      at async Promise.all (index 0)
      at loadRouteData (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3303:19)
      at queryImpl (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3184:20)
      at Object.query (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3136:18)
      at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15)

handle request
Error: D1_ERROR
    at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    ... 7 lines matching cause stack trace ...
    at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15) {
  [cause]: Error: Error: SqliteError: file is not a database
      at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at processTicksAndRejections (node:internal/process/task_queues:95:5)
      at D1PreparedStatement.raw (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:248:7)
      at callRouteLoaderRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4292:16)
      at callLoaderOrAction (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3531:16)
      at async Promise.all (index 0)
      at loadRouteData (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3303:19)
      at queryImpl (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3184:20)
      at Object.query (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3136:18)
      at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15)

handle request
Error: D1_ERROR
    at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:148:13)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    ... 7 lines matching cause stack trace ...
    at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15) {
  [cause]: Error: Error: SqliteError: file is not a database
      at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:149:16)
      at processTicksAndRejections (node:internal/process/task_queues:95:5)
      at D1PreparedStatement.raw (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:248:7)
      at callRouteLoaderRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4292:16)
      at callLoaderOrAction (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3531:16)
      at async Promise.all (index 0)
      at loadRouteData (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3303:19)
      at queryImpl (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3184:20)
      at Object.query (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3136:18)
      at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15)

Can anyone help to see what should I do to fix it?

EEpailes You're unlikely to get an employee recommending you use their beta product for p...

M

Matt Silverlock•5/3/23, 1:19 PM

I like this reply

AArthie Hey, not sure if this is known, but if you have a table with an SQL keyword as t...

M

Max (@rozenmd)OP•5/3/23, 8:21 PM

good catch, thanks!

DDr. Koti Reddy . Saripalli Alright, We will invest the same from our end. Only concern is downtime for rea...

M

Matt Silverlock•5/4/23, 9:29 AM

You should consider https://www.cloudflare.com/lp/workers-launchpad/

Cloudflare

Workers Launchpad by Cloudflare | Cloudflare

Workers Launchpad Funding Program is designed for startups to gain access to tools, capital and resources to innovate faster or accelerate the launch of their startup.

DDr. Koti Reddy . Saripalli Is there a time line of handling this gracefully and throw meaningful instructio...

M

Matt Silverlock•5/4/23, 10:07 AM

I will be extra transparent here: we’re in an alpha, and generally don’t share timelines about beta or GA steps, because they almost always lead to disappointment. A beta or GA isn’t just a checklist of features: it’s about ensuring we have observed the system to be reliable in the hands of users. This is especially true for a database product.

Further, when we land the new storage subsystem, we fully expect (we have validated internally, in fact) for these transient query failures to go away. They are an outcome of how we shipped an early alpha — so that users can play with D1 and provide feedback on the rest of the experience — versus holding off until we landed the storage layer we intend to build on proper

M

Matt Silverlock•5/4/23, 11:56 AM

Some upcoming D1 documentation:

Using indexes - https://silverlock-d1-indexes-json-l.cloudflare-docs-7ou.pages.dev/d1/learning/using-indexes/
Querying JSON (if you're used to JSON functions in Postgres, this is a big win): https://silverlock-d1-indexes-json-l.cloudflare-docs-7ou.pages.dev/d1/learning/querying-json/

MMatt Silverlock Some upcoming D1 documentation: - Using indexes - https://silverlock-d1-indexes...

M

Matt Silverlock•5/4/23, 11:57 AM

We'll also be looking at making it clearer on how to use Pages + D1 together as well.

F

Farhian•5/4/23, 2:27 PM

Hi all, I am trying to define some foreign key relationships and I am probably doing something wrong. I have created a sql script which creates the tables, indexes and the foreign key relationships. The table creation and index creation operations work while the foreign key statements fail. Does anyone have a small example on how to do that? I want to see if maybe my syntax is wrong. Thank you!

F

Farhian•5/4/23, 2:39 PM

here is a sample sql
CREATE TABLE

resellers

resellers

resellers

resellers (

id

id

id

id string PRIMARY KEY,

email

email

email

email string NOT NULL,

name

name

name

name string NOT NULL,

created

created

created

created datetime
);

CREATE TABLE

agencies

agencies

agencies

agencies (

id

id

id

id string PRIMARY KEY,

reseller_id

reseller_id

reseller_id

reseller_id string NOT NULL,

name

name

name

name string NOT NULL,

location

location

location

location string,

created

created

created

created datetime
FOREIGN KEY(

reseller_id

reseller_id

reseller_id

reseller_id) REFERENCES

resellers

resellers

resellers

resellers(

id

id

id

id),
);

F

Farhian•5/4/23, 2:40 PM

F

Farhian•5/4/23, 2:55 PM

omg

F

Farhian•5/4/23, 2:55 PM

thank you very much! @skye_31

F

Farhian•5/4/23, 2:55 PM

I need new glasses

A

Atinux•5/4/23, 4:08 PM

Just made an open source demo of Nuxt + CF Pages + D1: https://github.com/atinux/nuxt-todos-edge
Demo: https://nuxt-todos-edge.pages.dev/

GitHub

GitHub - Atinux/nuxt-todos-edge: A todos application with user auth...

A todos application with user authentication, with SSR & SQLite, working on the edge. - GitHub - Atinux/nuxt-todos-edge: A todos application with user authentication, with SSR & SQL...

Nuxt Todos Edge

A Nuxt demo hosted on CloudFlare Pages with server-side rendering on the edge and using the D1 database

Original message was deleted

M

Max (@rozenmd)OP•5/6/23, 6:12 PM

happy to fix it but it isn't clear what's happening in the screenshot

M

Max (@rozenmd)OP•5/6/23, 6:18 PM

oh right, will give it a look when I'm back at my laptop

M

Max (@rozenmd)OP•5/6/23, 6:18 PM

yeah that's definitely confusing

P

peachneo•5/7/23, 3:49 AM

hi all, Is there a limit on tables?

P

peachneo•5/7/23, 3:50 AM

*# of tables

Ppeachneo hi all, Is there a limit on tables?

C

Cyb3r-Jak3•5/7/23, 3:52 AM

There isn't a documented limit

Ppeachneo hi all, Is there a limit on tables?

M

Matt Silverlock•5/7/23, 9:21 AM

It depends on your total database size limit. At 100MB, it’s about 25,000, but then you wouldn’t have any room left for data nor indexes. In practice, we’re likely to document this as 1,000 (per DB) as a soft limit.

MMatt Silverlock It depends on your total database size limit. At 100MB, it’s about 25,000, but t...

P

peachneo•5/7/23, 9:21 AM

thanks

Ffate i tried around here and there, but i couldn't find options to set foreign keys i...

H

Hello, I’m Allie!•5/7/23, 7:07 PM

You should just be able to add foreign keys to your create table statement

T

TigersWay•5/8/23, 3:41 AM

Hi. Wondering how far/deep we should not be concerned about the (bad) performance of our SQL queries.... I have multiple - relatively simple - queries working with the primary-key-automatic-index which should be done in a few ms, taking now ~1s, while the network latency is not so great but clearly expected.

T

TigersWay•5/8/23, 3:42 AM

@geelen LOL the usual "soon"

T

TigersWay•5/8/23, 3:43 AM

Well it's still usable because clearly not in production.... I'll wait. Thanks

L

lukeed•5/8/23, 5:23 AM

Any pricing updates?

L

lukeed•5/8/23, 5:24 AM

J

James•5/8/23, 6:38 AM

Nothing official yet. Functionally, there’s probably not going to be much difference other than your Cloud vendor of choice, which is going to come down to availability and pricing.

D1 is still very early and in alpha right now, but it’ll probably make the most sense to use alongside the rest of the Cloudflare stack.

We're going to let folks write Workers that act as custom sqlite extensions eventually

Similar Threads

Similar Threads

Similar Threads