Skip to content

Instantly share code, notes, and snippets.

View robstradling's full-sized avatar

Rob Stradling robstradling

219 followers · 1 following
View GitHub Profile
@robstradling
robstradling / go.mod
Last active November 15, 2023 12:30
module gist.github.com/robstradling/f8f8c04b73af72e7f137c1eedb523d15
go 1.20
require github.com/sijms/go-ora/v2 v2.7.21
@robstradling
robstradling / main.go
Created September 6, 2023 13:52
Demonstrate some go-ora regressions since v2.7.14
package main
@robstradling
robstradling / query.sql
Last active February 20, 2024 14:31
2023-10-27: CA Owner "?" on https://crt.sh/cert-populations
WITH cas AS (
SELECT cac.CA_ID
FROM ccadb_certificate cc
JOIN ca_certificate cac ON cc.CERTIFICATE_ID = cac.CERTIFICATE_ID
WHERE cc.INCLUDED_CERTIFICATE_OWNER IS NULL
EXCEPT
SELECT cac.CA_ID
FROM ccadb_certificate cc
JOIN ca_certificate cac ON cc.CERTIFICATE_ID = cac.CERTIFICATE_ID
GROUP BY cac.CA_ID
@robstradling
robstradling / dequeue_array.go
Last active December 11, 2023 20:11
go-ora: Regression since v2.7.23 when using DBMS_AQ.DEQUEUE_ARRAY
package main
import (
"database/sql"
"flag"
"fmt"
"os"
"time"
go_ora "github.com/sijms/go-ora/v2"
@robstradling
robstradling / cant_assign_value.go
Last active February 16, 2024 09:23
go-ora: Regression since v2.8.7 for simple SELECTs into integer and floating point variables
package main
import (
"context"
"database/sql"
"flag"
"fmt"
"os"
go_ora "github.com/sijms/go-ora/v2"
@robstradling
robstradling / go.mod
Last active February 16, 2024 11:16
go-ora integer precision
module gist.github.com/robstradling/363b54e979b879e0450cfa36e238cca6
go 1.21.6
require github.com/sijms/go-ora/v2 v2.8.9
@robstradling
robstradling / check_extension_criticality.go
Last active April 9, 2024 11:35
TLSBRv2 §7.1.2.7.6 Subscriber Certificate Extensions: Survey of critical flag non-compliance
package main
import (
"context"
"flag"
"fmt"
"math"
"os/signal"
"syscall"
"time"