Search Results for "sqlite query builder"

sql.js is a javascript SQL database. It allows you to create a relational database and query it entirely in the browser. You can try it in this online demo. It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database. However, it allows you to import any existing sqlite file, and to export the created database as a JavaScript typed array. sql.js uses emscripten to compile SQLite to webassembly (or to javascript code for compatibility with older browsers). ...

puresql is a SQL library for node.js, heavily inspired by Clojure's yesql. It supports MySQL, MariaDB, PostgreSQL, MS SQL Server, and SQLite from the box. puresql takes a path to a .sql file containing query definitions and turns them into promisified functions. You can then call them and either pass one of the provided adapters (mySQL), or your own adapter (see one of the existing ones on the structure).

This is a component to create dinamic database queries from a check list view. You can set a db object (views/tables/etc) to select columns to be shown in the main checklist to build a query based in the check selection. Add dinamic (sql) or static HTML selects to filter results through wheres with few lines. Create dinamic XLSX reports easily (XLSXWritter)