Getting started
This page gets the web app running locally for development or evaluation.
Just want to look around?
npm run demo starts everything with sample data in one command. See Try it with demo data.
What you need
- Node 22
- Docker (for PostgreSQL with the
pg_duckdbextension) git
1. Get the code and install
git clone https://github.com/spiculedata/social-explorer.git
cd social-explorer/ex-accell-ui
npm ci
cp .env.example .env2. Start the database
The app needs PostgreSQL with the pg_duckdb extension. The project's compose file uses the pgduckdb/pgduckdb:17-main image, which you can run on its own:
docker run -d --name ex-db -p 5432:5432 \
-e POSTGRES_PASSWORD=changeme -e POSTGRES_DB=analytics \
pgduckdb/pgduckdb:17-mainA plain PostgreSQL image will not work: the app enables pg_duckdb when it connects.
3. Configure the first admin
Add these to .env (see Configuration for everything else):
POSTGRES_PASSWORD=changeme
POSTGRES_DB=analytics
ADMIN_EMAIL=you@example.com
ADMIN_PASSWORD=choose-at-least-12-charactersThe admin account is created on first use, when the users table is empty. After that you can remove ADMIN_PASSWORD from your environment.
4. Run it
For development:
npm run devOpen http://localhost:5173 and sign in with the admin credentials.
For a production-style run:
npm run build
SESSION_SECRET=$(openssl rand -hex 32) \
ORIGIN=http://localhost:3000 PORT=3000 \
node buildSESSION_SECRET is required in production. ORIGIN must match the URL users visit.
Safari and plain HTTP
Production mode marks the session cookie Secure. Chrome and Firefox accept that on http://localhost, but Safari does not. For a local production-style run in Safari, add COOKIE_SECURE=false.
Full stack
docker-compose.yml at the repository root also defines Redis, Dapr sidecars, the crawler, ETL, Jupyter, the WavePulse radio service and an Ollama container for local models. It requires SESSION_SECRET to be set. A step-by-step guide for the full stack is still being written; follow issue #60 for progress.
Next steps
- Configuration
- Authentication and roles
- Data sharing over IPFS (optional, off by default)
- Architecture overview