Copilot DB is an educational DBMS, never use in production 😄
I saw Building a C compiler with a team of parallel Claudes from antropic's blog. So I want to see if I can build and few-shot a plan.md with copilot.
So the workflow of Copilot DB is like:
- Generate a
plan.mdby discussing ChatGPT(I acutally use my ChatGPT Wrapper). - Iteratively Improve `plan.md, either manually or tell ChatGPT to fix it(I use mixed of two).
- Open copilot cli, tell copilot
Implement the whole project(@plan.md)
However, I cheat on it by telling copilot Its client tui is so ugly.Modify cli client to have fancy DuckDB like tui. after the first shot.
- I generate a plan to implement a more complete DBMS with MVCC/fuzzy checkpoint/common SQL, and it fail.
- I suspect it fail because fuzzy checkpoint is hard(MVCC seems fine), modify the plan to just use 2PL for transaction(abort later transaction on conflict), and it fail.
- Frustrated, I remove more feature from plan.md, don't use anything fancy, only support
CREATE/INSERT/SELECT/DELETE
