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:

file system
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.

tabli connection list

Name            Url
-------------   -----------------------------------------------------------------------
cd              file:///C:/Users/gerardnico/
entity          file:///D:/code/bytle-mono/db-gen-entities/src/main/resources/entity/
howto           file:///D:/code/bytle-mono/db-website/src/doc/howto/
memory          mem
mysql           jdbc:mysql://[host]:[port]/[database]
oracle          jdbc:oracle:thin:@localhost:1521:xe
postgres        jdbc:postgresql://localhost:5432/postgres
sqlite          jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db
sqlite_target   jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite_target.db
sqlserver       jdbc:sqlserver://localhost;databaseName=AdventureWorks;
temp            file:///C:/Users/GERARD~1/AppData/Local/Temp/
tpcds           tpcds
tpcds_query     file:///D:/code/bytle-mono/db-jdbc/src/main/sql/tpcds/

Learning Tabulify - Step 4 - How to select Data Resources

Connection

List

Next