Creative ideas list——TiDB Future App Hackathon 2023

Community TiDB hackathon
1

If you’re looking for inspiration, check out our Creative Ideas List.

And if you have a great idea of your own, we encourage you to share it! Plus, there’s an exciting opportunity to win an award: the Top 5 Idea-makers with the most votes will be recognized and rewarded. Don’t miss your chance to join the challenge!

Idea 1：Self-hosted status page

  • What problem does this application aim to solve?

    • You can do an open source page, like https://status.openai.com/ a page, although the market has, but we can be self-hosted this, with our own domain name, own database

  • How would you implement it?

    • Using GitHub Action to request URLs and get information like response code and time spent;

    • Using TiDB Cloud Serverless Tier to store the information you get back from above;

    • using Vercel for the status page page and Serverless API;"

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

Idea 2：GitHub Personal README Page Generator

  • What problem does this application aim to solve?

    • Our tool provides access to the GitHub API to get behavioral data about individuals or repositories, whether public or private. Over time, it can dynamically generate READMEs/Badge, etc. While there are many such tools on the market, none of them are self-hosted. Almost all badges are generated with recent data, not all historical data. However, our tool has a unique advantage: you will have full control over your own data, and can store it in your own free database and graph it.

  • How would you implement it?

    • GitHub GraphQL & Restful API(Free) to get events from individuals/repositories/organizationsTiDB Cloud Serverless Tier(Free) for storing grabbed dataGitHub Action(Free) to trigger crawlers

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • GitHub GraphQL & Restful API(Free) Get events for individuals/repositories/organizationshttps://docs.github.com/en/rest?apiVersion=2022-11-28https://docs.github.com/en/graphql"

Idea 3：Personally customized AI robots

  • What problem does this application aim to solve?

    • Save the questions you’ve asked in the past, the way you think about them, and send this background information in advance each time you give a ChatGPT prompt

  • How would you implement it?

    • Store this information with Serverless, so each user can have always-on data storage * Serverless accounts

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • Serverless accounts

Idea 4：self hosted voting system (form system)

  • What problem does this application aim to solve?

    • Many vendors want to have their own voting system instead of using a public service, which has the advantage of being able to customize the domain name and customize the style

  • How would you implement it?

    • Vercel is used to host the pages and the API Server needed for the pagesTiDB Cloud Serverless Tier used for data storage

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 5：fork and transform a short link service

Idea 6：An online whiteboard system based on Serverless database allows multiple users to draw on the same canvas in real time, facilitating remote collaboration among multiple people.

  • What problem does this application aim to solve?

    • A real-time whiteboard system is needed for multi-person remote collaboration, but many systems require their own servers to be built and are cumbersome to deploy.

  • How would you implement it?

    • Use Serverless databases to store canvas data and use WebSocket to transfer canvas content in real time to realize a real-time online whiteboard system.Using services such as Vercel to host the page

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 7：Learn SQL

  • What problem does this application aim to solve?

    • An online learning tool for people who want to learn sql but suffer from no lab environment, not only has a page tutorial, but also an interactive playground and output area, and you can also use MySQL command post tool to log in to MySQL compatible databases for deeper learning. The point is that it’s all free!

  • How would you implement it?

    • TiDB Cloud Serverless, used as a lab environment and to store learning progressVercel hosting page and host api

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • Serverless Documentation for TIDB Cloud

Idea 8:Planning to develop a Twitter bot called @savetotidb where users can save tweets they are interested in to TiDB’s free storage via @savetotidb

  • What problem does this application aim to solve?

    • This application aims to solve the problem that users need to keep track of their tweets by marking and favoriting them, which is not convenient enough and easy to miss. By using @savetotidb, users can directly save the tweets of interest to the database for later query and display.

  • How would you implement it?

    • The implementation of this application requires the development of a Twitter bot @savetotidb that accepts user commands and then saves the relevant tweets to the TiDB database. To make it easier for the user, a web application can be developed where the user can enter commands through the web page and then the bot saves the tweets to the database. In addition, a query and display interface needs to be developed where the user can query the tweets of interest via SQL and display the results on the web page.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • PingCAP TiDB Serverless DatabaseTwitter Developer API

