{"repo":"jonathan-gtd/scribe","free":true,"listed":false,"github":"https://github.com/jonathan-gtd/scribe","clone":"git clone https://github.com/jonathan-gtd/scribe.git","description":"High-performance TimescaleDB integration for Home Assistant — records states & events via asyncpg with automatic hypertables, compression policies, and rich entity/area/device context.","language":"Python","stars":51,"topics":["asyncpg","custom-integration","hacs","hacs-integration","home-assistant","home-automation","homeassistant","postgresql","recorder","time-series"],"license":"MIT","category":"databases-storage","readme_excerpt":"[!WARNING] # ⚠️ v3.x.x Database Schema Migration Version 3.x.x introduces a major database schema optimization ( states raw table). This only applies if you are upgrading from a previous version of Scribe The automated background migration ran perfectly on several production setup without any issues. However, it is strongly recommended to perform a database backup before updating. Scribe - High-Performance TimescaleDB Integration for Home Assistant Scribe is a next-generation component that writes Home Assistant states and events to a TimescaleDB database. Why Scribe? Scribe is built differently. Unlike other integrations that rely on synchronous drivers or the default recorder, Scribe uses asyncpg , a high-performance asynchronous PostgreSQL driver. This allows it to handle massive amounts of data without blocking Home Assistant's event loop. It's designed for stability, speed, and efficiency. Data structure and query An explanation of the data structure how to query can be found here: Data structure Table of Contents - Features - Installation - Configuration - Migration - Statistics Sensors - Services - Dashboard / View - Ecosystem / Related Projects - Troubleshooting - License Features - 🚀 Async-First Architecture : Built on asyncpg for non-blocking, high-throughput writes. - 📦 TimescaleDB Native : Automatically manages Hypertables and Compression Policies. - 📊 Granular Statistics : Optional sensors for monitoring chunk counts, compression ratios (up to 97% saved!), and","default_branch":null,"files":null,"tree":[],"storefront":"/r/jonathan-gtd","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jonathan-gtd/scribe/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}