---json
{
    "page_id": "gxjq8mmvy6lzmvg0gfmps"
}
---
====== Learning Tabulify - Step 3 - What's a Connection ? ======


===== Connection =====
In the [[2_data_resource|previous page]], we learned that all ''data'' are known as [[docs:resource:resource|data resource]].

[[docs:resource:resource|Data resources]] are stored in  ''systems'' in ''Tabulify''.


There is generally speaking two kind of [[docs:system:system|systems]]:
  * [[docs:system:file|file system]]
  * [[docs:system:database:database|database]] (Postgres, Oracle, MySql, ...)

A ''Connection'' is a set of properties that defines how to connect to this systems.


===== List =====

''Tabulify'' comes with:
  * [[docs:connection:built-in|built-in connection]] (connection that are always available)
  * and [[docs:connection:howtos|howto connection]] (connections used in the [[howto:howto|howto pages]])

The default connection is the ''current directory'' of the local file system, known as the [[docs:connection:cd|cd]] (for short).


In this ''learning guide'', we used mostly:
  * [[docs:connection:cd|cd]]: the local file system
  * [[docs:connection:tpcds|tpcds]]: a set of table and their data for benchmarking purpose.
  * and the [[docs:connection:howtos|sqlite howto local database]]


You can see the full list with the [[docs:tabul:connection:list|connection list]] command.
<unit display="none">
Init env
<code bash>
tabul data drop --no-strict-selection .tabul/.tabul.yml@home
</code>
</unit>
<unit>
<code bash>
tabul connection list
</code>
<console>
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/
</console>
</unit>

===== Next =====

<btn>
[[howto:getting_started:4_select_data_resources]]
</btn>