Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

stormy-gold
stormy-gold1/6/2024

Setting up sub DB for app Users

Our app requires setting up a private database (perhaps table) for users to store sensitive, private informations that can can be used store persisting data for use within their account. We have a Neon Instance with our database, and was wondering if this feature is doable with Neon or pointers on how to getting it done....
stormy-gold
stormy-gold1/5/2024

Question: Neon as storage..

Working on an app that needs a storage space for file documents (eg: ‘.txt’, ‘.pdf’ etc), but the files aren’t saving for some reason. I was wondering if such files can be stored in our Neon database, and if it’s best practice to do so. Intended use for the files are for use in AI applications. Thanks in advance for responding
stormy-gold
stormy-gold1/4/2024

Setting Up DATABASE_URL_UNPOOLED for Each Branch with Neon Plugin on Vercel

I'm currently working with the Neon plugin on Vercel. It's been great for linking my Vercel and Neon accounts, and everything's been running smoothly. However, I've been curious about how to configure the plugin to automatically set the DATABASE_URL and DATABASE_URL_POOLED environment variable for each new branch I create. Any ideas or tips on how to do this would be really helpful!
absent-sapphire
absent-sapphire1/1/2024

Subscribing to a remote database

Hi, I need to subscribe to a remote database somewhere else. Sadly Neon doesn't allow me to do this, because I need to be a super user. Is there a workaround for this?...
No description
apparent-cyan
apparent-cyan12/23/2023

File "require" not found when trying to connect to neondb database

Hello ! I tried neondb 2 months ago and i loved it. it worked fine until sundenly this errors appears, since i found no way to remove it. (Please check the message.txt file attach to it)...
optimistic-gold
optimistic-gold12/21/2023

API key per project or somehow restricted?

Is there an API key possible per project or restricted. If I am understanding correctly there is a superuser api key only and if I used it in correctly a github action can just delete my production project / prod branch using that one key?!
dependent-tan
dependent-tan12/21/2023

Use transaction query result in next query?

I checked here (https://github.com/neondatabase/serverless/blob/main/CONFIG.md#transaction-function) and didn't see an option, but: Is it possible for a query in a transaction set to reference a returned value from a previous query? E.g.: ```ts...
dependent-tan
dependent-tan12/20/2023

Persistent DuplicatedOperationError issues

Getting a lot of this when I first fire up our app for the day:
"Connection failed: {"errors":[{"errorType":"DuplicatedOperationError","message":"Duplicated operation with id 0fcfe9d7-afd7-46c6-bd80-3c2831381d89"}]}"
"Connection failed: {"errors":[{"errorType":"DuplicatedOperationError","message":"Duplicated operation with id 0fcfe9d7-afd7-46c6-bd80-3c2831381d89"}]}"
After a couple of page reloads, it stops. Should I be doing anything differently here? using fetchConnectionCache: true and using the non-pooled connection, via Lambda...
useful-bronze
useful-bronze12/19/2023

Trouble in pooled connection with SQLAlchemy

I'm trying to use a pooled connection with SQLAlchemy 2.0 but it keeps pointing that i need to disable the prepared statement cache size, which i already did. Anyone know what im doing wrong?? The error: ````...
rising-crimson
rising-crimson12/19/2023

DB URL w/ Vercel Integration

Hey all - really loving what Neon is doing. I saw recently that there is now a DATABASE_URL_UNPOOLED environment variable included in the Vercel integration. Is that intended for use with migrations, etc, and something we can rely on?
sensitive-blue
sensitive-blue12/17/2023

Too many connections to this endpoint. Please try again later

We have a PRO account and we are getting this error from our Cloudflare deployment when we try to connect.
afraid-scarlet
afraid-scarlet12/16/2023

How to list tables in the SQL Editor?

When trying to use \dt I get the error ERROR: syntax error at or near "\" (SQLSTATE 42601) . What command can I use to list the tables in the DB?
afraid-scarlet
afraid-scarlet12/16/2023

Parameter 'user' is missing in startup packet.

Seeing this error when attempting to connect to the DB through the command line, using a command that previously worked for me. Is this related to any ongoing outage?
conventional-tan
conventional-tan12/13/2023

Pooled connection with Neon serverless driver?

I'm getting a lot of Prepared statement does not exist errors. I'm using Drizzle with the @neondatabase/serverless driver. Should I not be using a pooled connection with this driver? It looks like other people are running into this as well: https://github.com/neondatabase/serverless/issues/53...
provincial-silver
provincial-silver12/13/2023

Database unavailable intermittently

Severity: Critical Business Impact Statement: Core revenue stream blocked. Risk of breach in FCA regulated compliance requirements. Problem Description: Our database becomes unavailable from our application and within the Neon console tables UI for long periods (up to minutes). We have tried increasing the base compute size but it seems to have made no difference. This is happening regularly (noticed multiple times a day as an end user). Is this something which is just due to Neon being unstable as a platform, or is this a problem with our database, can it be resolved?...
ambitious-aqua
ambitious-aqua12/13/2023

How to connect database from Visual Studio

Hi, I'm a newbie in using neon.tech. Can somebody help me connect database I created from Visual Studio, please? Thank you I use .net core mvc and c# to build a website...
No description
quickest-silver
quickest-silver12/12/2023

High amount of "Active time all computes"

Today I was surprised to see that I used 146% of "Active time all computes" and would like help in understanding how this works and how I used that much. I'm in the free tier and using Neon to test two apps that I'm developing using AppSheet. Neither of them are being actively used, only being slightly tested for now....
evident-indigo
evident-indigo12/12/2023

Sequelize and Neon ECONNREFUSED

Hi ! I am working on a Node.js project with Sequelize as the ORM. When I start my project locally on my machine, I am able to connect to the Neon database. However, on the production version of my app, I encounter an error: {"status":"error","statusCode":500,"message":"Error: connect ECONNREFUSED 3.126.212.11:5432"}...
dependent-tan
dependent-tan12/12/2023

Connection issues in dev mode

More woes in local/dev: ``` | Error: Console request failed: Request error: error sending request for url (http://neon-control-plane-api.neon-control-plane.svc.cluster.local:9095/management/api/v2/proxy_get_role_secret?session_id=...): error trying to connect: tcp connect error: Cannot assign requested address (os error 99) Caused by:...
stormy-gold
stormy-gold12/11/2023

Neon as file Storage?

Hello all, this is silly question, but it's worth asking to be sure. Can we use Neon as a file storage service to store assets like images etc?