PL/SQL Developer 是一種集成的Oracle資料庫開發環境,專門用於開發、測試、調試和優化Oracle PL/SQL存儲程式單元,比如觸發器等。軟體主要特點是具有上下文幫助,資料庫內容描述。軟體包括︰完整的調試器,代碼助手,模板庫,宏庫,命令視窗。PL/SQL Developer功能十分全面,大大縮短了程式師的開發週期。強大的PL/SQL編輯器,完善的Debugger調試器。
新版介紹
Enhancements
Performance and stability improvements
SELECT FOR UPDATE statements in the SQL Window could be rolled back if there were additional spaces or comments between FOR and UPDATE
Oracle23c Boolean field datatypes were displayed as boolean(1)
Oracle23c Boolean field data was displayed as T/F on an Oracle23c Client, instead of 1/0 on older clients
Oracle23c Boolean column data could not be exported with the “Export Tables” tool
Objects with Oracle23c Boolean attributes could not be accessed
Export User Objects now takes UTF8/ANSI encoding preference into account
Save text from large data editor now takes UTF8/ANSI encoding preference into account
Test Window would interpret bind variables within double quotes
Drag & Drop did not work correctly in the Connection List: only windows can now be moved to another connection
When using an external difference viewer, Unicode characters would be converted to question marks
Session Window detail queries did not support WITH FUNCTION statements
Drag & Drop of a shortcut will now open the shortcut target file
Performing a Find with an error in a regular expression could cause a long delay
Wrapped text in result grid cells could be visually truncated
Clicking on the “To-Do List” button in the Project Window will now directly take you to the To-Do Items
Command Window would not spool line comments
A comma in a password would not work correctly when the PL/SQL Developer desktop was reloaded
Some Test Manager Edit menu items would incorrectly be enabled
Export to Clipboard would not always work correctly for Unicode
Opening a database source with compilation errors would not allow you to navigate to an error
PostgreSQL Maestro 資料庫開發及管理的首選軟體
PostgreSQL Maestro 是一款功能強大的GUI圖形化介面資料庫開發及管理工具,支持所有最新的PostgreSQL server及7.3版,功能包括表空間、元引用、資料數據的導入/導出、創建、編輯、預覽等,並且可以執行和查詢SQL腳本,管理用戶和特權。
PostgreSQL Maestro is the premier PostgreSQL GUI admin tool for database management, control and development. Key features include:
Support for all versions of PostgreSQL versions starting from 7.3 including roles, tablespaces, partitions, extensions, and so on;
User-friendly interface with navigation style, well-described wizard system, quick launch panel for performing the commonest operations;
Easy PostgreSQL database objects management;
Visual Database Designer with reverse engineering and a lot of other features;
PL/pgSQL Debugger to investigate and fix your PL/pgSQL code in the shortest way;
Comfortable access to the PostgreSQL security features;
Powerful tools for working with SQL queries including Visual Query Builder;
Flexible customization of the application.
The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.
RediSQL 是Redis模塊,它嵌入了功能齊全的SQLite數據庫。
據我們所知,這是唯一一個提供SQL功能同時又非常快的系統,它可以用作緩存,可以輕鬆地與任何編程語言集成,因為每個Redis客戶端都可以使用它,並且維護成本非常低。
而且,它還可以用作主數據庫,它不僅可以將數據存儲在內存中,還可以存儲在文件中,還可以使用redis本身相同的持久性機制。
RediSQL is the Fast, in-memory, SQL engine with batteries included.
It provides several benefits for your application.
Fast, it can top up to 130k inserts per second.
Familiar, it works with standard SQL, no weird dialect or syntax to learn.
Easy to Operate, it is based on Redis, just start the standard Redis binary and and pass the RediSQL binary.
Easy to Use, being based on Redis there are already bindings for any language.
SQL Delta
SQL Delta是三合一的SQL比較工具,它執行:
模式比較 Schema Compare
數據比較 Data Compare
模式視圖 Schema View
使用該工具比較SQL資料庫。比較資料庫後,您可以使用SQL Delta同步目標資料庫以匹配源資料庫。
SQL Delta提供3個產品版本,SQL Delta for SQL Server,SQL Delta for Oracle和SQL Delta for MySQL.。
SQL Delta for SQL Server 是用於SQL Server資料庫的比較工具。SQL Delta可以通過圖表比較或者數據比較的方式展示兩個SQL Server資料庫的不同結果,然後生成一個同步腳本和部署。因此,你的資料庫比較是完全隨時同步的。
SQL Delta for MySQL 是一款資料庫對比工具,SQL Delta For MySQL能夠幫助用戶快速進行資料庫管理,可以很好的幫助用戶進行多個資料庫、平台的管理。
SQL Delta for Oracle 是款比較和同步Oracle數據庫的架構和數據。
SQLAPI++ 是一套可以讀取多個SQL資料庫(Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL)的C++ library。SQLAPI++直接調用本地目標資料庫管理系統(DBMS)的API,使得在SQLAPI + + library上的你開發的應用程序可以迅速有效的進行。該產品提供低級別的界面,允許開發人員存取資料庫的特定功能。SQLAPI++ library扮演了一個中間角色方便存取資料庫。
SQL資料庫伺服器支援以下的平台:
Server
Win32
Linux/Unix
Oracle Database Server
Supported (OCI)
Supported (OCI)
Microsoft SQL Server
Supported (DB-Library, OLE DB)
FreeTDS ODBC driver should be used
Sybase
Supported (Open Client, ASE & ASA)
Supported (Open Client, ASE & ASA)
DB2
Supported (DB2 CLI)
Supported (DB2 CLI)
Informix
Supported (Informix CLI)
Supported (Informix CLI)
InterBase/Firebird
Supported
Supported
SQLBase
Supported (CAPI)
Supported (CAPI)
MySQL, MariaDB
Supported (MySQL C API)
Supported (MySQL C API)
PostgreSQL
Supported (libpq)
Supported (libpq)
ODBC
Supported
Supported (iODBC, unixODBC)
SQLite
Supported
Supported
Sybase SQL Anywhere
Supported (SQL Anywhere C API)
Supported (SQL Anywhere C API)
SQLAPI++ library 新版介紹
NEW FEATURES
Oracle: Removed the code that changed the parameter/field character set form for Unicode version (thanks Jakub Zakrzewski)
SQL Server (ODBC): Added "SQL_SOPT_SS_DEFER_PREPARE" command option (changed to SQL_DP_ON by default, thanks Christian Maurer)
General: Code optimization according cppcheck detections
General: SACommand::RowsAffected returns sa_uint64_t instead of long
General: Replaced 'long' by 'int' type in SAInterval class
General: GetClientVersion/GetServerVersion methods return int instead of long
General: SA_dtLong/SA_dtULong data types and related methods replaced by SA_dtInt32/SA_dtUInt32 (old names are still here but operate with sa_int32_t/sa_uint32_t values)
General: Added SAPI::ThreadInit and SAPI::ThreadEnd methods
BUG FIXES
SQLite: Fixed crashing when an empty SQL statement is passed (thanks Christian Schmitz)
Informix: Fixed bug with rows prefetching (thanks Jesús Malo Poyatos)
MariaDB: Fixed ::IsAlive method detects the server connection lost (thanks Tennessy Tan)
WinSQL 是通用的資料庫管理工具,它可以使用任何關聯資料庫來執行管理任務,如導入/導出數據,產生測試數據,現有資料庫的逆向工程,在資料庫之間架構和數據的比較,或簡單地運行SQL查詢。一方面的WinSQL提供先進的用戶功能強大的工具來幫助他們管理自己的資料庫,另一方面在WinSQL的幾個導引可幫助新手用戶查看和修改現有的任何關聯資料庫的數據。總之,WinSQL對任何每天工作於各種資料庫的程式編寫員或資料庫管理員來說是一個必備的工具。
資料庫開發是一件枯燥乏味、極其耗時的任務。常常占用了開發人員寶貴的全部時間和精力。WinSQL是符合 ODBC 的資料庫開發解決方案,其簡化了與資料庫相關的日常任務。WinSQL 適用於任何符合 ODBC 的資料庫,包括 Oracle、Sybase、DB2、MS SQL Server、Informix、MS Access、MySQL、PostgreSQL 等。WinSQL 提供十分簡潔、功能強大的圖形用戶界面,幫助您輕鬆地提交 SQL 查詢、瀏覽資料庫編錄、查看不同項目之間的關係等。WinSQL 利用特定的資料庫插件來擴展默認的ODBC,換言之,這些插件將輔助ODBC完成其無法辦到的任務。
WinSQL 是資料庫管理員和程式開發員處理資料庫所必須擁有的工具。使用WinSQL資料庫管理員能輕易有效地管理任何一個關聯資料庫。程式開發員能快速地寫SQL語法,捕捉它們的反應時間並把它們轉換成程式碼。獲得表、圖、儲存過程、觸發器、規則等等的原始碼。且擁有有學習怎樣使用以幫助你建立SQL語法的導引。且可把一個資料庫的數據轉換到另一個資料庫,以及現有資料庫的逆向工程、畫 E/R 圖、產生數百萬行有意義的測試數據、在兩個資料庫之間查找結構性的不同、在不同的資料庫的兩張表之間查找數據的不同。 WinSQL將讓您的工作變得非常簡單。
新版介紹
Quick Search
Enhanced Special Comments
Enhanced fix-length export
Ability to convert CHAR FOR BIT DATA to string when exporting from DB2
Enhanced error handling
Ability to include titles when exporting to CSV files
Ability to assign primary keys to views, which is useful when using the Update Wizard
Ability to specify a /clean as a command line argument, which ignores previously stored sessions