Idea 9: Create a Serverless-based password manager that allows users to store and manage their own passwords. This platform can provide efficient password storage and access services, allowing users to manage their passwords more securely.

  • What problem does this application aim to solve?

    • Password managers typically require large amounts of storage space to store users’ passwords, but using a Serverless database can significantly reduce storage costs and provide efficient data storage and access services, making password managers more efficient and scalable.

  • How would you implement it?

    • Use TiDB Serverless to store users’ password data and use AWS Lambda to handle user requests. Finally, use Amazon API Gateway to manage and deploy the Password Manager service. Also, encryption algorithms can be used to secure users’ passwords.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • TiDB Serverless Database InstanceAWS Lambda ServiceAmazon API Gateway serviceEncryption algorithm libraries (e.g. OpenSSL)Front-end frameworks (e.g. React or Vue.js)Back-end programming languages (e.g. Python or Node.js)Development tools (e.g. VS Code or Sublime Text)

Idea 10: PromptHub

  • What problem does this application aim to solve?

    • Similar to GitHub, in the AI era, there should be a place to exchange/manage Prompt, so it’s called PromptHub, either public or private

  • How would you implement it?

    • TiDB Cloud Serverless Tier to store dataVercel used to build github.com like pages

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • tidb serverless documentationvercel documentation

Idea 11: AI Companion

  • What problem does this application aim to solve?

    • This AI companion can provide a variety of services, including voice chat, music recommendation, weather query, reminders, etc. It can provide an intelligent companion for single guys and girls to help them spend their lonely time.

  • How would you implement it?

    • Modern society is more and more concerned about personal privacy and self-protection. Many people are reluctant to interact with strangers, and the AI companion can be a good companion to accompany users anytime and anywhere to help them relieve the feeling of loneliness and isolation.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • First, we need to use some open source speech recognition and natural language processing technologies, such as Google’s TensorFlow and Natural Language Toolkit. Then, we can use AWS Lambda and TiDB Serverless to store and process user data, and Amazon Lex or Dialogflow to implement AI capabilities so that we can easily provide intelligent services to users. At the same time, we can upload the code of this AI companion to GitHub and deploy it using Vercel, making it easy for users to access and use it. Finally, we need to strengthen the security of user data by using encryption algorithms to protect user privacy and password security.

Idea 12: TiDB data visualization system based on chatGPT

Idea 13 :A system used to be similar to Baidu statistics/google ga

  • What problem does this application aim to solve?

    • Solving the enterprise such peripheral statistical services is not paid attention to the lack of operation and maintenance capacity, but grassroots work is a very important situation

  • How would you implement it?

    • Application of open source, data and computing in the cloud with low labor costs to solve most of the problems

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

Idea 14 :Get your own AI micro-model with one click

  • What problem does this application aim to solve?

    • OpenAI GPT model lacks professional data, which makes it difficult to apply in personal knowledge base, enterprise service, customer service, etc. The building, operation and maintenance of vector databases require more specialized knowledge. If there is a solution to using the GPT interface for natural language queries by simply uploading documents, it looks like it can solve a lot of problems.

  • How would you implement it?

    • To put a vector plugin on TiDB, maybe reference pgvector.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • There are still quite a few teaching resources for ChatGPT + vector database + Embedding API, like the one I just saw: https://builtbyjesse.com/

