Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: TiDB hackathon 2022 参赛项目介绍
|
username: Billmay表妹
- Event Details: TiDB Hackathon 2022 Homepage
- Quick Registration: Register Now
- Participation Guide: 【Important】TiDB Hackathon 2022 Participation Guide
- Community Team Formation: 【Hackathon 2022 Team Formation Guide】Looking for teammates? Check this out~~
- RFC Explanation: 【Important】Hackathon 2022 RFC Design Document Template
| No. | Team Name | Project Name | Project Brief Description | Track |
|---|---|---|---|---|
| 1 | 我垫你们蹲 | TiFlash Collocated Optimization | TiFlash supports Collocated Join | TiDB Product Group |
| 2 | 队长负责带饭 | TiBee | TiDB Product Group | |
| 3 | TINOCO | TiNocoDB | AirTable is a great low-code management tool, but they restrict free users from using row-based permission management with a paywall. NocoDB is its open-source alternative, but the MySQL backend will become a shackle in the near future. We believe TiDB’s powerful scalable features will fully unleash the potential of smart tables, allowing users to grow without worries. Therefore, we hope to integrate NocoDB with TiDB. | Application Group |
| 4 | 鸡你太美 | Sibyl | TiDB Product Group | |
| 5 | 开心就好 | cool | Application Group | |
| 6 | dbpro | TIDB Graphical Management Client macOS Software | TiDB Product Group | |
| 7 | Artbydt | Artbydt: Automatic Detection of Performance Regression in TIDB | TiDB Product Group | |
| 8 | 苍蝇腿也是肉 | Optimizer Support for INDEX SKIP SCAN | Adding index skip scan support to the TiDB optimizer and reusing the index skip scan capability to achieve loose index scan for group by and distinct operations | TiDB Product Group |
| 9 | 爱吃苦瓜和大米 | TiPipeline | Better TiFlash execution model! Based on Hyper morsel driven design, implementing a thread per core model to ensure high execution efficiency and query fairness scheduling in high concurrency scenarios for TiFlash. | TiBD Product Group |
| 10 | GO-PLG | Explosive TiCDC | We aim to deliver the CDC sink as a plugin to users, allowing them to customize logic without recompiling the Tiflow project and packaging TiCDC! Users can send TiKV data from TiCDC to any storage worldwide! | Application Group |
| 11 | 小宝突击队 | longitude | Check out old posts Support for SPATIAL functions, data types and indexes · Issue #6347 · pingcap/tidb · GitHub, Does tidb support Spatial database? · Issue #673 · pingcap/tidb · GitHub. After four, five, six, seven, or eight years, the poor GISers are still waiting for Geo-related support. The Xiaobao Assault Team decided to give it a try and add geographic data support to Tidb. Marathon plan: 1. GeoJSON data type 2. Support for geographic analysis functions based on GeoJSON 3. Finally, make a simple demo. Let’s start the engine and run… | TiDB Product Group |
| 12 | 西红柿八号 | Multi-platform Optimization of Database Core Operators | TiDB Product Group | |
| 13 | 发际线保护协会 | Data Engine | Application Group | |
| 14 | 更实用，更易用 | Tidb holding hands with S3 | Support exporting query result sets directly to specified S3 files | Application Group |
| 15 | Jiekun | FSDS | Provide full data export support for TiDB, facilitating the construction of heterogeneous storage/secondary storage. | TiDB Product Group |
| 16 | 彦青说得队 | Optimizer trace | Visualize the decision-making process of the TiDB optimizer | TiDB Product Group |
| 17 | The Powerful Elephants | Make table cache a little better | Table cache improvement plan | TiDB Product Group |
| 18 | 黑马警长 | One-stop Migration | Heartfelt connection for export and import | Application Group |
| 19 | KubeBrain | KubeBrain | Implement a Kubernetes metadata storage system based on TiDB | Application Group |
| 20 | 五湖四海 | SSO Implementation for TiDB Login Permission Verification | SSO Implementation for TiDB Login Permission Verification | Application Group |
| 21 | TiDB十一年老粉 | TasS API | Build a general data interface based on the distributed database TiDB, providing an out-of-the-box TiDB Data API | Application Group |
| 22 | 多租户多挣钱 | TiDB Multi-tenancy | Implement multi-tenancy for TiDB | Application Group |
| 23 | 神禹 | tibc | Blockchain data set | Application Group |
| 24 | 穹窿队 | Blockchain Data Analysis | 1. Load blockchain data, set data mapping, and import it into TiDB 2. Data analysis | Application Group |
| 25 | ikun | Tree Hole | Fun and interesting | Application Group |
| 26 | 6c0c6375-462b-4320-9af2-03593d55b227 | Mirror-Magic Mirror | Magic mirror, get analysis results without writing complex SQL. Team name inspiration: Magic mirror, magic mirror, tell me, who is the fastest growing distributed database in the world. First, the magic mirror will automatically read TIDB Cloud and obtain various metadata of the database. Then, through deep learning, it will convert user input in natural language into SQL. Finally, the results will be summarized by GPT3. | Application Group |
| 27 | 自己写 自己查 自己网站上挂队 | OSSInsight Marketplace | Our team plans to complete the Marketplace module of OSSInsight during Hackathon 2022. Users can freely upload their own components, and after review, other users can use these components and embed them into any page (via iframe). | Application Group |
| 28 | 周边真好看 | TBD | Performance optimization based on eBPF | TiDB Product Group |
| 29 | go.unwrap() | ticli-rs | tcli in rust! | TiDB Product Group |
| 30 | Ti 流批 | Ti 流批 | Implement a unified storage system for stream and batch processing based on TiDB + Flink Table Store to achieve cost reduction and efficiency improvement | Application Group |
| 31 | 大明湖畔的小天台 | MIXED HTAP ON K8S | Currently, TiFlash has not achieved high-throughput direct writing, which is not very friendly for offline computing. We will try to combine several open-source products to achieve high-throughput AP-side implementation based on TiDB. | Application Group |
| 32 | 炒鸡内卷队 | Community Interaction Transmission | Improve the upload speed for community file uploads | TiDB Product Group |
| 33 | 图一乐 | TiDB Playground | Try TiDB online~ | Application Group |
| 34 | 摸鱼就是 | Double Your QPS | One-click enhancement | TiDB Product Group |
| 35 | TiFancy | TiFancy | Fast at Scale | TiDB Product Group |
| 36 | HOTPOOR | FindMaster | Create websites as easily as making PPTs | Application Group |
| 37 | Ti可立刻 | Quickly create standard demo programs through online IDE | United and lively, brave to explore | Application Group |
| 38 | 不上班你养我啊 | 云迹 | In the wave of cloud technology, enterprises enjoy the benefits of elasticity while struggling with cloud resource cost management. Issues like forgetting to turn off resources, program resource leaks, and sudden cost spikes cause headaches for enterprise personnel. Amazon lists frugality as one of its leadership principles, highlighting the importance of cost for a company, especially for startups. Cost optimization is not just a company’s task; every cloud developer needs to have this sense. Extreme optimization can give birth to great software. The ultimate goal of this project is to solve the problem of unified cost analysis and key indicator monitoring and alerting for enterprises under cloud deployment architecture. Considering the huge amount of data, real-time query and alerting requirements for statistical analysis, we use the HTAP database TiDB as the storage and computing engine to leverage TiDB’s value in application scenarios. We hope to save you a little money through 云迹! | Application Group |
| 39 | 龙哥说的都 | Placement Rules Visualization Configuration | Placement Rules Visualization Configuration | TiDB Product Group |
| 40 | 三剑客 | PIT | Distributed version management system | Application Group |
| 41 | 不知道叫什么队 | TBD | Visual economy | Application Group |
| 42 | 代码人生 | Console | Console | Application Group |
| 43 | Second State | A serverless ETL runtime for the TiDB Cloud | We propose to create a cloud-native ETL application framework based on the WasmEdge WebAssembly runtime for developers to filter, map, and transform data going into TiDB cloud databases. Developers will be able to create secure, lightweight, fast, and cross-platform ETL functions that are located close to or even embedded in TiDB Cloud’s infrastructure. The ETL functions can be deployed as serverless functions and receive data from a variety of sources including event queues, webhook callbacks, and data streaming pipelines. The outcomes are written into user-configured TiDB tables for later analysis. | Application Group |
| 44 | 双呆 | tip | Clickhouse supports data queries via HTTP protocol, making it possible to use the database on any platform and programming language environment. We plan to support this practical feature in TiDB during this Hackathon and verify its usage scenarios through a simple demo. | Application Group |
| 45 | Sightseeing | TiDB Data Flow Monitoring Tool Based on eBPF | This project uses eBPF and the plugin system of TiDB and TiKV to achieve statistical monitoring of data flow, drawing real-time data flow diagrams to make up for the shortcomings of DashBoard in this regard. | TiDB Product Group |
| 46 | 1+1>2 | Implementing Aurora Cloud-native Database Based on TIKV+PostgreSQL | Implement AWS Aurora cloud-native database based on TIKV + PostgreSQL, achieving compute-storage separation in architecture, using PostgreSQL engine for computation and TIKV for storage; all primary and secondary instances share one data, with TIKV providing multi-version data page reading capability; following the idea of “log is database” mentioned in the paper, only writing WAL logs, with WAL logs asynchronously replayed into data pages | TiDB Product Group |
| 47 | 中企乘数 | ticloud | Create an automated deployment TiDB enterprise private cloud. | TiDB Product Group |
| 48 | MindBase队 | MindBase | MindBase | Application Group |
| 49 | Spark斯巴克 | Cloud-native Composite Robot Control System | Cloud-native composite robots define the new form of food delivery in the future. Composite robots use a tracked dual-wheel drive chassis to achieve low-speed unmanned driving in communities and parks; at the same time, the robot meets users’ dining needs by connecting to the pre-prepared food industry chain, cooking dishes like stir-fried pork, noodles, dumplings, and wontons. After users place an order through a mobile applet, the composite robot starts preparing the meal in a transparent space under a glass cover (supporting process playback under the camera) and moves to the designated pickup location; users can pick up the meal through facial recognition or mobile phone scanning. The team participates in the TiDB competition to leverage TiDB’s distributed and real-time database features to achieve low-latency robot control under 5G-MEC/WIFI6 networks. | Application Group |
| 50 | 莫慌！有我！ | NFTips | Directly use public chain data to visualize the “life” of NFT digital collectibles, helping buyers discover the potential of collectibles and assess investment risks; it may also provide insights for sellers in pricing, estimating transaction prices, and judging the number of resales when releasing digital collectibles. | Application Group |
| 51 | 12只喵 | MoreCat | Allow everyone to contribute components to TiDB through personal mirrors via tiup, creating a prototype of the component market | TiDB Product Group |
| 52 | 你说了算 | AutoIndex | Provide automatic index and TiFlash replica addition suggestions for cloud TiDB clusters to efficiently optimize user queries. | TiDB Product Group |
| 53 | 1’ or ‘1’ = '1 | TiSQLi | SQL-injection detection method with TiDB SQL parser | Application Group |
| 54 | 小蝌蚪找妈妈 | TiQ | Built-in message queue in TiDB, supporting subscription in SQL syntax | TiDB Product Group |
| 55 | 三恒诸浪 | SSO Implementation for TiDB Login Permission Verification | This project aims to use SSO as the login authentication method for TiDB, allowing users to avoid direct database username and password connections to TiDB, enhancing security and permission control. | Application Group |
| 56 | 敲代码不喊我是吧 | TiCat | The project focuses on implementing a migration verification tool for migrating from MySQL to TiDB. Using SQL lexical parser and predefined rules, design a highly extensible automated checker that can check whether SQL statements meet TiDB requirements, perform automatic migration, and provide suggestions and related links for non-compliant parts. | Application Group |
| 57 | Leonardo | WAY@TiDB GIS support | Leonardo da Vinci is a versatile talent in history. In this WAY program, we would like to support spatial data in TiDB, making TiDB support multi-model and become a uniform data platform in the future. | TiDB Product Group |
| 58 | jetcloud | TiDB HTAP Teaching System Financial Edition | Quantitative design database from data | Application Group |
| 59 | 中杯 大杯 超大杯 | TiTicket | TiDB ticket office, user authentication based on SSO, achieving self-registration and permission application on TiDB | Application Group |
| 60 | 工具人8 | Database Middleware | Database Middleware | Application Group |