Connection - URI attribute

URL

URI is a mandatory attribute of a connection and is also known as the connection string

It's a string that defines the most important connection properties such as:

the scheme: the technology used to connect
the host: the host where the system is located
the port: the port where the system is reachable on the host
the database: the database name

The URI is system dependent and therefore should be looked in the documentation page of each system.

This is the property that defines the connection to a system

The URI is also known as:

Data Source Name (DSN)
or connection string

Example

Example of URI with the tabul connection list command where you can see the howtos connection.

Init env

tabul data drop --no-strict-selection .tabul/.tabul.yml@home

tabul connection list

name            uri
-------------   ------------------------------------------------------------------------
cd              file:///home/tabulify/
data-home       file:///home/admin/.local/share/tabul/
desktop         file:///home/tabulify/Desktop
entity          file:///opt/tabulify/resources/entity/
home            file:///home/tabulify/
howto           file:///opt/tabulify/resources/howto/
log             file:///home/tabulify/.tabul/logs
memory          mem:/
mysql           jdbc:mysql://localhost:3306/howto
noop            noop
oracle          jdbc:oracle:thin:@localhost:1521/freepdb1
postgres        jdbc:postgresql://localhost:5432/postgres
smtp            smtp://localhost:1025
sqlite          jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3
sqlite_target   jdbc:sqlite:////home/tabulify/.tabul/sqlite_target.sqlite3
sqlserver       jdbc:sqlserver://localhost:1433;encrypt=true;trustServerCertificate=true
tmp             file:///mnt/wslg/runtime-dir/tabul
tpcds           tpcds
tpcds_query     file:///opt/tabulify/resources/tpcds_query/