[TriLUG] Interesting article: Ellison: Linux will wipe Microsoft out of the data center

Joseph Tate jtate at dragonstrider.com
Thu Apr 3 14:22:19 EST 2003


BLOB == BINARY large object.  TEXT !=BLOB.  If you want to store MP3 
files in MySQL how would you do it?  BASE 64 Encode it?

Jeremy Portzer wrote:

>On Thu, 2003-04-03 at 13:53, Joseph Tate wrote:
>  
>
>>Stored procedures (PL/pgSQL or C).  Triggers.  I can't remember if Mysql 
>>supports BLOBs or not, but Postgres does.  Up until 4.x there wasn't any 
>>transaction support (Commit/Rollback) in Mysql.
>>
>>    
>>
>
>MySQL does support BLOB equivalents (called TEXT I believe), and what
>I've heard is that they perform much better than Postgres. But yes, the
>lack of stored procedures and triggers does make MySQL much less
>useful.   I haven't played with MySQL 4 yet, but the 3.23 versions don't
>even support row-level locking or transactions (unless you use a
>non-free(dom) software table type).
>
>--Jeremy
>
>  
>




More information about the TriLUG mailing list