纯 json 文件导入数据库 - V2EX
V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
请不要在回答技术问题时复制粘贴 AI 生成的内容
teek

纯 json 文件导入数据库

  •  
  •   teek Oct 10, 2017 4648 views
    This topic created in 3135 days ago, the information mentioned may be changed or developed.
    RT
    发现一般数据库工具都不提供,有可能是 json 数据不像 csv 那样简单?
    倒是可以这样来读取大的 json 文件
    http://www.nurkiewicz.com/2017/09/streaming-large-json-file-with-jackson.html
    8 replies    2017-12-23 01:11:48 +08:00
    awesomes
        1
    awesomes  
       Oct 10, 2017
    自己写个工具多简单的事
    Thoxvi
        2
    Thoxvi  
       Oct 10, 2017 via Android
    mongodb?
    xmh51
        3
    xmh51  
       Oct 10, 2017
    navcat 就有啊
    F281M6Dh8DXpD1g2
        4
    F281M6Dh8DXpD1g2  
       Oct 10, 2017
    pyspark 几行代码的事
    codelover2016
        5
    codelover2016  
       Oct 10, 2017
    直接用 JS 生成 SQL 的只有我一个?
    noe132
        6
    noe132  
       Oct 10, 2017 via Android
    json 可以嵌套。。。
    大部分 sql 表都是二维的
    cstj0505
        7
    cstj0505  
       Oct 10, 2017
    postresql 可以。直接支持 json 类型,好用的飞起
    ole3021
        8
    ole3021  
       Dec 23, 2017
    实现了一个基于 mongoose 的 Mongodb 的,目前自己再用一切 OK

    主要特点:
    1. 支持外键依赖,自动计算依赖关系(单向的),并计算插入步骤
    2. 顺序插入,保证顺序

    https://github.com/mohjs/moh-mongo-injector

    如果你不用 mongo 的话 可以参考实现一个。
    About     Help     Advertise     Blog     API     FAQ     Solana     3282 Online   Highest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 47ms UTC 13:30 PVG 21:30 LAX 06:30 JFK 09:30
    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