psm Posts - Answer Overflow

psm

Explore posts from servers

CDCloudflare Developers DDeno KKysely DTDrizzle Team

•Created by psm on 8/24/2024 in #help

Synchronous queries to SQLite?

Is there any way to make synchronous queries to SQLite? As I understand it, better-sqlite3 is a synchronous library and Kysely's SQLite dialect uses better-sqlite3, so is there a way to make synchronous queries?

4 replies

CDCloudflare Developers

•Created by psm on 3/12/2024 in #general-help

Cloudflare WARP on MacOS: "One or more processes are already bound to port 53: mDNSResponder"

I'm on an M2 Macbook Air with MacOS 14.2.1 Sonoma, and I just installed the Cloudflare WARP client. It installed fine, but now when I try to connect, it gives me the error "The WARP Agent must be the only process responsible for DNS resolution on the device. One or more processes are already bound to port 53: mDNSResponder". I've looked this up online, but all the solutions involve something with Docker Desktop, and I don't have Docker or Docker Desktop installed, so that's not my issue. Does anyone else know any processes or apps that might be responsible for this?

2 replies

DTDrizzle Team

•Created by psm on 9/27/2023 in #help

How to set a default value for column based on another column?

For example, if I had this schema:

export const posts = sqliteTable({
  id: integer("id").primaryKey(),
  title: text("title"),
  slug: text("slug").default(/* ??? */),
});

export const posts = sqliteTable({
  id: integer("id").primaryKey(),
  title: text("title"),
  slug: text("slug").default(/* ??? */),
});

How could I make the slug column's default be determined based on title via a slugify function?

19 replies

CDCloudflare Developers

•Created by psm on 9/26/2023 in #pages-help

D1 and KV bindings not showing up in production?

I'm using SvelteKit with @sveltejs/adapter-cloudflare, and I have all of my bindings listed in wrangler.toml. Wrangler picks these up locally, but when I deploy, the bindings aren't in platform.env. The only keys I see there are ASSETS, CF_PAGES, CF_PAGES_BRANCH, CF_PAGES_COMMIT_SHA, and CF_PAGES_URL.

2 replies

CDCloudflare Developers

•Created by psm on 9/20/2023 in #workers-help

How to stream responses?

I have a worker that makes multiple fetch requests in series, and I want to tell the client when each of these responses is completed. Is there some way to "stream" the response, so I can add more data at any point but still have it be sent back to the client?

1 replies

CDCloudflare Developers

•Created by psm on 9/2/2023 in #workers-help

Cloudflare caching ignoring no-store?

I have a pretty simple worker that proxies requests to a CDN with some added goodies. Since the CDN is pretty slow, it's nice to have Cloudflare caching the response of the worker, too. But when I added a ?reload search parameter which should force the worker to refetch from the CDN, it still seems to be caching the response. I made it by setting the Cache-Control header to no-store (as opposed to the default public, max-age=3600), which should, AFAIK, bypass the Cloudflare cache. However, when I look at the responses from my worker, I'm still seeing Cf-Cache-Status: HIT. Am I doing something wrong?

3 replies

CDCloudflare Developers

•Created by psm on 5/28/2023 in #pages-help

How to handle private assets with Cloudflare Pages & GitHub?

I'm making a website that uses licensed fonts that I obviously can't distribute, but I want the rest of my site to be open source (I'm using a GitHub repository). I have the folder with the fonts in my .gitignore, but the fonts need to get to Cloudflare somehow. I currently have Cloudflare set to deploy my site from the GitHub repo, but I can't upload the fonts to GitHub, so how should I deploy my site instead?

5 replies

Gaming

Programming