Ubuntu Hardy Heron Install Live Blog
Posted by Double Compile on Friday, April 25. 2008 in GNU/Linux
Ubuntu 8.04 Hardy Heron came out yesterday. I meant to upgrade yesterday but, on a whim, I thought I'd install from scratch and live blog it. What follows is the result of that effort.
Did I mention I ordered the limited edition Hardy Heron t-shirt from the Canonical store? Because I did.
Another log on the fire
Posted by Double Compile on Tuesday, April 22. 2008 in Databases
If you want foreign key support in MySQL, you need to use the InnoDB storage engine. If you want fulltext index support, you need to use the MyISAM storage engine. Ain't that a bitch?
Just for the record: PostgreSQL supports them both well.
To be fair, the syntax for fulltext searching in MySQL is more simple than that of fulltext searching in PostgreSQL. Here's an example:
MySQL:
SELECT title
FROM example
WHERE MATCH (title, body) AGAINST ('foobar')
PostgreSQL:
SELECT title
FROM example
WHERE to_tsvector(title || body) @@ to_tsquery('foobar');
So while the syntax is easier, you can't use fulltext and foreign keys simultaneously in MySQL. PostgreSQL wins this battle.
Page 1 of 1, totaling 2 entries
Creative Commons
Syndicate This Blog
