This document outlines the project to build extension distribution, discovery, and packaging tools and services to power the growth, accessability, and
theory
/ extension-ecosystem-jobs-tools.md
Last active
December 26, 2025 00:20
This document sketches an idealized Postgres extension ecosystem
This document sketches an idealized Postgres extension ecosystem.
The past year has seen a surge in interest in Postgres extension distribution. A number of people have noted in particular the challenges in finding and
theory
/ my_github_events.pl
Last active
September 2, 2025 11:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use v5.12; | |
| use warnings; | |
| use utf8; | |
| my $uname = 'theory'; | |
| my ($curr_month, $curr_year) = (gmtime)[4,5]; | |
| $curr_year += 1900; | |
| $curr_month += 1; | |
| my %projects; | |
| for my $year (2012..$curr_year) { |
theory
/ cbor-json-number-string-tag.md
Last active
May 16, 2025 16:53
This document specifies a tag for representing JSON numbers as strings in Concise Binary Object Representation (CBOR)[1]. This allows the preservation of numeric values treated as strings rather than the I-JSON (RFC 7493[2]) limits on numbers.
- Tag: 284
- Data item: text string or byte string
- Semantics: JSON Numeric Value, Represented as its JSON Text
- Point of contact: David Wheeler david@justatheory.com
- Description of semantics: https://gist.github.com/theory/ef667af1c725240e6e30d525786d58e6
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package Demo; | |
| # perl -nE '/^use ([^;\s]+)/ && say $1' lib/Demo.pm | xargs cpanm --notest | |
| use strict; | |
| use warnings; | |
| use v5.28; | |
| use Term::TermKey; | |
| use IPC::System::Simple 1.17 qw(capturex run runx capture); | |
| use HTTP::Tiny; |
Say you have a JSON entity like this:
{
"meta": {
"created_at": "2024-06-25T11:56:42Z",
"updated_at": "2024-07-12T15:32:24Z",
"created_by": "theory",
"updated_by": "strongrrl"
},
theory
/ docker-compose.yml
Last active
June 20, 2024 19:49
POC: Create and install Postgres Trunk Binaries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| version: "3.9" | |
| name: trunking | |
| # Start a Zot service for pushing and pulling OCI images, and a | |
| # pgxn/pgxn-tools image for building and testing Linux/AMD binaries. | |
| # | |
| # docker compose up -d | |
| # docker compose exec linux bash | |
| # make clean && make && make trunk | |
| # |
theory
/ pgxn-dist-with-git-dir.txt
Created
January 31, 2024 16:42
PGXN distributions that contain a .git directory
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2011-08-22+17:22:16.0000000000 ./couchdb_fdw/couchdb_fdw-0.1.0/.git | |
| 2013-06-19+09:47:05.0000000000 ./jdbc_fdw/jdbc_fdw-1.0.0/.git | |
| 2013-06-19+09:47:12.0000000000 ./odbc_fdw/odbc_fdw-0.1.0/.git | |
| 2013-06-19+09:49:36.0000000000 ./www_fdw/www_fdw-0.1.6/.git | |
| 2017-05-24+22:15:01.8016781320 ./foreign-keycloak-wrapper/foreign-keycloak-wrapper-0.1.1/.git | |
| 2017-06-06+22:30:02.4726600060 ./foreign-keycloak-wrapper/foreign-keycloak-wrapper-1.0.0/.git | |
| 2017-06-06+23:45:02.3282102750 ./pg_feedback/pg_feedback-0.1.0/.git | |
| 2017-11-10+03:35:02.3228817480 ./pg_bulkload/pg_bulkload-3.1.14/.git | |
| 2018-05-16+23:40:02.2738588690 ./constraint_uniform/constraint_uniform-1.0.0/.git | |
| 2018-05-19+23:15:02.0967067030 ./constr_name_unif/constr_name_unif-1.0.0/.git |
theory
/ ahp-importance.csv
Last active
October 14, 2022 15:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Intensity of Importance | Definition | Explanation | |
|---|---|---|---|
| 1 | Equal importance | Two elements contribute equally to the objective | |
| 3 | Moderate importance | Experience and judgment moderately favor one element over another | |
| 5 | Strong importance | Experience and judgment strongly favor one element over another | |
| 7 | Very strong importance | One element is favored very strongly over another; its dominance is demonstrated in practice | |
| 9 | Extreme importance | The evidence favoring one element over another is of the highest possible order of affirmation |
theory
/ curl-sfc-repo-docker.sh
Last active
February 14, 2020 19:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # # In docker container | |
| # curl -v sfc-repo.snowflakecomputing.com/index.html | |
| * Expire in 0 ms for 6 (transfer 0x5560e6f4ef50) | |
| * Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 0 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 2 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 1 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 4 ms for 1 (transfer 0x5560e6f4ef50) | |
| * Expire in 2 ms for 1 (transfer 0x5560e6f4ef50) |
NewerOlder