Magic Hat for Secret Santa

Initial members

Google Sheets used for initial databese creation.
You need to make a copy and edit with your participants.

1. Open this link
2. Press File -> Make a copy
3. Save under your account (You'll need Google Account)
4. Press Share -> General access set to Anyone with link -> Copy link
5. Replace google_sheets_url in streamlit_app.py with your link

You can edit only yellow rows.
If you want to gift family member or all participants from different families just type for all differeft number in family column.

PostgreSQL configuration

Deploy an app and set up secrets.

1. Take the example of config
2. Modify it with your data
3. Add it to the streamlit.io secrets section

Example of config:

[connections.postgresql]
dialect = "postgresql"
host = "xxxxxx"
port = "5432"
database = "xxxxxx"
username = "xxxxxx"
password = "xxxxxx"

where host, port, database, username and password replace with yours.

For local testing modify secrets.toml in .streamlit folder with your data.

Free PostgreSQL nodes avalible on neon.tech or elephantsql.com or wherever you want.

Also, you can check for free instance Clever Cloud, Aiven, NodeChef, or any popular cloud provider like AWS, Azure, Google Cloud, Oracle Cloud, IBM Cloud, DigitalOcean, OVHcloud, or another provider for MySQL/PostgreSQL nodes as well.

Deploy

To deploy you need streamlit.io account and your own github.com repository.

1. Fork it
2. Replace google_sheets_url in streamlit_app.py
3. Deploy your app on streamlit.io and add your secrets