panthema / tags / qtsqlview

Weblog Articles Tagged with '#qtsqlview'

Weblog Articles

QtSqlView Screenshot 1

QtSqlView 0.8.0 Released

Posted on 2006-10-10 12:56 by Timo Bingmann at Permlink with 0 Comments. Tags: #qtsqlview #c++

Released the first version 0.8.0 of QtSqlView under the GPL.

QtSqlView is a simple and easy to use SQL database browser written in Qt 4.x using the excellent QtSql components. Using QtSql drivers it can natively connect to MySQL, PostgreSQL and SQLite databases. Furthermore other database systems may be accessed using their ODBC drivers. QtSqlView is released under the GNU General Public License: source code and win32 binary may be downloaded here.

This short program was initially written for a set of windows users, who need to access and edit a PostgreSQL database. All this is possible with M$ Access and ODBC, but the configuration of PostgreSQL's ODBC driver and the ODBC DSN is far too complicated for the average database editor. Thus problem-free access of open-source databases was top priority for QtSqlView.

QtSqlView boasts the following features:

  • Problem-free connecting to MySQL, PostgreSQL and SQLite databases on Windows.
  • Add, delete and modify a list of database connections.
  • Browse, edit, save and revert SQL tables, system tables and views of registered connections
  • Copy selected cells as tab-separated text to the clipboard.
  • View table schema including primary key.
  • Execute custom SQL queries on the database connect and view results.
  • SQL syntax highlighting in query editor.
  • Uses Qt4's greatly improved SQL components.

You may download the source code for Linux/OSX or a setup package for Windows.

More screenshots are available as well.