Top 23 TypeScript SQL Projects
Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.Project mention: Show HN: If VS Code had a data-centric IDE sibling, what would that look like? | news.ycombinator.com | 2022-07-18
I think there isn't, and if there is it would be illegal:
> You may not sublicense the Software Code or any use of it
A SQL database implemented purely in TypeScript type annotations.Project mention: HypeScript: Simplified TypeScript's type system in TypeScript's own type system | news.ycombinator.com | 2022-07-27
Which allows for things like this type that implements a simplified SQL query parser checked against a provided 'database' object:
This project was my go-to "nifty but pointless" example for TS string literal types before this article :)
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
App to easily query, script, and visualize data from every database, file, and API.Project mention: Engineers using dbt with VS Code - how are you previewing your results in lieu of the functionality provided by dbt cloud? | reddit.com/r/dataengineering | 2022-06-29
If my employer doesn't consider paying for dbt cloud, I will use u/eatonphil 's datastation, run the queries on a dev database then put them in dbt.
Database Client For Visual Studio CodeProject mention: DB Plugin | reddit.com/r/vscode | 2022-06-12
https://github.com/cweijan/vscode-database-client Have a look at this one, looks nice.
Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
TypeORM module for Nest framework (node.js) 🍇 (by nestjs)
A type-safe typescript SQL query builderProject mention: What is a clean way to build SQL queries to handle filters? | reddit.com/r/node | 2022-08-09
In fact, here's a prime example of that exact scenario for this exact situation: kysely. Kysely is a query builder much like knex that is being developed by Koskimas, the core maintainer of Objection.js. He's building kysely with an API inspired by knex but as a typescript-first solution. Knex is really a js solution so Kysely is able to leverage typescript more completely from the ground up to build out an even better experience for typescript based projects in ways that would never make sense for knex to do.
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
A whitespace formatter for different query languages (by sql-formatter-org)Project mention: Would love your feedback on this tutorial I wrote: Learn SQL with Datasette | reddit.com/r/SQL | 2022-02-28
To be honest I didn't put much thought into the formatting at all - I went with the defaults for the https://github.com/zeroturnaround/sql-formatter library, which is what runs when you click the "Format SQL" button on this page.
Node.js database migration management for PostgresqlProject mention: Fully featured Repository Pattern with Typescript and native PostgreSQL driver | dev.to | 2022-03-20
Why PG? For the clarity of the article to a large circle of developers, the entire explanation will be built by PostgreSQL and PG package. And in a real project, the database schema will change over time, and in order to be able to perform migrations, we will use Node PG migrate.
AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more (by adonisjs)Project mention: Moving MyUnisoft Node.js back to TypeORM | dev.to | 2022-08-02
When I started this project I was inspired by Lucid which is the ORM of the Adonis.js framework.
Node.js client for Google Cloud BigQuery: A fast, economical and fully-managed enterprise data warehouse for large-scale data analytics.Project mention: How to authenticate via JSON file and query a table from NodeJS? | reddit.com/r/bigquery | 2022-07-25
I have been searching the entire day, reading through the source code in https://github.com/googleapis/nodejs-bigquery , and I have yet to find an answer to this very basic, and at this point I feel also dumb, question.
An SQL linterProject mention: sql-lint - A linter for SQL (finally hits version 1.0.0) | reddit.com/r/coolgithubprojects | 2022-06-24
A pure ORM for writing native SQL queries yielding pure business objectsProject mention: An ORM which only does object relational mapping | reddit.com/r/Database | 2022-05-09
SQL Language ServerProject mention: A postgres plugin for neovim | reddit.com/r/neovim | 2022-03-15
Nice. I'm going to try it out. This would go well with sql-language-server.
TypeScript clients for databases that prevent SQL InjectionProject mention: SQL result into variable | reddit.com/r/node | 2022-07-31
Since the method is marked as async, you can use await to get the results of a query (if your database library supports promises. For example with https://www.atdatabases.org as your db library you could do
Tellery lets you build metrics using SQL and bring them to your team. As easy as using a document. As powerful as a data modeling tool.Project mention: my list of self-hosted (dev) tools | reddit.com/r/selfhosted | 2022-05-19
please take a look at tellery https://tellery.io/ this can be a great project , but it is stuck in 200 likes for a while now and i wanted to give it some love from the self-hosted community.
Not a huge project but has some users, and I still try to work on it to get the typings (TypeScript) where I want them.
ES2015 tagged template string for preparing SQL statements, works with `pg` and `mysql`Project mention: Knex Raw SQL String SQL Highlighting VS Code and best practices to avoid SQL Injection Attack? | reddit.com/r/node | 2022-04-10
If you prefer SQL and you use postgres you can check out slonik. If you want to keep using knex you can use https://github.com/blakeembrey/sql-template-tag. They will add placeholders for all the values and expose helper for query building via strings (e.g. a special join). At the same time they are typesafe.
Infrastructure as data in PostgreSQLProject mention: UPDATE iasql SET source = 'open'; | dev.to | 2022-03-03
We are excited to announce that IaSQL is now open source! The main repository is under https://github.com/iasql/iasql-engine. As perfectionists, we feel like IaSQL will never be truly ready. However, we believe IaSQL is at the point where it can start to be useful for developers managing infrastructure in the cloud. IaSQL is a SaaS that lets you model your infrastructure as data by maintaining a 2-way connection between your AWS account and a Postgres SQL database to represent the definitive state (and status) of your cloud which cannot be achieved with a static infrastructure declaration. This means that when you connect an AWS account to an IaSQL instance it automatically backfills the database with your existing cloud resources. No need to painstakingly redefine or reconcile your existing infrastructure, and IaSQL's module system means you can specify which parts of your cloud infrastructure you wish to control.
A tasty tool that lets you save, load and share postgres snapshots with ease (by sdelements)Project mention: Flan – A tasty tool that lets you save, load and share Postgres dumps with ease | news.ycombinator.com | 2021-10-29
TypeORM helper library enhancing safety in the compilation levelProject mention: safe-typeorm, helper library of typeorm in the compilation level | reddit.com/r/typescript | 2021-09-14
Name of the helper library is safe-typeorm and this helper library makes below things possible. With the safe-typeorm, you can develop your solution much easily and conveniently by taking such advantages:
Conjure SQL from GraphQL queries 🧙🔮✨
A Visual Studio Code plugin for running BigQuery queries.Project mention: Released BigQuery Runner | reddit.com/r/vscode | 2021-11-24
It's a fork of google/vscode-bigquery with some improvements.Even if the field type is a deep and complex array or struct, the result will be output in an easy to read format, and the error message will be output in an easy to read format when the query fails.
TypeScript SQL related posts
SQL result into variable
2 projects | reddit.com/r/node | 31 Jul 2022
How to authenticate via JSON file and query a table from NodeJS?
2 projects | reddit.com/r/bigquery | 25 Jul 2022
Atdatabases: TypeScript Clients for Databases
1 project | news.ycombinator.com | 11 Jul 2022
sql-lint - A linter for SQL (finally hits version 1.0.0)
1 project | reddit.com/r/coolgithubprojects | 24 Jun 2022
Raw SQL vs Knex.js vs Prisma vs MikroORM
3 projects | reddit.com/r/node | 20 Jun 2022
RefQL - Query a PostgreSQL database with a GraphQL feeling.
1 project | reddit.com/r/node | 9 Jun 2022
RefQL - Query a PostgreSQL database with a GraphQL feeling.
1 project | reddit.com/r/typescript | 8 Jun 2022
What are some of the best open-source SQL projects in TypeScript? This list will help you:
Are you hiring? Post a new remote job listing for free.