Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

fair-rose
fair-rose12/23/2024

asyncpg acquire timeout

Hi! i was migrating db from mongodb to postgres using asyncpg and created pool and did pool.acquire to get connection and passed to functions One of the functions had to call discord api to check some stuff which took quite some time and when it completed, i got connection has been back to pool So is there any time limit after which the connection is released back to pool ?...
dependent-tan
dependent-tan12/9/2024

Install the Neon Postgres Native Integra...

hey all, following the Install the Neon Postgres Native Integration on Vercel guide, but after installing there is no option to navigate to the Neon account the installation process says it creates. Does anyone know why? I'm selecting the postgres option here, is the integration not live yet? https://neon.tech/docs/guides/vercel-native-integration#need-help...
No description
eager-peach
eager-peach11/28/2024

If I use a db for a vercel project I can

If I use a db for a vercel project I can't connect via neon cli?
xenial-black
xenial-black11/14/2024

```

``` import { drizzle } from "drizzle-orm/neon-http"; import { neon } from "@neondatabase/serverless"; import { config } from "dotenv"; ...
optimistic-gold
optimistic-gold11/9/2024

I have been using neon db for my expo

I have been using neon db for my expo react native application for server routes but in the production phase I need clear routes for the backend route that I was using locally. Something like "https://..." am getting this error "'Fetch error:', [TypeError: Invalid URL: /(api)/driver/create]" Where can I go to get that url? Or any procedures I can take to get that working
stormy-gold
stormy-gold10/25/2024

new RLS feature from Neon

any RLS aficionados in here? we have a pretty cool new feature around making RLS easier and would love to get a few users testing
stormy-gold
stormy-gold10/7/2024

create role error

Hi Tristan, It's a service account that automatically creates the role upon request. I'm not sure to how exactly this service account creates roles. Obviously the best course here is to create the role with password, but in my case with the service account that's not possible....
harsh-harlequin
harsh-harlequin10/5/2024

My Neon console is showing the database

My Neon console is showing the database is running but the prisma is unable to connect it. I checked the connection string but it not able to connect.
conscious-sapphire
conscious-sapphire10/1/2024

Hello, I don't know which branch to ask

Hello, I don't know which branch to ask this question, so I will ask it here. As I understand it, Neon doesn't work with postgres as 2 different applications, so the question is how do you avoid longjmp from postgres in case of a critical error. Can someone tell us or give a link to this discussion?
absent-sapphire
absent-sapphire9/12/2024

In regards to databases with serverless

In regards to databases with serverless deployment, does Neon offer features like built-in triggers, push/pull updates (firebase/supabase) or other database features along those lines? Would we have to develop in house solutions ourselves?
other-emerald
other-emerald9/12/2024

what's your connection string and can

what's your connection string and can you fill out the picture
plain-purple
plain-purple9/12/2024

support/connections

Okay, so I'm likely going into the basic plan, how can I get a good idea of my limitations, and am I supposed to contact support to get past the 64 default connections? Sorry, if these are dumb questions.
stormy-gold
stormy-gold8/26/2024

How are we able to rollback transactions

How are we able to rollback transactions made within the Neon rest api?
genetic-orange
genetic-orange8/26/2024

trying to connect with psql from win 10

trying to connect with psql from win 10 box, but getting a connection error. all I do is, run "psql postgresql://neondb_owner:GBPr1epQY8Cg@ep-white-dew-a6toqdmj.us-west-2.aws.neon.tech/neondb?sslmode=require" from a cmd line prompt. what am I missing?
adverse-sapphire
adverse-sapphire8/14/2024

You're welcome. Do consider hosting

You're welcome. Do consider hosting Redis or some in-memory solution on Neon if possible. Would love it.
rival-black
rival-black8/13/2024

hey I'm new here , I found neon is a b

hey I'm new here , I found neon is a b etter alternate to meta , how to see my server or dashboard of postgreSQL
ratty-blush
ratty-blush8/13/2024

Hi, I use postgres. I connected and have

Hi, I use postgres. I connected and have error: ERROR: remaining connection slots are reserved for roles with the SUPERUSER attribute. Please help me
conscious-sapphire
conscious-sapphire8/9/2024

Does neon work as a solution for

Does neon work as a solution for postgres with schema based multi-tenancy?
unwilling-turquoise
unwilling-turquoise8/5/2024

hello, i keep getting this error when

hello, i keep getting this error when trying to connect .. it connected at. home but right now I am at the library and it is no longer connectiing .. does anyone have any advice ? Error connecting to PostgreSQL Database: connection to server at xyz.us-east-2.aws.neon.tech port 5432 failed: Operation timed out Is the server running on that host and accepting TCP/IP connections?...
relaxed-coral
relaxed-coral8/5/2024

conn = _connect(dsn, connection_factory=

conn = _connect(dsn, connection_factory=connection_factory, **kwasync) django.db.utils.OperationalError: connection to server at "ep-billowing-resonance-a54yftck.us-east-2.aws.neon.tech" (3.143.47.40), port 5432 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. I got this error when I try to "py manage.py migrate"...