Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

unwilling-turquoise
unwilling-turquoise9/7/2024

Multi-tenant Approach using One Project per Tenant

Is this sort of the ideal approach to multi-tenant (project per tenant) with Neon? ``` TENANT1_DATABASE_URL="postgresql://<user>:<password>@<endpoint_hostname>.neon.tech:<port>/<dbname>?sslmode=require"...
absent-sapphire
absent-sapphire9/6/2024

make case insensitive schema.prisma

Someone know what typo that I have, cause I thought it should be possible.
No description
adverse-sapphire
adverse-sapphire9/6/2024

High, inconsistent query latency in warm node from same region

I'm testing a project on Neon cloud (tiny-sky-56601552) in eu-central-1 and connecting from the same region, but get 40-60ms latency for simple queries. The latency should be single digit milliseconds as my queries are simple: insert into .. returning id or update .. where returning id, revision, etc. But I'm observing most queries take around 40-60ms to complete, with a few lucky ones randomly much faster at ~5ms (as it should be). This kills performance when executing even just a couple queries per request. Any ideas?...
rare-sapphire
rare-sapphire9/6/2024

Error ECONNREFUSED

Hi, Guys. First time using NodeJS and Neon. I'm having some troubles to connect with Neon. I copy the .env file and created the app.js. I'll post some photos of my app.js file and my database-postgres.js file and the error....
No description
conscious-sapphire
conscious-sapphire9/6/2024

Delete a materialized view

Whenever I try to delete a materialized view from the console. By dropping the table, it gives me this error. How can I get rid of materialized views?
No description
correct-apricot
correct-apricot9/5/2024

"Failed to fetch password" error in console

I thought I was just cleaning up some old roles on an older project, but I've messed something up. Now when I try to view the tables, or any data on the project, I get "Failed to fetch password" errors. I can access things with psql and from my app with a known-good role/password, but I don't really understand what role the UI is using and/or how to change it. I'd like to use the UI.
graceful-blue
graceful-blue9/5/2024

Last active on CLI?

Is there a way to get the Last active field from the browser UI with this command: neonctl branches list --project-id PROJECT_ID --output json? Currently, I only see a created_at and an updated_at, neither of which match the data of the Last active column. We're trying to automate branch cleanup and need this data to know which branches are safe to be pruned....
flat-fuchsia
flat-fuchsia9/4/2024

can an account can have multiple plans at once?

like seperate monthly payment, seperate dedicated resources
unwilling-turquoise
unwilling-turquoise9/4/2024

How does the neon client work?

Does this code snippet create a constant connection to the neon database? Or it only connects when it executes a query: ``` import { neon } from "@neondatabase/serverless"; import { drizzle } from "drizzle-orm/neon-http";...
like-gold
like-gold9/4/2024

delete-branch-action github action is flakey

I have the following github workflow, which gives me the error. However, this error is flakey and only sometimes shows up. Why?? ERROR: Not enough non-option arguments: got 0, need at least 1 Error: Process completed with exit code 1. ...
No description
robust-apricot
robust-apricot9/3/2024

Reached storage limit with 28 MiB data

Just got this banner that I've reached storage capacity (512 MiB, free tier) yet it's showing 29.82 MiB of actual stored data. I'm using a single branch and only have about 6 entries total between two tables. This looks like the same issue that Code Ducky ran into on 8/22. My project Id is quiet-field-31355758
No description
deep-jade
deep-jade9/2/2024

Storage size not accurate

I'm on the free plan currently, and the used storage size is not showing accurately. I have data worth around 160 MB, which was being shown properly, before I ran a migration which modified all the rows (1.32 mil) in a table, I just changed a column to use enum. Now it shows that my db is using 410+ MB. How can I fix this? Project ID: falling-lab-37192996...
No description
national-gold
national-gold9/2/2024

Database missing from Neon dashboard

Hi, I previously created a database using a certain email X. It's been a while since I've signed into the dashboard and I can't remember the password so I just went with the Google sign-in option with the same email X. However I'm unable to see the database in the dashboard. The database itself is still functioning i.e. I'm able to connect using the connection string. I'm unsure if this is a Neon issue or if I just used the wrong email. Is anyone able to check the email associated with the compute endpoint ID ep-damp-dew-134912? Thanks!...
genetic-orange
genetic-orange9/2/2024

Don't insert data on database with nextjs

Hello guys this query is working on nextjs? I execute but don't create table :/ and don't display error when i use this Error: relation "short_link_free" does not exist await sql( 'INSERT INTO short_link_free(origin, redirect, created, ip, country, activate) VALUES ($1,$2,$3,$4,$5,$6)', [origin, redirect, created, getIp, getCountry, activate]...
No description
xenophobic-harlequin
xenophobic-harlequin9/1/2024

When do the limits reset?

I had warning of database limit reaching to maximum for one a project on free plan, since most of the data is old data, I have taken backups and purged data from multiple tables. Now the database size should be very small, and it's the start of the new month, I am still seeing the usage warning on the dashboard and receiving warning emails. When does the limits reset on the dashboard?...
extended-salmon
extended-salmon9/1/2024

Guys can anyone help me out connection with postgres error

I just installed prisma in my nextjs project and pasted DATABASE_URL inside my env file. but when I push anything in my database it refuses the connection and gives error like Error: P1001: Can't reach database server. I am also having an error in my dashboard. Can anybody from the support team or the community help me out?
No description
absent-sapphire
absent-sapphire9/1/2024

Help with getting to subscribe

Possible to pay with something else where you don't need a credit card? Paypal/crypto/debit/skrill?
foreign-sapphire
foreign-sapphire8/31/2024

integration with Better Stack Logs

I currently use Better Stack Logs as a logging service for my service and services where I work and support, there I monitor the API, proxy, machines and more But one thing I can't monitor is the database, because I need to run some commands, but I don't know how I can do it There are so many commands, it would be unfeasible to send them here, but you can see the guide here: https://betterstack.com/docs/logs/postgresql/...
No description
conscious-sapphire
conscious-sapphire8/28/2024

Reset branch from parent without resetting password

Hey There, we use one protected master branch and several child development branches, which we regularly reset from the master branch to keep them up to date. However, each time we do a reset, the password changes and we have to update all development environments with the newest credentials. Is there a way to keep the old branch password when resetting?...