okay I think we're gonna raise this higher. Creating new DBs being broken is one thing, but migratio

okay I think we're gonna raise this higher. Creating new DBs being broken is one thing, but migrations being broken is a big deal. Give us a moment

JamesOP•11/24/23, 10:42 PM

Thanks for the info all

JJames okay I think we're gonna raise this higher. Creating new DBs being broken is one...

Matt Silverlock•11/24/23, 10:44 PM

@rozenmd

andy__yo•11/24/23, 10:47 PM

Is there any starter repo for nextjs with CloudFlare D1 on Drizzle? I am new to the CloudFlare environment, I tried with bindings as per doc couldn't get that up running.

Aandy__yo Is there any starter repo for nextjs with CloudFlare D1 on Drizzle? I am new to...

Matt Silverlock•11/24/23, 10:48 PM

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

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 …

Matt Silverlock•11/24/23, 10:51 PM

Hi folks - we’re having some API issues specific to D1 and expect to remediate shortly.

Matt Silverlock•11/24/23, 11:13 PM

@D1 Database Issues with the D1 API (including the dashboard) should now be resolved. We attempted to roll out an important fix, but introduced an authentication issue. We've rolled this back until we can re-test the fix.

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

JamesOP•11/24/23, 11:16 PM

Thanks Matt. It might be good to get a retro status page up for this, just in case folks had hit errors in their CI and can correlate the time it happened to the status report.

Constantin•11/24/23, 11:18 PM

is there a cloudflare features roadmap? i'm curious in an auth/user management feature

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

Rob M.•11/24/23, 11:22 PM

Still can't access the D1 Dashboard blobhaj

CConstantin is there a cloudflare features roadmap? i'm curious in an auth/user management f...

Cyb3r-Jak3•11/24/23, 11:23 PM

Non I’m aware of. They do typically announce stuff with blog posts so can follow those

Constantin•11/24/23, 11:30 PM

it's the last missing part of the puzzle imho

. it feels bad to use a 3rd party provider (hosted in a different region/cloud infra) and wait for users to login. i'm implementing my own, however users has been allways a hard thing to reason about

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

Max (@rozenmd)•11/24/23, 11:32 PM

Should be working now in EMEA

Unsmart•11/24/23, 11:32 PM

Tbh doing your own auth is a million times better than using a service even if the cloud service you host on is the one offering it. Lucia auth works wonders and has D1 compat. @cmnstmntmn

Constantin•11/24/23, 11:35 PM

indeed now i'm setting it up

UUnsmart Tbh doing your own auth is a million times better than using a service even if t...

Isaac McFadyen•11/24/23, 11:35 PM

That's very much an opinion though, I'd argue at larger scales it's a lot of extra work to do your own auth

Isaac McFadyen•11/24/23, 11:36 PM

For an indie dev or startup? Maybe best.

Isaac McFadyen•11/24/23, 11:36 PM

For a big business who just wants to focus on their business? Maybe not.

Unsmart•11/24/23, 11:36 PM

Everything is always opions of course but mine is right Kapp

Constantin•11/24/23, 11:37 PM

yeah, and i really had bad experiences before with auth0 .. never again

Constantin•11/24/23, 11:38 PM

such a bad piece of software, that costs a furtune ..

Unsmart•11/24/23, 11:39 PM

Yeah my work was using auth0... it was terrible. Now we use cognito... its also terrible KEKW

Tried using clerk/supabase and a few others all of em suck

Matt Silverlock•11/24/23, 11:40 PM

I’m a big fan of Clerk. Lucia is nice for self-managed but if I was building from scratch I’d use Clerk for my MVP. Auth is hard, and is more than just the login part. Error handling, attribution, etc all important.

Constantin•11/24/23, 11:40 PM

i was looking into stytch .. that a bit different, but still not entirely happy about it

Unsmart•11/24/23, 11:40 PM

Supabase might actually make a lot of sense to use if you use their database since it does integrate with it pretty well but I dont use SQL much

Constantin•11/24/23, 11:43 PM

i was thinking that having Zero Trust product .. would be easly for CF to extend it to a wider scope

Unsmart•11/24/23, 11:44 PM

I've never had to do SSO before so maybe that parts hard but everything else isnt too bad imo

