SQLite management software

From LemonWiki共筆
Revision as of 16:09, 9 November 2019 by Planetoid (talk | contribs) (Created page with "Comparison of SQLite management softwares [https://sqlitebrowser.org/ DB Browser for SQLite] v. 3.11.2 on {{Win}}, {{Mac}} & {{Linux}} * Import: (1) database from SQL file (2...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Comparison of SQLite management softwares

DB Browser for SQLite v. 3.11.2 on Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • Import: (1) database from SQL file (2) table from CSV file
  • Export: (1) database to SQL file (2) table(s) as CSV file (3) table(s) as JSON file (3) Export the query result: ok. Steps: execute SQL -> click "Save the results" as CSV file
  • Copyright/License: "bi-licensed under the Mozilla Public License Version 2, as well as the GNU General Public License Version 3 or later"[1]

SQLiteStudio v. 3.2.1 on Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • Import: table from CSV/Text file "custom text files using regular expressions"
  • Export: (1) table as CSV, HTML, XML, PDF, JSON & SQL file (2) Export the query result: CSV, HTML, XML, PDF, JSON & SQL file
  • Copyright/License: GPL v.3

sqlite-manager: Manage all your sqlite databases using this lightweight extension for firefox, thunderbird, seamonkey, komodo etc.

  • Import:
  • Export:
  • Copyright/License:

Valentina Business Intelligence: Valentina Studio Pro, Reports, Database & Server v. 9.6.4 on Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png Wiki

  • Import: table from CSV file
  • Export: (1) table as CSV file (2) Export the query result: CSV, Excel Good.gif, HTML, JSON & SQL file
  • Copyright/License: all rights reserved. "Valentina Studio is licensed but free for commercial and academic purposes."[2] Good.gif

$ Navicat Premium on Win Os windows.png , Mac icon_os_mac.png & Linux Os linux.png

  • Import: (1) database from SQL file (2) table from CSV/Excel file
  • Export: (1) database to SQL file (2) table as CSV/Excel file (3) Export the query result: ok
  • Copyright/License: all rights reserved.

SQLiteSpy on Win Os windows.png

  • Import:
  • Export:
  • Copyright/License: all rights reserved. "Freeware for personal and educational use"

TkSQLite v.0.5.13 (2016-04-29) Icon_exclaim.gif not update for a while

  • Import:
  • Export:
  • Copyright/License: BSD

(left blank intentionally)

title
* Import:
* Export:
* Copyright/License:

Related resources

References