Skip to content

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

License

Unknown, Unknown licenses found

Licenses found

Unknown
LICENSE
Unknown
LICENSE-PLUGINS
Notifications You must be signed in to change notification settings

absorbguo/sqlitebrowser

Repository files navigation

SQLite Database Browser

This is a fork from the SF project which seems to be stagnant.

Screenshot

SQLiteBrowser Screenshot

Old Project

What it is

(taken from the website linked to above; it's still true - now even more)

SQLite Database Browser is a freeware, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands.

What's been done since then

  • Qt3Support was removed
  • Recent files menu added
  • Improved UI, making it more modern, replacing some dialogs etc.
  • Syntax highlighting for SQL code
  • Cleaned up the code, reducing the SLOC quite a bit
  • Added basic support for triggers and views
  • Added pragma editing
  • Added BLOB support
  • Added a new filter row for searching
  • Improved performance when opening large tables
  • Extended the SQL tab
  • Added SQLite extension support
  • Fixed a ton of bugs
  • Probably more

All in all a fair amount of the code has been rewritten in order to regain maintainability. Based on this quite a few bugs could be fixed and some features added.

What's still to do

Windows binaries

Windows binaries can be downloaded from here:

https://github.com/rp-/sqlitebrowser/releases

MacOS X

SQLite Database Browser works pretty well on MacOS X.

  • OSX 10.7 (Lion) and 10.8 (Mountain Lion) are tested and known to work

Building on OSX is simple, but depends on SQLite and Qt to be installed using Homebrew first:

$ brew install sqlite --with-functions
$ brew install qt --with-qt3support

Then it's just a matter of:

$ git clone https://github.com/rp-/sqlitebrowser.git
$ cd sqlitebrowser
$ qmake
$ make
$ mv src/sqlitebrowser.app /Applications/

An icon for "sqlitebrowser" should now be in your main OSX Applications list, ready to launch.

About

Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

Resources

License

Unknown, Unknown licenses found

Licenses found

Unknown
LICENSE
Unknown
LICENSE-PLUGINS

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C++ 94.9%
  • C 3.2%
  • CMake 0.6%
  • Yacc 0.5%
  • QMake 0.3%
  • Batchfile 0.2%
  • Other 0.3%