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 (xls, csv, mdb, ...) and export
- Download SQLiteManager for free. SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5.
- SQLiteStudio is a SQLite database manager with the following features:. Portable - no need to install or uninstall. Just download, unpack and run. Intuitive interface,; Powerful, yet light and fast,; All SQLite3 and SQLite2 features wrapped within simple GUI,; Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X and should work on other Unixes (not tested yet).
- Download SQLiteManager. A practical, reliable and effective database manager specially intended for SQLite databases that enables you to execute SQL statements and create tables and triggers.
Feb 02, 2015 DB Browser for SQLite is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface. Note - This project has previous been known as 'SQLite Browser' and 'Database Browser for SQLite'. DB Browser for SQLite is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface. Note - This project has previous been known as 'SQLite Browser' and 'Database Browser for SQLite'.
closed as not constructive by Ken White, gnat, gabrielhilal, Pragnani, Yan SklyarenkoApr 3 '13 at 8:48
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
4 Answers
Sqlite Manager Firefox
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.
Sqlite Browser Download
slapthelownoteslapthelownoteHere is a list of toolshttp://www.sqlite.org/cvstrac/wiki?p=ManagementToolsI have tried many of them and finally I choose
SQLite2009 Pro Enterprise Manager
This is also good alternativeSQLite 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/
Cyril DebaCyril Deba