# Week4
This week, I reached a major milestone in implementing a Postgres backend for the Lighthouse Beacon Node database layer:

* **Implemented Core PostgresDB Functionality**
* Successfully implemented `get_bytes`, `put_bytes` for the Postgres backend, matching the functionality of existing LevelDB and Redb backends.
* **Integrated with Lighthouse Test Suite**
* Enabled Lighthouse’s internal test suite to run with `--features postgres.`
* Confirmed working test coverage for the Postgres backend — all tests pass.

* **Plugged into Lighthouse’s DB Abstraction Layer**
* Postgres backend is now feature-gated and pluggable via the `KeyValueStore` trait, just like Redb/LevelDB.

* **Planning Schema Redesign**
* Based on feedback from the Lighthouse team, I’m moving from a single shared table to separate Postgres tables per `DBColumn`, which mirrors the structure used in Redb. This will improve performance and maintainability.

## Next Steps

* Redesign the Postgres schema to support per-column tables.
* Refactor existing queries to operate on per-column tables.
* Ensure batch writes remain performant during this transition.