Budi
Explore posts from serversAdd caching to Node Dockerfile
I want to ask for feedback on my Dockerfile. This is the first time I've set up caching.
This Dockerfile works. My first deploy of this file was 143 secs, the second 124 secs. But that's still really slow IMO for that second try. Have I set this up properly for Node and PNPM as package manager?
Is there anything else I can do to speed these builds up?
I also noticed it's required to hardcode your
session-id
. I've now bound this to the service-id
of my main
production environment in Railway. What are the implication of this when a different environment is created in Railway for your project, for example when you create a new PR on Github?
Thanks!
59 replies
Help with Github automatic deployments
I've configured Github Automatic deployments per the docs. My production service is linked to my
/main
branch in the repo. I further have PR environments enabled and give them the env vars of main
.
1. New Railway environments are created successfully whenever we create a new PR, however they don't appear to close after we merge and close the PRs.
2. Also, the environments don't start with any services and therefore don't automatically deploy anything. The only workaround I've found is to manually enter the PR env in the Railway GUI and to sync the services with the ones running in the production environment.
3. The Railway bot comments on our PRs but always says the environment's deleted. See screenshot.
How can I fix these issues? Thanks.10 replies
Private networking in SvelteKit app
I've deployed a SvelteKit application on Railway using a Dockerfile. Within that project I have a separate service for cron jobs, also deployed with a Dockerfile.
The cron service calls endpoints on my SvelteKit application. This works fine using the public domain of the app service using HTTPS, but when attempting to use private networking it doesn't work.
In my app service, I've configured the server to listen on
0.0.0.0
with Railway's injected port. This builds well and logs Listening on 0.0.0.0:8080
, so I know it's working.
37 replies
DTDrizzle Team
•Created by Budi on 3/31/2024 in #help
What's the best way to query my db?
I'm running Supabase Postgres locally with Drizzle.
In production, I'd use the connection pooler which would ensure I don't have too many concurrent connections.
I can't locally however and Supabase often gives this error:
PostgresError: remaining connection slots are reserved for non-replication superuser connections
.
I'm initiating the db as such:
And then in the necessary functions I import db and call it, like so: const database = db()
.
I have many helper functions which each create a db connection for the query, for example:
Is this the right way of doing things? Or should I pass the database to the helper functions, instead of initiating a connection there?
I want to ensure I'm not creating unnecessary connections to the DB. Are there any best practices I should be aware of?
Thanks!8 replies
DTDrizzle Team
•Created by Budi on 3/30/2024 in #help
Studio not enough info to infer relation
I'm getting this error:
Here's my schema:
https://github.com/budivoogt/bv_markdown_blog/blob/a15ec5062337460647693dd070e504e9eca54e14/src/lib/schemas/drizzleSchema.ts
I believe I followed the docs carefully and ensured every table has its relations defined. The app works fine but studio doesn't launch. Any suggestions?
19 replies
DTDrizzle Team
•Created by Budi on 3/15/2024 in #help
Can't access innerJoin result in page data using Svelte
In src/routes/+layout.server.ts I have this load function, which returns postTags via a Drizzle query to my Supabase Postgres DB. It's successfully returning a result which I'm able to log to my console.
However, I am unable to access the property via export let data or $page.data on child pages. Strangely, the other properties returned from my load functions are made accessible fine. I don't have any load functions that override the returned postTags in this server load function.
Why could this be? I can't figure it out and since the other properties are returning fine, I doubt it's a Svelte issue. I'm not getting any typescript errors either. So I suspect it may be something related to the ORM. Thanks!
Relevant code:
https://github.com/brucey0x/bv_markdown_blog/blob/ebe102f5a4713443d5b2e8e1c1a77cad6b88403c/src/routes/%2Blayout.server.ts
https://github.com/brucey0x/bv_markdown_blog/blob/ebe102f5a4713443d5b2e8e1c1a77cad6b88403c/src/app.d.ts
4 replies
DTDrizzle Team
•Created by Budi on 12/29/2023 in #help
Drizzle Studio not working with bun
I had a basic project running with pnpm, then switched to bun and removed the dotenv package and its imports in
/drizzle.config.ts
.
Now when I run bun drizzle-kit studio
I get this error:
/drizzle/drizzle.config.json file does not exist
Previously it didn't look in the /drizzle folder for the config file, and automatically detected that my config was in root and ended with a .ts extension.
If I run bun drizzle-kit studio --config ../drizzle.config.ts
it picks up the config file, but I get this error:
Here's my drizzle.config.ts
:
The one change I've made to my config file is that I removed the dotenv package that I previously used (when still using pnpm/node). It seems that drizzle studio isn't picking up the env variables via bun.
Is this intentional behaviour? How should I resolve this? Thanks!2 replies