So Atuin actually runs postgresql on the server only - the part that handles sync for many users

On the client, it uses sqlite. As of recently, it also keeps an in-memory Nucleo index to make fuzzy searching much faster