go 持久化用哪个库好? - V2EX
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
The Go Programming Language
http://golang.org/
Go Playground
Go Projects
Revel Web Framework
gramyang

go 持久化用哪个库好?

  •  
  •   gramyang Jun 24, 2019 5430 views
    This topic created in 2501 days ago, the information mentioned may be changed or developed.

    我不喜欢 orm,感觉很僵硬,比较习惯用 mybatis。

    go 有什么选项吗?初步意向是在 sqlx 和 xorm 中选一个。

    15 replies    2019-06-25 18:38:43 +08:00
    zarte
        1
    zarte  
       Jun 24, 2019
    目前用 xorm
    gowk
        2
    gowk  
       Jun 24, 2019 via Android
    难道不是首先考虑 gorm 吗
    其实我也不太喜欢 orm,我觉得 sqlx 就挺好,但是单表的 curd 还得靠手写就比较烦,你可以试试 github.com/ilibs/gosql,在 sqlx 之上又封装了一下,用起来还算比较舒服。另外也可以配合一些 sqlbuilder 库用,比如滴滴的 gendry
    DonaidTrump
        3
    DonaidTrump  
       Jun 24, 2019
    gramyang
        4
    gramyang  
    OP
       Jun 24, 2019
    @gowk gosql 打不开啦。我是首先考虑的 gorm,但是一看这个用法就想起了 hibernate,还是算了吧
    freeznet
        5
    freeznet  
       Jun 24, 2019
    waising
        6
    waising  
       Jun 24, 2019
    推荐 sqlx 个人准备用,不过数据库 null 值问题到时候看怎么处理方便
    gxm44
        7
    gxm44  
       Jun 24, 2019
    目前用 xorm
    gowk
        8
    gowk  
       Jun 24, 2019 via Android
    keepeye
        9
    keepeye  
       Jun 24, 2019
    gorm 的 raw 查询 scan 到自定义的结构体
    jjx
        10
    jjx  
       Jun 24, 2019
    postgresql 推荐 https://github.com/go-pg/pg
    hst001
        11
    hst001  
       Jun 24, 2019
    @jjx #10 这个有什么什么隐藏坑?
    jjx
        12
    jjx  
       Jun 24, 2019
    @hst001

    线上用几年了, 没坑

    唯一碰到的也是自己代码的问题

    没有处理一个未知的 panic (前端在某次更新后传递一个非法的参数导致类型转换失败) 连接没有关闭 连接没有释放 导致连接用尽

    其他就没有遇到过问题
    zjupigeon
        13
    zjupigeon  
       Jun 24, 2019 via iPhone
    sqlboiler
    leopku
        14
    leopku  
       Jun 24, 2019 via iPhone
    喜欢 mybatis 可以看下 xormplus
    fuckshit
        15
    fuckshit  
       Jun 25, 2019
    gorm 了解下
    About     Help     Advertise     Blog     API     FAQ     Solana     1307 Online   Highest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 48ms UTC 17:25 PVG 01:25 LAX 10:25 JFK 13:25
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86