跪拜 Guibai
← Back to the summary

AI Codes a BI Dashboard and Two WeChat Mini-Programs in One Month

I used AI to write code and made three small things.

In the past, I couldn't have done them independently.

These days I built a data analysis BI system and two WeChat mini-programs: Mini Course Schedule (already online) and Workstation Idle (still under ICP filing).

SuperBI

This is a BI data analysis tool, deployed based on Java. I plan to release a standalone version later, because source code deployment still has a threshold; not everyone knows the java -jar command.

Login and user permissions → data source connection → metadata reading → SQL query → save analysis and visualization configuration → dashboard.

Currently it only supports MySQL, SQLite, Oracle, SQL Server as analysis data sources, read-only SELECT, table/bar/line charts and numeric display, and ordered dashboard cards.

Image Image Image Image Image Image Image Image Image Image

The app is implemented based on Codex.

Considering the low-barrier positioning, it hasn't been uploaded to GitHub yet.

Gitee address: https://gitee.com/ddxygq/SuperBI

Mini Course Schedule

This one is already online, because I heard that the first mini-program per person gets fast ICP filing.

It uses Tencent Cloud's native server and database. I downloaded WeChat DevTools, and it wrote it by itself. It hasn't cost a penny so far, but there is a 30-yuan WeChat certification fee. I'm hesitating.

I fully suspect WeChat wants to earn our 30-yuan certification fee, because when I created a new project and entered the description "course schedule," it just wrote the whole thing for me. I was stunned.

Workstation Idle

This is a mini-program for health management during work breaks (slacking off).

I originally wanted to name it "Slacking Master" (摸鱼达人), but that name was taken. I tried many names and none worked, so I finally adopted the name provided by Doubao: Workstation Idle (工位闲).

The code has been submitted and passed WeChat review. It is still under ICP filing, and it should go live automatically after filing completes.

WeChat reminds that if not certified within a month, it can't be searched. Isn't that just to earn everyone's 30-yuan certification fee? After all, a large number of mini-programs are being churned out quickly every day now. I just wanted to say.