Get the latest tech news
Litdb – type safe SQL for JavaScript/TS
u know but type safe parameterized, expressive & portable litdb contains LINQ-like type-safe SQL builders for TypeScript/JavaScript for writing type-safe expressive SQL that's parameterized & portable across SQLite, MySQL & PostgreSQL SQL-like No need to learn a new query language, litdb lets you write familiar SQL you know using its type-safe expressions and query builders that's safe by default. APIs are designed to keep a close affinity to SQL making it clear what SQL is being generated, expressions utilize tagged templates to take away the tedium of maintaining table and column references, parameterizing values and catering for different SQL dialects to retain the expressive freedom of SQL, but portable across multiple RDBMS's.
To get the most out of litdb we recommend using text editors that supports TypeScript definitions (e.g. VS Code, JetBrains IDEs, neovim, etc.) If you'd like to see a driver for a specific client, please open or vote for a feature request on litdb's GitHub Discussions. They're lightweight data adapters providing convenience APIs for executing SQL with named and positional parameters.
Or read this on Hacker News
