Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

genetic-orange

12/10/2024

Read replica/primary limits

- Based on this image, it looks like replica using same compute (resources) with primary. So for eaxample on Scale plan it still will be in sum maximum 8CU (for example 4CU primary + 4CU read replica or 6CU primary 2CU read replica, so it can be 8CU for primary and 8CU for read replica) right? - Max connection on 8CU will be 3604 in sum (primary + all read replicas) right? - Is there any replica lag? thank you...

rising-crimson

12/10/2024

348 GB of Data Transfer?

Our Dashboard shows 348.45 GB of data transfer, our whole database is 69 MiB (nice). How is this possible? Curios to see that I’m getting the exactly same info from my computer (“Usage since Dec 3, 2024”) and my iPad (“Usage since Nov 30, 2024”), for some reason the dates are different while the information is the same. I’m available if you guys need to debug something....

sensitive-blue

12/10/2024

change the region?

Can I know how to

eastern-cyan

12/9/2024

"Unexpected error" on tables pages

Why do I get an "unexpected error...report to our support team" (TypeError: s.toSorted is not a function...) on the tables page? This has occurred with both of my DBs (one disconnected/inactive). The data is still accessible programmatically. I have not changed the DB schemas or API since checking the tables page several days ago. I would greatly appreciate any help!...

foreign-sapphire

12/8/2024

(Incorrect?) Exceeding Storage Limit on Free Tier

Dear, Currently I am working on a project using the Neon Tech free tier. Unfortunately I think an error has occured thinking I exceeded the storage limit for my tier. When I look at storage in Account Usage it states that I used 0.52/0.47 GiB but when 1 look at the Review Usage tab I can see that I only used 0.01/0.5 GB per month. Is this indeed an error or did I do something wrong? I would love to hear from you. Kind regards, ...

conscious-sapphire

12/7/2024

Project went 16gb over compute hours without having worked on it since the new periode

So I have this nextjs application where I seed your(neon) database (once, not every boot) with a sql file which creates two tables to display chat messages. Total chat users e.g. : Row A - Name, Row B - Name, this only contans 5 or six rows. Then I have the table which I tore the messages in which accumilate around, well i'm not sure 250-500k. I query on the front-end (NextJS) via drizzle ORM which worked perfectly fine, I check the first table to match name in table 2 with the messages and dispay whatsapp history like that, with some additionalf eaturs like favouriting, better-search yadadad. Long story short. Previous month I just got over 5gb due to importing hundred thousands of sql statements I suppose. This month I worked about a day on it but did NOT import anything not really change anything int he query language but for some reason now I can't work on the project because i'm over the quota. Which also means I can't dump my data out of your panel it seems like....

passive-yellow

12/7/2024

Delete parent branch (or make new parent)

This question was asked by someone else a few months ago but not answered. The situation is that we forgot we were on a child branch and progressed a lot both in schema and data changes. It has exactly what we want, and we've made it the default. Things are working fine, but seeing a parent branch hanging around that we can't delete is annoying. Is there any way to clean this up?

optimistic-gold

12/6/2024

Why can't we add Neon to Next.js/Vercel with `vercel integration add neon`?

Title. This would simplify my life.

variable-lime

12/6/2024

Slow verification email delivery for company email account

I am attempting to sign up for an account using my company email (Microsoft 365) but it takes more than 30 minutes to receive the email from Neon. By the time I do receive the email, the link is expired preventing me from confirming my account. Is there any known issues with delivering email to M365 accounts? This is the first time I have had this issue with any provider. This is a major blocker in trying to build a POC for transitioning to Neon....

rising-crimson

12/5/2024

Local Svelte+Drizzle/Neon development using docker

https://justpaste.it/d7lj4 i was unable to ask the question here, since it didn't allow me to write long messages. sorry!

extended-yellow

12/5/2024

"Extension 'neon' is not available for installation in target"

Hi folks, I have multiple Neon DBs, and I'm migrating one for technical reasons over DigitalOcean and trying to use their migration functionality that synchronizes both DBs. Unfortunately, I haven't been able to do it because of the following error: "Extension 'neon' is not available for installation in target." Although, when I do SELECT * FROM pg_extension; in my Neon DB, I don't see the neon extension in the list. Any help appreciated....

ambitious-aqua

12/5/2024

Has anyone tried out the integration of Next/Prisma/Postgres at scale? What was your experience?

Hi everyone, I had been facing issues using Supabase database in the past with Prisma and Next.js. Hence switched over to Vercel's own partner Neon for the database. We are building a trading platform with thousands of users trading every hour hence we need to make the app really reliable. Has anyone tried this combination at scale yet?

continuing-cyan

12/5/2024

Tons of storage use coming from nowhere

Hey, the dashboard says that I’m using 94% of my storage plan, and it shows that one of my projects is 350mb (the other 2 are ~40mb). However, when I check the branch, it says the db is only using ~29mb of storage. I’m only using the db, where is that extra usage coming from?

eastern-cyan

12/4/2024

Vercel DB unlinked with no Neon account

Hey everyone. I am having an issue and would appreciate any help. I was using a template from Vercel that automatically had created a neon AWS database for me that I could access through the "storage" tab on Vercel. Recently instead of auto deploying with a linked GitHub account, I changed to use github actions and this seemed to have disconnected the neon server from my storage tab where i used to access it. I tried using the PostgreSQL explorer extension on VScode tp reconnect and this worked...

eastern-cyan

12/3/2024

Neon Authorize with one project per user

Hi, I have being playing with Neon Authorize and was about to try it with a one project per user. This needs a custom JWT endpoint per tenant and a JWT per user per tenant so the SUB can be the user in the tenant database. It's there a way to configure the endpoint with the Neon API? https://neon.tech/api_spec/release/v2.json...

like-gold

12/2/2024

Beginner Question: Materialized View - Refresh how?

I am unable to refresh a materialized view using drizzle & neon, i posted a repro repository if anyone has a moment to check. I want to visit a next js api route to refresh, the console shows its successful, but the data returned is not refreshed in the view unless i manually run REFRESH MATERIALIZED VIEW in the neon editor, any ideas? possibly the error is from nextjs or drizzle, but i don't see any type errors from my implementation of drizzle and i think my next js route handler is not throwing, open to any suggestions! https://github.com/arm-learning/postgresql-q...

crude-lavender

12/2/2024

Help with best practices

Hello team, I am new to the concept of branching on DBs and I would appreciate some guidance on guidelines. In our app, we - follow a trunk-based approach - have 2 vercel apps (e.g. project and project-staging) sharing the same codebase. one is for prod and one for staging/next. (as a reminder, with trunk-based approach you have only one branch + many feature branches, so having a permanent 'staging' branch is not allowed...

sensitive-blue

12/1/2024

Recover deleted branch

I accidentally deleted one of the branches. I want to restore it. Can someone please help me with this?

wise-white

11/30/2024

Neon Authorize Anonymous role

don't get angry if the question is dumb, but I'm trying to setup Row-Level Security (RLS) on my DB, I saw that neon auth already supports that with clerk (auth provider), I saw the neon exposes anonymous role, if I'm not mistaken it's for the guests, when I request the connection string from the neon dashboard it will not have a password, and if I use it, it will give an error about missing password (because I should be either provide a password or use authToken), can someone point me to an example how to use this anonymous role, I didn't find many useful examples in neon...

xenial-black

11/29/2024

Made an account yesterday for my project and now i have 80% storage full?

I have barely done anything with my DB and apparently its full? It says 33.38MiB/512MiB but complins about being 80% full?

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord