MesgApi Compare
Introduction | Spread Toolkit | Examples | Download | Install | API Reference | Comparison | Details
[edit] Comparison
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 |
For more information, contact John David Duncan, jdd@mysql.com
This product uses software developed by Spread Concepts LLC for use in the Spread toolkit. For more information about Spread see http://www.spread.org