What do you do with a database that is specific to that database?

Hi folks.  I am looking for some information from you regarding features that you use in databases where those features fall outside of the “standard“ set of database features.  For example, all database support things that are standard.  The sql language is relatively standard, in that each major database supports insert, update, delete, and select (though joins seem to have slightly differing syntaxes).  Each database seems to have their own extensions to do something that is specific to them or not handled well by the standard sql language.  What do you do with a database (Sql Server, Oracle, DB/2, MySql, or whatever) that is fairly database specific?  For example, do you use the Sql Servver full text search Contains or FreeText commands to query data, which is different than the MySql Match command?  Do you use the database to store BLOBs?  Here is my current list of general items that are different.  Please feedback with ones that are different along with the database that you use them in.

  • JOINs. (MySql seems to be lagging in this.  Oracle seems to have caught up in this.).
  • BLOBs.
  • Full-Text Search.
  • XML.
  • Primary keys (sequence in Oracle vs. Identity or GUID in Sql Server).

Wally

2 Comments

Comments have been disabled for this content.