gsSQL
sqliterally
gsSQL | sqliterally | |
---|---|---|
5 | 1 | |
16 | 260 | |
- | - | |
8.3 | 0.0 | |
20 days ago | about 2 years ago | |
JavaScript | JavaScript | |
GNU General Public License v3.0 only | MIT License |
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.
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
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.
What are some alternatives?
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
visulate-ora2pg - Docker image and single page web application for Ora2Pg
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.
typeorm-model-generator - Generates models for TypeORM from existing database.
plaid-transaction-script - Automate bank transaction data using the Plaid API into Google Sheets
slonik - A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
extract-gsheet - Quickly extract JSON data from a public Google Sheet without any API keys.
lucid - AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
gcp-video-intelligence - The GCP Video Intelligence function allows you to enable powerful content discovery and analysis in your videos.
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.
react-awesome-query-builder - User-friendly query builder for React
ship-hold - data access framework for Postgresql on nodejs