Skip to content

Instantly share code, notes, and snippets.

View schani's full-sized avatar
⌨️
I just sit at my computer and curse a bit.

Mark Probst schani

⌨️
I just sit at my computer and curse a bit.
View GitHub Profile
@schani
schani / mirror2023-repro-tar-gz.base64.txt
Created July 6, 2026 20:08
Repro input for glideapps/quicktype#2187 (mirrored OPDS2/RWPM schema graph, refs localized; base64 tar.gz - decode with: base64 -d file | tar xzf -)
H4sIAAAAAAAAA+09aXPbuJL57F/B8r4PyW5kW7Zk705tzXvy7bFlaSQ7TjKVrYFISEJCkRoePmaS/75AgxdA8JBEy5M8olyGiLPRaACNRqOxtf3q2d0OdQcHbeY3D9o7ST90r5rt3d3dA+parVc7zZ323u4rrf38oL165bsecjTtlatPkUWy0xXFf6dua3uMsdGYYQ8ZyENbtJl4hrY+u7ZVWR2sg/f3W1n932y39qT+b+/RaG2nMghy3L95//+1oWmb/+C9vvmTtjn1vPlP29us/xsBLdjOZNtw0Nhr7Bxs87D/2HzL8nnEMzHL1esfD7VuQENB3NMcouzRZ6x7PGzu2HPseAS7NIbVTMOIgS2PjAl2orBEbtdziDWB3BA+tp0Z8liM75BNCP3GIzf/FeRZpYywQXIZvwXfWqo0GoIcBz0lA4ImBwGfhBpcf/T8lcxsg2HUWAwbtO9wwyMzLOLEwK7ukLlHbCunPCEL8fDM7WOnjybKHiGWhye0wyMg8KNu+i65x11ikZk/o4l2hBJ133EonVRXoOXPRtjpjS8YqKWKnMklbQSlbTr4D584gO7fknS0wfrl28ZLD/Fct7WNdAq9S1j/NjhRVb0IFMz/O+3mvjT/77f2d+v5fx2uwvm/ExOS1kvM+mVXgoL5W5wPpsRUTm/iPMlnokQ61lgHjyFlLt2HE+u34rHOav4ehrrScf7vWdi+yBWM//0WZfbF8b/XPmjV438drsLxf0oJabERH+46kgNZZDc2j2zLQ8RyNdimmPgem1qYTXN9faohVwM4NNvR+Kqu2WOND/xoHggHfeZmR5xeTGJ9cXOgOo2BgaQRJC5GDv1FQZmjCbEQZHi7/CTlPMxn26wK5dwUleBb5A8fh7yM5/g4itIDBIrlK3ojiHGwKQUx7tN66o0FFpW7v6TvbD4zkYJC5ALD6WJzvCnFf5Mz5FQh88TJGtJtLgtBOOdnfX/aUMUk4E6vEVG4GVcWFvNNILy5PzKJDmSTR38dSnaux+g8mUHz
const fs = require("fs");
const path = require("path");
// Replace these with your actual values
const APP_ID = "YOUR-APP-ID";
const API_KEY = "YOU-API-KEY";
const BASE_URL = "https://api.glideapps.com";
async function createUpload(contentType, contentLength, fileName) {
06:26:12.553 [JettyServerThreadPool-128] ERROR com.glideapps.jdbcgateway.Server - Uncaught exception when handling /query
org.jooq.exception.SQLDialectNotSupportedException: Type signed is not supported in dialect MYSQL
curl --location --request POST 'http://jdbc-gateway.staging.internal.glideapps.com/query' \
--header 'Content-Type: application/json' \
--data-raw '{
"connectionInfo": {
"uri": "jdbc:mysql://mysql-test-1.mysql.database.azure.com/test?sslMode=REQUIRED",
"props": {
"user": "adminuser",
[1] [2023-08-13T10:55:34.223Z] ERROR (error-or.js:15) - Error 400 SQL [update `test`.`companies` set `test`.`companies`.`Date` = ? where `ID` = ?]; Data truncation: Incorrect date value: '2023-03-05T12:00:00.000Z' for column 'Date' at row 1
[1] [2023-08-13T11:03:21.788Z] ERROR (error-or.js:15) - Error 400 SQL [update `test`.`companies` set `test`.`companies`.`Datetime` = ? where `ID` = ?]; Data truncation: Incorrect datetime value: '2024-03-05T12:00:00.000Z' for column 'Datetime' at row 1
commit 618e4f19f47bb6473f15e70973fbb54ca7bb3cbc
Author: Mark Probst <mark.probst@gmail.com>
Date: Tue Sep 28 20:28:02 2021 -0400
Benchmark
diff --git a/functions/src/cli-routines/all-routines.ts b/functions/src/cli-routines/all-routines.ts
index f0d4f219dc..555077558d 100644
--- a/functions/src/cli-routines/all-routines.ts
+++ b/functions/src/cli-routines/all-routines.ts
<html>
<head>
<title>Game of Life</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<canvas id="canvas" width="300" height="300"></canvas>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script>
<!DOCTYPE html><html lang="en" style="overflow:hidden"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1,shrink-to-fit=no,user-scalable=no,viewport-fit=cover"><meta name="theme-color" content="#000000"><link rel="apple-touch-icon" id="apple-touch-icon-placeholder"><meta name="apple-mobile-web-app-capable" content="yes"><meta name="apple-mobile-web-app-status-bar-style" content="default"><meta name="google-site-verification" content="c_kjzc6ibzAo9F9ILkH8tTMkiY353BxP4pUMrpMhcXM"><meta name="google" content="notranslate"><title>Inside Glide</title><link href="https://fonts.googleapis.com/css?family=Roboto+Mono|Roboto:400,500,700,900&amp;display=swap" rel="stylesheet"><link rel="icon" type="image/png" href="https://firebasestorage.googleapis.com/v0/b/glide-staging.appspot.com/o/pwa-assets%2FE6caTFQNaRWQ157Zrfho-favicon-16.png?alt=media" sizes="16x16"><link rel="icon" type="image/png" href="https://firebasestorage.googleapis.com/v0/b/glide-staging.appspot.com/o/pwa-asset
// To parse this data:
//
// import { Convert, ProtocolMessage, Request, Event, Response, ErrorResponse, InitializedEvent, StoppedEvent, ContinuedEvent, ExitedEvent, TerminatedEvent, ThreadEvent, OutputEvent, BreakpointEvent, ModuleEvent, LoadedSourceEvent, ProcessEvent, CapabilitiesEvent, RunInTerminalRequest, RunInTerminalRequestArguments, RunInTerminalResponse, InitializeRequest, InitializeRequestArguments, InitializeResponse, ConfigurationDoneRequest, ConfigurationDoneResponse, LaunchRequest, LaunchRequestArguments, LaunchResponse, AttachRequest, AttachRequestArguments, AttachResponse, RestartRequest, RestartResponse, DisconnectRequest, DisconnectArguments, DisconnectResponse, TerminateRequest, TerminateArguments, TerminateResponse, SetBreakpointsRequest, SetBreakpointsArguments, SetBreakpointsResponse, SetFunctionBreakpointsRequest, SetFunctionBreakpointsArguments, SetFunctionBreakpointsResponse, SetExceptionBreakpointsRequest, SetExceptionBreakpointsArguments, SetExceptionBreakpointsResponse, Continue