Sunday, March 28, 2010

Moving to MySQL

When I first started this project I wanted to use MySQL as the database: it was already installed on my computer, and in general MySQL enjoys widespread use. I couldn't get it to work, so I went with the default SQLite db, which worked fine.

The next major addition I'd like to make to U is a full text search. After some exploration, I settled on Sphinx. However, it seems Sphinx only supports MySQL and PostgreSQL, and maybe some commercial stuff. I went back to trying to use MySQL. After some installing, uninstalling with apt-get and gem (and remembering my root password), I got it working. We are now on "kepplerapp3".

Now on to getting Sphinx to work.

No comments:

Post a Comment