{"repo":"NobleMajo/al-sql","free":true,"listed":false,"github":"https://github.com/NobleMajo/al-sql","clone":"git clone https://github.com/NobleMajo/al-sql.git","description":"Abstraction_Layer-Sql is a sql abstraction layer that can be used for every sql database to perform simple querys.","language":"TypeScript","stars":37,"topics":["sql","postgresql","database","postgres","nodejs","node","node-js","sqlite","mysql","mariadb"],"license":"MIT","category":"databases-storage","readme_excerpt":"al-sql \"al-sql\" is a Abstraction Layer for sql databases to perform simple sql querys. You create or use a sql dialect interface and a sql connection interface for your sql database. With this you can create a SqlClient instance which provides full controll over a database and its table structure. There is already a working postgres abstraction implementation that you can use for a postgres databases or as base to create a own abstraction implementation (see here). --- - al-sql - Getting started (postgres) - 1. Install package - 2. Client cnnnections - 3. Table definition - 4. Implement control functions - 6. Use the table - Debugging help - Layer Implementation - AbstractSqlDialect - AbstractSqlConnection - Postgres connection via 'pg' - NPM Scripts - use - base scripts - watch mode - Contributing - License - Disclaimer Getting started (postgres) 1. Install package 2. Client cnnnections Don't worry, much of it is or can be copied and pasted or distributed across multiple files. Implement the base client connection: 3. Table definition Define your tables in the database, this tables can be created via al-sql: 4. Implement control functions This way database entities feel like local objects with control functions. This is just a example, there are better implementations depends on the codebase and coding style: 6. Use the table After defining the tables in code use \"createTable()\" on the client to create the tables if not exist: You can use the \"dropAllTables()\" function to dr","default_branch":null,"files":null,"tree":[],"storefront":"/r/NobleMajo","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/NobleMajo/al-sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}