apps-script-samples
nodejs-bigquery
apps-script-samples | nodejs-bigquery | |
---|---|---|
37 | 43 | |
4,349 | 457 | |
1.0% | 0.9% | |
5.9 | 8.0 | |
6 days ago | 5 days ago | |
JavaScript | TypeScript | |
Apache License 2.0 | Apache License 2.0 |
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.
apps-script-samples
-
Open source at Fastly is getting opener
One of the things that stifles openness is noise. Sifting through our public repos, some are very obviously redundant and just distracting. So we started by archiving a whole bunch of them - over half, in fact. We wrote some Google Apps Script in a spreadsheet to import and analyze the state of all our public repos:
- Google Apps Script: Automate and Extend Google Workspace with Simple Code
-
Ask HN: Should I move away from JavaScript based skillset because of saturation?
I am not a JS developer, but in some tech areas there are niches with relatively fewer developers competing for the same position.
I don't know if this is actually a niche, but since I don't see it mentioned frequently on HN, perhaps you could have a look at Google Apps Script [0], which is basically JS for automating and extending Google Docs (Docs, Sheets, Forms, Slides), and integrating them into GCP. Tons of companies have whole departments living inside Google Docs, so I imagine they would pay for software making their lives easier. I would but I currently don't have the budget for it, so I am writing short scripts myself. Curiously, Bard and ChatGPT produce really bad Apps Scripts code, which would be to your advantage.
When I occasionally hire people, I do look at their repos to see how good they are in a specific language. Specifically, how easy to follow and idiomatic their code is, what the quality of their comments and documentation is, are there any tests, even if very rudimentary. I particularly enjoy original projects like home automation, custom keyboard firmware, an alternative Netflix UI, a ggplot extension, a basic Python wrapper for some overly-complicated API vs. your typical to-do app or yet another analysis of the Bike Sharing dataset. I don't expect all people to have public repos or FLOSS contributions because not everyone has the time for that. However, if you wanted to demonstrate skills in a technology you haven't used professionally, I think it is a good idea.
0. https://developers.google.com/apps-script
-
Apps Script function frequency and quotas
I have a function in Apps Script that returns the Document Position, and I currently have it set to be called every second. However, I'm concerned about potential limitations or quotas that I might reach by making such frequent function calls. I got the idea from their own samples.
-
How can I use app scripts on google sites?
Here is the documentation link to help you: https://developers.google.com/apps-script/
- Script to send 3rd party recruiter emails in Gmail directly to SPAM with a GFY canned response
-
How to Connect Your Google Sheet to ChatGPT
Before we get started with ChatGPT, you'll need to set up Google Apps Script. If you're not already familiar with Google Apps Script, you can get started with the documentation here.
-
Google Calendar add-on: Emotify Events
Since a few years I had a Google Apps Script that prefixed some events in my calendar with an emoji. This helps me spot certain events or categories of events. This blogpost explains very well why I like to add emoji's to my calendar events.
-
Ask HN: What does everyone like for all-purpose business process platforms?
From my current employer I discovered that you can get surprisingly high mileage with spreadsheets and a little bit of scripting.
My employer uses Google Sheets with app scripts [1].
It automatically reads emails, updates a bunch of spreadsheets, makes other API calls, creates entire report documents etc.
The initial setup might take a while though.
[1] https://developers.google.com/apps-script
-
Coding Class for Pre-teen?
I have completed https://grasshopper.app entirely with no prior knowledge of coding. It is very hands on easy to follow. There is more doing coding than reading and each question has a walkthrough available. It is by Google and directs you too Google's own coding platform when you finish. It covers the basics of coding, automation, HTML/CSS/JavaScript and Google's AppScript that work with apps like Google Drive and Sheets. Each course has a PDF certificate of completion. (Last I checked the app was bricked and suggested using the webpage until they figured out the bug with the new operating system.)
nodejs-bigquery
-
Wrangling BigQuery at Reddit
If you've ever wondered what it's like to manage a BigQuery instance at Reddit scale, know that it's exactly like smaller systems just with much, much bigger numbers in the logs. Database management fundamentals are eerily similar regardless of scale or platform; BigQuery handles just about anything we throw at it, and we do indeed throw it the whole book. Our BigQuery platform is more than 100 petabytes of data that supports data science, machine learning, and analytics workloads that drive experiments, analytics, advertising, revenue, safety, and more. As Reddit grew, so did the workload velocity and complexity within BigQuery and thus the need for more elegant and fine-tuned workload management.
-
Building a dev.to analytics dashboard using OpenSearch
Now I know I've got some data I could use, I now need to find a platform that I can use to analyse the data coming from the Forem API. I did consider some other pieces of software, such as Google BigQuery (with looker studio) and ElasticSearch (with Kibana), I ultimately went with OpenSearch which is essentially a forked version of ElasticSearch maintained by AWS. The main reasons are that I could host it locally for free (unlike BigQuery). I do have some prior experience with both elastic (back when it was called ELK) and OpenSearch, but my work with OpenSearch was far more recent, so I decided to go with that.
- Como evitar SQL Injection utilizando client do BigQuery
- Learning Excel. Is there a resource for fake data sets like retail and wholesale inventories and sales histories etc for testing and practice?
-
How to Totally Fubar Your Cloud Infrastructure Costs
First, in one of our recent projects, we helped our client to run the cloud-based infrastructure of their entirely automated, real-time SEO platform. The solution rested in the safe familiarity of Googleโs popular cloud-based data centres (i.e. Google Cloud Platform), whilst also making use of BigQuery โ a serverless, multi-cloud data warehouse.
-
Data Analytics at Potloc I: Making data integrity your priority with Elementary & Meltano
Bigquery as our data warehouse
-
I've tried really hard but need some help please. Bigquery not returning data after 2019.
This post in github thinks it may be an error in bigquery's backend.
-
Deploying a Data Warehouse with Pulumi and Amazon Redshift
A data warehouse is a specialized database that's purpose built for gathering and analyzing data. Unlike general-purpose databases like MySQL or PostgreSQL, which are designed to meet the real-time performance and transactional needs of applications, a data warehouse is designed to collect and process the data produced by those applications, collectively and over time, to help you gain insight from it. Examples of data-warehouse products include Snowflake, Google BigQuery, Azure Synapse Analytics, and Amazon Redshift โ all of which, incidentally, are easily managed with Pulumi.
- [Question] Which GCP tool should I use to build a Business decisional dashboard?
-
Designing a Video Streaming Platform ๐น
Google BigQuery
What are some alternatives?
nocodb - ๐ฅ ๐ฅ ๐ฅ Open Source Airtable Alternative
airbyte - The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
ODrive - Google Drive GUI for Windows / Mac / Linux
dbt-core - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
examples - Example actors, capability providers, and other demonstrations
dagster - An orchestration platform for the development, production, and observation of data assets.
jsPDF - Client-side JavaScript PDF generation for everyone.
rudderstack-docs - Documentation repository for RudderStack - the Customer Data Platform for Developers.
wear-os-samples - Multiple samples showing best practices in app and watch face development on Wear OS.
dbt - dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications. [Moved to: https://github.com/dbt-labs/dbt-core]
google-apps-script - A collection of Google Apps Script that I've worked on over time.
streamlit - Streamlit โ A faster way to build and share data apps.