{"repo":"hstptcn5/Catena","free":true,"listed":false,"github":"https://github.com/hstptcn5/Catena","clone":"git clone https://github.com/hstptcn5/Catena.git","description":"Catena exposes any SQLite database as a secure HTTP + WebSocket API in one small Go binary.","language":"Go","stars":13,"topics":["cgo-free","database","docker","go","golang","http-server","pubsub","realtime","self-hosted","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"Catena Turn any SQLite file into a realtime HTTP and WebSocket API. Catena sits in front of a normal SQLite file and gives it a network API: run parameterized SQL over HTTP, receive realtime notifications for writes made through Catena over WebSocket, inspect it from an embedded admin UI, and export or back it up when needed. Why Catena? SQLite is excellent for local-first apps, internal tools, edge devices, prototypes, and small services. The missing piece is often a simple way to let another process, browser, device, or script talk to that same SQLite file without embedding a driver everywhere. Catena provides that missing layer: - Keep your real .db file. - Start one binary. - Talk to it with HTTP and WebSocket. - Use SQL directly, with parameters. - Keep writes serialized and reads concurrent through SQLite WAL mode. Long-term, Catena aims to make SQLite files instantly usable as APIs: local, self-hosted, edge-hosted, or cloud-hosted. [!IMPORTANT] Catena emits WebSocket notifications only for successful writes executed through Catena. Changes made directly by another SQLite connection are not observed. Table detection covers common INSERT, UPDATE, DELETE, and REPLACE statements; advanced SQL shapes and trigger side effects may not produce complete notifications. Who Catena Is For Catena is designed as a single-node sidecar for an existing SQLite file. It serves trusted dashboards, scripts, services, and edge devices that need HTTP access without a custom API or a larger d","default_branch":null,"files":null,"tree":[],"storefront":"/r/hstptcn5","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/hstptcn5/Catena/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."}