If you just have it stopped, while you activate WAL, it seems it should work going forward? At least that's how I interpret the docs 🙂

It's easy to try out (just a

docker compose up

away) ...

Sure, it doesn't have to be very long, just a couple of paragraphs with links and a sample docker compose

The setting survives server restarts:

sqlite3 data/users.db "pragma journal_mode"
# -> wal
docker compose up -d
[+] Running 2/2
 ✔ Network lldap_default    Created               0.2s
 ✔ Container lldap-lldap-1  Started               0.5s

sqlite3 data/users.db "pragma journal_mode"
wal

@nitnelave: would you mind adding a

pragma journal_mode=WAL

to the initialisation of the newly created DB?

I don't see any real drawbacks other than the 1-2% performance hit, which I'd say is negligible. The other disadvantages mentioned in https://www.sqlite.org/wal.html are irrelevant for the use case.

You don't technically need it, you just need to stop lldap once, and set it manually, then you're set. I could imagine nitnelave would prefer not to have that sqlite specific initialization in lldap, when it's not needed -- can't say for sure though 🙂

Ah the schema migration is DB agnostic? Then forget what I said.

Yeah, I think all of it is.

Never had the chance to look into Rust. Is it an ORM tool which creates the schema?

Found it: SeaORM https://github.com/lldap/lldap/blob/main/crates/domain-model/src/model/users.rs

We already have one SQLite specific pragma

I think we just execute the SQL and ignore errors (for the other engines)

I forget which one

./crates/sql-backend-handler/src/sql_migrations.rs

That's the one

DatabaseConnection has a get_database_backend which returns an enum which contains

Sqlite

in case of sqlite: https://docs.rs/sea-orm/latest/sea_orm/type.DbBackend.html

I know, I added that :p

I guess I haven't migrated my code yet!

I'll be back next week to bug you with additional questions when starting to use lldap. Have a nice weekend!

is there a cli tool to create users with?

or a api?

There's both! You can create users through the LDAP protocol, although it's not fully supported. We have a GraphQL API (see docs/scripting.md), and there's a community written CLI using that API, lldap-cli

thanks I'll take a look

can the secrets be specified with a docker secret?

nvm, figured it out

(they can)

Hello everyone! I'm making a crowd sourcing experiment to develop a tool for automated rust refactoring (extract a crate), have a look and participate! https://www.reddit.com/r/rust/s/ETulG9w9iO

hehe, sounds like a fun experiment 🙂