Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

relaxed-coral
relaxed-coral3/3/2024

Project / Branch / Database best practices

Hey there 👋 I've been using neon's serverless pg for a while now for a rather narrow use-case: terraform state backend. Currently I'm looking if it can be of help for other more typical use-cases as a db for a small nodejs api. Whilst reading through the docs I found it a bit hard to have a clear picture for my api setup with one production and one staging/test environment. ...
vicious-gold
vicious-gold3/2/2024

South asia region?

Do you guys plan to add more regions? if so, i'd love south asian region support
xenial-black
xenial-black3/2/2024

SQL HTTP API

Hi Is it possible to execute SQL queries (and transactions) via HTTPS with neon? Thanks...
xenial-black
xenial-black3/2/2024

How to connect to neon with md5 passwords for older 42.2.1 JDBC driver

Hi, I have a constraint of using an older JDBC driver which only supports md5 passwords for connections. Is there any way to configure neon postgres to accept these? Thanks...
relaxed-coral
relaxed-coral3/1/2024

"Cannot run interactive auth in CI" when creating branch

Hi everyone. I've been lately experiencing some strange behavior with my Github Actions CI/CD pipelines while creating a branch with neondatabase/create-branch-action@v4 Everything is working fine for normal PRs, but when dependabot creates a PR, the pipeline stage fails with this output: ```...
absent-sapphire
absent-sapphire3/1/2024

Can't restore DB

Hello, I restored my branch a 1st time, it worked fine + it created a new branch_old. However, i would like to revert the restore, and its not working. Plus, the branch_old created is empty. In the picture you can see the error message....
No description
extended-salmon
extended-salmon3/1/2024

Data amount Missmatch on the Neon.tech dashboard

Hey everyone! While developing my projects I suddenly saw the amount of data used on neon sky rocket up after adding 2 more databases for my recent project. I'm now up to 6 databases on one branch in one project on the free plan. If I remember correctly under billing my "Storage" was previously at 100/500 MiB , then went up to 200 and is now at 459 MiB, so almost at the limit....
No description
conscious-sapphire
conscious-sapphire3/1/2024

Enterprise Question: Calendly Appointment not working

Would like to migrate our on-prem db to Neon, ~200GB, but cannot find suitable pricing plan. Also would like to ask questions and get guidance about Enterprise plan, and how to manage branches and security.
No description
vicious-gold
vicious-gold3/1/2024

Clarity on pricing based on projects

I'm a little confused about the pricing Let's base everything under 0.25 CPU 1GB RAM and only 1 primary branch So, let's say i have project A and project B on neon with one database each...
yelping-magenta
yelping-magenta3/1/2024

How to migrate data from Neon db?

Hi team, I started using neon db a month back but I was not happy by the services I want to migrate db data Please help me out here...
adverse-sapphire
adverse-sapphire2/29/2024

Strange Storage usage metrics on the Neon dashboard

Hi all. I'm currently running a free tier account. Since I had a call with a couple of Neon folks yesterday about your new pricing model, I started looking at some metrics present on the dashboard. And noticed something strange about the "Usage since February 23" storage metric : It is currently showing 450 MB but the only branch I'm using is reported on the same dashboard to be 67 MB. I've attached a screenshot to illustrate. Since the actual data on that branch is around 2 MB for a compressed dump or 10 MB uncompressed. I'm assuming that the 67 MB reported at the branch level represent the full data, plus indexes, plus the 7 days rollback history. However I don't understand how my monthly storage quota reads 450 MB. Reading https://neon.tech/docs/introduction/usage-metrics did not help me figure out the issue as well....
No description
correct-apricot
correct-apricot2/28/2024

Typescript error: Argument of type 'NeonQueryFunction<false, false>'

Hey guys. So I've been getting this ts error and I'm not sure how to fix it. It's happening on my index.ts inside src/db, on drizzle(sql). It does not break my code in any way, but its pretty annoying. `import { neon } from "@neondatabase/serverless" import { drizzle } from "drizzle-orm/neon-http" ...
No description
correct-apricot
correct-apricot2/28/2024

Error connecting to neon.tech from Elixir (electric-sql)

I've been using Neon with Electric for a month or so now with no issues but when I restarted my electric instance, it's now refusing to connect to Neon. Did something change recently on your end?
multiple-amethyst
multiple-amethyst2/28/2024

How does one Link to AWS?

Hi, I've just got this neon setup via AWS Marketplace but I'm not able to link it to my neon console account?...
conscious-sapphire
conscious-sapphire2/28/2024

Error when running node app.js command

I'm trying to set up connection between my app and database/ SQL server on Neon and was following steps listed on https://neon.tech/docs/guides/node. I don't know why I'm getting this error PS C:\Users\filip_btijweq\bootcamp\Fluolingo-backend> cd src PS C:\Users\filip_btijweq\bootcamp\Fluolingo-backend\src> node app.js node:internal/process/promises:289...
wee-brown
wee-brown2/27/2024

Billing Support

We recently transitioned leadership and I can't find where to access invoices or update the credit card on file on either the previous or the new account. Can someone please direct me? Neither of us have the "Organizations" tab at the top.
No description
xenophobic-harlequin
xenophobic-harlequin2/26/2024

Airbyte connector broken on subsequent syncs. Replication slot is being automatically deleted.

This was working fine up until 2/23. These docs are no longer applicable: https://neon.tech/docs/guides/logical-replication-airbyte Can you please provide a suggested work around?...
continuing-cyan
continuing-cyan2/26/2024

Best way for Schema/Database per tenant?

Hello, my SaaS project will require a separate database (or schema) for each tenant. (Each trial registration would create a new database). From what I've read it looks like Neon should be able to support this model. But I am not completely sure it is a good idea. I am wondering, at what level should I separate my tenants by? A project per tenant?...
inland-turquoise
inland-turquoise2/26/2024

I am facing 2 issues while migrating using drizzle

Basically there are 2 major issues i am facing. First is while migrating using drizzle , I get a error . After logging it it looks something like this , " PostgresError: password authentication failed for user "oskul" at ErrorResponse (webpack-internal:///(rsc)/./node_modules/postgres/src/connection.js:539:70) at handle (webpack-internal:///(rsc)/./node_modules/postgres/src/connection.js:339:728) at Socket.data (webpack-internal:///(rsc)/./node_modules/postgres/src/connection.js:225:17) at Socket.emit (node:events:518:28)...
No description
wise-white
wise-white2/23/2024

Switched to pooled connection, but still seeing `prepared statement XXXX` does not exist.

Hi, I am using the pooled connection string combined with Drizzle. I am using the latest Neon packages and Drizzle packages. Sentry is reporting some calls are 400'ing to https://api.us-east-1.aws.neon.tech/sql ...