• Registered: 2015-12-04
  • Posts: 13

Topic: Free Tool for Sqlite Databases

Dear All
I found a free software called DB Browser for Sqlite databases. You should give it a try. It helps me to import my CSV files and more
As the web site says
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

Controls and wizards are available for users to:

    Create and compact database files
    Create, define, modify and delete tables
    Create, define and delete indexes
    Browse, edit, add and delete records
    Search records
    Import and export records as text
    Import and export tables from/to CSV files
    Import and export databases from/to SQL dump files
    Issue SQL queries and inspect the results
    Examine a log of all SQL commands issued by the application

To download it Pls go to the web site

http://sqlitebrowser.org/

Best Regards for ALL

  • Registered: 2015-02-24
  • Posts: 446

Re: Free Tool for Sqlite Databases

Thanks for the info.


I personally use http://www.navicat.com/products/navicat-premium but only because I have it for work smile


There is also http://sqlitestudio.pl/?act=gallery that works pretty well.


Cheers


Mathias

I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor

3 Reply by tcoton (edited by tcoton 2015-12-23 09:58:56)

  • Registered: 2014-06-25
  • Posts: 865

Re: Free Tool for Sqlite Databases

A long time ago I was using the "universal" tool Aqua Studio http://www.aquafold.com/aquadatastudio_features.html It is not free anymore though!!

  • jrga
  • Member
  • Offline
  • From: Brasil
  • Registered: 2015-10-26
  • Posts: 127

Re: Free Tool for Sqlite Databases

Eu uso o sqlite expert personal, que é um freeware. Faz tudo no sqlite. Very, very, very good!

Roberto Alencar
  • Registered: 2018-10-02
  • Posts: 5

Re: Free Tool for Sqlite Databases

smoustafa wrote:

Dear All
I found a free software called DB Browser for Sqlite databases. You should give it a try. It helps me to import my CSV files and more
As the web site says
DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

Controls and wizards are available for users to:

    Create and compact database files
    Create, define, modify and delete tables
    Create, define and delete indexes
    Browse, edit, add and delete records
    Search records
    Import and export records as text
    Import and export tables from/to CSV files
    Import and export databases from/to SQL dump files
    Issue SQL queries and inspect the results
    Examine a log of all SQL commands issued by the application

To download it Pls go to the web site

http://sqlitebrowser.org/

Best Regards for ALL

Tools that I use for SQLite:

  • Valentina Studio (the best for me, there is a free version)

  • SQLite Expert Profressional (there is also a free version)(for windows only)

  • Navicat Premium (it let you convert from sqlite to mysql or sql server)(for windows, mac, linux)

  • SQLite Studio (free)(multiplatform)

rodmontgt's Website