DegenRocket-server is a backend for a web3 decentralized social media with native support for Degen Messaging Protocol (DMP).
If you don't have any experience at setting up a server, then there is a beginner-friendly guide with scripts for an automated initial server setup.
By default, user postgres doesn't have a password on Ubuntu, so the backend will fail to connect due to a wrong password and it's generally not a good idea to use a default postgres user with superuser privileges for the app. The solution is to create a new user with a password, but without privileges, e.g.:
sudo su - postgres
psql
CREATE USER dbuser WITH PASSWORD 'dbuser';
CREATE DATABASE spasm_database WITH OWNER = dbuser;
CREATE DATABASE spasm_database_test WITH OWNER = dbuser;
exit
exit
Note: make sure to use a strong password and add it to .env.
nano .env
Example:
POSTGRES_PASSWORD=dbuser
POSTGRES_USER=dbuser
To create all tables in a new database, execute the code from database.sql.
Note: skip lines CREATE DATABASE spasm_database; and CREATE DATABASE spasm_database_test; because we've already created databases in the step above.
sudo su - postgres
psql -h localhost -d spasm_database -U dbuser -p 5432
CREATE TABLE IF NOT EXISTS posts(
id SERIAL NOT NULL,
...
Note: table posts is not necessary if you disable web2 posts. However, it's suggested to create table posts to avoid any errors.
Alternatively, you can use scripts npm run initialize-db or npm run migrate, which will attempt to create new main and test databases, as well as all the necessary tables and indices.
However, these scripts require a database user to have a privilege to create a new database. If your database user doesn't have that privilege, then you can grant it by executing the following SQL command from a superuser:
ALTER USER your_username CREATEDB;
Once your database user has a privilege to create new databases, you can run scripts npm run initialize-db or npm run migrate again.
Table posts contains web2 posts (not signed with any private key), usually fetched from RSS sources.
Table actions contains all web3 actions that are signed with a private key.
Table actions_count contains the number of reactions received by the target action from other actions on this server.
# update npm
npm install -g npm
# install nvm to manage node versions
# https://github.com/nvm-sh/nvm
# install node v18
nvm install 18
# set node v18 as default
nvm alias default 18
# switch to node v18
nvm use 18
# install packages
npm install
Create default .env file, see example .env.example.
cp .env.example .env
npm run dev
Run with pm2
# Install pm2
npm i pm2 -g
# To make sure app starts after reboot
pm2 startup
# Run the app
npm run prod
# Freeze a process list on reboot
pm2 save
# Check processes
pm2 list
The current git version doesn't include the RSS module. It might be added in the future.
Send a message to degenrocket on Session if you need any help.