|
Introduction
Spread Toolkit
Examples
Download
Install
API Reference
Comparison
Details
|
|
|
A comparison of the available messaging APIs for MySQL, Microsoft SQL Server,
and Oracle.
| |
MySQL |
Microsoft SQL Server 2005 |
Oracle |
| Message Facility |
Message API |
Service Broker |
Advanced Queueing (AQ) |
| Open Source |
Yes |
No |
No |
| API Style |
SQL functions:
SELECT send_mesg("cooks","hello"); |
SQL statements:
CREATE QUEUE [OrderQueue] ... ;
|
PL/SQL packages:
EXEC DBMS_AQ.ENQUEUE ( ... ) |
| Network Models |
unicast & multicast |
unicast only |
unicast & multicast |
| Transactional |
No |
Yes |
Yes |
| Interoperability |
Application code in C, Java, PHP, Perl, C#,
etc. |
None - SQL Server only |
JMS |
|