DB Browser for SQLite Icon

DB Browser for SQLite

Create database files compatible with SQLite (was SQLite Database Browser).

DB Browser for SQLiteOverview

DB Browser for SQLite (was SQLite Database Browser) 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, and 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

Note - This project has previous been known as "SQLite Browser" and "Database Browser for SQLite". "DB Browser for SQLite" will hopefully be the name that sticks. :)

NEW

Improvements

  • Several, several fixes in our SQL grammar parser allowing you to edit more databases using the UI tools.
  • Make adding new rows less confusing by showing automatically generated data by default values, triggers or the PK right after the new row is added.
  • Edit Table dialog: Add option for adding a unique constraint to columns.
  • UI improvements: Show line numbers in the SQL log, avoid extreme column widths in the table view showing the results of a SQL statement, add a new dock showing the DB schema
  • Add a database schema pane (can be torn off), so the schema can be viewed while in the Execute SQL tab.
  • Tag name correction in git repo.

Translations

  • Added a Russian translation.
  • We have most of a German translation now.

Bug fixes

  • Fixed a few "crashes when loading database" bugs.
  • Fix import of CSV files containing multi-byte Unicode characters.
  • Complete quoting for parameters of some CMake commands.
  • Some comments were corrected.
  • Compilation warning [-Wformat] fixes.
  • Outdated version number in src/app.plist file.

DB Browser for SQLiteInformation

Version
3.3.1
Date
10.11.14
License
Free
Language
English
File Size
7.9 MB
Category
SubCategory
Operating Systems
Mac OS X
System Requirements
  • OS X 10.6 or later
macSvn Icon
An easy to use svn client for mac, it integrates seamlessly into the Finder.
Trial
DB Browser for SQLite Icon
Create database files compatible with SQLite (was SQLite Database Browser).
Free
Tower Icon
Version control with Git made easy.
Trial
GitHub Icon
Synchronize branches, clone repositories, and more.
Free
Source Icon
System-wide code-snippet manager.
Paid
Schwartz Icon
Template-based graphics code generator.
Trial
ActiveTcl Icon
Complete and ready-to-install Tcl distribution.
Free
Mockups Icon
Collaborative wireframing for app development.
Trial
More