apologies, the error was actually `SqliteError: no such table: todos`

00xidigwu apologies, the error was actually `SqliteError: no such table: todos`

I

That looks like the table isn’t there, which I’m gonna believe. Can you check in the dashboard’s list of tables if the table exists?

Ssumé ሱሜ I have a table that gets periodicall updates (additions) in the form of a csv fi...

M

Matt Silverlock•9/5/23, 2:59 AM

Write a Worker that consumes the CSV and writes directly to D1?

Ssumé ሱሜ I was trying to make use of sqlite's ability to convert the csv into sql for me

M

Matt Silverlock•9/5/23, 3:39 AM

That’s less “SQLite” the query engine (what D1 uses) and more “SQLite the CLI tool” - they are different.

VViper Is there a working tutorial on how to connect to D1 using a Nextjs app?

M

Matt Silverlock•9/5/23, 11:15 AM

https://developers.cloudflare.com/pages/framework-guides/deploy-a-nextjs-site/#use-bindings-in-your-nextjs-application - replace KV with D1.

Deploy a Next.js site · Cloudflare Pages docs

Next.js is an open-source React framework for creating websites and applications. In this guide, you will create a new Next.js application and deploy …

A

addison•9/6/23, 3:53 AM

Is there a plan to have nicer errors. I cant find a better way to handle this error other than this and its kinda icky.

U

Unsmart•9/6/23, 4:17 AM

Not sure what you would want? Any way they format the errors you are going to have to do all the same conditions

M

Mehanika•9/6/23, 8:46 AM

Hello all. I am taking a deep look into D1. Is there any roadmap for when it will leave Alpha etc? Just to have an indication of the product maturity?

MMatt Silverlock There’s no practical limit on columns or rows (especially rows). We allow 100 co...

M

muslax•9/6/23, 8:51 AM

Is this new (100 cols per table)? Previously I managed to create a table with 269 cols, but now it always fails remotely (--local is still OK).

M

muslax•9/6/23, 8:52 AM

M

muslax•9/6/23, 8:56 AM

C

Codename_404•9/6/23, 9:46 AM

Is there plan to make d1 accessible externally as well? Or will it always be restricted to worker only?

N

Nehal Ali•9/6/23, 12:28 PM

i am getting an error "env.DB.prepare(...).run is not a function" , i logged env.DB and it is undefined,
in my controller i use it like this:

What did i do wrong here ?

N

Nehal Ali•9/6/23, 12:30 PM

[[d1_databases]]
binding = "TEMPDB"
database_name = "test"
database_id = "databaseid here"

The correct data is in my wrangler.toml file

NNehal Ali i am getting an error "env.DB.prepare(...).run is not a function" , i logged env...

M

Max (@rozenmd)•9/6/23, 12:48 PM

You might have called it

env.DB

env.DB

env.DB

env.DB somewhere but your wrangler binding is for

env.TEMPDB

env.TEMPDB

env.TEMPDB

env.TEMPDB - you'll want to update the code

N

Nehal Ali•9/6/23, 1:05 PM

i pass env.TEMPDB to my templates model constructer and then use this.DB.prepare(...)

N

Nehal Ali•9/6/23, 1:06 PM

NNehal Ali Click to see attachment

M

Max (@rozenmd)•9/6/23, 1:09 PM

What's DB?

N

Nehal Ali•9/6/23, 1:19 PM

DB is the variable name passed in the constructor

NNehal Ali i am getting an error "env.DB.prepare(...).run is not a function" , i logged env...

M

Matt Silverlock•9/6/23, 3:40 PM

i am getting an error "env.DB.prepare(...).run is not a function" , i logged env.DB and it is undefined,

Right —

env.DB

env.DB

env.DB

env.DB is undefined because you called it

TEMPDB

TEMPDB

TEMPDB

TEMPDB. How do you get from the D1 binding on

env.TEMPDB

env.TEMPDB

env.TEMPDB

env.TEMPDB to your own class?

Can I suggest simplifying your code here? Call the methods on

env.TEMPDB

env.TEMPDB

env.TEMPDB

env.TEMPDB directly vs. abstracting them - get it working first.

S

schwartzmj•9/6/23, 4:35 PM

This works in local dev, and my other CRUD routes work without issue, however the following code throws error

Error: D1_ERROR: Error: not authorized

Error: D1_ERROR: Error: not authorized

Error: D1_ERROR: Error: not authorized

Error: D1_ERROR: Error: not authorized in production.

Anybody have any ideas? Is something not supported in D1 like

returning()

returning()

returning()

returning() or transactions or something? I'm using Miniflare in dev and it works there.

