Learning Tabulify - Step 3 - What's a Connection ?
Connection
In the previous page, we learned that all data are known as data resource.
Data resources are stored in systems in Tabulify.
There is generally speaking two kind of systems:
- database (Postgres, Oracle, MySql, …)
A Connection is a set of properties that defines how to connect to this systems.
List
Tabulify comes with:
- built-in connection (connection that are always available)
- and howto connection (connections used in the howto pages)
The default connection is the current directory of the local file system, known as the cd (for short).
In this learning guide, we used mostly:
- cd: the local file system
- tpcds: a set of table and their data for benchmarking purpose.
- and the sqlite howto local database
You can see the full list with the connection list command.
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/