This is the main customer-facing application.
Uses workbench-production on RDS.
Microservice that handles most of the communication with third-party AI services.
Uses talaria-production on RDS. Should move to workbench-production
This is the customer-access portal at https://researchresultswebsite.com/.
Uses researchresultswebsite on RDS.
This is the monitor and coordination tool for LiveLabs focus groups.
Has a local postgres instance.
This runs long-running background tasks (primarily video generation) for talaria.
Has a local postgres instance.
This provides an interface for accessing project billing data.
It currently has no database usage, though it's configured for a local postgres instance.
This is a link shortener. It redirects https://masurveys.com/<link> to a designated URL. There are a couple white-label versions running for partners.
Microservice to manage SMS and MMS communication (supports Media Blogs).
Uses sqlite3.
Engineering task tracking tool.
A project tracking app for LSG.
Uses workbench-production on RDS.
config/deploy/production.rb.config/credentials/production.yml.enc (or config/credentials.yml.enc if single file).workbench-production matches or exceeds talaria-production version/params.psql "host=workbench-production... dbname=postgres user=master_user" -c "CREATE ROLE app_user WITH LOGIN PASSWORD '...';"
psql "host=workbench-production... dbname=app_db user=master_user" -c "CREATE EXTENSION IF NOT EXISTS pgcrypto;"
talaria-productionpg_dump --format=custom --no-owner --no-acl \
--dbname="postgresql://app_user:...@talaria-production.../app_db" \
--file=/tmp/app_db.dump
workbench-productioncreatedb --host=workbench-production... --username=master_user app_db
pg_restore --no-owner --no-acl \
--dbname="postgresql://app_user:...@workbench-production.../app_db" \
/tmp/app_db.dump
EDITOR=vi bundle exec rails credentials:edit -e production
database_url: (or host/user/password/dbname entries). Save and exit.bundle exec cap production deploy
bundle exec cap production rails:db:prepare
(or)
bundle exec cap production rails:db:migrate
bundle exec cap production rails:runner "puts ActiveRecord::Base.connection.execute('select 1')"
talaria-production, redeploy:EDITOR=vi bundle exec rails credentials:edit -e production
bundle exec cap production deploy
talaria-production to read-only or keep as snapshot, then remove.