sqliterally
gsSQL
sqliterally | gsSQL | |
---|---|---|
1 | 5 | |
260 | 17 | |
- | - | |
0.0 | 8.3 | |
about 2 years ago | 24 days ago | |
JavaScript | JavaScript | |
MIT License | GNU General Public License v3.0 only |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqliterally
-
Stuck On Node database management. Should I use a different ORM? Should I use raw SQL?
You can use something like sqliterally to compose your SQL, and maybe make it a bit cleaner.
gsSQL
-
What's the formula for this?
The code is at: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
-
Need Help
You would need the custom function added to your Apps Script. The source code is here: https://github.com/demmings/gsSQL/blob/main/dist/gssql.js
- Show HN: Google Sheets Full SQL Select Custom Function
- Google App Script Project and Code Coverage on GITHUB
-
Combining two QUERY tables with common column
gsSQL on GITHUB
What are some alternatives?
visulate-ora2pg - Docker image and single page web application for Ora2Pg
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
typeorm-model-generator - Generates models for TypeORM from existing database.
cachefinance - A custom function and trigger to supplement GOOGLEFINANCE so data is always available and unsupported stocks can get price/name/yield data. As you can guess from the name, data is cached so when '#N/A' appears it does not mess up your asset history logging/graphing.
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
lucid - AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
TypeORM - ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
ship-hold - data access framework for Postgresql on nodejs
react-awesome-query-builder - User-friendly query builder for React