Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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
Sign in to Comment

Related questions

Android Studio, how to retrieve data from Sqlite database and display it into textview?
Testing ASP Net Core Application with SQLite throws unknown function: newid()
Android Room. Which method of insertion will be faster?
Updating a column for a list of items in Room
How to fix NPM install SQLite build fail?
How can I access files (like a SQLite database) outside of my app's folder in a UWP application?
With TypeORM, `SQLITE_CONSTRAINT: FOREIGN KEY constraint failed` when adding a column to an entity
Is it possible to have separate SQLite databases within the same Django project?
Is SQLite thread safe under this situation?
Can you format 24-hour time string into 12-hour time string with AM/PM?
"ambiguous column name" in SQLite INNER JOIN
How can I write my own aggregate functions with sqlalchemy?
SQLite behaviour on INSERT on iPhone
Any considerations before jumping into SQLite?
Insert into a table if a condition is met with sqlite3
Case insensitive group_by in Rails?
SQLite: sqlite3.dll vs System.Data.SQLite.dll?
Rails schema.rb different for different databases
Is it OK to use static "database helper" class?
How can I fetch the data of specific month from SQLite database

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!