---json { "aliases": [ { "path": ":docs:system:sqlite:howto" } ], "page_id": "ax73n2xjyu8kdwlgu6to6" } --- ====== Sqlite - HowTo Connection ====== ===== About ===== A [[docs:connection:howtos|default howto sqlite connection]] is provided after a fresh installation that is used in the [[howto:howto|howto's]]. ===== Info ===== tabul connection info sqlite Information about the connection (sqlite) Attribute Value Description -------------------------- --------------------------------------------------- -------------------------------------------------------------------- BOOLEAN_DATA_TYPE Native Boolean data type used to store boolean values BUILDER_CACHE_ENABLED true Enable or disable the builder cache CHAR_DEFAULT_PRECISION 1 Default CHAR precision COMMENT The sqlite default connection A connection description DATABASE_MAJOR_VERSION The major version number of the database DATABASE_MINOR_VERSION The minor version number of the database DATABASE_PRODUCT_NAME The name of the database DATABASE_PRODUCT_VERSION The version of the database DATE_DATA_TYPE NATIVE Date data type used to store date values DRIVER org.sqlite.JDBC The jdbc driver class DRIVER_NAME The driver name DRIVER_VERSION The driver version HOST Host Server JDBC_MAJOR_VERSION The major version number of JDBC JDBC_MINOR_VERSION The minor version number of JDBC LOGIN_STATEMENTS Statements that runs after a connection has been established 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 sqlite The name of the connection NAME_QUOTING_DISABLED_CASE UPPERCASE The case to apply when quoting is disabled NAME_QUOTING_ENABLED true Enable quoting of names NATIVES Native Driver attributes (jdbc properties, ...) NCHAR_DEFAULT_PRECISION 1 Default NCHAR precision NVARCHAR_DEFAULT_PRECISION 0 Default NVARCHAR precision ORIGIN CONF The origin of the connection PASSWORD The user password PORT Host Port SUPPORT_BATCH_UPDATES If the system supports batch SQL updates SUPPORT_NAMED_PARAMETERS If the system supports named parameters in the SQL statement TIMESTAMP_DATA_TYPE NATIVE Timestamp data type used to store timestamp values TIME_DATA_TYPE NATIVE Time format data type to store time values TYPE_AFFINITY_CONVERSION false If true, the type name are converted to affinity name URI jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3 The uri of the connection USER The user name VARCHAR_DEFAULT_PRECISION 0 Default VARCHAR precision WORKING_PATH The working path (Schema for database, directory for file system)