Cloudflare Developers•2y ago

call your API endpoint directly when your business logic calls your function to create a new item?

Max (@rozenmd)OP•7/12/24, 7:59 AM

though that doesn't help if you're letting folks use the dashboard to directly edit the DB

RRahul Is there any trigger function in Cloudflare worker when data changes in D1? like...

Matt Silverlock•7/12/24, 10:30 AM

D1 does support SQL based triggers right now, to be clear.

Matt Silverlock•7/12/24, 10:30 AM

CREATE TRIGGER

CREATE TRIGGER

statements work.

MMax (@rozenmd)call your API endpoint directly when your business logic calls your function to ...

森

森@VerseLink (RW)•7/12/24, 11:19 AM

yeh that's what i had in mind as a suggestion for rahul too
it's more cumbersome but it can work for now

Sam•7/12/24, 3:16 PM

Why is the location not shown within the dashboard? Would be cool to have an easy way to confirm where the D1 is running, and the data is already available in the api.

SSam Why is the location not shown within the dashboard? Would be cool to have an eas...

Max (@rozenmd)OP•7/12/24, 4:48 PM

good idea, we'll add it

Max (@rozenmd)OP•7/12/24, 4:48 PM

not everything has an explicit reason btw, sometimes we miss things

森

森@VerseLink (RW)•7/12/24, 9:44 PM

Is there a roadmap of when we can get to Sessions API for D1? As in could we expect it to be released soon, or would it take a while?

Cory•7/13/24, 12:14 AM

Are there any plans to add realtime sync to D1?

Cory•7/13/24, 12:15 AM

Recently ran into https://www.triplit.dev/ which looks very cool

Vijay•7/13/24, 8:43 AM

@Cloudflare (Dev) why there is no rename option for files in my r2 buckets? any specific reasons, I need to rename few files?

VVijay @Cloudflare (Dev) why there is no rename option for files in my r2 buckets? any ...

Hello, I’m Allie!•7/13/24, 9:01 AM

Try #r2

RRahul For example, using a Firebase function, when new user data is saved in Firebase ...

Isaac McFadyen•7/13/24, 3:59 PM

So I think they're suggesting that you just call your API endpoint when creating a new user.

Isaac McFadyen•7/13/24, 3:59 PM

In your example, rather than creating user in the Function -> firebase calls your endpoint, you just create user and then call your endpoint from the same Function.

ZZiga Zajc Any estimates on when the feature to dynamically create multiple databases would...

Hello, I’m Allie!•7/13/24, 7:11 PM

:soontm:

MMax (@rozenmd)good idea, we'll add it

Sam•7/13/24, 7:47 PM

Also — and sorry for mentioning you, it would also be really cool if we could add descriptions to the D1’s. So team members can see what the D1 is exactly for.

Same for R2, queue’s and a single Worker.

森森@VerseLink (RW)Is there a roadmap of when we can get to Sessions API for D1? As in could we exp...

murzin•7/13/24, 8:44 PM

Any updates on this? Would be insanely dope to have replicas for D1

murzin•7/13/24, 8:46 PM

Also if you need any alpha testers, all for it

ZZiga Zajc also based on Slovenian law, everything needs to be stored for at least 10 years

Hello, I’m Allie!•7/14/24, 8:36 AM

Another thing too is that while the law may require storing data for 10 years, it may only be actively used for a shorter period of time. Any data that is older than that could be pushed as a compressed dump to R2, for example

Hello, I’m Allie!•7/14/24, 8:37 AM

It’s still there, and can still be recalled, but it won’t count toward the 10 GB limit

wataru•7/14/24, 7:12 PM

Hello. I have a question. How would you connect a local Cloudflare D1 DB through a script?

This is

exec.ts

exec.ts

, I will want to use this script for seeding against my local environment.

import { Log, LogLevel, Miniflare } from "miniflare";

const nullScript =
  "export default {fetch: () => new Response(null, {status:404})};";
const mf = new Miniflare({
  modules: true,
  script: nullScript,
  d1Databases: { DB: "xxx-xxx" },
  log: new Log(LogLevel.INFO),
});

const env = await mf.getBindings();
const { results } = await (env.DB as D1Database)
  .prepare(`PRAGMA table_list;`)
  .all();
console.log(results);
await mf.dispose();

