Sqlite
About
Tabulify supports the sqlite relational database as a system
If you don't have any knowledge of Tabulify, you can start with the Learning Guide.
Connection
See How to create a SQLite connection?
Driver
The driver used is the Xerial one
Table Size
Table size is determined with the following query against dbstat
SELECT SUM("pgsize") FROM "dbstat" WHERE name='table_name'
Support
Data Type
SQLite does not support the creation and drop of constraints in the alter statement (primary, unique and foreign key)
Unfortunately, SQLite does not support the creation and dropping of constraints in the alter table statement.
Therefore, you can't drop any primary key, unique key and foreign keys once the tables have been created.
You need to:
- and to copy or move the data
We still support the constraint creation with the CREATE TABLE statement.
LowerCase Table Name
Table names are lowercase normalized by SQLite, not by Tabulify. The column names are not.
create table FOO (bar char);
-- is equivalent to
create table foo (bar char);
-- but not to
create table foo (BAR char);
The second statement will result in the following error:
[SQLITE_ERROR] SQL error or missing database (table foo already exists)