What SQLite GUI tools are available for Windows to edit/manage SQLite databases?
The goals are:
- free
- user-friendly
- easy to work with SQLite databases for
create
,delete
, filling tables with data - import 开发者_JS百科(xls, csv, mdb, ...) and export
I have tried already tools mentioned here, and then came across Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview, which i think is far superior to others GUI tools. It is FREE. It works on three OS: MAC, WIN, LIN. It works as with mySQL/mariaDB, so with PostgreSQL, SQLite and Valentina DB. I think it deserves to be at the top of the list.
Personally, I like the sqlite manager firefox plugin (https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/). However, I have to say sqlite really lends itself to command line work very well if you are prepared to get over the "no gui" hurdle.
Here is a list of tools http://www.sqlite.org/cvstrac/wiki?p=ManagementTools I have tried many of them and finally I choose
SQLite2009 Pro Enterprise Manager
This is also good alternative SQLite Manager - Add-on for Firefox
I do use the Navicat Database Admin Tools because it works well on Mac OS as well as on Windows, supports different DB servers, and in general well stable. Moreover, you can get absolutely free community edition build - although it has some limitations, in general it covers basic needs.
More information you will find here http://www.navicat.com/
精彩评论