Data

Tools

Indexes

Applications

Experiments

Open Source Science

sqlite

Qompass AI SQLite setup

https://github.com/qompassai/sqlite

Science Score: 54.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ✓
    Academic publication links
    Links to: arxiv.org, researchgate.net, zenodo.org
  • ○
    Committers with academic emails
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (10.0%) to scientific vocabulary

Keywords

sqlite
Last synced: 4 months ago · JSON representation ·

Repository

Qompass AI SQLite setup

Basic Info
  • Host: GitHub
  • Owner: qompassai
  • License: agpl-3.0
  • Language: Python
  • Default Branch: main
  • Size: 85 KB
Statistics
  • Stars: 0
  • Watchers: 0
  • Forks: 0
  • Open Issues: 0
  • Releases: 12
Topics
sqlite
Created 8 months ago · Last pushed 4 months ago
Metadata Files
Readme Funding License Citation Zenodo

README.md

SQLite: For "lightweight" data needs

Qompass AI on SQLite

Repository Views GitHub all releases SQLite
SQLite Documentation SQLite Tutorials
License: AGPL v3 License: Q-CDA

▶️ Qompass AI Quick Start
```bash bash <(curl -L https://raw.githubusercontent.com/qompassai/dotfiles/main/scripts/quickstart.sh) ```
📄 We advise you read the script BEFORE running it 😉 
#!/usr/bin/env bash
# /qompassai/dotfiles/scripts/quickstart.sh
# Qompass AI Quick Start Script
# Copyright (C) 2025 Qompass AI, All rights reserved
####################################################

REPO="https://github.com/qompassai/dotfiles"
TARGET_DIR="$HOME/.dotfiles"
if [ -d "$TARGET_DIR" ]; then
    echo "Removing existing dotfiles directory..."
    rm -rf "$TARGET_DIR"
fi
echo "Cloning Qompass AI Dotfiles..."
git clone "$REPO" "$TARGET_DIR"
echo "Setting up symlinks..."
mkdir -p "$HOME/.config/nix" "$HOME/.profile.d"
ln -sf "$TARGET_DIR/.config/nix/nix.conf" "$HOME/.config/nix/nix.conf"
ln -sf "$TARGET_DIR/.profile.d/67-nix.sh" "$HOME/.profile.d/67-nix.sh"
mkdir -p "$HOME/.config"
ln -sfn "$TARGET_DIR/home" "$HOME/.config/home" 2>/dev/null || true
ln -sfn "$TARGET_DIR/.local" "$HOME/.local" 2>/dev/null || true
ln -sf "$TARGET_DIR/flake.nix" "$HOME/.config/flake.nix" 2>/dev/null || true
source "$HOME/.profile.d/67-nix.sh" 2>/dev/null || {
    echo "WARNING: Could not source Nix profile configuration. Falling back to manual exporting"
    export NIX_CONF_DIR="$HOME/.config/nix"
    export NIX_STORE_DIR="$HOME/.nix/store"
    export NIX_STATE_DIR="$HOME/.local/state/nix"
    export NIX_LOG_DIR="$HOME/.local/state/nix/log"
    export NIX_PROFILE_DIR="$HOME/.nix-profile"
    export PATH="$NIX_PROFILE_DIR/bin:$PATH"
}
if ! command -v nix >/dev/null; then
    echo "Installing Nix with custom configuration..."
    mkdir -p /.nix/var/nix/{profiles,gcroots,db}
    chown -R "$(whoami)" /.nix
    sh <(curl -L https://nixos.org/nix/install) --daemon \
        --nix-extra-conf-file "$NIX_CONF_DIR/nix.conf"
    if [ -f '/.nix/var/nix/profiles/default/etc/profile.d/nix-daemon.sh' ]; then
        . '/.nix/var/nix/profiles/default/etc/profile.d/nix-daemon.sh'
    fi
fi
echo "Setting up Nix environment..."
cd "$TARGET_DIR"
nix flake update
detect_shell() {
    case "$(ps -p $$ -o comm=)" in
        *bash*) echo "bash" ;;
        *zsh*)  echo "zsh" ;;
        *fish*) echo "fish" ;;
        *)      echo "bash" ;;
    esac
}
USER_SHELL=$(detect_shell)
echo "Detected shell: $USER_SHELL"
nix develop --command "$USER_SHELL"

Or, View the quickstart script.

🧭 About Qompass AI

Matthew A. Porter
Former Intelligence Officer
Educator & Learner
DeepTech Founder & CEO

Publications

ORCID ResearchGate Zenodo

Developer Programs

