Refer to H2 Database to Implement Connection to Multiple Modes and Support Various Database Standards

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 参考H2数据库实现连接多种mode,支持多种数据库标准

| username: vincentLi

The H2 database is a commonly used test database that can be compatible with different database syntax by specifying MODE in the connection string. I feel that this feature is related to whether TiDB can benefit from the wave of domestic adoption. After all, most large-scale enterprises in China probably wouldn’t use MySQL as their core database, and if they are already using MySQL, there wouldn’t be a significant effort to replace MySQL with TiDB.

| username: xiaoqiao | Original post link

:+1: The road is probably quite long.

| username: DBAER | Original post link

It’s laborious and doesn’t seem to achieve the desired effect. Replacements usually have their own business requirements. Syntax sugar and the like can be implemented in the program.

| username: WalterWj | Original post link

This is an analysis of market demand and costs. From your company’s strategy, it seems that this approach is not being considered at the moment. Additionally, some companies using MySQL are not considered innovative. Moreover, MySQL itself requires sharding and partitioning for large data volumes, making maintenance relatively more difficult.

| username: 有猫万事足 | Original post link

Despite H2 having such good features, I haven’t seen any domestic database developed from H2.

| username: ShawnYan | Original post link

Learned something new, it’s my first time hearing about H2.

No need to say “temporarily,” being comprehensive and all-encompassing really isn’t that great.

| username: TIDB-Learner | Original post link

H2, this is the first time I’ve heard of it.

| username: 有猫万事足 | Original post link

The default database for Metabase is H2.

When you download and start it, it uses the H2 database by default. Switching from H2 to MySQL/TiDB midway and exporting the data was a huge hassle. Personally, I’ve had enough of H2. Regardless of its performance, at least the ease of exporting data is not very good.