recursive-cte 开源项目推荐（28 个）

santoshkhatri9860 /advanced-sql-practice-mysql

Advanced SQL workbook: subqueries, window functions, CTEs, recursive CTEs, and datetime practice.

alitrack /duckdb-graphrag

Graph-RAG without a graph database, on DuckDB — two tables, batched SQL hops, recursive-CTE walks. Port of the plain-SQL graph pattern (EdgeQuake v0.36 style) to embedded analytics.

Amayyas /SQLCraft

PostgreSQL queries from basic joins to window functions, recursive CTEs and measured index optimisation. One e-commerce schema, one Docker command, pure SQL.

CilginYazilim /nested-categories

PHP + MySQL iç içe kategori ağacı: adjacency list, recursive CTE ile tek sorguda okuma, sürükle-bırak taşıma, döngü ve derinlik koruması, alt ağaç ürün sayaçları — PDO, Ajax, Bootstrap 5

MehdiTayefi /GroupDiscountPlatform

Advanced PostgreSQL database project demonstrating stored procedures, triggers, views, indexing, recursive CTEs, and concurrency control.

Spandan228 /LineageKnot

Active infrastructure dependency tracker and self-healing graph engine to detect and repair lineage loop anomalies.

dev171996 /olist-ecommerce-sql-analytics

End-to-end PostgreSQL e-commerce analytics project covering data quality, relational modeling, safe financial reconciliation, business KPIs, recursive CTEs, RFM, retention and query optimization.

D1sordxr /comment-tree

Threaded comments API in Go: nested trees with recursive CTEs, paginated root threads, sqlc + PostgreSQL

Navneet6050 /comm-log-reconciliation

Reconciling a merchant's true target_base (customers reached) from raw SQLite send logs — resolving retry chains via recursive CTEs, campaign eligibility gates, and standalone vs. chained dedup logic. Includes a full reconciliation bridge, verified SQL, and an independent pandas validation script.

heidericklucas /blast-radius

Service-dependency blast radius, deploy order, and cycle detection computed entirely with Postgres recursive CTEs. React 19 + Express 5 + TypeScript.

Ester-Developer /SQL-Query-Practice

🗃️ T-SQL query practice against the BikeStores sample database — recursive CTEs, window functions, joins, date logic, and dynamic SQL.

Mansi-Katarmal /Voltkart-Modern-SQL-Challenge

Engineered advanced SQL solutions for analytical, hierarchical, and data engineering problems using SQL Server.

erichenschel /postgres-graph-patterns

Production-tested Postgres patterns for graph-shaped data — recursive traversal, hybrid trigram+vector entity resolution, momentum scoring, keyset pagination. Runnable and verified.

pandeyishita021 /Financial-Fraud-Detection-Using-SQL

Advanced SQL project analyzing financial transaction datasets to uncover fraud patterns, suspicious transfers, balance inconsistencies, and high-risk accounts using CTEs, recursive queries, and window functions.

IvanShamin /glaze-bom-sql

SQL portfolio: multi-level BOM, glaze chemistry, costing and supplier what-if (MySQL 8, synthetic data)

xxxxxKINGxxxxx /Enterprise-SQL-Mastery

Enterprise-grade SQL portfolio isolating advanced database engineering from any dashboard or app layer — window functions, recursive CTEs, transactional stored procedures, triggers, and measured query optimization on PostgreSQL, verified with real EXPLAIN ANALYZE evidence.

Nafsgerman /cobol-estate-modernizer

AI-powered analyzer for legacy COBOL estates — maps call graphs, detects recursive cycles, and generates modernization tickets. Next.js + Vercel + Aurora PostgreSQL + Claude.

JFrusher /PortDB

A container terminal where PostgreSQL decides what’s allowed to happen. Three berths, cranes on a shared rail, robot trucks, rail and customs, all simulated in SimPy and committed as transactions. Traffic, stacking and stowage rules are constraints and triggers. Rendered as an isometric 3D diorama.

GokulChandarKumaran /supply-chain-risk

Dependency-graph risk analysis in SQL: recursive CTE traversal over 117 npm roots finds 52.8% of 1,985 reachable packages have a single maintainer, and jest installs 284 packages from 4 declared.

ShadiEskafi /academic-management-system

A modular, clean-architecture academic management system built with Vanilla JS, Vite, and Supabase. Features recursive CTE topic trees, RLS policies, custom hash routing, and automated DB triggers.