Need clarification on free tier limit
I am a newbie and I want to host a Pg database for my django application
Is the primary branch always up ? And does it have any compute hour limits ?...
Error API POST branch: project already has running operations, scheduling of new ones is prohibited
Strangely I seem to be getting the above mentioned error when creating a new branch and endpoint through a POST to /projects/{project_id}/branches, but when I try it with the exact same configuration on the README docs, it seems to work.
What am I missing? (the creation of the project was already successful earlier in the same function)
Details of my request (see image)...
How do you change the compute host for the Neon main branch?
For security purposes, I want to change the compute host, i.e. the auto-generated subdomain.
The only workaround I can see is to delete the main branch and push the main branch again so that Neon detects that the main branch exists again....
Change owner of a database
Hey guys, I'm trying to change the owner of a database so they can complete an import, but can't seem to get them permissioned correctly. All sql commands fail. Is there any way to change an owner?
Branch-specific history length
I don't want to keep my history for all my dev/staging branches but I do want history for prod branch. Is there any way to do this in neon?
Is Neon Serverless Driver ready for production?
I recognize it’s difficult to set expectations about a product roadmap. I am newly developing on Neon now and need to decide on a driver. I intend to launch in production in April. My next.js app uses Drizzle, is hosted on Vercel, and is not using any edge functions.
Ideally, I could just use Neon Serverless Driver now since it handles both HTTP and websockets, and seems to be positioned by Neon to be the default way to use Neon. I think over time tutorials and docs will more prevalently reference this driver. But the driver is in Beta according to Neon docs.
I could alternatively start with node-postgres and change it later.
What does Neon recommend?...
Can end users of a Neon partner use the Neon console?
I notice that in Vercel documentation:
https://vercel.com/docs/storage/vercel-postgres
Unsupported Neon features
Vercel Postgres is a first-party integration with Neon, and many of Neon's features are available with Vercel Postgres. However, there are some differences worth noting:
- Accessing the Neon web console is not supported...
websockets fail on nodejs test package
Hey all, I have a monorepo which looks something like this
```
mono/
├─ apps/...
Neon Transaction Support with drizzle in cloudflare workers
Hi, I am trying to make a db transaction using drizzle orm in cloudlfare workers using NeonDB. I am using the neon function as client which is imported from @neondatabase/serverless module. When I make an api request, it returns me an error saying:
"No transactions support in neon-http driver".
Can someone help me with this?
...
Neon Console Restore Issue: Inaccessible Storage Despite Branch Deletion
Hi, I was trying to restore some data using the Restore option in the Neon console. The issue I ran into is when I tried to delete the old branch first, it gave me a bunch of errors about it being the root branch (it was not). Then, when I created a new branch and deleted the old one, the storage still seems to be there in the dashboard usage tab, but there is no way to access it. I get 'Request failed: no read-write endpoint for branch,' 'The selected branch does not have a compute endpoint.'
If anyone has encountered a similar issue or has insights on how to resolve this, your help would be greatly appreciated!...
Access a Specific Branch via Database Client
Hello, I'm struggling to see in the neon.tech/docs how to connect to a specific branch from a database client. The connection strings provided all default to the main branch it seems? https://neon.tech/docs/manage/branches#create-a-branch
Free Tier Compute Discrepency
On the pricing page (https://neon.tech/pricing), it says I get 20 hours of compute per month on the free tier.
However, in the console, it says I get 5 hours of compute per month on the free tier.
Which value is correct? Obviously, I'm more inclined to trust the value in the console, but this is extremely frustrating since you advertise higher capacity on your pricing page. This feels very dishonest....
How to view postgresql function 'explain' with Neon?
I would like to view the execution plan for a function in my postgres db running on Neon. From my understanding the way to do this is to use 'auto_explain'? However when I try to run
LOAD 'auto_explain'; (https://neon.tech/docs/postgres/auto-explain) I get an error saying that access to auto_explain library is not allowed. Now I think that has to do with my user privileges but my user is part of the neon_superuser group, but when I check the privileges for the neon_superuser that user does not have super user access either and from understanding of the docs the user needs access to the super user role to access this library?
I am on the free tier, not sure if that is part of the problem?
Thank you....runtime exceeded
Error: Query cancelled, runtime exceeded. SQL queries over HTTP must not exceed 15 seconds of runtime. Please consider using our websocket based connections
Please help me solve that, please......
Connection string in .NET
Hey! Trying to connect to neon from a .NET application. I figured using Npgsql would be the happy path since it is a PostgreSQL database, but I can't quite figure out how I should form my connection string. Seems like there aren't a lot of .NET people using Neon yet, so no guide up on the website, but I wouldn't mind writing up a first draft for a language guide on .NET.
Right now I'm just passing what I was provided in the "connection string" field but I'm getting an error from Npgsql,
Format of the initialization string does not conform to specification starting at index 0.
This is what I am passing:...How to integrate Neon with search vendors?
I'm evaluating Neon for its ability to integrate with search vendors such as Typesense. I especially need full text search for languages that don't delimit words with spaces, such as Chinese. Neon doesn't support the PGroonga extension, which seems to be the popular way to do FTS for Chinese, Japanese, and other such languages.
A concerning thing is that in Typesense Cloud documentation, the integration with Supabase is based on a cron job, and it requires these Postgres extensions, all of which are not supported by Neon.
https://typesense.org/docs/guide/supabase-full-text-search.html#enabling-relevant-postgresql-extensions
PG_NET (opens new window): allows the database to make asynchronous http/https requests with JSON...
Can you expound on what a Neon customer gets with "SOC 2 Report" in the Scale plan?
I am evaluating both Neon and Supabase. I see that in Supabase, a customer would need to be in Supabase's $599/month Team plan to get "SOC2". Is this essentially the same offering? i.e. A customer can use these reports to prove SOC compliance to an enterprise buyer?
Fly.io express app (Chicago) slow queries to Neon (Ohio)
I'm trying to figure out what the latency I'm experiencing is caused by. I'm comparing Fly postgres with Neon. The increase in latency is insane, and so I doubt the regional differences is the issue here. Cold starts aren't the issue either, since I've done queries in quick succession.
NeonDB scenario:
```
Fly env: Dev...