Skip to Content
DocsDatabasePostgreSQL

Neon PostgreSQL Integration

Skillsaint comes with PostgreSQL integration, making it easy to set up a database for your LMS. We recommend using Neon , a serverless PostgreSQL platform, for its ease of use and scalability.

In this section, we will guide you through how to integrate Neon PostgreSQL with the boilerplate template.

Note: valid connection string is required to connect the database with the project.

Setting up Neon

  1. Sign in to Neon: Go to Neon.tech  and sign up or log in.

  2. Create a Project: Click on New Project, giving it a name, and select your preferred region.

  3. Get Connection String: Once the project is created, you will be presented with a “Connection String”. It looks like this:

    postgres://user:password@ep-host-1234.region.aws.neon.tech/dbname?sslmode=require

  4. Update Environment Variables: Copy this connection string and update your .env file in the project root:

    DATABASE_URL="your_connection_string_here"

Key Benefits of Using Neon

  • Serverless Architecture: Neon automatically scales compute resources based on demand, scaling to zero when not in use to save costs.
  • Database Branching: Just like Git branching, you can create branches of your database for development and testing without affecting production.
  • High Availability: Built on top of robust cloud infrastructure ensuring your data is always accessible.
  • Open Source Compatibility: Fully compatible with PostgreSQL, so you can use all standard Postgres tools and libraries.

Pro tip: Use Neon’s branching feature to safely test schema changes before applying them to your main database.

IntroductionMigrate the Schema