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.how do I see which tables are being used the most within my project since I hit my usage limit?
title. I hit my usage limit for my database but I have multiple tables for different projects within that database. Is there anyway I can tell exactly which table was used the most and hit the usage limit?
Neon RLS and Clerk Authorization
I'm looking for some docs that explain how my clerk user is recognized by postgres? Aside from comparing a user_id from a token to a table field value, what if I just want to define read access to a role? Or what if I want to create a new role and use that to secure read access to a table? I feel like the end to end explanation is not documented anywhere that I have seen. At this point I have to resort to assumptions but it's not the best way to evaluate something I will be spending time and money on in the near future.
My Assumptions are:
- When I create a user in Clerk, I also have to create the same user in postgres via sql script? I'll assume I can use a webhook on the Clerk side to call an API on my side to handle this script execution....
Hyperdrive private tunnel
Itās not currently possible to use the private tunnel functionality in hyperdrive because
cloudflared cannot be installed. Is there any ongoing work to enable this functionality? https://developers.cloudflare.com/hyperdrive/configuration/connect-to-private-databaseusing Next.js 15 , neon , drizzle
trying to create role for Row-Level Security getting error : Tried to create a role with a NULL password
export const admin = pgRole("admin");
...
Cannot Connect Neon DB to Railway: Database connection error: Error: connect ECONNREFUSED ::1:5432
Hello! I'm building an app using neon for my database and railway to deploy but when deploying I get this error.
```
Database connection error: Error: connect ECONNREFUSED ::1:5432
at /app/node_modules/pg-pool/index.js:45:11...
Using chatgpt for database entry
Hi everyone! My name is Dave. Im new to this discord so i need help to navigate. Im building a new project and using chatgpt to generate the data for my database. I do t k ow if the question has been asked before but i would like to use chatgpt to automate the process. Can someone point me to a tutorial and give me some instruction on how to do it at the basic level, even if it means having to generate and import a csv or json file myself first, it would be a good firat step. My project is curre...