Tag
#sql
106 repositories
Repos
Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
Chainquery parses and syncs the LBRY blockchain data into structured SQL
A decentralized, trusted, high performance, SQL database with blockchain features
@IceFireLabs -> IceFireDB is a database built for web3.0 It strives to fill the gap between web2 and web3.0 with a friendly database experience, making web3 application data storage more convenient, and making it easier for web2 applications to achieve decentralization and data immutability.
👩🏫 👨🏫 The open-source curriculum of Enki!
🗄️ Solutions to Database System Concepts Seventh Edition
Next-generation decentralized data lakehouse and a multi-party stream processing network
A curated list of awesome decentralized databases and related resources.
ETL for moving Ethereum data to PostgreSQL database
dune snippets is a collection of sql queries for duneanalytics.com / Google BigQuery
A modular indexer for Cardano with an SQL Postgres backend (an alternative to the well known cardano-db-sync)
⚛️ Generate GraphQL Scheme Online From SQL Query - https://sql-to-graphql.now.sh/
A python library to push ethereum blockchain data into an sql database.
FastQuery(Method of fast database query) 基于Java语言. 简化Java操作数据层.做为一个开发者,仅仅只需要设计编写DAO接口. 因此,开发代码不得不简洁而优雅.从而,大幅度提升开发效率.
Go implementation of the Tableland database/validator - run your own node, handling on-chain events and serving read-queries
Tableland Smart Contracts - Simple solidity tooling to interact with Tableland from on-chain calls.
CodeIgniter 3 - REST API Integration with JWT (JSON Web Tokens)
Time travelling relational database engine and urQL (SQL derived) scripting for the Urbit computer
Resources
基于SpringJdbcTemplate的ORM框架,比Mybatis更方便,更简单,仅需定义Model就可支持各种SQL查询和动态SQL,不再用拼写XML文件和SQL语句,可以通过各种注解式插件扩展,目前主要支持Mysql数据库
Efficiency-first framework for pulling, storing, and aggregating Kraken data using the v2 API.
A Canine-Centric Social Media Platform for AI-Powered NFTs and Charitable Giving, Powered by Appwrite
An advanced Self-Centered Intelligence (SCI) prototype that represents a new paradigm in AI-human interaction.
MiniAuth is a minimalist, secure backend authentication system built with pure PHP and SQLite. It uses JWT tokens to protect API endpoints and offers a clean, modular structure ideal for small projects, prototypes, or educational use.
SQL DAL Maker is a generator of DTO, Model, and DAO classes to access relational databases. Target programming languages: PHP, Java, C++, Python, and Go. To generate the class, you declare it in XML meta-program.
SQL Queries For Usage on EVM Datasets
Ethereum JDBC driver implements a pure java, type 4 JDBC driver that executes SQL queries on Ethereum Blockchain.
Cloud-Scale Data for Spring Developers Quick Start Guide
universum library / gem (ruby edition) - next generation ethereum 2.0 world computer runtime; run contract scripts / transactions (in plain vanilla / standard ruby) on the blockchain; update the (contract-protected / isolated) world states with plain vanilla / standard SQL - work-in-progress / experimental
A collection of SQL views used to enrich data produced by a Helium blockchain-etl
Python scripts for ETL (extract, transform and load) jobs for Tezos blocks, balance updates, and operations
Web based Banking Decentralised Application (DApp) built on Ethereum blockchain which focuses on preventing fraudulent attacks such as that of PNB frauds on sanctioning of Loans and Tenders.
A Recipe Management System built using Java Swing, implementing layered architecture and design patterns. Uses SQL for data storage and Maven for dependency management.
This is a Go library for parsing a Tableland SQL statement.
Standard health reference databases including units of measurement, biomarkers, medical codes, medications, side-effects, supplements, foods, ingredients, and more.
Exasol Driver for VSCode plugin SQLTools
ETL (extract, transform and load) tools for ingesting IoTeX blockchain data to Google BigQuery and Pub/Sub
ft_transcendence is a project developed as part of the 42 coding school curriculum. This application delivers a fully functional multiplayer online Pong game built with modern web development practices and a secure, robust backend.
Tools to analyze event log data of Ethereum and other EVM blockchains by Postgres, Amazon Redshift, DuckDb
CreatorVault — Web3 Creator Economy Platform CreatorVault is a multi-tenant SaaS platform that empowers digital creators to launch their own fully branded storefronts to sell NFTs, digital assets, exclusive content, and services — powered by Web3 and traditional payments.
Dune Analytics / Google BigQuery SQL Queries for OpenMEV/Sushi Relay
Built a fully functional Web3 Crypto Wallet Extension that allows users to transfer, deposit, and swap crypto coins. Technologies used include Ethers, Node.js, React, Express.js, JavaScript, HTML, CSS, and Solidity.
A Steampipe plugin to interface with the Blockchain.com API
Streamlit Dashboard about MetaWin (web3 Casinò) getting data from Flipside API
An end-to-end data engineering project and analytical application designed to support long-term Bitcoin investing. Built with dbt, Snowflake, Airflow, and Streamlit.
Python project for analyzing Bitcoin market, on-chain, and sentiment data using public APIs and SQLite.
SQL Virtual Microservice Gateway - supporting multiple DB / non-DB adapters and communication interfaces (proof of concept).
An end-to-end analytics pipeline for a cross-chain DEX (Ethereum + Solana).
NestJS backend for Gloop Lending protocol, ingests lending events, maintains Postgres cache with points/health-factor views, exposes APIs for deposits, borrowing, staking, and liquidation monitoring.
Stable memory bindings for Turso (SQLite) on ICP
Sync and serve Tezos delegation data via a clean, production-ready Go microservice.
Bitcoin solo mining dashboard featuring CKPool historical performance and a real-time win probability calculator. Analyze market share, energy efficiency, and cost-to-mine for solo hardware.
SQL database, indexer and explorer for Bitcoin-based blockchains.
Data analysis and visualization of Coinbase Pro's (previously GDAX) main coins: BTC, ETH, and LTC
🦘 Accelerate ECDLP solutions with a cross-platform GPU implementation of Pollard's Kangaroo algorithm using Rust and wgpu for diverse hardware support.
Extract data about fund transfers on different blockchains from Google BigQuery datasets and process the data in order to obtain weekly top richest holders
Retrieve and store price of ETHUSD from onchain sources into an SQLite DB for reading.
500 production-ready Dune SQL queries for blockchain support engineers & analysts. Covers Ethereum & Solana raw tables, decoded contracts, Spellbook abstractions, Trino SQL patterns, query optimization, and support triage — using Trino SQL syntax.