Idea 15 : Global Sentiment Change Prediction System

  • What problem does this application aim to solve?

    • A sentiment analysis system based on social networks can help people better understand the information on social networks by analyzing the sentiment of different topics through user interactions and comments on social networks. On social networks, many messages are expressed in informal language, and it is often difficult to understand users’ emotions and attitudes accurately. This system can help users better understand the information on social networks.

  • How would you implement it?

    • Firstly, we need to use some open source natural language processing and sentiment analysis technologies, such as NLTK and TextBlob.Then, we can use AWS Lambda and TiDB Serverless to store and process user data, and AWS Comprehend or Sagemaker to implement sentiment analysis features so that we can easily provide intelligent services to users. At the same time, we can upload the code for this system to GitHub and deploy it using Vercel, making it easy for users to access and use it. Finally, we need to strengthen the security of user data by using encryption algorithms to protect user privacy and password security.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • The dataset can include user interactions and comments on social networks, etc. Related technologies include natural language processing techniques, sentiment analysis techniques, AWS Lambda, TiDB Serverless, and machine learning tools such as AWS Comprehend or Sagemaker. Documentation and reference resources for these technologies can be found on their official websites, such as AWS developer documentation and official documentation for NLTK and TextBlob. Also, we can obtain data from publicly available datasets, such as sentiment analysis datasets on Twitter and IMDb movie review datasets.

Idea 16 : A distributed storage application

  • What problem does this application aim to solve?

    • Massive data files are slow to read and write, and consistency is hard to guarantee by storing the file system into a database.

  • How would you implement it?

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • File metadata is a key/value storage engine using rockdb, direct storage in tikv needs to understand tikv

Idea 17 : Healthcare data management: Build a system that manages and analyzes healthcare data, such as patient records or medical imaging. This could help healthcare providers make more informed decisions and improve patient outcomes

  • What problem does this application aim to solve?

    • Aims to solve the problem of managing and storing large volumes of healthcare data. Healthcare data is highly sensitive and critical, and it needs to be managed securely, efficiently, and accurately. By using TiDB Cloud Serverless or TiDB Data API to build a healthcare data management system, healthcare organizations can store and manage their data more effectively, ensuring patient privacy and accuracy while improving the speed and efficiency of healthcare operations. This can help healthcare providers make informed decisions, improve patient outcomes, and reduce costs.

  • How would you implement it?

    • Identify data sources: Identify the healthcare data sources that you want to store and manage, such as electronic health records (EHRs), medical imaging data, patient-generated data, and other sources. Set up TiDB Cloud Serverless or TiDB Data API: Set up a TiDB Cloud Serverless or TiDB Data API instance to store and manage your healthcare data. TiDB is a distributed database that supports horizontal scaling, high availability, and ACID transactions, making it suitable for managing large volumes of healthcare data. Ensure data privacy and security: Healthcare data is highly sensitive and must be managed with strict security and privacy measures. Ensure that your TiDB Cloud Serverless or TiDB Data API instance meets the necessary security and compliance standards, such as HIPAA, GDPR, and other regulations. Data ingestion and processing: Ingest the healthcare data into your TiDB instance using TiDB Data API or other data ingestion tools. You can then process the data to extract insights, perform analytics, and generate reports. Data visualization and analysis: Use data visualization tools such as Tableau, Grafana, or other BI tools to visualize and analyze the healthcare data stored in your TiDB instance. Integrate with other systems: Integrate your TiDB instance with other healthcare systems and applications, such as EHRs, medical imaging systems, and patient monitoring devices, to create a unified healthcare data management system. Ensure data accuracy and consistency: Healthcare data needs to be accurate and consistent, and any changes made to the data must be auditable. TiDB supports ACID transactions, which ensure data consistency and accuracy, making it suitable for managing critical healthcare data.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • We will need the following datasets, resources, and tools: Healthcare data sources: Identify the healthcare data sources that you want to store and manage, such as EHRs, medical imaging data, patient-generated data, and other sources. You may need to access or purchase datasets from healthcare providers or other sources. TiDB documentation: The TiDB documentation provides comprehensive guides, tutorials, and references on how to set up, use, and manage TiDB databases. You can access the documentation at TiDB Introduction | PingCAP Docs. TiDB Cloud: TiDB Cloud is a fully managed database service that provides a cloud-based TiDB instance with automatic scaling, backup, and recovery. You can sign up for TiDB Cloud at https://cloud.pingcap.com/. TiDB Data API: TiDB Data API is a RESTful API that allows you to access and manipulate TiDB databases using HTTP/HTTPS requests. You can learn more about TiDB Data API at https://docs.pingcap.com/tidb/stable/tidb-data-api-overview. Data ingestion tools: You may need to use data ingestion tools such as Apache Kafka, Apache Nifi, or other tools to ingest healthcare data into your TiDB instance. Data visualization and analysis tools: You can use data visualization and analysis tools such as Tableau, Grafana, or other BI tools to visualize and analyze the healthcare data stored in your TiDB instance. Security and compliance resources: Healthcare data is highly sensitive, and you need to ensure that your TiDB instance meets the necessary security and compliance standards, such as HIPAA, GDPR, and other regulations. You can refer to resources such as the HIPAA Security Rule and GDPR guidelines for more information. Developer tools: You will need development tools to build, test, and deploy your healthcare data management system, such as Git, Docker, Kubernetes, or other development tools. You can access relevant documentation, blogs, and tutorials on the TiDB website and other relevant technology websites to help you implement your healthcare data management system using TiDB Cloud Serverless or TiDB Data API.

