Hi, Im UkJin CHOI from South Korea, Im really passinate for building database engine. Claude code makes it possible. and I found this channel. I worked as DBA and Data engineer for years.
While building many services with PostgreSQL, SQLite, Azure SQL. I found that there are rarely cases in which primary key were update in buisiness logic.
Mutable keys expand undo logs, deepen WAL record and plus complecity.
So Im building a database with immutable tuple key specialized in OLTP database for 2month with Claude code.
Minimum feature were finished like SQLs, Catalog, Transaction (ReadRepeatable, Read Committed), MVCC, WAL, Indexes, Forein Key. Dropping them keeps the engine simpler and faster.
What do you think?
Am I on the proper way? do you think that it will works and company adopt it rather than PostgreSQL if it is mature?
I really appreciate any advice and opinion!
Thank you.