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.
Query Tool (using ODBC) 是一個Universal Data Access (UDA)工具。它可以讓你查詢ODBC數據源、author SQL scripts and queries、同時執行多個SQL腳本或存儲過程,返回網路或自由格式的文本,導出HTML格式的Excel結果,檢索OBC驅動程式訊息等。
系統需求
System Requirements:
Windows
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數據庫的架構和數據。