Coding environment: Linux in Github Codespaces (Note: Please read the setup guide at https://www.tanyongsheng.com/note/building-trigram-search-for-stock-tickers-with-python-sqlalchemy-and-postgresql/ for more details)
-
git clone https://github.com/tan-yong-sheng/postgres_trigram_search.git
-
start database container
mv .env.sample .env
docker compose up -d
- Activate virtual environment:
python -m virtualenv .venv
source .venv/bin/activate
pip install -r requirements.txt
-
python -m models
-
python -m scrape_tickers
-
python -m insert_tickers_db
-
python -m main
Please feel free to adjust the parameters search_term
or exchange_market
in main.py file
- search_term: str
- exchange_market: enum('Bursa', 'SGX')
This is just a simple prototype project. Thanks for reading, and hope for more suggestions.
Besides Github Codespaces, you could also try to use GitPod so you could start your coding environment very quickly: https://gitpod.io/#https://github.com/tan-yong-sheng/postgres_trigram_search (Note: I'm not affiliate with GitPod, and the free plan gives you 50 hours per month at no cost as of 30 Sep 2024.)