Requirements

What the store needs to run, and how to switch the database to PostgreSQL.

Software

Version Notes
Node.js 20.9 or newer (22 LTS recommended) Needed by Next.js 16
npm 10 or newer Comes with Node.js
Database SQLite (included) or PostgreSQL 14+ SQLite needs nothing installed
Python 3 optional Only for scripts/e2e_api.py, scripts/check_pages.py and the photo generator

Server

A small VPS is enough for a store with a few thousand products: 1 vCPU, 1 GB RAM and 10 GB disk. The production build itself takes about 1 GB of RAM while it runs; on a 512 MB server, build on your computer and copy the .next folder.

Main packages

Package Used for
Next.js 16, React 19 Pages, server rendering and the API
next-intl 4 Arabic and English, right to left, language in every URL
Tailwind CSS 4 Styling, with the brand colours as tokens
Prisma 6 Database access and the schema
zod 4 Checking every request body
jose Signed session cookies
marked These docs pages
lucide-react Icons

PostgreSQL

SQLite is a single file and is the simplest choice for one server. Use PostgreSQL when you run several servers, or when your host already offers a managed database.

  1. In prisma/schema.prisma, change the provider:

    datasource db {
      provider = "postgresql"
      url      = env("DATABASE_URL")
    }
    
  2. In .env, set the connection string:

    DATABASE_URL="postgresql://souq:password@localhost:5432/souq?schema=public"
    
  3. Create the tables and the sample data: npm run setup.

No code changes are needed: search uses plain contains filters that work on both databases. Money is stored as integers in both.

Browsers

The store and the dashboard work in current versions of Chrome, Safari, Edge and Firefox, on phones and desktops. The quick search shortcut is Ctrl K on Windows and Linux, Cmd K on a Mac.