Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQLite managers for Windows [closed]

Tags:

sqlite

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
like image 552
MC. Avatar asked Aug 24 '11 20:08

MC.


People also ask

Is SQLite still in use?

SQLite is often used as the on-disk file format for desktop applications such as version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs, and so forth.

How do I open SQLite browser in Windows?

To open the database in DB Browser do the following; Click on the 'open database' button in the toolbar. Navigate to where you have stored the database file on your local machine, select it and click open.


2 Answers

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.

like image 112
anthoni daniel Avatar answered Sep 17 '22 19:09

anthoni daniel


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.

like image 43
slapthelownote Avatar answered Sep 20 '22 19:09

slapthelownote