{"id":94312,"date":"2020-05-01T06:25:59","date_gmt":"2020-04-30T22:25:59","guid":{"rendered":"http:\/\/4563.org\/?p=94312"},"modified":"2020-05-01T06:25:59","modified_gmt":"2020-04-30T22:25:59","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ae%a2%e6%88%b7%e7%ab%af%e6%96%b0%e9%80%89%e6%8b%a9%ef%bc%9a-dbkangaroo","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=94312","title":{"rendered":"\u6570\u636e\u5e93\u5ba2\u6237\u7aef\u65b0\u9009\u62e9\uff1a DBKangaroo"},"content":{"rendered":"
\n
\n
\n

\u6570\u636e\u5e93\u5ba2\u6237\u7aef\u65b0\u9009\u62e9\uff1a DBKangaroo <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : andytao <\/span> <\/i> 21<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

DBKangaroo News Timeline<\/h1>\n

<\/p>\n

Kangaroo v0.19.1.200413<\/h2>\n
    \n
  1. Implement copy object name menu on dbtree.<\/li>\n
  2. Implement copy as SQL(Insert\/Update\/Delete) in the datagrid.<\/li>\n
  3. Implement copy as TSV in the datagrid<\/li>\n
  4. Implement copy as CSV in the datagrid<\/li>\n
  5. Implement copy as PHP array in the datagrid<\/li>\n
  6. Implement copy as JSON in the datagrid<\/li>\n
  7. Improve paned widget border style.<\/li>\n
  8. fixed: crashed while stringize the blob column<\/li>\n
  9. fixed: crashed while no primary key<\/li>\n
  10. fixed: crashed while primary key contain character(_)<\/li>\n
  11. fixed: warning message while column with empty value<\/li>\n
  12. fixed: warning message while invalid calling(to_string)<\/li>\n<\/ol>\n

    Kangaroo v0.18.1.200406<\/h2>\n
      \n
    1. encrypt user password to keep user passwords safe.<\/li>\n
    2. Implement insert, clone and delete functionality in the datagrid.<\/li>\n
    3. Implement connection clone functionality in the start view<\/li>\n
    4. Implement dump sql functionality on the dbtree<\/li>\n
    5. Implement table schema editor on the dbtree<\/li>\n
    6. Implement refresh functionality on the dbtree<\/li>\n
    7. Improve workspace tab behavior(auto hide for one)<\/li>\n
    8. fixed: return key behavior invalid on the dbtree<\/li>\n
    9. fixed: crashed while open table with null value<\/li>\n<\/ol>\n

      Kangaroo v0.17.0.200323<\/h2>\n
        \n
      1. Support connection over SSH tunnel (Windows, Linux\/Unix and MacOS)<\/li>\n
      2. Add testing support for connection dialog<\/li>\n
      3. Refactor context menu of datagrid<\/li>\n
      4. Add dump sql (file and text) menu for dbtree<\/li>\n
      5. Implement selection menu of datagrid<\/li>\n
      6. Implement goto cell menu of datagrid<\/li>\n
      7. Fixed: crashed while switching grid to form.<\/li>\n<\/ol>\n

        Kangaroo v0.16.0.200316<\/h2>\n
          \n
        1. Support SSH tunnel(Windows not yet pass test).<\/li>\n
        2. Support input page number to switch page<\/li>\n
        3. Improve: update layout of switch widget on dialog<\/li>\n
        4. Fixed: can’t open link on windows<\/li>\n
        5. Fixed: log file index error<\/li>\n<\/ol>\n

          Kangaroo v0.15.0.200302<\/h2>\n
            \n
          1. Update and share openssl.vapi to keep user data safe.<\/li>\n
          2. Improve language support(kangaroo.pot, zh_Hans and zh_Hant)<\/li>\n
          3. Improve home view’s web resource load performance<\/li>\n
          4. Apply proxy setting for loading web resource<\/li>\n
          5. Linux: change browser view to timeline text view<\/li>\n
          6. Use combobox widget instead entry for log file size<\/li>\n<\/ol>\n

            Kangaroo v0.14.0.200217<\/h2>\n
              \n
            1. SQLite: support to create new database<\/li>\n
            2. refactor database tree context menu<\/li>\n
            3. integrated with openssl to keep user’s password safe<\/li>\n
            4. add pointer cursor for right panel icon<\/li>\n
            5. fixed: update workbench default size while first run<\/li>\n<\/ol>\n

              Kangaroo v0.13.0.200210<\/h2>\n
                \n
              1. apply data grid style setting<\/li>\n
              2. apply sql editor style setting<\/li>\n
              3. windows 32bit version support<\/li>\n
              4. implement SSH tunnel support(not yet integrate)<\/li>\n
              5. minor change for connection dialog UI<\/li>\n
              6. fixed: tool’s icon incorrect on release version<\/li>\n<\/ol>\n

                Kangaroo v0.12.1.200120<\/h2>\n
                  \n
                1. add setting dialog<\/li>\n
                2. add dark theme support<\/li>\n
                3. bind connection dialog with new setting model<\/li>\n
                4. update start view with new setting model<\/li>\n<\/ol>\n

                  Kangaroo v0.11.1.200113<\/h2>\n
                    \n
                  1. redesign connection dialog to support SSH and SSL<\/li>\n
                  2. add donate icon on home page(Paypal\/Wechat\/Alipay)<\/li>\n
                  3. redesign configuration model and file(init –> json)<\/li>\n
                  4. Use symbolic icons in the Header Bar(#25)<\/li>\n
                  5. fixed: edit data in grid will update all rows<\/li>\n<\/ol>\n

                    Kangaroo v0.11.0.200106<\/h2>\n
                      \n
                    1. add app home page<\/li>\n
                    2. reimplement DSV format engine<\/li>\n
                    3. improve DSV compatible with other tools.<\/li>\n
                    4. improve DSV option UI layout<\/li>\n
                    5. improve date column editting support<\/li>\n
                    6. fixed: generate sql statement incorrect.<\/li>\n
                    7. fixed: crash while importing data<\/li>\n
                    8. fixed: can’t save data while editting on data grid<\/li>\n
                    9. fixed: warning message about db tree<\/li>\n<\/ol>\n

                      Kangaroo v0.10.0.191223<\/h2>\n
                        \n
                      1. add export assistant UI<\/li>\n
                      2. batch export table to file.<\/li>\n
                      3. support data formats(DSV\/JSON\/XML\/HTML\/Markdown\/SQL)<\/li>\n
                      4. support title for column(rename)<\/li>\n<\/ol>\n

                        Kangaroo v0.9.5.191216<\/h2>\n
                          \n
                        1. import data from DSV format<\/li>\n
                        2. import data from JSON format<\/li>\n
                        3. import data from XML format<\/li>\n
                        4. Rewritten export data as XML format with libxml2;<\/li>\n
                        5. add export modules assistant UI<\/li>\n
                        6. implement export format and table selection page<\/li>\n<\/ol>\n

                          Kangaroo v0.9.4.191209<\/h2>\n
                            \n
                          1. add import summary page<\/li>\n
                          2. add five kinds of import mode<\/li>\n
                          3. import csv format data to table<\/li>\n
                          4. fixed logo can’t show on linux and macos platform<\/li>\n<\/ol>\n

                            Kangaroo v0.9.3.191202<\/h2>\n
                              \n
                            1. implement column mapping function<\/li>\n<\/ol>\n

                              Kangaroo v0.9.2.191125<\/h2>\n
                                \n
                              1. Import data from file(dsv\/xml\/json) #19\n
                                  \n
                                • implement the import UI(format, encoding and preview)<\/li>\n
                                • implement the import UI(DSV format option)<\/li>\n
                                • implement the import UI(data preview)<\/li>\n
                                • implement the import UI(column mapping)<\/li>\n
                                • implement the import UI(process progress)<\/li>\n
                                • implement DSV format parse and preview<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

                                  Kangaroo v0.9.1.191118<\/h2>\n
                                    \n
                                  1. Export data to file(dsv(csv\/tsv\/…)\/xml\/json\/sql\/md\/html) #18\n
                                      \n
                                    • Export data to DSV format(CSV\/TSV\/…)<\/li>\n
                                    • Export data to JSON format<\/li>\n
                                    • Export data to XML format<\/li>\n
                                    • Export data to HTML format<\/li>\n
                                    • Export data to SQL format(INSERT)<\/li>\n
                                    • Export data to Markdown format<\/li>\n<\/ul>\n<\/li>\n
                                    • Improve file filter of save dialog<\/li>\n<\/ol>\n

                                      Kangaroo v0.9.0.191111<\/h2>\n
                                        \n
                                      1. Edit table schema and save to database #5<\/li>\n
                                      2. Export data to JSON and DSV format<\/li>\n<\/ol>\n

                                        Kangaroo v0.8.5.191104<\/h2>\n
                                          \n
                                        1. Edit table schema and save to database(SQLite and PostgreSQL preview) #5<\/li>\n
                                        2. Add export data formats UI and interfaces<\/li>\n
                                        3. Update tab’s title while save the new table<\/li>\n<\/ol>\n

                                          Kangaroo v0.8.4.191028<\/h2>\n
                                            \n
                                          1. Rearrange db tree and UI #17<\/li>\n
                                          2. Add refresh menu on db tree<\/li>\n
                                          3. Implement multiple databases support<\/li>\n
                                          4. Edit table schema and save to database(MySQL Preview) #5<\/li>\n<\/ol>\n

                                            Kangaroo v0.8.3.191021<\/h2>\n
                                              \n
                                            1. \u65b0\u5efa\u8fde\u63a5\u65f6\u51fa\u73b0\u63d2\u4ef6\u672a\u52a0\u8f7d\u9519\u8bef #12
                                              Load plugin failed while create new connection #12<\/li>\n
                                            2. Add MacOS compilation support #13<\/li>\n
                                            3. refactor database model to improve interoperability<\/li>\n<\/ol>\n

                                              Kangaroo v0.8.2.191014<\/h2>\n
                                                \n
                                              1. improve: field selection dialog support to select fields by value(#9)<\/li>\n
                                              2. improve: schema designer support to navigate with Tab key(#3)<\/li>\n
                                              3. fixed: fields expression dialog reload value failed(#10)<\/li>\n
                                              4. fixed: missing windows shortcut icon(start menu and desktop) (#7)<\/li>\n
                                              5. fixed: missing syntax highlighting support(#8)<\/li>\n
                                              6. fixed: load data in form view failed(#11)<\/li>\n<\/ol>\n

                                                Kangaroo v0.8.1.190930<\/h2>\n
                                                  \n
                                                1. improve: generate exact correct editing sql<\/li>\n
                                                2. refactor: add source code editor module<\/li>\n
                                                3. improve SQLite schema sql builder<\/li>\n
                                                4. fixed: text editor and code editor can’t show blank line<\/li>\n
                                                5. fixed: get string failed while create data row(console)<\/li>\n
                                                6. fixed: console critical message while editing schema<\/li>\n<\/ol>\n

                                                  Kangaroo v0.8.0.190923<\/h2>\n
                                                    \n
                                                  1. implement the builder of PostgreSQL(11.0)<\/li>\n
                                                  2. save table schema to database(create only)<\/li>\n
                                                  3. update build script: hide app console window<\/li>\n
                                                  4. update windows installer: add MySQL and PostgreSQL client library<\/li>\n
                                                  5. update the links on the about window<\/li>\n
                                                  6. improve single line edit control(auto focus)<\/li>\n
                                                  7. update gui cursor while busy<\/li>\n<\/ol>\n

                                                    Kangaroo v0.7.2.190916<\/h2>\n
                                                      \n
                                                    1. Implement loader of PostgreSQL 11(full version)<\/li>\n
                                                    2. Improve designer form of PostgreSQL 11<\/li>\n
                                                    3. refactor content of Kangaroo repo<\/li>\n
                                                    4. create new site: dbkangaroo.github.io<\/li>\n
                                                    5. add windows installer script<\/li>\n<\/ol><\/div>\n
                                                      \u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (10<\/span>) <\/div>\n
                                                      <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
                                                        \n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : andytao <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u7a33\u5b9a\u7248 0.20.1 \u5373\u5c06\u63a8\u51fa\u3002\u3002\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : MinQ <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u6709\u8ddf DBeaver \u7684\u5bf9\u6bd4\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : andytao <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        @MinQ \u6682\u672a\u505a\u7ec6\u81f4\u7684\u7279\u6027\u5bf9\u6bd4\uff0c\u6b22\u8fce\u5c1d\u8bd5 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : smallgoogle <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u5176\u5b9e\u6211\u6bd4\u8f83\u5173\u6ce8\u754c\u9762\u6709\u591a\u597d\u770b\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : kukat <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u514d\u8d39\u4f46\u4e0d\u5f00\u6e90\u7684\u4ea7\u54c1\u4e0d\u592a\u6562\u7528 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : jry <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u652f\u6301\uff0c\u5efa\u8bae\u5b66\u4e60\u4e0b TablePlus \u7684\u7406\u5ff5\uff0c\u4fee\u6539\u53ea\u662f\u6682\u5b58\uff0cCTRL+S \u4fdd\u5b58\u65f6\u7edf\u4e00\u518d\u6267\u884c Sql \u592a\u597d\u7528\u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : justin2018 <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u989c\u503c\u4e0d\u9ad8 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u8cc7\u6df1\u5927\u4f6c : jin7 <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u770b\u754c\u9762\u50cf gtk \u679c\u7136\u662f <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : andytao <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        @jry \u8c22\u8c22\u60a8\u63d0\u51fa\u7684\u5efa\u8bae\uff0c\u6211\u7814\u7a76\u4e00\u4e0b\u54c8 <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n
                                                        \n
                                                        \n
                                                        \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : andytao <\/span> <\/div>\n
                                                        <\/i> <\/span> <\/div>\n<\/p><\/div>\n
                                                        \u888b\u9f20\u6570\u636e\u5e93\u7ba1\u7406\u5de5\u5177\uff08 DBKangaroo \uff09 0.20.1 \u5df2\u53d1\u5e03\uff0c\u66f4\u597d\u7528\u7684\u8868\u8bbe\u8ba1\u5668\u5df2\u4e0a\u7ebf\uff1b <\/div>\n<\/p><\/div>\n<\/li>\n
                                                      • \n","protected":false},"excerpt":{"rendered":"

                                                        \u6570\u636e\u5e93\u5ba2\u6237\u7aef\u65b0\u9009\u62e9\uff1a DBKang…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94312"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94312"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94312\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94312"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}