SQL you 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

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. The primary difference between SQL is how queries are constructed, where the SELECT Query Builder directs queries to be constructed in the order they're run, by specifying the data sources first, i.e. the FROM table first, followed by any JOINs (just like LINQ) which allows litdb query builders to provide type safety and intellisense for the rest of the query.

To get the most out of litdb we recommend using text editors that supports TypeScript definitions (e.g. VS Code, JetBrains IDEs, neovim, etc.)

Leave a Comment