nano VS PostgreSQL

nano

We haven't tracked posts mentioning nano yet.
Tracking mentions began in Dec 2020.

PostgreSQL

• Neon Is Generally Available: Serverless Postgres
  6 projects | news.ycombinator.com | 15 Apr 2024

  pg doesn't do too well with serverless, dead connections are left in the pool (or something)

  https://github.com/brianc/node-postgres/issues/2112

• NodeJS Security Best Practices
  11 projects | dev.to | 19 Feb 2024

  If you don't want to use ORM then there are some other packages as well! For PostgreSQL we have node-postgres

• Building Secure Neon-Infused Web Apps with Auth0, Express, and EJS
  5 projects | dev.to | 18 Dec 2023

  Interface with PostgreSQL database

• Drizzle is just as unready for prime-time as Prisma, what else is there?
  12 projects | /r/reactjs | 6 Dec 2023

  (Instead of the following with pg.)

• Nile, Serverless Postgres for Modern SaaS
  4 projects | news.ycombinator.com | 25 Oct 2023

  So far every JS framework that uses https://node-postgres.com works great and so no reason to think Drizzle wouldn't.

• We migrated to SQL. Our biggest learning? Don't use Prisma
  11 projects | news.ycombinator.com | 9 Oct 2023

  One thing that keeps coming up is that SQL equals low productivity. I don't think this is true. I think the culprit is that most developers are using to heavily abstracting SQL using ORMs like Prisma that hides the database and SQL logic.

  Since building a SQL generator (https://aihelperbot.com) as a side project, I have become much more proficient in SQL and even though I am also locked into Prisma, I use the `queryRaw` all the time to execute raw SQL queries. You can understand the code without knowing Prisma API. It is more performant. For more complex SQL queries, I use the SQL generator for initial suggestions and adapt if needed.

  For the next projects I build I want to use the minimal Postgres client (https://github.com/brianc/node-postgres) combined with a lightweight migration library.

• Using AI I have departed from ORM and embraced SQL
  2 projects | /r/SQL | 13 Sep 2023

  For newer projects I use the small Postgres client. Initially my leap into SQL was lead by AI but as I refreshed and relearned SQL, I now use a mixture of AI and self-written SQL queries. Something like this is just easier to have AI do the grunt work and then adjustment as needed.

• Credentials Leak with Knex
  3 projects | dev.to | 6 Jun 2023

  This was a known issue for pg developers, and they managed to fix it a long time ago (at the pg level), but the knowledge of this problem didn't reach Knex maintainers.

• Why SQL is right for Infrastructure Management
  6 projects | dev.to | 6 Apr 2023

  Integrate the database into your application itself with a postgres client library allowing your applications to make infrastructure changes (like provisioning sharded resources for a client that wants isolation, or using a more accurate forecasting model to pre-allocate more resources before the storm hits).

• What is your development stack for 2023?
  10 projects | /r/node | 9 Jan 2023

  node-postgres (raw sql, without ORM)