Database Workbench

Last updated
Database Workbench
Original author(s) Upscene Productions
Stable release
6.5.2 [1] / July 15, 2024;26 days ago (2024-07-15)
Operating system Windows
Type Database design, management, development
License Trialware
Website www.upscene.com/database_workbench/

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.

Contents

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

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

<span class="mw-page-title-main">SQLite</span> Serverless relational database management system (RDBMS)

SQLite is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the most widely deployed database engine, as it is used by several of the top web browsers, operating systems, mobile phones, and other embedded systems.

An SQL INSERT statement adds one or more records to any single table in a relational database.

ADO.NET is a data access technology from the Microsoft .NET Framework that provides communication between relational and non-relational systems through a common set of components. ADO.NET is a set of computer software components that programmers can use to access data and data services from a database. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational data sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

ADOdb is a database abstraction library for PHP, originally based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a consistent way regardless of the underlying database system storing the information. The advantage is that the database system can be changed without re-writing every call to it in the application.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

<span class="mw-page-title-main">MySQL Workbench</span> Database design graphical tool

MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. It is the successor to DBDesigner 4 from fabFORCE.net, and replaces the previous package of software, MySQL GUI Tools Bundle.

In relational databases, the information schema is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. It can be used as a source of the information that some databases make available through non-standard commands, such as:

 => SELECT count(table_name) FROM information_schema.tables;  count   -------  99    => SELECT column_name, data_type, column_default, is_nullable  FROM information_schema.columns WHERE table_name='alpha';  column_name | data_type | column_default | is_nullable   -------------+-----------+----------------+-------------  foo | integer | | YES  bar | character | | YES    => SELECT * FROM information_schema.information_schema_catalog_name;  catalog_name   --------------  johnd
<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures.

A database shard, or simply a shard, is a horizontal partition of data in a database or search engine. Each shard is held on a separate database server instance, to spread load.

<span class="mw-page-title-main">DatabaseSpy</span> SQL database profiling tool and GUI

DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major relational databases, facilitating SQL querying, database structure design, database content editing, and database comparison and conversion.

<span class="mw-page-title-main">Couchbase Server</span> Open-source NoSQL database

Couchbase Server, originally known as Membase, is a source-available, distributed multi-model NoSQL document-oriented database software package optimized for interactive applications. These applications may serve many concurrent users by creating, storing, retrieving, aggregating, manipulating and presenting data. In support of these kinds of application needs, Couchbase Server is designed to provide easy-to-scale key-value, or JSON document access, with low latency and high sustainability throughput. It is designed to be clustered from a single machine to very large-scale deployments spanning many machines.

<span class="mw-page-title-main">SpatiaLite</span> Spatial extension to SQLite

SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality. It is similar to PostGIS, Oracle Spatial, and SQL Server with spatial extensions, although SQLite/SpatiaLite aren't based on client-server architecture: they adopt a simpler personal architecture. i.e. the whole SQL engine is directly embedded within the application itself: a complete database simply is an ordinary file which can be freely copied and transferred from one computer/OS to a different one without any special precaution.

In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic expression. Virtual columns are defined of SQL:2003 as Generated Column, and are only implemented by some DBMSs, like MariaDB, SQL Server, Oracle, PostgreSQL, SQLite and Firebird.

The following outline is provided as an overview of and topical guide to MySQL:

<span class="mw-page-title-main">DBeaver</span> Multi-platform database administration software

DBeaver is a SQL client software application and a database administration tool. For relational databases it uses the JDBC application programming interface (API) to interact with databases via a JDBC driver. For other databases (NoSQL) it uses proprietary database drivers. It provides an editor that supports code completion and syntax highlighting. It provides a plug-in architecture that allows users to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. This is a desktop application written in Java and based on Eclipse platform.

References

  1. ↑ "Database Workbench 6.5.2 released". Upscene Productions. July 15, 2024. Retrieved 2024-08-01.
  2. ↑ Miguel van de Laar (Sep 12, 2010). "Database Workbench, productiviteits tool voor database ontwikkelaars en netwerkbeheerders". Blaise Pascal Magazine (in Dutch) (93). DelphiGG. Retrieved 2014-09-19.
  3. ↑ Borrie, Helen (2004). "Appendix V: Administration Tools". The Firebird Book: A Reference for Database Developers . APress. p.  937. ISBN   1-59059-279-4 . Retrieved 2014-09-19. Database Workbench.
  4. ↑ Marco Cantù (2003). "Introducing InterBase". Mastering Delphi 7. SYBEX Inc. ISBN   078214201X . Retrieved 2014-09-23.
  5. ↑ Christian Ullenboom (2003). "20.5.1 Datenbank Interbase und Firebird". Java ist auch eine Insel (2. Aufl.) (in German). Galileo Press GmbH. ISBN   978-3-8362-2873-2 . Retrieved 2014-09-23.
  6. ↑ "About Us". Upscene Productions. Retrieved 2014-09-23.
  7. ↑ Matthew Hicks (Sep 2, 2004). "Mozilla Renames Browser, Revs New Releases". eWeek. Retrieved 2014-09-23.
  8. ↑ Sean Leyne. "FirebirdSQL Project Update" (PDF). IBPhoenix. Retrieved 2014-09-23.
  9. ↑ Martijn Tonies (Sep 3, 2014). "Database Workbench 5.0 now available". Firebird News. Retrieved 2014-09-19.
  10. ↑ "Database Workbench available editions and feature matrix". Upscene Productions. Retrieved 2016-01-06.
  11. ↑ Cristina Jitaru (Feb 18, 2014). "Database Workbench Lite for Firebird (Review)". Softpedia. Archived from the original on 2015-05-22. Retrieved 2014-09-19.
  12. ↑ "Database Workbench Lite for Firebird" (in Polish and Czech). Dobreprogramy. Aug 19, 2015. Retrieved 2016-01-06.
  13. ↑ Cristina Jitaru (Jun 26, 2015). "Database Workbench Lite for Firebird". Software.informer. Retrieved 2016-01-06.
  14. ↑ Roberto Jimenez. "Database Workbench Pro (Editorial Review)". Software Informer. Retrieved 2014-09-19.
  15. ↑ Astrid Wagner (13 August 2012). "Database Workbench 4.3.0 Pro mit Debugger für MySQL erhältlich" (in German). PHPmagazin. Retrieved 2014-09-23.
  16. ↑ Harald M. Genauck (14 August 2012). "Database Workbench 4.3.0 mit hilfreichen neuen Features" (in German). heise.de. Retrieved 2015-07-14.
  17. ↑ "Database Workbench Pro (Review)" (in French). commentcamarche.net. 5 May 2012. Retrieved 2014-09-23.
  18. ↑ "Running Database Workbench 5 under Wine, how to manuals". Upscene Productions. Sep 2014. Retrieved 2014-10-16.
  19. ↑ "Database Workbench learn how it's useful for you". Upscene Productions. Retrieved 2014-09-23.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.