Appears on
Articles11
Build a Dynamic E-Commerce Store UI with Astro, Neon Postgres, and AWS Amplify
This guide covers the step-by-step process of building an e-commerce store UI powered by Neon in Astro and Postgres. Upon completing the guide, you will understand how to build dynamic pages in Astro by querying your Postgres database over HTTP requests and automating deployments...
Authenticating users in Astro using Neon Postgres and Lucia Auth
This guide covers the step-by-step process of building user authentication APIs and HTML pages in Astro application with Lucia Auth and Postgres, powered by Neon. User authentication provides a way to manage user identities and access control in your application. Upon completing...
The silent syntax difference in foreign keys between Postgres and MySQL
Foreign keys are a concept embedded in almost every relational database. If you are normalizing your database, you will expect to use foreign keys throughout. And they seem simple. But simplicity often belies the subtle differences that can trip you up when switching between data...
Database testing with fixtures and seeding
To test a new database, you need data, and not just any data. You need consistent, reliable data that behaves the same way every time you run your tests. Otherwise, how can you trust that your database and code is working correctly? This is where the twin concepts of seeding and...
If I have read-only tables in Postgres, should I index them heavily?
We often get questions about Postgres indexing strategies, and read-only (or read-heavy) tables are especially interesting. This post was actually inspired by this question on Reddit: “I have a table with about 20 columns that each have Boolean values indicating whether the row h...
Building Slack notifications to monitor pg_dump and restore workflows
📚 This article is part of a series on setting up Neon for dev, test, and staging environments while keeping your prod database in RDS. Find out what we’re talking about. In a previous blog post, we showed you how to create a Neon Twin using a GitHub Action that automatically run...
Neon Twin: How to deploy a change tested in Neon to prod in RDS
In previous articles, we discussed the advantages of using Neon as a development database while keeping your production workloads on AWS RDS. We covered how to set up nightly dump/restore jobs using GitHub Actions to create a synchronized Neon Twin of your production database and...
Comparing local-first frameworks and approaches
Cloud applications can feel like magic. You write text in a Google Doc on your laptop, and it magically appears in the doc on your phone. Or you’re working on some code in an online IDE like Replit, and your entire team can build together. But, like magic, we all know a lot is go...
Build Your Own AI Voice Assistant
It’s very likely that you, like many developers today, are exploring how to build AI apps using the hottest tools—and one of them is definitely ElevenLabs. That’s why we’ve put together a guide that teaches you how to create an app like this—an AI voice assistant we’ve named Puls...
Instantly Copy TB-Size Datasets: The Magic of Copy-on-Write
Neon’s serverless architecture with decoupled storage and compute makes it possible to offer database branching via copy-on-write. This feature is among the most loved by teams using Neon, but if you’ve never seen it in action, it’s hard to visualize how it works or why it’s usef...
Search From a Million Books in Milliseconds With Neon and pg_search
We just announced that pg_search is available on Neon, making it easier than ever to build fast, full-text search experiences with Postgres. To demonstrate its performance, we forked Vercel’s Book Inventory template and replaced the AI-powered search with native PostgreSQL full-t...