- PostgreSQL, often simply Postgres, is an open source object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.
Connecting & Authenticating
- When configuring PostgreSQL using DatabaseReference[URL["url"]], "url" is typically of the form "postgresql://user:password@host:port/name".
- In DatabaseReference[assoc], typical elements of assoc include:
|"Backend"||the type of SQL backend used|
|"Name"||the name of the database|
|"Host"||the host serving the database|
|"Port"||the server port through which to access the database|
|"Username"||the username used to authenticate the database|
|"Password"||the password used to authenticate the database|