Idea 18 : Make:ai data collection for eating, living and traveling apps

  • What problem does this application aim to solve?

    • Solve the storage and deployment problems of distributed database

  • How would you implement it?

    • By using TiDB Cloud + data collection for eating and living apps + AI

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • Need to use github+pingcap

Idea 19 : Some resources are shared by a group. For example, the test cluster resources within the group. Each person only needs to use it for a small period of time at a time, and it needs to be exclusive within this time period. In a trusted environment, we don’t need a complex product, just the simplest/fastest interface. Even a SQL DBMS is enough.

  • What problem does this application aim to solve?

    • minimal booking service

  • How would you implement it?

    • TiDB serverless tier + simple UI (simplest form can be a MySQL client)

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 20 : Serverless system based on serverless TiDB

  • What problem does this application aim to solve?

    • There are many free static site hosting services on the market, but few dynamic site hosting services.

  • How would you implement it?

    • Use serverless TiDB and dataAPI to connect directly to DB from front-end for less important systems, such as blog commenting system, simple anonymous forum

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • serverless tidb + data api

Idea 21 : homed (or envd, profiled)

  • What problem does this application aim to solve?

    • A self hosted application that centrally manages various profiles under $HOME to backup/restore to a new environment:.myclirc.vimrc.pip/pip.conf.bashrc.bash_profile.zshrc etc.

  • How would you implement it?

    • Go/Python development CLI that can be used for backup/restoreStore backups with tidb cloud serverless db

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 22 : Chrome New Tab extension based on oh-my-github

  • What problem does this application aim to solve?

    • Chrome’s default New Tab page is plain and irrelevant to work. But with the advent of the oh-my-github repository, everyone can have their own serverless database and store events/data relevant only to them in that database. Therefore, a Chrome extension could be developed that draws cool and useful charts by displaying GitHub data extracted from a person’s serverless database. This way, every time a user opens a new tab, the page is not only cool, but also useful for seeing their GitHub information.

  • How would you implement it?

    • oh-my-githubChrome Extension Marketplace + 1 USDVercel Hosted API Server

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • TiDB Cloud Serverless Tier documentationChrome Extension Development DocumentationReact/Nextjs/Vercel Development Deployment Documentation

Idea 23 : OSSInsight ChatGPT Plugin

  • What problem does this application aim to solve?

    • With the ChatGPT open plugin platform, a ChatGPT OSSI plugin can be made to allow other users in the ChatGPT ecosystem to use the OSSI interface

  • How would you implement it?

    • ChatGPT Plugin MarketplaceOSS Insight API"

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 24 : Hackathon entry/registration/notification/submission website

  • What problem does this application aim to solve?

    • There are very few websites dedicated to Hackathon, and Hackathon requires multiple steps, such as entry/registration/notification/submission, and there is no open source solution to solve this problem.

  • How would you implement it?

    • TiDB Cloud Serverless TierVercel

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • React/NextJS/Vercel development and deployment documentationTiDB Cloud Documentation

