sskycn
V2EX  ›  数据库

netbadb 应该做 mysql 兼容还是做 postgresql 兼容

  •  
  •   sskycn · 3h 59m ago · 483 views

    项目地址: https://github.com/sskycn/netbadb

    netbadb 起源: https://www.v2ex.com/t/1233772?p=1#reply45

    主要目标不是实现另一个数据库,而是做一个强类型数据库,做 mysql/postgresql 兼容能让用户快速用来起,但选哪个是个问题。

    大家怎么看?

    Supplement 1  ·  44 mins ago

    AI真是强大,不到一个星期,就已经实现到可以测试的阶段了。单位为 ns/op:

    scenario                         min       median        p95
    point_seq                    2,497,416   2,761,208   3,069,584
    point_index                     19,792      20,584      21,750
    duplicate_indexed_equality   1,841,041   1,978,084   2,178,167
    selective_secondary_index       22,209      22,375      23,166
    is_null_low_rate                82,333      82,875      84,209
    is_null_high_rate            2,309,416   2,522,166   2,538,292
    range_one_percent            2,358,917   2,442,708   2,694,208
    range_fifty_percent          1,847,458   2,448,667   2,983,500
    order_by_limit               2,773,209   3,153,958   3,997,042
    group_by_low_cardinality     2,636,667   2,894,208   3,389,084
    group_by_higher_cardinality  2,398,458   2,894,375   3,307,750
    join_unique_small            1,465,667   1,611,375   1,742,541
    join_duplicate_small         1,395,042   1,421,458   1,465,792
    join_unique_large            8,062,916   8,104,958   8,196,458
    join_duplicate_large         8,083,333   8,184,708   8,198,291
    insert_0_indexes               175,990     180,193     183,379
    insert_1_indexes             1,059,991   1,303,545   1,320,131
    insert_2_indexes             1,792,027   1,823,592   1,836,044
    update_indexed_key           2,220,875   4,025,604   5,057,542
    inspect_compile_plan             8,708       8,833       9,084
    
    4 replies    2026-08-16 14:37:45 +08:00
    WayneCmd
        1
    WayneCmd  
       3h 11m ago
    MySQL ,不管是 Ranking 还是中间件的市场 都要更好一点。
    yangg
        2
    yangg  
       2h 58m ago via Android
    现在开源 ai 都 pg 吧
    willygeek007
        3
    willygeek007  
       1h 28m ago via iPhone
    国产 ob 选择同时兼容 mysql/oracle
    loading
        4
    loading  
       23 mins ago
    建议同时兼容。

    个人用 ai 写的数据库,除了烧 token 外,感觉没啥用。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   2812 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 25ms · UTC 07:01 · PVG 15:01 · LAX 00:01 · JFK 03:01
    ♥ Do have faith in what you're doing.