---json
{
    "aliases": [
        { "path": ":docs:connection:temp" }
    ],
    "page_id": "ukhyo74jzoadvp94ymtkb"
}
---
====== Tmp (Temporary Runtime directory) Connection ======


===== About =====

''tmp'' is a [[built-in|built-in connection]] that points to the runtime temporary [[docs:resource:directory|directory]] of the [[docs:system:local|local file system]].


===== Value =====


<code>
RUNTIME_DIR/tabul
</code>
where:
  * ''RUNTIME_DIR'' is the value of the [[https://specifications.freedesktop.org/basedir-spec/latest/|XDG_RUNTIME_DIR]] [[docs:conf:os|os env]] if found otherwise it's the operating system temporary directory.


Example of Runtime Temporary Directories:
  * Linux: ''/tmp''
  * Windows WSL Linux: ''/mnt/wslg/runtime-dir''
  * Windows: ''%TEMP%''
===== Usage =====

This is the default connection for the logs of [[:docs:op:execute|execution]] and other temporary runtime data.

===== Info =====
With the [[docs:tabul:connection:info|connection info]] command
<unit>
<code bash>
tabul connection info tmp
</code>
<console>
Information about the connection (tmp)
Attribute                    Value                                Description
--------------------------   ----------------------------------   --------------------------------------------------------------------
BOOLEAN_DATA_TYPE            Native                               Boolean data type used to store boolean values
CHAR_DEFAULT_PRECISION       1                                    Default CHAR precision
COMMENT                      The temporary runtime directory      A connection description
DATE_DATA_TYPE               NATIVE                               Date data type used to store date values
HOST                                                              Host Server
MAX_CONCURRENT_THREAD                                             The maximum number of threads that can be created against the system
MAX_NAME_IN_PATH                                                  The maximum number of names in a path
NAME                         tmp                                  The name of the connection
NATIVES                                                           Native Driver attributes (jdbc properties, ...)
NCHAR_DEFAULT_PRECISION      1                                    Default NCHAR precision
NVARCHAR_DEFAULT_PRECISION   0                                    Default NVARCHAR precision
ORIGIN                       BUILT_IN                             The origin of the connection
PASSWORD                                                          The user password
PORT                                                              Host Port
TABULAR_FILE_TYPE            text/csv                             The default media type when downloading tabular data
TIMESTAMP_DATA_TYPE          NATIVE                               Timestamp data type used to store timestamp values
TIME_DATA_TYPE               NATIVE                               Time format data type to store time values
URI                          file:///mnt/wslg/runtime-dir/tabul   The uri of the connection
USER                                                              The user name
VARCHAR_DEFAULT_PRECISION    0                                    Default VARCHAR precision
WORKING_PATH                 /mnt/wslg/runtime-dir/tabul          The working path (Schema for database, directory for file system)
</console>
</unit>