Tip: DB Browser for SQLite

[Erel]

I highly recommend: https://sqlitebrowser.org/
Especially when you need to create or alter complex tables.

 

[ilan]

i Agree ?

SQLite DB Browser (for encrypted files)

for a project I am working on right now, I needed an SQLite reader for encrypted DB files but could not find one so I build my own SQLite browser. I was using DB Browser (SQLite) (which I find really awesome) but it is not working with encrypted SQLite DB files. I tried also DB Browser...

www.b4x.com

 

[Pendrush]

SQLite Expert — the visual tool for SQLite databases

SQLite Expert is a powerful visual tool for creating, administering, and exploring SQLite 3 databases on Windows: visual designers, a Query Builder, a schema diagram, an SQL editor, a rich data grid, and import/export. Free Personal Edition.

www.sqliteexpert.com

personal version is free.

HeidiSQL - MariaDB/MySQL, MSSQL, PostgreSQL, SQLite and Interbase/Firebird made easy

HeidiSQL is a free and powerful client for MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite and Interbase/Firebird

www.heidisql.com

MySQL, MariaDB, MSSQL, SQLite, PostgreSQL - open source.

 

[mcqueccu]

SQLite Expert — the visual tool for SQLite databases

SQLite Expert is a powerful visual tool for creating, administering, and exploring SQLite 3 databases on Windows: visual designers, a Query Builder, a schema diagram, an SQL editor, a rich data grid, and import/export. Free Personal Edition.

www.sqliteexpert.com

personal version is free.

Do you know how to make this support Encrypted Databases?

Currently, I used DBBrowser for SQLite which supports encrypted database out of the box.

 

[mcqueccu]

Create, edit, browse SQLite databases.

Letos

sqlitestudio.pl

 

[Pendrush]

Do you know how to make this support Encrypted Databases?

Professional version only.

Features — SQLite Expert

Everything SQLite Expert can do: visual table and view designers, Query Builder, schema diagram, SQL editor, a rich data grid, import/export, scripting, and more — compared across the Personal and Professional editions.

www.sqliteexpert.com

 

[TILogistic]

Create, edit, browse SQLite databases.

Letos

sqlitestudio.pl

I use it and it is very good:

 

[Sandman]

As we're now dragging in other database tools into this thread, I'd also like to recommend DBeaver. Excellent, and there's a free community version. (I use it every day and like it a lot.)

DBeaver Community | Free Open-Source Database Management Tool

dbeaver.io

 

[ilan]

wow, so many tools. i only now db browser for sqlite and HeidiSQL (suggested to me by @Peter Simpson)
HeidiSQL is really cool but sometimes stuff does not work there and i get errors. but it is very fast.
i do find SQLite Administration recommended by @Pendrush very interesting.

 

[DB_Guy]

I highly recommend: https://sqlitebrowser.org/
Especially when you need to create or alter complex tables.

I use DB Browser for SQLite Version 3.13.99 on Linux; the only issue is File -> Open Database from within a hidden folder; there is no option to view .hidden folder other than to create a symlink. Is there an alternative?