Branching with Vercel
Hi everyone!!!
I finally moved from Supabase to Neon and I'm very happy about it. One of the reasons I wanted to move: simplicity with branching.
Can you tell me, when integrating with Vercel, is it possible to set the parameters by which a new branch will be created as if we create manually via new branch?...
Escaping SQL Server Hell… support for Babelfish?
Babelfish https://babelfishpg.org/ allows SQL Server T-SQL queries to run on Postgres. My boss loves SQL server but our wallet doesn’t. Is this something that could be supported?
read only transaction?
When i connect to a neon endpoint, sometimes it seems to think its a read only transaction?
```
psql (16.1, server 16.4)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help....
is it possible to add data to NEON table from a local project ?
hi ! I'm having a Golang project and i already connected my project to the NEON database successfully. I was wondering it is possible for me to interact with my data (insert or delete) from NEON using code in my local project ?
Limited to 3 projects
I'm on the free plan and was happy to see the announcement that the project limit was increased to 10. I'm not seeing that in my console, though. When I try to create a new project (the 4th), I'm hit with the upgrade paywall (where is does mention the 10 number). Anything I need to do?
How to insert multiple rows at once using sql`...` from @neondatabase/serverless ?
I have an array of 3 row values I'd like insert in a single sql command. I can't find syntax that doesn't fail. Anyone has an example?
```
import { neon } from "@neondatabase/serverless";
const sql = neon(Bun.env.DATABASE_URL);...
Database Server Error
I had got an error on database fetching.
The Error is :
Error
at https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/app-DpqOF4PV.js:3817:46272...
Conditional batch on Neon Batch API?
Hi, it's possible to do something like:
```typescript
const deleteImages = true // can be true or false
await db.batch([...
database design suggestions
i am creating a minimal issue tracker application, the user flow is as follows:
- user signs in (passwordless auth)
- creates a username (if signing in first time)
- creates a project
- creates custom priority levels...
Data-Level Diffs
Are there plans to support data-level diffing on neon? It's something I'd want to add to our application and would have to do separately as of now
Rust sqlx: Use sqlx pooler or Neon pooler?
Rust crate
sqlx has a built in connection pool: https://docs.rs/sqlx/latest/sqlx/pool/index.html. You use it like this:
```
let pool = PgPoolOptions::new()
.max_connections(5)
.connect(database_url).await?;...Download Database manually
How can i download a DB from my account manually (like an option provided to download the DB easily)
How to: Multi tenancy beyond 500 tenants with Neon?
Hi there,
I'm a little confused. All marketing material/ YouTube/ blog posts tout multi tenancy as a DB per tenant for Neon.
However, the pricing pages simply list a limit of 500 DBs (per branch) for all plans....
Terminating connection due to administrator command
hi! We are using drizzle + node in aws lambda and we are constantly hit by the
Terminating connection due to administrator command error. I understand why it happens due to neon compute being suspended due to inactivity.
From my understanding the best solution is for the client to reconnect to the db in case when this happens, however i'm not exactly sure how to achieve this following the neon docs.
Here is how db connection pool is created:...issue connecting neon with drizzle
Have the following in my index.ts file:
const sql = neon(process.env.DATABASE_URL!);
const db = drizzle({ client: sql });
Yet, seeing this error when I run the file:...
Is there a documentation on how does the Export all to .csv work from the Neon console?
I'm trying to create a feature similar to it but just can't figure it out.
Migrating from Neon project into another
I'm seeing an error like this:
This part seems like a something I don't necessarily want/need to migrate over. How do I work around this issue?...
ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT SELECT,INSERT,REFERENCES,DELETE,TRIGGER,TRUNCATE,UPDATE ON TABLES TO neon_superuser WITH GRANT OPTION;
ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT SELECT,INSERT,REFERENCES,DELETE,TRIGGER,TRUNCATE,UPDATE ON TABLES TO neon_superuser WITH GRANT OPTION;
Getting unexpected error on fetching data from database
```py
Traceback (most recent call last):
File "/usr/local/lib/python3.10/dist-packages/discord/ext/commands/core.py", line 235, in wrapped
ret = await coro(*args, **kwargs)
File "/root/cogs/bot.py", line 393, in botinfo...
Branches as backups?
Hi, I recently migrated to a database-per-tenant architecture and now I need to implement backups. I was thinking about using the classic pg_dump and pg_restore command and store the result on a S3.
Is it possible to do it with Neon Braching? Like creating a branch and restoring it later if needed?...
Grant "pg_read_all_data"
Hello, is it possible to grant
pg_read_all_data/pg_write_all_data to a user created via sql?
```
grant pg_read_all_data to ${ownerCredential.user};
grant pg_write_all_data to ${ownerCredential.user};...