Oleg Valter Oaphi

Nowadays, many people use Large Language Models (LLMs) for programming. While I can understand that these tools are convenient (and sometimes there's also pressure from management), I personally don't want to use these tools and this article attempts to capture some of my reasons why. This is not intended to convince others to stop using LLMs but to explain why I think that working with LLMs isn't worth it for me.

Licensing

One reason I don't want my code to be written (or co-authored by) AI tools is licensing. When I write code, it is undoubtably my own. With code written by an LLM, it's a bit more complicated. At least at the time of writing, I am not convinced that me generating code with an LLM would result in me fully "owning" the code in terms of copyright/licensing. What's worse is that (especially when generating bigger snippets of code using an LLM) it is possible for an LLM to reproduce code from other people that may be licensed in a way I don't want. When an LLM generates code for me, it mig

IMPORTANT: reduceRight with and without v8 runtime for Google Apps Script

This is an important point for using reduceRignt with and without v8 runtime for Google Apps Script.

Sample script

function myFunction() {
  var array = ["a", "b", "c", "d", "e"];
 var res = array.reduceRight(function (ar, e, i) {

Drive API got to be able to create Google Apps Script project again

I have reported "Drive API cannot create Google Apps Script project no longer". Ref About this, I had reported the future request. Ref Today, I could confirm that the Google Apps Script project of the standalone type got to be able to be created by multipart/form-data using Drive API. This is a good news for me. By this, the following 2 patterns can be used from now.

Pattern 1:

Create new standalone GAS project by Apps Script API.
Put the local script to the created GAS project by updating the project with Apps Script API.
Move the GAS project from the root folder to the specific folder using Drive API.

In this pattern, 3 API calls are required.

Workaround: Showing Log in Web Apps to Apps Script Dashboard using Javascript

I have already reported for showing the log to "Apps Script Dashboard" when it requests to the Web Apps. Ref In order to show the log to "Apps Script Dashboard" when it requests to the Web Apps, it is required to use the access token. But in the current stage, when the access token is used for XMLHttpRequest and fetch of Javascript in the request headers, the error related to CORS occurs. So, in this report, I would like to propose the workaround for resolving this issue.

Workaround

In this workaround, the access token is NOT used for requesting with Javascript. Javascript which is the client side requests to the Web Apps without the access token. By this, no error occurs.

At Web Apps which is the server side, the log is shown in "Apps Script Dashboard" using the access token.

Logs in Web Apps for Google Apps Script

This is a report for retrieving the logs in Web Apps for Google Apps Script, when it requests to the Web Apps.

Experimental condition

1. Sample script for Web Apps

const doGet = (e) =&gt; {

Tags Using Together with google-apps-script Tag at Stackoverflow

This table shows all tags using together with the tag of "google-apps-script" at Stackoverflow. The tags are summarized every year. At 2020, the data is retrieved from January 1, 2020 to July 16, 2020. The number enclosed (###) means the number of use of the tag. When this table was a material for discussing about the current tags for "google-apps-script", I'm glad.

| Year | Used Tag list | | :

Statistics of gas Tag on Stackoverflow

This is the statistics for the tag gas on Stackoverflow. This statistics are retrieve from Stackoverflow using Stackexchange API. About 2020, the data is retrieved from 2020-01-01 to 2020-07-01.

This statistics data was obtained at 2020-07-15.

Measurement result

Statistics of appscript Tag on Stackoverflow

This is the statistics for the tag appscript on Stackoverflow. This statistics are retrieve from Stackoverflow using Stackexchange API. About 2020, the data is retrieved from 2020-01-01 to 2020-07-01.

Recently, this tag is modified by editing the tags. So I think that it has to be said that this statistics data is obtained at 2020-07-06.

	var PropertyLock = (() => {

	let locked = false;
	let timeout = 0;

	const store = PropertiesService.getScriptProperties();

	const propertyName = "locked";
	const triggerName = "PropertyLock.releaseLock";

Oleg Valter Oaphi

Licensing

IMPORTANT: reduceRight with and without v8 runtime for Google Apps Script

Sample script

Drive API got to be able to create Google Apps Script project again

Pattern 1:

Workaround: Showing Log in Web Apps to Apps Script Dashboard using Javascript

Workaround

Logs in Web Apps for Google Apps Script

Experimental condition

1. Sample script for Web Apps

Tags Using Together with google-apps-script Tag at Stackoverflow

Statistics of gas Tag on Stackoverflow

Measurement result

Statistics of appscript Tag on Stackoverflow

Measurement result

Benchmark: Process Costs under V8 using Google Apps Script

Introduction