Setting temp_file_limit
As a security precaution i would like to be able to set temp_file_limit in a session. However i get a permissions denied error, im assuming because neon does not give out superuser roles to us (which is understandable). Is there any possible workarounds here? Open to using other non-superuser settings that achieve a similar effect (for context im trying to block malicious queries that would consume a ton of resources, such as a recursive cte that runs forever).
Thanks !
more info:...
Vercel integration and migrations
When I migrate my vercel-dev branch (that I use for local testing) using
drizzle-kit migrate and then deploy to production, will my main neon branch get migrated as well or do I have to manually change something? Im confused on the process of how to sync the migration of my production db branch with my app's deployments.
Thank you for any advice!!...How can I merge my branches?
Hello members! I hope you're doing well!
I'm new in this platform and I wanted to ask if I'm able to do a merge of my branches in the web platform of Neon. Thanks in advance....
Looking for advice on local vs prod setup
Hey all, first time dabbling so excuse the beginner question. I'm looking for advice on the best approach to tackle local dev vs the production environment. In my mind I'd like to use neon just for the production env so that I don't churn through my free tier allowance while deving locally, but I'm not sure on the best way to approach this. Local postgreSQL db with the data duplicated over to neon?
Missing Database
I had a database disappear from Neon. I am not aware of anything that I did to remove. When I look at the dashboard, I have one branch and one compute as expected but only the development database. The database that I was using for my production instance does not appear on the dashboard and I can no longer access it using the connect string that worked earlier today. Does anyone know how I can get it back? Thanks.
Failing to connect to the DB.
I have a nodejs application and I have been trying to connect using the conncetion string but I have just been getting errors
Here is the code
`const { Client } = require("pg");...
Free Data Transer Limit - Month Period
Hey there,
Realy enjoing working with neondb so far.
I use a lot of request to fill up the DB with relevent data, bu i didnt realy optimize my call I think.
Anyway I'm apporching the free data transfer limit.
But as my application is not use a lot I think the free plan will work for daily use....
Interactive transactions and serverless
Hey there, happy neon users this side š
we've been using neon with the http transport on cloudflare workers, recent additions to the product requires us to use transactions (interactive)
from what I've read so far since the http transport doesn't support transactions we'd need to use the serverless Pool/client the websocket based transports, however this feels like an anit-pattern to use a pool/client in a serverless environment like workers where it'll be connected/disconnected per request, ...
Failed to connect to database: failed to connect to `user=user database=db`:
Hi all,
Iām new to Neon and currently setting up a project using Go with Neon and PostgreSQL. While following the connection string provided in the quickstart guide, Iām encountering a timeout error when trying to connect to the database.
Hereās what Iāve tried so far:...
Schema Diff - don't see changes in compare
I've tested a few different use-cases.
SQL editor, UI, and in my CMS. The only time I see a different in my compare is when I run a script in the UI. If I create a new table via the UI or if I create a table via my CMS... i don't see the changes between branches. Any ideas?...
Cant run query and also cant access Table
Recently created a new project then try to run query from dashboard i can't run it, it throw Unknown Error and also cant access tables page
WS to connect to the db failed
I set up prisma to use neon the way it was shown in their docs but i kept getting this error
this is my code for the db setup
```...
How scalable and performant is Neon, compared to Supabase?
Could you answer these two questions I posted to the Supabase GitHub discussions, but as it pertains to Neon? I am on the fence about which one to go with (Supabase vs. Neon), because I would like a cloud SQL solution which:
1. Is easy to deploy, use, and autoscale, without being a master devops engineer.
2. Allows for a very large (or infinite) amount of db connections (with automatic pooling for fast startup).
3. Returns most queries in under 1 second....
didn't find my project
I have a project on Neon but after I disconnected and then when I connected it, I didn't find my project. And display this screen shot. Can anyone help me?
Limit reached
Team,
Iām working on a project using Neon DB integrated through Vercel, but now Iām getting this error:
PostgresError: Your project has exceeded the data transfer quota. Upgrade your plan to increase limits.
...drizzle uuid troubles
Hello, I am just exploring NextJS finally. I have a drizzle, neon setup. Was originally following a theo.gg tutorial. I am not super versed in postgres or db design tbh. But all the DB's I've worked in use a uuid as the userID for security i guess. However when I try and push up the uuid table I get
PostgresError: identity column type must be smallint, integer, or bigint. Can someone help me understand what is going on here? Is this a neon thing? Are UUIDs not good for identifiers? I think I am missing a piece of this puzzle. Here is my table in drizzle:
```ts
export const users = createTable(
"user",
{...1 project multiple tenants vs Project per tenant
Hey people!
I was wondering if I rather should setup a tenant per project or just go with one project where I have my catalog and all my tenants as new database (since I realised there can be multiple databases per branch) it seemed actually better that if I setup a new branch I already create a new version for all the tenants as well without having to create a new branch for all the tenants.
Any experience with this?
Is there a limitation to how many databases one can setup per projekt?...
websocket connection failed
i have just created a new account and not able to connect my postgre sql db with my next.js project , also the table section throwing erros
need help ??...
Can't connect to Sydney region but can connect to EU using neon driver
Hi, I'm in EU, and I'm trying to connect to the Sydney region as that's where my main DB will live.
I can connect using psql, but not the neon driver, it seems to timeout straight away.
I'm trying to run drizzle-kit push
I'm using Next.js locally to connect with drizzle ORM....
Rust crate or example for AWS lambda or Netlify Functions
I'm using Netlify Functions (AWS lambda with Rust) to connect to Neon (postgres) and have it working fine.
The only issue I had was to have to config (Fixed: Not sure if it was due to moving my lambda region to match the region I'm using for Neon or updating the node version of the lambda build).
Questions:...
tokio-postgres to use IPv4 due to an error ("Address family not supported by protocol"), but want to use the host instead. I'm sure the IP address could change at any time and will break eventually.