{"repo":"CrystallineCore/Biscuit","free":true,"listed":false,"github":"https://github.com/CrystallineCore/Biscuit","clone":"git clone https://github.com/CrystallineCore/Biscuit.git","description":"Biscuit – a high-performance, bitmap-based deterministic index for PostgreSQL","language":"C","stars":300,"topics":["indexing","open-source","postgresql","postgresql-extension","wildcard"],"license":null,"category":"databases-storage","readme_excerpt":"Biscuit — Positional Pattern-Matching Index for PostgreSQL Biscuit is a PostgreSQL index access method for LIKE and ILIKE pattern matching, with native multi-column support. It evaluates patterns by intersecting bitmaps that record which character occurs at which position in each indexed string. Matches are therefore exact, and PostgreSQL does not need to recheck candidates against the heap ( xs recheck = false ). The name stands for B itmap I ndexed S earching with C omprehensive U nion and I ntersection T echniques . Biscuit indexes position rather than content . This shapes its performance profile: it is strongest where the position of characters forms part of the predicate — anchored patterns, wildcards, and string length — and less suited to unanchored substring search, which is well served by existing options such as pg trgm . --- Stability Notice This extension is currently under active development and has not yet received the level of testing and operational experience expected of production-ready software. Users are encouraged to evaluate the extension thoroughly in development and staging environments before considering deployment in production systems. In particular, testing should include representative datasets, workloads, upgrade procedures, backup and recovery workflows, and performance validation. Although the extension is intended to operate safely and reliably, defects or unexpected behavior may still be present. As with any new database component, appropria","default_branch":null,"files":null,"tree":[],"storefront":"/r/CrystallineCore","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/CrystallineCore/Biscuit/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."}