Using Python and Streamlit with MS SQL
Table of Contents Create and activate the Python environment Install Python modules Install MS SQL Start coding & Run Prerequisites For this project, we used MS SQL, so the operating system is Windows Server 2012. I installed MS SQL Server 2012 Advanced. If your system is Windows 10 or Windows 11, install the latest version of MS SQL Express instead. Python 3.12 Windows OS MS SQL Express Internet Get started Create and activate the Python environment # Create the virtual environment python -m venv c:\project\event # Activate it cd c:\project\event\Scripts .\activate # Deactivate it when finished deactivateInstall Python modules You can install these modules step by step, or use pip install -r requirement.txt. ...