[PYTHON/STREAMLIT] connection 함수 : 데이터베이스 연결 만들기

■ connection 함수를 사용해 POSTGRESQL 데이터베이스 연결을 만드는 방법을 보여준다.

▶ ./.streamlit/secrets.toml


[connections.posgreSQL]
    type="sql"
    dialect="postgresql"
    username="user1"
    password="password1"
    host="127.0.0.1"
    port=5432
    database="test"

[connections.posgreSQL]

type="sql"

dialect="postgresql"

username="user1"

password="password1"

host="127.0.0.1"

port=5432

database="test"

※ postgreSQL : 연결명
※ postgresql : 데이터베이스 타입
※ user1 : 데이터베이스 사용자명
※ password1 : 데이터베이스 패스워드
※ 127.0.0.1 : 데이터베이스 서버 IP 주소 또는 URL
※ 5432 : 데이터베이스 서버 포트
※ test : 데이터베이스명

▶ main.py


import streamlit as st

sqlConnection = st.connection("posgreSQL") # streamlit.connections.sql_connection.SQLConnection

import streamlit as st

sqlConnection = st.connection("posgreSQL") # streamlit.connections.sql_connection.SQLConnection

▶ requirements.txt


altair==5.3.0
attrs==23.2.0
blinker==1.8.2
cachetools==5.3.3
certifi==2024.6.2
charset-normalizer==3.3.2
click==8.1.7
gitdb==4.0.11
GitPython==3.1.43
greenlet==3.0.3
idna==3.7
Jinja2==3.1.4
jsonschema==4.22.0
jsonschema-specifications==2023.12.1
markdown-it-py==3.0.0
MarkupSafe==2.1.5
mdurl==0.1.2
numpy==2.0.0
packaging==24.1
pandas==2.2.2
pillow==10.3.0
protobuf==5.27.2
psycopg2-binary==2.9.9
pyarrow==16.1.0
pydeck==0.9.1
Pygments==2.18.0
python-dateutil==2.9.0.post0
pytz==2024.1
referencing==0.35.1
requests==2.32.3
rich==13.7.1
rpds-py==0.18.1
six==1.16.0
smmap==5.0.1
SQLAlchemy==2.0.31
streamlit==1.36.0
tenacity==8.4.2
toml==0.10.2
toolz==0.12.1
tornado==6.4.1
typing_extensions==4.12.2
tzdata==2024.1
urllib3==2.2.2
watchdog==4.0.1

altair==5.3.0

attrs==23.2.0

blinker==1.8.2

cachetools==5.3.3

certifi==2024.6.2

charset-normalizer==3.3.2

click==8.1.7

gitdb==4.0.11

GitPython==3.1.43

greenlet==3.0.3

idna==3.7

Jinja2==3.1.4

jsonschema==4.22.0

jsonschema-specifications==2023.12.1

markdown-it-py==3.0.0

MarkupSafe==2.1.5

mdurl==0.1.2

numpy==2.0.0

packaging==24.1

pandas==2.2.2

pillow==10.3.0

protobuf==5.27.2

psycopg2-binary==2.9.9

pyarrow==16.1.0

pydeck==0.9.1

Pygments==2.18.0

python-dateutil==2.9.0.post0

pytz==2024.1

referencing==0.35.1

requests==2.32.3

rich==13.7.1

rpds-py==0.18.1

six==1.16.0

smmap==5.0.1

SQLAlchemy==2.0.31

streamlit==1.36.0

tenacity==8.4.2

toml==0.10.2

toolz==0.12.1

tornado==6.4.1

typing_extensions==4.12.2

tzdata==2024.1

urllib3==2.2.2

watchdog==4.0.1

※ pip install streamlit sqlalchemy psycopg2-binary 명령을 실행했다.