Connection String: Your App's Key and Address to Data
A connection string is your app's address and key to a data source. It bundles the host, port, database name, and credentials into a single string for a driver to use. The main footgun is committing credentials to version control by hardcoding the string in.
A connection string is the complete address and key your application uses to find and unlock a data source. It's a single string of key-value pairs telling a driver the server location, database name, and authentication details. You use one every time your code needs to talk to a database, spreadsheet, or even a text file. The biggest footgun is hardcoding these strings with secrets into your source code, exposing them in version control and making updates a pain. Always use environment variables or a secrets manager instead.
Read the original → Wikipedia: Connection string
- #database
- #architecture
- #configuration
- #security
Get five bites like this every day.
Tezvyn delivers a daily feed of 60-second tech bites with quizzes to lock in what you learn.