René's URL Explorer Experiment

{
  "@context": "https://schema.org",
  "@graph": [
    {
      "@type": "SoftwareApplication",
      "@id": "software:pgsql-test",
      "name": "PgSQL Test",
      "description": "A high-performance Postgres testing framework for TypeScript, enabling isolated databases, per-test rollback, RLS simulation, and flexible seeding strategies.",
      "url": "https://github.com/constructive-io/constructive",
      "codeRepository": "https://github.com/constructive-io/constructive",
      "sameAs": [
        "https://www.npmjs.com/package/pgsql-test",
        "https://github.com/constructive-io/constructive",
        "https://github.com/constructive-io/constructive/tree/main/packages/pgsql-test"
      ],
      "programmingLanguage": "TypeScript",
      "creator": [
        {
          "@id": "org:constructive"
        }
      ],
      "contributor": [
        {
          "@id": "person:danlynch"
        }
      ],
      "applicationCategory": [
        "database",
        "postgres"
      ]
    },
    {
      "@id": "org:constructive",
      "@type": "Organization",
      "name": "Constructive",
      "alternateName": "Interweb, Inc.",
      "url": "https://constructive.io",
      "x-logo": "/logos/constructive.svg",
      "keywords": [
        "founded"
      ],
      "logo": "https://constructive.io/logo.svg",
      "founder": [
        {
          "@id": "person:danlynch"
        }
      ],
      "subjectOf": [
        {
          "@id": "article:interweb-rebrands-as-constructive"
        },
        {
          "@id": "article:constructive-investorhangout"
        },
        {
          "@id": "article:constructives-pgpm-innovating-postgresql-investorhangout"
        },
        {
          "@id": "article:constructive-launches-pgpm-pr-newswire"
        },
        {
          "@id": "article:constructive-launches-pgpm-yahoo"
        },
        {
          "@id": "article:introducing-pgpm-postgresql-org"
        }
      ]
    },
    {
      "@id": "person:danlynch",
      "@type": "Person",
      "name": "Dan Lynch",
      "alternateName": [
        "Dan Lynch",
        "Daniel Lynch",
        "pyramation"
      ],
      "url": "https://www.danlynch.com",
      "sameAs": [
        "https://www.npmjs.com/~pyramation",
        "https://www.youtube.com/@pyramation",
        "https://scholar.google.com/citations?user=1U4vfEUAAAAJ&hl=en",
        "https://berkeley.academia.edu/DanLynch",
        "https://github.com/pyramation",
        "https://www.linkedin.com/in/dan-p-lynch/",
        "https://www.crunchbase.com/person/dan-lynch-3",
        "https://x.com/danlynch",
        "https://www.instagram.com/pyramation/",
        "https://www.facebook.com/danlynch"
      ],
      "image": "https://avatars.githubusercontent.com/u/545047?v=4",
      "jobTitle": "Founder & CEO",
      "worksFor": {
        "@id": "org:constructive"
      },
      "description": "Dan Lynch is a serial entrepreneur and founder of Constructive, with multiple successful exits including Brandcast and Amaze/Famo.us. He holds two EECS degrees from UC Berkeley and has built platforms powering billions in blockchain and cloud transactions."
    },
    {
      "@type": "Article",
      "@id": "article:interweb-rebrands-as-constructive",
      "headline": "Interweb, Inc. Rebrands as Constructive™ -- A Unified, Modular, and Secure Postgres Platform for Production-Grade Applications",
      "url": "https://www.prnewswire.com/news-releases/interweb-inc-rebrands-as-constructive--a-unified-modular-and-secure-postgres-platform-for-production-grade-applications-302638777.html",
      "publisher": {
        "@id": "org:pr-newswire"
      },
      "datePublished": "2025-12-11",
      "about": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "org:launchql"
        },
        {
          "@id": "org:hyperweb"
        }
      ],
      "mentions": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "org:launchql"
        },
        {
          "@id": "org:hyperweb"
        },
        {
          "@id": "person:danlynch"
        },
        {
          "@id": "org:supabase"
        },
        {
          "@id": "person:paul-copplestone"
        }
      ],
      "image": [
        {
          "@id": "image:constructive-pr-newswire"
        }
      ]
    },
    {
      "@type": "Article",
      "@id": "article:constructive-investorhangout",
      "headline": "Constructive™: The Comprehensive Postgres Platform for Development",
      "url": "https://investorshangout.com/constructive-the-comprehensive-postgres-platform-for-development-485840-/",
      "publisher": {
        "@id": "org:investor-hangout"
      },
      "datePublished": "2025-12-11",
      "author": {
        "@type": "Person",
        "name": "Thomas Cooper"
      },
      "about": [
        {
          "@id": "org:constructive"
        }
      ],
      "mentions": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "person:danlynch"
        }
      ]
    },
    {
      "@type": "Article",
      "@id": "article:constructives-pgpm-innovating-postgresql-investorhangout",
      "headline": "Constructive's pgpm: Innovating PostgreSQL for Developers",
      "url": "https://investorshangout.com/constructives-pgpm-innovating-postgresql-for-developers-490322-/",
      "datePublished": "2025-12-17",
      "author": {
        "@type": "Person",
        "name": "Dominic Sanders"
      },
      "publisher": {
        "@id": "org:investor-hangout"
      },
      "about": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        }
      ],
      "mentions": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        },
        {
          "@id": "person:danlynch"
        }
      ]
    },
    {
      "@type": "NewsArticle",
      "@id": "article:constructive-launches-pgpm-pr-newswire",
      "headline": "Constructive Launches pgpm: Modular Postgres for Large-Scale Application Development",
      "url": "https://www.prnewswire.com/news-releases/constructive-launches-pgpm-modular-postgres-for-large-scale-application-development-302644203.html",
      "datePublished": "2025-12-17",
      "publisher": {
        "@id": "org:pr-newswire"
      },
      "about": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        }
      ],
      "mentions": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        },
        {
          "@id": "person:danlynch"
        },
        {
          "@id": "person:kemnitz"
        },
        {
          "@id": "person:stonebraker"
        }
      ]
    },
    {
      "@type": "NewsArticle",
      "@id": "article:constructive-launches-pgpm-yahoo",
      "headline": "Constructive Launches pgpm: Modular Postgres for Large-Scale Application Development",
      "url": "https://finance.yahoo.com/news/constructive-launches-pgpm-modular-postgres-131400906.html",
      "datePublished": "2025-12-17",
      "publisher": {
        "@id": "org:yahoo"
      },
      "about": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        }
      ],
      "mentions": [
        {
          "@id": "org:constructive"
        },
        {
          "@id": "software:pgpm"
        },
        {
          "@id": "person:danlynch"
        },
        {
          "@id": "person:kemnitz"
        },
        {
          "@id": "person:stonebraker"
        }
      ]
    },
    {
      "@type": "NewsArticle",
      "@id": "article:introducing-pgpm-postgresql-org",
      "headline": "Introducing pgpm: A Package Manager for Modular PostgreSQL",
      "url": "https://www.postgresql.org/about/news/introducing-pgpm-a-package-manager-for-modular-postgresql-3196/",
      "datePublished": "2026-01-07",
      "publisher": {
        "@id": "org:postgresql"
      },
      "author": {
        "@id": "org:constructive"
      },
      "about": [
        {
          "@id": "software:pgpm"
        },
        {
          "@id": "org:constructive"
        }
      ],
      "mentions": [
        {
          "@id": "software:pgpm"
        },
        {
          "@id": "org:constructive"
        },
        {
          "@id": "person:danlynch"
        },
        {
          "@id": "person:kemnitz"
        }
      ]
    },
    {
      "@type": "Organization",
      "@id": "org:pr-newswire",
      "name": "PR Newswire",
      "url": "https://www.prnewswire.com/",
      "keywords": [
        "press"
      ]
    },
    {
      "@type": "Organization",
      "@id": "org:launchql",
      "name": "LaunchQL",
      "description": "Former product brand for Postgres developer tools, now consolidated under Constructive.",
      "url": "https://launchql.com",
      "keywords": [
        "founded",
        "deprecated"
      ],
      "parentOrganization": {
        "@id": "org:constructive"
      }
    },
    {
      "@type": "Organization",
      "@id": "org:hyperweb",
      "name": "Hyperweb",
      "description": "Web3 developer tools and infrastructure.",
      "url": "https://hyperweb.io",
      "keywords": [
        "founded"
      ],
      "parentOrganization": {
        "@id": "org:constructive"
      }
    },
    {
      "@type": "Organization",
      "@id": "org:supabase",
      "name": "Supabase",
      "url": "https://supabase.com/",
      "logo": "https://constructive.io/logos/supabase.svg",
      "x-logo": "/logos/supabase.svg",
      "x-logoWidth": 140,
      "keywords": [
        "advised",
        "served",
        "logo-cloud"
      ],
      "x-priority": 18,
      "sameAs": [
        "https://github.com/supabase",
        "https://x.com/supabase"
      ],
      "memberOf": {
        "@id": "org:postgres"
      },
      "usesSoftware": [
        {
          "@id": "software:constructive"
        },
        {
          "@id": "software:pgsql-parser"
        }
      ]
    },
    {
      "@type": "Person",
      "@id": "person:paul-copplestone",
      "name": "Paul Copplestone",
      "affiliation": {
        "@id": "org:supabase"
      },
      "sameAs": [
        "https://twitter.com/kiwicopple",
        "https://github.com/kiwicopple"
      ]
    },
    {
      "@type": "ImageObject",
      "@id": "image:constructive-pr-newswire",
      "name": "Constructive PR Newswire Announcement",
      "caption": "Interweb, Inc. Rebrands as Constructive™ — A Unified, Modular, and Secure Postgres Platform for Production-Grade Applications",
      "associatedOrganization": "org:constructive",
      "keywords": [
        "startup",
        "constructive",
        "rebrand",
        "press-release",
        "pr-newswire"
      ],
      "contentUrl": "https://constructive.io/timeline/startups/constructive/pr-newswire.jpg"
    },
    {
      "@type": "Organization",
      "@id": "org:investor-hangout",
      "name": "Investors Hangout",
      "url": "https://investorshangout.com/",
      "keywords": [
        "press"
      ]
    },
    {
      "@type": "SoftwareApplication",
      "@id": "software:pgpm",
      "name": "pgpm",
      "description": "Modern package manager for Postgres extensions with dependency resolution and version management.",
      "url": "https://github.com/constructive-io/constructive",
      "codeRepository": "https://github.com/constructive-io/constructive",
      "sameAs": [
        "https://www.npmjs.com/package/pgpm",
        "https://pgpm.io"
      ],
      "subjectOf": [
        {
          "@id": "website:pgpm.io"
        },
        {
          "@id": "article:introducing-pgpm-postgresql-org"
        }
      ],
      "programmingLanguage": "TypeScript",
      "creator": [
        {
          "@id": "org:constructive"
        }
      ],
      "contributor": [
        {
          "@id": "person:danlynch"
        }
      ],
      "applicationCategory": [
        "database",
        "package-manager",
        "devops"
      ]
    },
    {
      "@type": "Person",
      "@id": "person:kemnitz",
      "name": "Greg Kemnitz",
      "jobTitle": "Co-founder",
      "affiliation": {
        "@id": "org:wirekite"
      },
      "sameAs": [
        "https://www.linkedin.com/in/greg-kemnitz-aba9151/"
      ],
      "worksFor": [
        {
          "@type": "Role",
          "roleName": "Chief Programmer",
          "startDate": "1989-05",
          "endDate": "1991-12",
          "worksFor": {
            "@id": "org:postgres-project-berkeley"
          }
        }
      ]
    },
    {
      "@type": "Person",
      "@id": "person:stonebraker",
      "name": "Michael Stonebraker",
      "jobTitle": "Professor",
      "affiliation": {
        "@id": "school:berkeley"
      },
      "sameAs": [
        "https://en.wikipedia.org/wiki/Michael_Stonebraker"
      ],
      "award": [
        "Turing Award (2014)"
      ],
      "description": "Computer scientist, creator of Postgres, and Turing Award winner."
    },
    {
      "@type": "Organization",
      "@id": "org:yahoo",
      "name": "Yahoo Finance",
      "url": "https://finance.yahoo.com/",
      "keywords": [
        "press"
      ]
    },
    {
      "@type": "Organization",
      "@id": "org:postgres",
      "name": "PostgreSQL Global Development Group",
      "alternateName": "Postgres",
      "url": "https://www.postgresql.org/",
      "logo": "https://constructive.io/logos/postgres.svg",
      "sameAs": [
        "https://github.com/postgres",
        "https://en.wikipedia.org/wiki/PostgreSQL",
        "https://x.com/PostgreSQL"
      ],
      "x-logo": "/logos/postgres.svg",
      "x-logoWidth": 60
    },
    {
      "@type": "SoftwareApplication",
      "@id": "software:pgsql-parser",
      "name": "PgSQL Parser",
      "description": "The definitive PostgreSQL parser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.",
      "url": "https://github.com/constructive-io/pgsql-parser",
      "codeRepository": "https://github.com/constructive-io/pgsql-parser",
      "sameAs": [
        "https://www.npmjs.com/package/pgsql-parser"
      ],
      "programmingLanguage": "TypeScript",
      "creator": [
        {
          "@id": "org:constructive"
        }
      ],
      "contributor": {
        "@id": "person:danlynch"
      },
      "applicationCategory": [
        "database",
        "postgres",
        "ast"
      ],
      "softwareRequirements": {
        "@id": "software:pgsql-deparser"
      },
      "isBasedOn": {
        "@id": "software:postgresql"
      }
    },
    {
      "@type": "WebSite",
      "@id": "website:pgpm.io",
      "url": "https://pgpm.io",
      "name": "pgpm",
      "description": "A Postgres Package Manager",
      "mainEntity": {
        "@id": "software:pgpm"
      },
      "publisher": {
        "@id": "org:constructive"
      }
    },
    {
      "@type": "Organization",
      "@id": "org:wirekite",
      "name": "Wirekite",
      "url": "https://wirekite.io",
      "founder": [
        {
          "@id": "person:kemnitz"
        }
      ]
    },
    {
      "@type": "Organization",
      "@id": "org:postgres-project-berkeley",
      "name": "Postgres Project",
      "description": "The original Postgres research project at UC Berkeley (1986-1994), led by Michael Stonebraker, which became the foundation for PostgreSQL.",
      "parentOrganization": {
        "@id": "school:berkeley"
      },
      "founder": [
        {
          "@id": "person:stonebraker"
        }
      ],
      "member": [
        {
          "@id": "person:stonebraker"
        },
        {
          "@id": "person:kemnitz"
        }
      ],
      "foundingDate": "1986",
      "dissolutionDate": "1994",
      "sameAs": [
        "https://en.wikipedia.org/wiki/PostgreSQL#History"
      ]
    },
    {
      "@type": "CollegeOrUniversity",
      "@id": "school:berkeley",
      "name": "University of California, Berkeley",
      "url": "https://www.berkeley.edu",
      "keywords": [
        "studied"
      ],
      "alumni": [
        {
          "@id": "person:danlynch"
        }
      ],
      "x-priority": 12
    },
    {
      "@type": "SoftwareApplication",
      "@id": "software:pgsql-deparser",
      "name": "PgSQL Deparser",
      "description": "The definitive Postgres deparser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.",
      "url": "https://github.com/constructive-io/pgsql-parser",
      "codeRepository": "https://github.com/constructive-io/pgsql-parser",
      "sameAs": [
        "https://www.npmjs.com/package/pgsql-deparser"
      ],
      "programmingLanguage": "TypeScript",
      "creator": [
        {
          "@id": "org:constructive"
        }
      ],
      "contributor": {
        "@id": "person:danlynch"
      },
      "applicationCategory": [
        "database",
        "postgres",
        "ast"
      ]
    },
    {
      "@type": "SoftwareSourceCode",
      "@id": "software:postgresql",
      "name": "PostgreSQL",
      "url": "https://www.postgresql.org/",
      "codeRepository": "https://github.com/postgres/postgres",
      "programmingLanguage": "C",
      "applicationCategory": [
        "database",
        "postgres"
      ],
      "creator": {
        "@id": "org:postgres"
      },
      "license": "https://opensource.org/licenses/PostgreSQL"
    }
  ]
}