Showh HN: SQLite JavaScript - extend your database with JavaScript

SQLite-JS Extension SQLite-JS is a powerful extension that brings JavaScript capabilities to SQLite. With this extension, you can create custom SQLite functions, aggregates, window functions, and collation sequences using JavaScript code, allowing for flexible and powerful data manipulation directly within your SQLite database. Table of Contents Installation Pre-built Binaries Download the appropriate pre-built binary for your platform from the official Releases page: Linux: x86 and ARM macOS: x86 and ARM Windows: x86 Android iOS Loading the Extension -- In SQLite CLI .load . / js -- In SQL SELECT load_extension( ' ./js ' ); Functions Overview SQLite-JS provides several ways to extend SQLite functionality with JavaScript: Function Type Description Scalar Functions Process individual rows and return a single value Aggregate Functions Process multiple rows and return a single aggregated result Window Functions Similar to aggregates but can access the full dataset Collation ... Read full article.