I’m not sure how to configure this myself, but UUIDs are available as extensions to SQLite. Has anyone enabled UUIDs and know if it will work with Wappler’s Database Manager?
It looks like the knex function to create tables currently only covers Postgres, MSSQL, and MySQL.
I did find a uuid extension for SQLite, but just not sure how to implement it.
// Originally from the uuid SQLite exension, Public Domain
// https://www.sqlite.org/src/file/ext/misc/uuid.c
// Modified by Anton Zhiyanov, https://github.com/nalgeon/sqlean/, MIT License
/*
* This SQLite extension implements functions that handling RFC-4122 UUIDs
* Three SQL functions are implemented:
*
* uuid4() - generate a version 4 UUID as a string
* uuid_str(X) - convert a UUID X into a well-formed UUID string
* uuid_blob(X) - convert a UUID X into a 16-byte blob
*
* The output from uuid4() and uuid_str(X) are always well-formed RFC-4122
* UUID strings in this format:
*
* xxxxxxxx-xxxx-Mxxx-Nxxx-xxxxxxxxxxxx
*
* All of the 'x', 'M', and 'N' values are lower-case hexadecimal digits.
* The M digit indicates the "version". For uuid4()-generated UUIDs, the
* version is always "4" (a random UUID). The upper three bits of N digit
show original
