This table's branch is unarchiving, during which query or modification response times may be slow.
Hey started to see this warning when checking my tables in the Neon Console. What does that exactly mean?
Cheers,
Marvin...
DB content deleted after some time of DB connection being idle
Hello,
I'm ussing ferretdb with Neon on the free plan.
It works, I can insert data, all is operational. However, my application is not always inserting/querying data.
After some time I see the connection idle. And then, my tables, and all the data is deleted.
Can you please tell me if this is expected in the free plan?...
Incorrect storage figure?
My database says I've used around 0.5GB (free tier limit). However I've only got around 12000 records in my database, and the monitoring tab says it is only around 50mb, this is going to cause my database to stop acccepting records unless I upgrade?
Is it possible to delete a project, and if so, does it get removed from your count of total projects
I am considering using Neon for a test project that isn't serious or meant to stay. I'd like to delete the project when I'm done with it. If I do so, will I be able to create 10 new projects on the free plan, after the test project, since I would have deleted it? Or can you not delete it in that way and get your quota back?
I would assume you'd be able to delete it and have the full allotment of projects you can make again, but I'd like to be absolutely certain before I use up a slot on a project that is just for testing and practice, and ultimately does not matter.
(I appreciate if you answer my question, if you can ping me just in case, since I may or may not see the reply otherwise, as I am in a lot of servers.)...
Connection refused using pythonanywhere
Hello, I'm trying to host my python Flask application using pythonanywhere, but I'm running into an issue using Neon postgresql database.
For some reason all works good while running the application on localhost, but once I try to start the app on pythonanywhere and try to read or create an entry from the database I get this error with Connection refused and don't really know why?...
S3 storage option available?
Hi,
I'm thinking of using neon for postgres. But... your storage costs literally kill the prospect. Maybe you are taking a page out of apple's book? 😅
Anyway, my use case is analytics and it's a saas. So the storage rates will increase. That said. For the analytics side, perhaps I could move data out of neon but still be called. I'm not sure....
Weird timeouts?
Hi, recently I started getting some timeouts in my personal account without any code changed.
With the serverless driver adapter, is a singleton pattern still necessary for database connection?
With the Neon serverless driver adapter, is a singleton pattern still necessary for database connections?
For context, I noticed that many Next.js + Prisma examples use a pattern like this:
```...
How to Handle transaction with Nextjs 14 and Drizzle ORM
I am developing a app with nextjs14, drizzle orm & neonDB/postgress and having issue with transaction quries
here is my code
src/db/drizzle.ts
import { config } from "dotenv";...
permission denied for schema public
I'm trying to get an Elixir Phoenix project deployed and am running into this error
permission denied for schema public when first starting the deploy. It happens when trying to run the initial migrations to set up the database.Can not create or access branches in paid account
Hi,
we have a paid account with the launch plan, only used ~16h compute, but suddenly can't create new branches or access existing ones.
When creating new ones we get the error message:...
connection terminated on vercel
I'm running a remix app on vercel with prisma. The connection happens through
@neondatabase/serverless@0.9.3 and @prisma/adapter-neon (changelog indicates that there isn't much changes between 0.9.3 and latest).
I'm experiencing Unhandled Rejection: Error: Connection terminated unexpectedly and Error: socket hang up on file:///var/task/node_modules/.pnpm/@neondatabase+serverless@0.9.3/node_modules/@neondatabase/serverless/index.mjs. Nothing on my neon dashboard is showing issues.
It does not happen consistently. The query does return a big payload: 1.3MB spread out on 433 records, it is sent compressed to the client so it isn't that heavy. My assumption is that the size of the results is causing this issue. Am I correct?
The result size is kind of outrageous 🙈😅 so I'll be filtering what data I actually need on the page. ...
PGRag example does not work?
I'm trying the end-to-end RAG example: https://neon.tech/docs/extensions/pgrag#end-to-end-rag-example however i keep getting stuck at the part that uses
rag_bge_small_en_v15.embedding_for_passage, a basic example that shows the error:
```
neondb=> SELECT rag_bge_small_en_v15.embedding_for_passage('This is just a test'); ERROR: [rag_bge_small_en_v15] Couldn't connect worker stream /tmp/.s.pgrag.rag_bge_small_en_v15.31673: No such file or directory (os error 2)
CONTEXT: SQL function "embedding_for_passage" statement 1...Rust Up & Running Tutorial not compiling
Following: https://neon.tech/docs/guides/rust
And I'm getting this error:
```bash
matt@laptop: ~/RustroverProjects/seaorm on HEAD (unknown) [?]...
Can't connect to local db with drizzle-kit
I followed this guide: https://neon.tech/guides/local-development-with-neon#local-postgresql to set up a local database but I get this error: 'connect ECONNREFUSED ::1:443' when I try to run migrations and such.
I have set the DATABASE_URL to the local connection string (postgres://postgres:postgres@db.localtest.me:5432/main?sslmode=require) and this is my drizzle.config.ts:
```
import { config } from 'dotenv';...
Quick compute hours question :)
I'm simply using SvelteKit to deploy a vercel serverless app that uses the below standard code and I noticed my compute hours are nearly maxed out even tho im still just developing my app by myself..
Will my neon database start up everytime my app loads, and I import
db in a used file, even if I conditionally don't query it? If so is there a way to prevent this?
Thank you!!...data transfer exceeded, even after upgraded
hello, started receiving
i upgraded to Scale plan but i'm still receiving the error. can you help? it's urgent as the database and our apps are down....
Your project has exceeded the data transfer quota. Upgrade your plan to increase limits.
Your project has exceeded the data transfer quota. Upgrade your plan to increase limits.
Child branches installing different extension versions than parent - breaks prisma migrations
Hi, I seem to have encountered a bug with extension versioning and branching. I am using prisma for migrations and I initially just had this line in my migration CREATE EXTENSION IF NOT EXISTS "vector";
Summary: when creating a child branch, it has 0.7.4 pgvector version even though main branch has 0.7.2. There is no way to change the installed version in branches, and this breaks prisma migrations (and is also unexpected that main and child branches would have different versions).
Fixes: Either have a global extension version for all databases, or keep the extension version consistent when branching....
Error: P1001: Can't reach database server at `ep-withered
i tried npx prisma migrate dev --name init
and it shows this error
i have tried changing password , network(vpn),mobile hotspot , connect_timeout , pg bouncer nothing works please help....