# Removing Ledger State from SQL Databases in 22.1

> Stellar-core 22.1 will drop SQL support for ledger state and transaction history tables. The release introduces a new high-throughput HTTP query server with the `getledgerentryraw` endpoint as the replacement for direct SQL access.

**Metadata**

- Published: 2024-11-25
- Author: Garand Tyson
- Original publisher: `stellar.org`
- Original article: https://stellar.org/blog/developers/removing-ledger-state-from-sql-databases-in-22-1
- Tags: Developer Tools, API, Developers

## Summary

Starting with stellar-core 22.1, SQL tables storing ledger state (ACCOUNT, TRUSTLINE, DATA, CLAIMABLE_BALANCE, LIQUIDITY_POOL, CONTRACT_DATA, CONTRACT_CODE, CONFIG_SETTING, TTL) and transaction history (TXSETHISTORY, TXHISTORY) will be permanently dropped. These tables were deprecated in previous releases but could still be enabled via configuration; 22.0 is the final version supporting this option. To replace SQL-based ledger state queries, stellar-core 22.0 introduces a new HTTP query server with the `getledgerentryraw` endpoint, capable of serving 20,000 requests per second with 500µs average latency. Transaction and transaction set history will no longer be stored in stellar-core; users should instead run RPC or Horizon nodes or query public history archives. The `--in-memory` mode flag is also deprecated and will be ignored starting in 22.1.

*Lumen Loop re-covers third-party publications. The full article body is not exposed here — follow the original-article link above for verbatim content.*

---
*Source: https://lumenloop.com/news/removing-ledger-state-sql-databases-22-1*