Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

like-gold
like-gold2/5/2024

Where is the "restore" page?

I'm considering hosting a database on Neon, and want to test the point-in-time recovery feature. According to the documentation (https://neon.tech/docs/guides/branch-restore#how-to-use-branch-restore), I should be able to access a page called "Restore," but I don't see any way to get to that page. Is it because I'm on the free tier, or because my database is too new (I created it about 2 hours ago)?
vicious-gold
vicious-gold2/5/2024

Error in POST function: NeonDbError: value too long for type character varying(200)

This is what I am trying to do:
const chat_id = await db.insert(chats).values({ fileKey: file_key, pdfname: file_name, pdfUrl: getfileurl(file_key),...
adverse-sapphire
adverse-sapphire2/5/2024

Neon x Cloudflare Pages. Can't Connect To Database.

Hello, I'm having trouble connecting to the neon database using @neondatabase/serverless with the error message Reflect.get called on non-object. I've checked the issue raised on this page https://github.com/cloudflare/next-on-pages/issues/499. I'm curious if there's a workaround or an alternative method to connect to the Neon database in the meantime. Any suggestions or insights would be appreciated....
foreign-sapphire
foreign-sapphire2/4/2024

Question about using Neon for prod services

Hey guys, great product first of all. Right now we are using Neon to develop our product, but as we move towards production, I am concerned about using Neon. At the top of the page, I see: "You are participating in the Neon Technical Preview." Can someone confirm that Neon is currently in the state of being used for prod applications? If so, is there anywhere that discusses the availability and reliability of neon? Thanks!...
sensitive-blue
sensitive-blue2/2/2024

Need Help Starting Out ;-; (Next.js + Tailwind + Neon)

Hi y'all I'm currently developing my portfolio site with Next.js 14 and the App Router and am very new to databases in general. The reason why I wanted to connect it to neon was to extend my portfolio to have full-stack capabilities: if I ever wanted to add something, I could just log in and then add stuff via a dashboard, etc. I've taken classes in Databases and PostgreSQL in my studies but am just now dipping my toes into getting connections set up to an actual web application. Looking on the Neon Documentation, a lot of existing resources uses the page routers, and if there is mention of the app router, there's not much pertaining to route handlers as a whole. Thus, I've been attempting to get connected by utilizing the neon serverless drivers, but overall I'm still very lost and am not sure where to go. I have the following in a .env.local file to start out, details omitted:...
sensitive-blue
sensitive-blue2/2/2024

Duplicate billing

Hello. My January bill was charged twice on my credit card. How can I solve?...
other-emerald
other-emerald2/2/2024

Poor performance, even when increasing compute size

Hello! I've recently launched a website with a friend of mine, but we've been running into some issues recently with our Neon database. Just yesterday our site was running fine, but now there seems to be an issue with Neon's response times. We've recently upgraded to Pro to try and solve the problem, but it hasn't helped. Changing the compute size seems to help for a few minutes, so I don't believe it's a problem with inefficient queries, but after a few minutes the performance decreases significantly. We're currently using 2 vCPU, 8 GB of RAM, which is way more than we'd expect to need....
harsh-harlequin
harsh-harlequin2/1/2024

Neon API v2 CORS support for client-side fetch

Hi, I dove into the recent changelog (https://neon.tech/docs/changelog/2022-11-17-console#fixes-and-improvements) and noticed the CORS support for Neon API v2. Quick tech question: Can we fetch data directly from Neon API v2 using the browser's fetch API on the client (frontend) side? ...
deep-jade
deep-jade1/31/2024

Error connection terminated unexpectedly

Hi 🙂 New user of neon here. I am trying to connect to a DB from a local nextjs execution using the @neondatabase/serverless But I always get ...
generous-apricot
generous-apricot1/30/2024

Neon Postgres issue

I have a neon postgres server and I am using the Prisma ORM to connect to it. The database successfully connects to the server but whenever I try to create a document (specifically one with an embedding), it rejects the query and gives me the following error: `` PrismaClientUnknownRequestError: Invalid prisma.article.create()` invocation: ...
fascinating-indigo
fascinating-indigo1/30/2024

invalid input syntax for type bigint when importing vectors from CSV

Hello everyone is this the right place for asking for help? I get this error when trying to follow the documentation for importing from CSV files. I have created all my embeddings and stored them in a CSV ``` ...
No description
absent-sapphire
absent-sapphire1/29/2024

Getting more and more errors on Vercel (can't reach database and DATABASE_URL not set)

The Vercel - Neon integration had been working great for us, but now we're getting stuck with "Can't reach database server" errors and " DATABASE_URL has not been set on Vercel by the Neon integration yet; aborting" all over the place. It ends up working after 5+ retries, but this is a huge pain.
unwilling-turquoise
unwilling-turquoise1/29/2024

Can't login to the console ERR_TOO_MANY_REDIRECTS

Dear all, I'm trying to login to the console but I get a ERR_TOO_MANY_REDIRECTS. Can anyone help me Thanks...
sunny-green
sunny-green1/29/2024

Can't connect to website

I was using the website normally until yesterday. Now when i try to navigate on it, it will pop the "site can't be reached". I've tried with Opera GX and Microsoft Edge so far. I managed to get the discord url from using LTE roaming on my phone....
xenial-black
xenial-black1/28/2024

Can I see the logs or something for my DB?

We're having some issues, and trying to debug.
sensitive-blue
sensitive-blue1/28/2024

suggestions for branching with SST/Drizzle

On my phone but wanted to ask what the suggested patterns were for creating and managing branches in a project with SST and drizzle? In SST you can use a Config construct to set env variables so I set one database url env variable and in my tRPC server I can connect to the db on server side. In client side I can use an .env file. Although I’m not sure how to utilize branches when I’m working. I figure I can manually set up env variables with Config for diff db urls for the branches but wondering if this is the best approach....
absent-sapphire
absent-sapphire1/27/2024

about plan upgrade to pro

Hey, I just upgraded to pro plan and I am seeing February 2024 Pricing Plan Update will drop. Neo will be stil pay per usage or how will it work. I upgraded to pro plan thinking it's pay per usage. on the 2024 update it's showing minimum 19$ / month ? how does this work is it like even if there is no usage I still pay 19$ min? or it's calculating compute for 1 month 24/h running. please let me know. I am using for development environment only alone don't want to over spend for no usage. Thanks you...
No description
vicious-gold
vicious-gold1/27/2024

Production builds can't read the .env variable

Hi guys I'm facing a problem where when i try to npm run build my sveltekit project it's complaining that :
Error: No database connection string was provided to `neon()`. Perhaps an environment variable has not been set?
Error: No database connection string was provided to `neon()`. Perhaps an environment variable has not been set?
...
No description
vicious-gold
vicious-gold1/27/2024

Can i merge branch with main?

Hi Guys Recently i was working with drizzle and neondb with it's branching feature which is amazing, but i have a follow up questions where if i do some changes in the branch (in this case branch name=dev) after i feels ok with the dev branch schemas, how i can replicate the changes to the main branch? how i can make sure that the data that i have in the main branch is not affected, but the column is updated based on the dev branch?...
robust-apricot
robust-apricot1/26/2024

Barebones .NET Project Can't Connect - Console Request Failed

Hey folks. I've got an extremely simple console app and a free-tier database. ```cs using Npgsql; ...
No description