atuin/crates/atuin-server-postgres/src/lib.rs, branch main

chore: Move everything into one big crate

2026-06-10T22:54:30Z

That helps remove duplicated code and rustc/cargo will now also show dead code correctly.

refactor: pull `fn into_utc` into atuin-server-database crate (#3487)

2026-05-14T23:07:08Z

The `fn into_utc` was defined in both `atuin-server-postgres` and `atuin-server-sqlite`, with tests being in the postgres crate. This pulls the function into the `atuin-server-database` crate along with the tests and references it from both crates. ## Checks - [X] I am happy for maintainers to push small adjustments to this PR, to speed up the review cycle - [X] I have checked that there are no existing pull requests for the same thing

refactor: Implement From and clean up fix_error (#3484)

2026-05-14T21:53:32Z

In the database crates for atuin-server, there is `fn fix_error`. This PR implements `From` on `DbError` which makes it possible to mostly use `?` to bubble up the errors. There are cases where `?` is not being used e.g. ```rust async fn get_session(&self, token: &str) -> DbResult { sqlx::query_as("select id, user_id, token from sessions where token = $1") .bind(token) .fetch_one(&self.pool) .await .map_err(fix_error) .map(|DbSession(session)| session) } ``` There are two options ## 1. Use `Into::into` ```rust async fn get_session(&self, token: &str) -> DbResult { sqlx::query_as("select id, user_id, token from sessions where token = $1") .bind(token) .fetch_one(&self.pool) .await .map_err(fix_error) .map(|DbSession(session)| session) } ``` ## 2. Create a variable and use `?` ```rust async fn get_session(&self, token: &str) -> DbResult { let session = sqlx::query_as("select id, user_id, token from sessions where token = $1") .bind(token) .fetch_one(&self.pool) .await .map(|DbSession(session)| session)?; Ok(session) } ``` I chose to do option 1 as it was just a find/replace but say the word and I'll convert them all to option 2 ## Checks - [X] I am happy for maintainers to push small adjustments to this PR, to speed up the review cycle - [X] I have checked that there are no existing pull requests for the same thing

feat: remove user verification functionality (#3108)

2026-01-27T21:56:18Z

## Checks - [ ] I am happy for maintainers to push small adjustments to this PR, to speed up the review cycle - [ ] I have checked that there are no existing pull requests for the same thing --------- Co-authored-by: greptile-apps[bot] <165735046+greptile-apps[bot]@users.noreply.github.com>

chore!: remove total_history from api index response (#3094)

2026-01-23T20:27:43Z

Remove the expensive and inaccurate `total_history` field from the API index endpoint. The query `select sum(total) from total_history_count_user` ran on every request but is no longer relevant. The underlying table remains for per-user cached counts used by `/sync/count`. ## Checks - [x] I am happy for maintainers to push small adjustments to this PR, to speed up the review cycle - [x] I have checked that there are no existing pull requests for the same thing

feat: add support for read replicas to postgres (#3029)

2025-12-18T21:12:39Z

Support for routing read queries to read replicas for Postgres We have very high database usage these days, and now run shell history sync off of [Planetscale](https://planetscale.com/) This setup gives us 2x read replicas, meaning we can reduce load on the primary I doubt this is required for anyone else's setup - lmk if so.

feat: add IDX_CACHE_ROLLOUT (#2850)

2025-07-29T14:14:27Z

Only really useful for Atuin cloud Given a % chance, either use the idx cache or use the old aggregation query This is to enable us to test rollout the idx cache, without breaking all queries in weird ways. Can monitor for a change in http codes/etc, and easily roll back.

fix: ensure the idx cache is cleaned on deletion, only insert if records are inserted (#2841)

2025-07-24T12:29:37Z

fix: use transaction for idx consistency checking (#2840)

2025-07-24T08:08:20Z

chore: update to rust 1.88 (#2815)

2025-07-22T14:03:20Z

* chore: update to rust 1.88 * clippy + fmt * update ci version * update flake