Also a lot of times not even doing password and only allowing auth with google is the way to go.

Constantin•11/24/23, 11:50 PM

my journey with the current project, started with vercel .. but they don't have user mgmt; then i added supabase and wanted to go fully with them, but they don't have hosting .. :)) that's crazy

Constantin•11/24/23, 11:50 PM

but CF seems to have almost all i need

Constantin•11/24/23, 11:51 PM

even the ques feature

Constantin•11/24/23, 11:52 PM

so i don't have to pick a 3rd party for long running tasks. great product!

MMatt Silverlock @D1 Database Issues with the D1 API (including the dashboard) should now be reso...

Matt Silverlock•11/25/23, 12:13 AM

https://www.cloudflarestatus.com/incidents/qhqg8dj5y14g (this is now resolved)

Issues with D1 API and dashboard

Constantin•11/25/23, 12:49 AM

one question related to D1/micrations and CI/CD;

Constantin•11/25/23, 12:49 AM

i have a migration

Constantin•11/25/23, 12:51 AM

-- Migration number: 0001      2023-11-24T23:25:49.684Z
-- Up

CREATE TABLE user (
    id VARCHAR(15) PRIMARY KEY,
    username VARCHAR(31) NOT NULL UNIQUE
);

-- Migration number: 0001      2023-11-24T23:25:49.684Z
-- Up

CREATE TABLE user (
    id VARCHAR(15) PRIMARY KEY,
    username VARCHAR(31) NOT NULL UNIQUE
);

and the wrangler.toml

[env.staging]
[[d1_databases]]
binding = "DB"
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
migrations_table = "d1_migrations"
migrations_dir = "migrations"

[env.staging]
[[d1_databases]]
binding = "DB"
database_name = "user"
database_id = "97285d4c-b85d-4df9-b44f-d4411fe1cbbc"
migrations_table = "d1_migrations"
migrations_dir = "migrations"

Constantin•11/25/23, 12:52 AM

does the migrations are auto applied as part of deployment? or a custom CI/CD pipeline should orchestrate the process?

CConstantin does the migrations are auto applied as part of deployment? or a custom CI/CD pi...

Matt Silverlock•11/25/23, 12:55 AM

You need to apply them manually, or by invoking wrangler d1 migrationswrangler d1 migrations as part of your CI/CD workflow

Constantin•11/25/23, 12:56 AM

johnswarbrick•11/25/23, 12:00 PM

Hi - could someone please help me understand the purpose of the success: boolean,success: boolean, response in the D1ResultD1Result object?

If the SQL query is malformed or fails, then there is an

error

error

response which I'm picking up with catch (error)catch (error)

if the query is successful then success: truesuccess: true even if there are 0 results matched, which I would expect.

But when would success:success: ever be

false

false

?

I was kinda expecting success: falsesuccess: false to be returned when the query failed with a SQL error?

Original message was deleted

johnswarbrick•11/25/23, 1:55 PM

Thanks for the reply @nora. It does indeed seem that success: booleansuccess: boolean is redundant!

Constantin•11/25/23, 5:51 PM

hey, is it possible to enforce d1/sql table/row policies?

CConstantin hey, is it possible to enforce d1/sql table/row policies?

Matt Silverlock•11/25/23, 9:38 PM

No, D1 doesn’t support row-level security. Not something we plan in the near term.

Bulbasaur•11/25/23, 9:47 PM

is D1 globally read replicated at all yet? Or still just single-region?

Bulbasaur•11/25/23, 9:48 PM

And is that theoretically planned to be a 1.0 feature or... later?

BBulbasaur And is that theoretically planned to be a 1.0 feature or... later?

Matt Silverlock•11/25/23, 9:49 PM

d1-database

Bulbasaur•11/25/23, 9:51 PM

Gotcha cool, I didn't see any mentions in the dos, it might be helpful to have a list of the "still to be implemented" features (unless I missed it)

AAlexander I believe I was never able to access the D1 Dashboard, I get all ways the Worker...

Rob M.•11/25/23, 11:21 PM

Looks like you need to create a worker/page first.

okay I think we're gonna raise this higher. Creating new DBs being broken is one thing, but migratio

Similar Threads

Similar Threads

Similar Threads