Running locally to test

you can always run the full stack in sphinx-stack. But if you only want to run sphinx-tribes by itself, you can do so:

• download postgres
• download a postgres tool like PgAdmin
• create database called sphinx under the postgres user
• run the init sql script: https://raw.githubusercontent.com/stakwork/sphinx-stack/master/init.sql
• make a .env file in sphinx-tribes with

DATABASE_URL=postgres://postgres:postgres@localhost:5432/sphinx?sslmode=disable
SKIP_LOOPS=true

• go build
• ./sphinx-tribes

insert a test record:

INSERT into tribes (uuid, owner_pub_key, owner_alias, group_key, name, description, tags, img, price_to_join, price_per_message, unique_name, last_active)
VALUES
('XuOp5B9kC3CcL52svtl_LJJJFbV1OTgnq7thtOjdKJMnOuETIw_hlLkVfonozVIwz5wADlya_i946GiKFZAgMto0cDuk', '02290714deafd0cb33d2be3b634fc977a98a9c9fa1dd6c53cf17d99b350c08c67b', 'Evan', 'MIIBCgKCAQEAtofW10NdmR4fPHIzxKoUUYhTBb84wzlLVD+fy2V5bZoJoJsMgQ9KmGMQZUk+HG/LgMb/vJ0OAy2rVi6JGxget47GRBc+1IXTN6lKmzgBs6UFDMWJAgajdoqvz4fXrUB2R8ovr/Ux9zuhxWO5rY+GwGvPbnzslMA6mgNBAn5xSani8M72brQE2K5P7aUQEc5nJE3nVSm4iy8H4+7Kk9eMRSy6A1ClHOfzyvWwkywoz4nmNTmU75t6YjoUfk9W/kkY3sC3VQuEeJhzlMXaNjDfTLJEt2mJzps449rqJvinJ9QY8g0uYnCgCTkgpmQlkI5miNOfvkhAZFewU7ZBxzu1AwIDAQAB', 'Testing sphinx', 'testing sphinx!', '{"bitcoin"}', 'https://memes.sphinx.chat/public/Axj5psD9cSYQWWwhDrgHj4EY5MotgrD79cYznantwzA=', 50, 0, 'testingsphinx', 1661887388);