PostgreSQL Integration

Our boilerplate comes with the PostgreSQL integration. It makes it easy to set up a database for your e-commerce store. It allows you to easily deploy your projects on Vercel with the built-in PostgreSQL support and manage your databases.

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

Getting the Database URL

Before we integrate the database in the template first you have to deploy (opens in a new tab) it to Vercel.

Once you deploy it follow the instruction to create the database.

1. Go to the Storage tab.

2. Now Scroll down and click on the Create New Database button.

After that select Postgres and then the Continue button.

Now do the following to create a new database:

3. Enter the database name. The name can only contain alphanumeric letters, "_" and "-" and can't exceed 32 characters.
4. Select a region.
5. Click Create.

The Database is created successfully.

Because we created the database in a project, we won’t have to add the environment variables manually to Vercel. It’ll be added automatically.

Now we have to pull the environment variables to the local project.

To do that, first of all, you have to install Vercel CLI

npm i -g vercel@latest

After that run this command to pull the .env variables.

vercel env pull .env

Key Benefits of Using PostgreSQL in NextMerce

• Open-source & Cost-effective: As an open-source, PostgreSQL has no licensing fees. So, it is a cost-effective solution for businesses of all sizes.
• Scalability: It can easily handle a large amount of data. So, it is a great choice for growing e-commerce businesses.
• Data Security: PostgreSQL also offers better security of your information. It includes user access control, role management, and data encryption. In this way, it ensures your data is safe and transactions are safe and protected.
• Advanced Querying: It supports complex queries, full-text search, and JSON data types. So, you can handle product filtering, search functionalities, and user personalization easily with NextMerce.
• Performance Optimization: Postgre also supports indexing, caching, and query optimization. It can significantly improve your store’s performance even during peak traffic times.