Description
Description:
We need CockroachDB support in LLDAP to take advantage of CockroachDB's superior scalability and fault tolerance, ensuring high availability and efficient data distribution for our user authentication system. This integration will significantly enhance our infrastructure's resilience and performance.
I encountered issues when attempting to use CockroachDB with LLDAP. The initial error message indicated a missing column during schema upgrade:
Execution Error: error returned from database: column "display_name" does not exist
I attempted a workaround by starting the lldap initially with PostgreSQL to finish its migrations, and then dump the db and import into CockroachDB. After the migration, I encountered another error:
error occurred while decoding column "A_group_id": mismatched types; Rust type `core::option::Option<i32>` (as SQL type `INT4`) is not compatible with SQL type `INT8`
These issues suggest compatibility problems with CockroachDB. Support for CockroachDB would be highly beneficial, as it is a scalable and resilient database option.
Environment:
- LLDAP version: v0.5.0
- CockroachDB version: v24.1.1