{"repo":"Florents-Tselai/spat","free":true,"listed":false,"github":"https://github.com/Florents-Tselai/spat","clone":"git clone https://github.com/Florents-Tselai/spat.git","description":"Redis-like In-Memory DB Embedded in Postgres","language":"C","stars":29,"topics":["cache","postgresql","redis","sql","valkey"],"license":"AGPL-3.0","category":"databases-storage","readme_excerpt":"spat: Redis-like In-Memory DB Embedded in Postgres [!CAUTION] This is stil in alpha and not production ready! Read notes on ACID below. spat is a Redis-like in-memory data structure server embedded in Postgres. Data is stored in Postgres shared memory. The data model is key-value. Keys are strings, but values can be strings, lists, sets, or hashes. With spat : - You don't need to maintain an external caching server. This greatly reduces complexity. - You can cache and share expensive or static data across SQL queries without having to model them relationally. - You can express powerful logic by embedding data structures like lists and sets in your SQL queries. - You can reduce your infrastructure costs by reusing server resources. Getting Started To quickly get a Spat instance up and running, pull and run the latest Docker image: This will start a Spat instance with default user postgres and password password. You can then connect to the database using psql: Then install the extension For other installation optionse see Installation Usage [!TIP] Development follows roughly TDD principles, thus, the best and most up-to-date documentation are the test cases in test/sql spat key s are always text . Values can be strings (aka text Postgres type) or data structures containing strings (sets, lists etc.). You can, however, pass anyelement to SPSET, and the value will be stored as a string according to the type's textual representation. For example, to cache a jsonb object and get it","default_branch":null,"files":null,"tree":[],"storefront":"/r/Florents-Tselai","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Florents-Tselai/spat/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."}