Idea 25 : oh-my-repos(inspired by oh-my-github)

  • What problem does this application aim to solve?

    • oh-my-github is a GitHub data crawler with a personal dimension, while repository maintainers are more interested in the code repositories they maintain, so oh-my-github is designed to crawl GitHub data with a code repository dimension, and present repository details/weekly reports, etc.

  • How would you implement it?

    • GitHub GraphQL APITiDB Cloud Serverless TierGitHub ActionDevelop with React or other data visualization/BI/big screen tools

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 26 : Store your own sports data into TiDB Serverless

Idea 27 : A TiDB Serverless based gpt-index solution

  • What problem does this application aim to solve?

    • TiDB Serverless is an OpenAI based intelligent application, limited by token size, based on embedding and gpt-index to do lookup

  • How would you implement it?

    • Implement adapter layer, use tidb serverless as storage layer, so that the front end can be static/edge function, and the back end is openai api + tidb serverless, to achieve lightweight, no operation and maintenance, scale from 0 to ira if the solution

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

Idea 28 : Idea Board

  • What problem does this application aim to solve?

    • Make an open source product idea collection system similar to Snowflake Community to help major open source/closed source products collect user ideas to improve the product

  • How would you implement it?

    • tidb cloud serverless dbvercel to host api server

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 29 : Serverless Stack

  • What problem does this application aim to solve?

    • You can use various free serverless infrastructure/products on the market to make an open source self-hosted PaaS platform, very lightweight, not too heavy, to solve some developers (beginners)who want to do some projects, but no resources do not want to spend money on the scenario.

  • How would you implement it?

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • Docs of all of them

Idea 30 : MySQL Sharding

  • What problem does this application aim to solve?

    • Step1: Make a sharing/learning/blogging site that only talks about MySQL sharding technology, with excellent SEO and first page search;Step2: Put an ad in the top right corner "Here’s an all-in-one MySQL solution without sharding, want to try it?

  • How would you implement it?

    • search for various MySQL sharding documentation; * reorganize, build;Reorganize and build the site;

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 31 : Artificial Intelligence Applications

  • What problem does this application aim to solve?

    • Use data stored in TiDB Cloud Serverless for training machine learning models, or use TiDB Cloud Serverless to store trained models.

  • How would you implement it?

    • Enables users to more easily use machine learning and artificial intelligence capabilities

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

    • None

Idea 32 : TaxyAI/browser-extension

  • What problem does this application aim to solve?

    • “Taxy uses GPT-4 to control your browser and perform repetitive actions on your behalf. Currently, it allows you to define ad-hoc instructions. In the future, it will also support saved and scheduled workflows.”

  • How would you implement it?

    • You can refer to TaxyAI/browser-extension to do a project with similar ideas. Or go to github and look at Taxy’s open source code to make changes.

  • What datasets and resources are needed to implement this application? (Documents of the relevant technologies, blogs, developer tools)

4

If you have any thoughts or discussions you would like to share, feel free to join us on Discord.

:sparkles:Posting an idea to win the TOP 5 idea-maker prize with $100 cash prize!

To get this award, you need to post your idea on this channel according to the format requirements, and the award will be based on the number of emoji received from the reaction to the post.

format requirements：**(The following three components must be included)

  1. What problem does this application aim to solve?
  2. How would you implement it?
  3. What datasets and resources are needed to implement this 4. Application (Documents of the relevant technologies, blogs, developer tools)Who can Win the prize: All participants who have registered for the TiDB Future App Hackathon. And in the period from 6.6 to 7.29, this channel published the idea. How the scores are calculated: Ideas will be ranked based on the number of “ ” emoji reactions they receive. The top five ideas with the most reactions will win the award.
5
6
7

Hackathon Project Idea: Real-time Twitter Sentiment Analysis with TiDB

Project Description:
Create a real-time sentiment analysis system for Twitter using TiDB, an open-source distributed SQL database. The goal of this project is to analyze and visualize the sentiment of tweets related to a particular topic or event in real-time. The system will provide valuable insights into public opinion and sentiment trends on social media.