Nick
Explore posts from serversDTDrizzle Team
•Created by Nick on 10/10/2024 in #help
Subquery select without left join
Is it possible to select fields from a correlated subquery on a table without doing a LEFT JOIN? Drizzle keeps telling me that it needs to be in a JOIN, but I don't want to join.
1 replies
DTDrizzle Team
•Created by Nick on 6/21/2024 in #help
Custom aggregation column types
I have a custom column type with Drizzle for a monetary amount column (numeric PG type). The type is transformed into a "Big" type from a library, allowing me to do decimal-accurate math.
However, in aggregations like sum, it goes back to being a string. Is there a way to write custom aggregations as well?
1 replies
CDCloudflare Developers
•Created by Nick on 1/23/2024 in #pages-help
Uploading assets for "direct deployment" CF Pages
We're building our CF page in our own service rather than using the CF build service. Our goal is to create a new (preview) deployment, retrieve the URL for that deplyoment (to use elsewhere), then upload the build assets to that deployment. How would we do that with the REST API?
I see the docs for creating a new deployment, but now how to push build assets to it: https://developers.cloudflare.com/api/operations/pages-deployment-create-deployment
2 replies
CDCloudflare Developers
•Created by Nick on 1/18/2024 in #workers-help
Too many redirects when making fetch requests from a worker
When I make a fetch request from a CF Worker, I'm getting a "Too many redirects" error from the fetch. The redirect URLs aren't changing, each new location is the same URL as the previous.
This only happens when making requests to the same domain that the worker lives on (different subdomain). When making a request manually from my device, there are no redirects. It happens with any URL on the same CF domain.
For example, if my CF worker lives on worker.example.com. When I use
fetch in the Worker to make a request to https://api.example.com/somepath, the Fetch errors out with an infinite redirect, where each redirect location is https://api.example.com/somepath. I can make manual requests to https://api.example.com/somepath from my device and do not see any redirects.9 replies
CDCloudflare Developers
•Created by Nick on 5/12/2023 in #pages-help
Deploy a production vs preview build using GitHub Actions
I have a GitHub action setup to build a React project, then deploy using this GitHub action: https://github.com/marketplace/actions/cloudflare-pages-github-action
When it deploys, it's deploying it as a preview build. How do I get it to deploy as a production build instead?
The docs seem to indicate that I can specify which branch is the production branch, but I've looked all over the Page settings in CF and don't see that option. It seems to be missing.
1 replies