Awesome GitHub RepositoriesNode.js SQL ORMs

Knex is a programmatic SQL query builder for Node.js applications. It provides a unified interface for generating database statements and managing structural versioning through a schema migration tool. The project features a multi-dialect database layer that translates programmatic queries into specific syntax for relational databases including PostgreSQL, MySQL, SQLite3, and MSSQL. This allows for writing database logic that remains compatible across different systems. The system includes infrastructure for managing reusable database connection pools and handling relational transactions to

Objection.js is an object-relational mapper for Node.js that maps SQL database tables to classes and rows to model instances. It functions as a high-level abstraction layer built on top of the Knex.js query builder to provide structured model definitions and relational data mapping. The project distinguishes itself through its ability to manage complex object graphs, allowing for the persistence and eager-loading of deeply nested related data in single operations. It incorporates a data integrity layer that uses JSON schema validation to verify model instances before they are persisted to the

JSqlParser is a Java library for SQL query parsing, converting raw SQL strings into a structured hierarchy of strongly typed Java objects. It provides the means to programmatically analyze and manipulate database queries by representing them as a tree of objects. The library supports both the parsing of existing SQL text and the programmatic generation of new statements through a fluent API. It includes mechanisms for transforming query trees and serializing structured object models back into formatted SQL text. Additional capabilities include database schema analysis, such as the extraction

Waterline is an adapter-based database library and object relational mapper for Node.js. It serves as a multi-database persistence layer that translates standard method calls into specific queries for both SQL and NoSQL databases. The library provides a unified interface for managing data across different stores, including MySQL, PostgreSQL, MongoDB, and Microsoft SQL Server. This architecture allows for the integration of multiple database backends within a single application and facilitates database vendor migration by changing adapters without altering business logic. The project covers r

Slonik, Node.js के लिए एक टाइप-सेफ PostgreSQL क्लाइंट है जो यह सुनिश्चित करने के लिए टैग्ड टेम्प्लेट लिटरल्स का उपयोग करता है कि पैरामीटर्स बाउंड हैं और इंजेक्शन हमलों से सुरक्षित हैं। यह क्वेरीज़ और डेटाबेस स्कीमा के लिए ऑटोमैटिक टाइप चेकिंग के साथ PostgreSQL से एप्लिकेशन को जोड़ने के लिए एक फ्रेमवर्क प्रदान करता है। यह प्रोजेक्ट एक विशेष SQL क्वेरी लिंटर के माध्यम से खुद को अलग करता है जो विकास प्रक्रिया के दौरान लाइव डेटाबेस स्कीमा के खिलाफ कोड को सत्यापित करके अमान्य कॉलम और टाइप मिसमैच का पता लगाता है। इसमें नेटिव बाइनरी सीरियलाइज़ेशन का उपयोग करके बड़े डेटासेट लोड करने के लिए एक उच्च-प्रदर्शन बाइनरी बल्क डेटा इन्सर्टर भी शामिल है।