Database Workbench Explained

Database Workbench
Author:Upscene Productions
Latest Release Version:6.5.2[1]
Genre:Database design, management, development
License:Trialware

Database Workbench is a software application for development and administration of multiple relational databases using SQL, with interoperationality between different database systems, developed by Upscene Productions.

Because Databases Workbench supports multiple database systems, it can provide software developers with the same interface and development environment for these otherwise different database systems and also includes cross database tools.[2] [3]

Development

Database Workbench started out as a developer tool specifically for InterBase, "InterBase Workbench", initially modeled after the SQL Navigator tool for Oracle Database by Quest Software.[4] [5] During its early years, InterBase became open-source for a short while, and soon after Firebird was created as a fork from the InterBase code base. The main developer of Database Workbench, Martijn Tonies,[6] was closely involved in the early development of Firebird, has been a committee member of the Firebird Foundation and continues to be a Foundation member and sponsor.[7]

Database Workbench continued to support both database systems, initially through a separate "Firebird Workbench" release.[8] Not long after, the program became interoperational between the different database systems and this initial support for multiple database systems led to the renaming of the product to its current title "Database Workbench" in 2003. It also opened the path to the inclusion of support for more database systems: support for Microsoft SQL Server and MySQL was added in 2003; in 2005, support for Oracle Database and NexusDB was added and SQL Anywhere support followed in 2008. Early 2010, a full Unicode version of Database Workbench was released and version 5 of Database Workbench was released in August 2014.[9] In December 2021, Database Workbench 6 was released with a revamped user interface including a more consistent look and feel and the multi-threaded loading of database metadata. This version introduced the Enterprise Edition with its TeamServer component. In 2024, SQLite support was added. A free version with limited functionality,[10] Data Workbench Lite, based on Data Workbench 4 is also available.[11] [12] [13]

Supported databases and environments

Database Workbench supports the following relational databases: Oracle Database, Microsoft SQL Server, SQL Anywhere, Firebird, NexusDB, InterBase, MySQL, MariaDB, SQLite and PostgreSQL[14] [15] [16] Version 6 of Database Workbench is a 64-bit application for Windows platforms, previous versions were 32-bit.[17] Under Linux, FreeBSD or Mac OS X Database Workbench can operate using Wine.[18]

Features

Database Workbench can be used to view, create and edit tables, indexes, stored procedures and other database meta data objects. It also supports:[19]

It includes several productivity features:

History

External links

Notes and References

  1. Web site: Database Workbench 6.5.2 released . Upscene Productions . July 15, 2024 . 2024-08-01.
  2. Database Workbench, productiviteits tool voor database ontwikkelaars en netwerkbeheerders. Dutch. Blaise Pascal Magazine. 93. DelphiGG. Miguel van de Laar . Sep 12, 2010. 2014-09-19.
  3. Book: Borrie , Helen . 2004. The Firebird Book: A Reference for Database Developers. registration. Database Workbench.. APress. Appendix V: Administration Tools. 937. 1-59059-279-4. 2014-09-19.
  4. Book: Mastering Delphi 7. SYBEX Inc.. Marco Cantù. 2003. 078214201X. Introducing InterBase. 2014-09-23.
  5. Book: Java ist auch eine Insel (2. Aufl.). Galileo Press GmbH. Christian Ullenboom. German. 2003. 978-3-8362-2873-2. 20.5.1 Datenbank Interbase und Firebird. 2014-09-23.
  6. Web site: About Us. Upscene Productions. 2014-09-23.
  7. Web site: Mozilla Renames Browser, Revs New Releases. Matthew Hicks. eWeek. Sep 2, 2004. 2014-09-23.
  8. Web site: FirebirdSQL Project Update. IBPhoenix. Sean Leyne. 2014-09-23.
  9. Web site: Database Workbench 5.0 now available. Firebird News. Sep 3, 2014. Martijn Tonies. 2014-09-19.
  10. Web site: Database Workbench available editions and feature matrix. Upscene Productions. 2016-01-06.
  11. Web site: Database Workbench Lite for Firebird (Review). Softpedia. Feb 18, 2014. Cristina Jitaru. 2014-09-19. 2015-05-22. https://web.archive.org/web/20150522211257/http://www.softpedia.com/get/Internet/Servers/Database-Utils/Database-Workbench-Lite-for-Firebird.shtml. dead.
  12. Web site: Database Workbench Lite for Firebird. Dobreprogramy. Aug 19, 2015. Polish, Czech. 2016-01-06.
  13. Web site: Database Workbench Lite for Firebird. Software.informer. Jun 26, 2015. Cristina Jitaru. 2016-01-06.
  14. Web site: Database Workbench Pro (Editorial Review). Software Informer. Roberto Jimenez. 2014-09-19.
  15. Web site: Database Workbench 4.3.0 Pro mit Debugger für MySQL erhältlich. 13 August 2012. PHPmagazin. Astrid Wagner. German. 2014-09-23.
  16. Web site: Database Workbench 4.3.0 mit hilfreichen neuen Features. 14 August 2012. heise.de. German. Harald M. Genauck. 2015-07-14.
  17. Web site: Database Workbench Pro (Review). 5 May 2012. commentcamarche.net. French. 2014-09-23.
  18. Web site: Running Database Workbench 5 under Wine, how to manuals. Sep 2014. Upscene Productions. 2014-10-16.
  19. Web site: Database Workbench learn how it's useful for you. Upscene Productions. 2014-09-23.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "Database Workbench".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2024, A B Cryer, All Rights Reserved. Cookie policy.