(using Drizzle ORM)

        const newTeam = await locals.db
            .transaction(async (tx) => {
                const newTeam = await tx.insert(teams).values(form.data).returning().get();
                await tx.insert(usersToTeams).values({
                    userId,
                    teamId: newTeam.id,
                    isAdmin: 1
                });
                return newTeam;
            })
            .catch((e) => {
                console.log('ERROR: ', e);
                throw error(500, 'Something went wrong creating your team.');
            });

        const newTeam = await locals.db
            .transaction(async (tx) => {
                const newTeam = await tx.insert(teams).values(form.data).returning().get();
                await tx.insert(usersToTeams).values({
                    userId,
                    teamId: newTeam.id,
                    isAdmin: 1
                });
                return newTeam;
            })
            .catch((e) => {
                console.log('ERROR: ', e);
                throw error(500, 'Something went wrong creating your team.');
            });

        const newTeam = await locals.db
            .transaction(async (tx) => {
                const newTeam = await tx.insert(teams).values(form.data).returning().get();
                await tx.insert(usersToTeams).values({
                    userId,
                    teamId: newTeam.id,
                    isAdmin: 1
                });
                return newTeam;
            })
            .catch((e) => {
                console.log('ERROR: ', e);
                throw error(500, 'Something went wrong creating your team.');
            });

        const newTeam = await locals.db
            .transaction(async (tx) => {
                const newTeam = await tx.insert(teams).values(form.data).returning().get();
                await tx.insert(usersToTeams).values({
                    userId,
                    teamId: newTeam.id,
                    isAdmin: 1
                });
                return newTeam;
            })
            .catch((e) => {
                console.log('ERROR: ', e);
                throw error(500, 'Something went wrong creating your team.');
            });

JJamie What causes `wrangler d1 execute` to print out the information after "Loading DB...

I

itsmatteomanf•9/7/23, 12:13 AM

That's cause by the API its using. The Worker binding by default return results, success and meta properties.

I

itsmatteomanf•9/7/23, 12:13 AM

https://developers.cloudflare.com/d1/platform/client-api/#return-object

I

itsmatteomanf•9/7/23, 12:14 AM

Those

***

***

***

*** are definitely GitHub Action logging issues.

JJamie Thanks I see. What causes those logs to be printed out? They don't get printed o...

I

itsmatteomanf•9/7/23, 6:50 AM

That I’m not sure… it should return something, though. If my memory is correct.

MMatt Silverlock > i am getting an error "env.DB.prepare(...).run is not a function" , **i logged...

N

Nehal Ali•9/7/23, 8:05 AM

i tried that and it gave the same error , i also logged env.TEMPDB in the router function directly and it gave me undefined.
i don't know why it is not reading this variable , but when i use wrangler execute d1 for the commands on the database it is working fine.

NNehal Ali i tried that and it gave the same error , i also logged env.TEMPDB in the router...

M

Matt Silverlock•9/7/23, 10:11 AM

Please open a GitHub issue. There’s not enough info to go off here. Provide your code, wrangler.toml, and the commands you’ve used.

J

Jadugar_Jaggu•9/7/23, 4:18 PM

hey guys I have almost per monthly KV write operations around 5 million, and it is costing me almost 30$ + a month, My question is the D1 database in open alpha right now, can I use it in my service to replace KV for some operations, Like I am storing users IP address currently in KV , it can handle millions read and write?

J

Jadugar_Jaggu•9/7/23, 4:19 PM

I want to lower the cost of my services, and I was checking our D1 database it has very low cost compare to KV

JJadugar_Jaggu hey guys I have almost per monthly KV write operations around 5 million, and it ...

U

Unsmart•9/7/23, 4:25 PM

Its not recommended to use for production critical applications, but #durable-objects are a good alternative to KV that's cheaper.

JJadugar_Jaggu hey guys I have almost per monthly KV write operations around 5 million, and it ...

I

itsmatteomanf•9/7/23, 5:34 PM

What @Unsmart | Tech debt said is valid, but do note that D1 it can handle millions of write per minute easily. I have done it, consistently for hours and days on end.

I

itsmatteomanf•9/7/23, 5:34 PM

(While still reading fast, and read replicas aren’t even here yet)

JJamie If I redirect the output to a file then I see the results locally, but don't see...

I

itsmatteomanf•9/8/23, 6:43 AM

No, I don’t think I understood here… which output should be turned off? If you write it doesn’t return anything, apart from meta and success.

JJamie If I redirect the output to a file then I see the results locally, but don't see...

M

Max (@rozenmd)•9/8/23, 8:56 AM

run wrangler with the

WRANGLER_LOG

WRANGLER_LOG

WRANGLER_LOG

WRANGLER_LOG env variable set to

error

error

error

error or

none

none

none

none

VViper What my `.env` file should be like? I have it like this. ```.env binding="DB"...

M

Matt Silverlock•9/8/23, 11:20 AM

Nothing to do with your

.env

.env

file. You need to create the Pages binding to D1 in the dashboard first: 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 …

VViper What my `.env` file should be like? I have it like this. ```.env binding="DB"...

M

Matt Silverlock•9/8/23, 11:20 AM

process.env

process.env

process.env

process.env is how they are injected into Next.js within your code.

apologies, the error was actually `SqliteError: no such table: todos`

Similar Threads

Similar Threads

Similar Threads