import { Log, LogLevel, Miniflare } from "miniflare";

const nullScript =
  "export default {fetch: () => new Response(null, {status:404})};";
const mf = new Miniflare({
  modules: true,
  script: nullScript,
  d1Databases: { DB: "xxx-xxx" },
  log: new Log(LogLevel.INFO),
});

const env = await mf.getBindings();
const { results } = await (env.DB as D1Database)
  .prepare(`PRAGMA table_list;`)
  .all();
console.log(results);
await mf.dispose();

Then, I'm executing this with

npx tsx exec.ts

npx tsx exec.ts

The app’s D1 has a “users” table that I created through the

wrangler d1 execute

wrangler d1 execute

command. The Miniflare in the

exec.ts

exec.ts

doesn't acknowledge the “users” table.

I have only one D1 Database, and can confirm that the

.wrangler/state/v3/d1/miniflare-D1DatabaseObject

.wrangler/state/v3/d1/miniflare-D1DatabaseObject

has only one set of files.

Your help is appreciated!

bennycondon•7/15/24, 3:27 AM

Hey there! This might be more of an SQLite question than a D1 quetion. But, is there a way to treat NULLs as indistinct in SQLite? I found this, which explains there is NULL_ALWAYS_DISTINCT to always treat NULLs as distinct. But, I haven't found a way to always treat NULLs as indistinct? I'd like to to perform INSERT OR IGNORE queries using ON CONFLICT and a UNIQUE CONSTRAINT that may include NULLs.

布

布鲁诺普雷托•7/15/24, 2:07 PM

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

CREATE TABLE Players (
  player_id INT PRIMARY KEY,
  player_name VARCHAR(50) NOT NULL,
  server_id INT,
  FOREIGN KEY (server_id) REFERENCES Servers(server_id)
);

Does D1 support this as well as junction tables

布布鲁诺普雷托 ```sql CREATE TABLE Players ( player_id INT PRIMARY KEY, player_name VARCHAR...

Matt Silverlock•7/15/24, 7:22 PM

Foreign keys? Yes. https://developers.cloudflare.com/d1/build-with-d1/foreign-keys/

Cloudflare Docs

Define foreign keys · Cloudflare D1 docs

D1 supports defining and enforcing foreign key constraints across tables in a database.

thipperz•7/16/24, 2:01 AM

i'm seeing some nice improvements to D1 dashboard (i.e. more rows per page and ordering finally) - keep it up!

wot•7/16/24, 12:55 PM

Won't let me select today for recovery. Earliest I could do was Yesterday at 23:59:59.

Wwot Won't let me select today for recovery. Earliest I could do was Yesterday at 23:...

Max (@rozenmd)OP•7/16/24, 1:54 PM

that's weird, if you go to your system's shell or terminal and type

date

date

, what's the output?

MMax (@rozenmd)that's weird, if you go to your system's shell or terminal and type `date`, what...

wot•7/16/24, 2:17 PM

Tue 16 Jul 2024 10:17:08 AM EDT

wot•7/16/24, 2:18 PM

It states I should be able to restore today but I can't unfortunately, right when I needed it.

Wwot It states I *should* be able to restore today but I can't unfortunately, right w...

Max (@rozenmd)OP•7/16/24, 2:44 PM

this might sound crazy, but can you change your system's timezone to London (UTC+1) and refresh?

Max (@rozenmd)OP•7/16/24, 2:44 PM

looks like a bug in how the UI has handled timezones

MMax (@rozenmd)this might sound crazy, but can you change your system's timezone to London (UTC...

wot•7/16/24, 2:57 PM

Yes that works... I should've never left the UK huh

wot•7/16/24, 2:58 PM

Thanks for figuring that out. I'll know for next time I botch a migration.

import { Log, LogLevel, Miniflare } from "miniflare"; const nullScript = "export default {fetch: () => new Response(null, {status:404})};"; const mf = new Miniflare({ modules: true, script: nullScript, d1Databases: { DB: "xxx-xxx" }, log: new Log(LogLevel.INFO), }); const env = await mf.getBindings(); const { results } = await (env.DB as D1Database) .prepare(`PRAGMA table_list;`) .all(); console.log(results); await mf.dispose();

call your API endpoint directly when your business logic calls your function to create a new item?

Similar Threads

Similar Threads

Similar Threads