🧪 CNAG-Biomedical-Informatics SQL.js-HTTPVFS Playground

This is a fork of nishad’s sql.js-httpvfs playground.

💡 It enables querying an SQLite database stored on GitHub, directly in the browser using GitHub Pages — powered by sql.js-httpvfs, a wrapper around sql.js.

---

🎯 Use Case

This tool lets you explore Pheno-Ranker output of:

• 🧬 OMIM
• 🧫 TCGA

on here: 👉 cnag-biomedical-informatics.github.io/sql.js-httpvfs-playground

The databases are served directly from:
📁 CNAG Biomedical Informatics - CBI datahub

---

🔄 Key Differences to nishad's Playground

🌟 More polished look and feel of the rendered mounw-powertable

• Power-table CSS enabled
• Clickable links in the table cells

🔗 Pre-configured Database URLs

• No need to paste database links — switch between available datasets using tabs.

🧾 SQL Query Builder

• No SQL skills? No problem! Easily build queries via a form-based UI.
• ✍️ The CodeJar editor is hidden by default and can be toggled for manual editing.

---

Authors

👤 Humans (at CNAG)

• Ivo Christopher Leist (ICL), PhD student
• Manuel Rueda (MR), PhD

Contributions	👤
Creation of this fork	ICL
Adaptation to the CNAG use case	ICL, MR
Running of Pheno-Ranker and the creation of the SQLite databases	MR

🤖 GenAI tools contributions

Tool	Contribution
GitHub Copilot	code completion
OpenAI ChatGPT 4o and o4-mini-high	various code suggestions, styling of this README
OpenAI Codex (research preview)	merged PRs