[![NVIDIA Developer](https://img.shields.io/badge/NVIDIA-Developer_Program-76B900?style=for-the-badge\&logo=nvidia\&logoColor=white)](https://developer.nvidia.com/) [![Meta Developer](https://img.shields.io/badge/Meta-Developer_Program-0668E1?style=for-the-badge\&logo=meta\&logoColor=white)](https://developers.facebook.com/) [![HackerOne](https://img.shields.io/badge/-HackerOne-%23494649?style=for-the-badge\&logo=hackerone\&logoColor=white)](https://hackerone.com/phaedrusflow) [![HuggingFace](https://img.shields.io/badge/HuggingFace-qompass-yellow?style=flat-square\&logo=huggingface)](https://huggingface.co/qompass) [![Epic Games Developer](https://img.shields.io/badge/Epic_Games-Developer_Program-313131?style=for-the-badge\&logo=epic-games\&logoColor=white)](https://dev.epicgames.com/)

Professional Profiles

Personal LinkedIn Startup LinkedIn

Social Media

X/Twitter Instagram Qompass AI YouTube

🔥 How Do I Support
🏛️ Qompass AI Pre-Seed Funding 2023-2025 🏆 Amount 📅 Date
RJOS/Zimmer Biomet Research Grant $30,000 March 2024
Pathfinders Intern Program
View on LinkedIn		 $2,000 October 2024

🤝 How To Support Our Mission

[![GitHub Sponsors](https://img.shields.io/badge/GitHub-Sponsor-EA4AAA?style=for-the-badge\&logo=github-sponsors\&logoColor=white)](https://github.com/sponsors/phaedrusflow) [![Patreon](https://img.shields.io/badge/Patreon-Support-F96854?style=for-the-badge\&logo=patreon\&logoColor=white)](https://patreon.com/qompassai) [![Liberapay](https://img.shields.io/badge/Liberapay-Donate-F6C915?style=for-the-badge\&logo=liberapay\&logoColor=black)](https://liberapay.com/qompassai) [![Open Collective](https://img.shields.io/badge/Open%20Collective-Support-7FADF2?style=for-the-badge\&logo=opencollective\&logoColor=white)](https://opencollective.com/qompassai) [![Buy Me A Coffee](https://img.shields.io/badge/Buy%20Me%20A%20Coffee-Support-FFDD00?style=for-the-badge\&logo=buy-me-a-coffee\&logoColor=black)](https://www.buymeacoffee.com/phaedrusflow)
🔐 Cryptocurrency Donations **Monero (XMR):**
Monero QR Code
42HGspSFJQ4MjM5ZusAiKZj9JZWhfNgVraKb1eGCsHoC6QJqpo2ERCBZDhhKfByVjECernQ6KeZwFcnq8hVwTTnD8v4PzyH

Funding helps us continue our research at the intersection of AI, healthcare, and education

Frequently Asked Questions ### Q: How do you mitigate against bias? **TLDR - we do math to make AI ethically useful** ### A: We delineate between mathematical bias (MB) - a fundamental parameter in neural network equations - and algorithmic/social bias (ASB). While MB is optimized during model training through backpropagation, ASB requires careful consideration of data sources, model architecture, and deployment strategies. We implement attention mechanisms for improved input processing and use legal open-source data and secure web-search APIs to help mitigate ASB. [AAMC AI Guidelines | One way to align AI against ASB](https://www.aamc.org/about-us/mission-areas/medical-education/principles-ai-use) ### AI Math at a glance ## Forward Propagation Algorithm $$ y = w_1x_1 + w_2x_2 + ... + w_nx_n + b $$ Where: - $y$ represents the model output - $(x_1, x_2, ..., x_n)$ are input features - $(w_1, w_2, ..., w_n)$ are feature weights - $b$ is the bias term ### Neural Network Activation For neural networks, the bias term is incorporated before activation: $$ z = \\sum\_{i=1}^{n} w_ix_i + b $$ $$ a = \\sigma(z) $$ Where: - $z$ is the weighted sum plus bias - $a$ is the activation output - $\\sigma$ is the activation function ### Attention Mechanism- aka what makes the Transformer (The "T" in ChatGPT) powerful - [Attention High level overview video](https://www.youtube.com/watch?v=fjJOgb-E41w) - [Attention Is All You Need Arxiv Paper](https://arxiv.org/abs/1706.03762) The Attention mechanism equation is: $$ \\text{Attention}(Q, K, V) = \\text{softmax}\\left( \\frac{QK^T}{\\sqrt{d_k}} \\right) V $$ Where: - $Q$ represents the Query matrix - $K$ represents the Key matrix - $V$ represents the Value matrix - $d_k$ is the dimension of the key vectors - $\\text{softmax}(\\cdot)$ normalizes scores to sum to 1 ### Q: Do I have to buy a Linux computer to use this? I don't have time for that! ### A: No. You can run Linux and/or the tools we share alongside your existing operating system: - Windows users can use Windows Subsystem for Linux [WSL](https://learn.microsoft.com/en-us/windows/wsl/install) - Mac users can use [Homebrew](https://brew.sh/) - The code-base instructions were developed with both beginners and advanced users in mind. ### Q: Do you have to get a masters in AI? ### A: Not if you don't want to. To get competent enough to get past ChatGPT dependence at least, you just need a computer and a beginning's mindset. Huggingface is a good place to start. - [Huggingface](https://docs.google.com/presentation/d/1IkzESdOwdmwvPxIELYJi8--K3EZ98_cL6c5ZcLKSyVg/edit#slide=id.p) ### Q: What makes a "small" AI model? ### A: AI models ~=10 billion(10B) parameters and below. For comparison, OpenAI's GPT4o contains approximately 200B parameters.
What a Dual-License Means ### Protection for Vulnerable Populations The dual licensing aims to address the cybersecurity gap that disproportionately affects underserved populations. As highlighted by recent attacks[1], low-income residents, seniors, and foreign language speakers face higher-than-average risks of being victims of cyberattacks. By offering both open-source and commercial licensing options, we encourage the development of cybersecurity solutions that can reach these vulnerable groups while also enabling sustainable development and support. ### Preventing Malicious Use The AGPL-3.0 license ensures that any modifications to the software remain open source, preventing bad actors from creating closed-source variants that could be used for exploitation. This is especially crucial given the rising threats to vulnerable communities, including children in educational settings. The attack on Minneapolis Public Schools, which resulted in the leak of 300,000 files and a $1 million ransom demand, highlights the importance of transparency and security[8]. ### Addressing Cybersecurity in Critical Sectors The commercial license option allows for tailored solutions in critical sectors such as healthcare, which has seen significant impacts from cyberattacks. For example, the recent Change Healthcare attack[4] affected millions of Americans and caused widespread disruption for hospitals and other providers. In January 2025, CISA[2] and FDA[3] jointly warned of critical backdoor vulnerabilities in Contec CMS8000 patient monitors, revealing how medical devices could be compromised for unauthorized remote access and patient data manipulation. ### Supporting Cybersecurity Awareness The dual licensing model supports initiatives like the Cybersecurity and Infrastructure Security Agency (CISA) efforts to improve cybersecurity awareness[7] in "target rich" sectors, including K-12 education[5]. By allowing both open-source and commercial use, we aim to facilitate the development of tools that support these critical awareness and protection efforts. ### Bridging the Digital Divide The unfortunate reality is that too many individuals and organizations have gone into a frenzy in every facet of our daily lives[6]. These unfortunate folks identify themselves with their talk of "10X" returns and building towards Artificial General Intelligence aka "AGI" while offering GPT wrappers. Our dual licensing approach aims to acknowledge this deeply concerning predatory paradigm with clear eyes while still operating to bring the best parts of the open-source community with our services and solutions. ### Recent Cybersecurity Attacks Recent attacks underscore the importance of robust cybersecurity measures: - The Change Healthcare cyberattack in February 2024 affected millions of Americans and caused significant disruption to healthcare providers. - The White House and Congress jointly designated October 2024 as Cybersecurity Awareness Month. This designation comes with over 100 actions that align the Federal government and public/private sector partners are taking to help every man, woman, and child to safely navigate the age of AI. By offering both open source and commercial licensing options, we strive to create a balance that promotes innovation and accessibility. We address the complex cybersecurity challenges faced by vulnerable populations and critical infrastructure sectors as the foundation of our solutions, not an afterthought. ### References

Owner

  • Name: Qompass
  • Login: qompassai
  • Kind: organization
  • Email: map@qompass.ai
  • Location: United States of America

Cost-Conscious GenAI Microservices

Citation (CITATION.cff) 

cff-version: 1.2.0
title: "sqlite"
message: "If you use this software, please cite it as below."
authors:
  - family-names: "Porter"
    given-names: "Matthew A."
    orcid: "https://orcid.org/0000-0002-0302-4812"
    affiliation: "Qompass AI"
version: "v2025-09-04"
date-released: "2025-09-04"
repository-code: "https://github.com/qompassai/sqlite"
license: "Q-CDA-1.0"
keywords:
  - AI
  - Education
  - Healthcare
  - Post-Quantum Cryptography
  - Quantum
  - data science
  - machine learning
  - python
abstract: "Qompass AI SQLite setup"

GitHub Events

Total
  • Release event: 9
  • Push event: 93
  • Create event: 13
Last Year
  • Release event: 9
  • Push event: 93
  • Create event: 13

Committers

Last synced: 5 months ago

All Time
  • Total Commits: 98
  • Total Committers: 2
  • Avg Commits per committer: 49.0
  • Development Distribution Score (DDS): 0.02
Past Year
  • Commits: 98
  • Committers: 2
  • Avg Commits per committer: 49.0
  • Development Distribution Score (DDS): 0.02
Top Committers
Name Email Commits
phaedrusflow m****p@q****i 96
Qompass Current c****t@q****i 2
Committer Domains (Top 20 + Academic)
qompass.ai: 2

Issues and Pull Requests

Last synced: 5 months ago

Dependencies

.github/workflows/fh.yml actions