Tagged with 'sql'
MySQL v. SQLite
Much of the Rails world is ga-ga for SQLite, but I've always had MySQL-something installed on my development machine for other reasons. Lately, though, those other reasons have been melting away, so I decided to try out SQLite.
I have a rather complicated Web app whose tests have always run long (around a minute for the full suite), so I ran one last test with MySQL, then switched over to SQLite for a comparison run.
| MySQL | SQLite | |
| Unit | 8.95 | 11.16 |
| Functional | 25.64 | |
| Integration | 21.38 |
I don't have an exact measurement of the functional or integration tests, because they stalled out. I left the machine running for minutes (no other major processes) and it had made no progress through the functional tests (no ...s appeared, just a line saying "Started".
This isn't a scientific comparison, but it's enough to scare me away for now. And, it's in tune with my last attempt to use SQLite (on a resource limited VPS that couldn't manage MySQL at all, SQLite took minutes for some fairly simple queries).
Misadventures in SQL
Let's say you have a database full of links, and you want to know how many unique links you have (unique meaning a unique URL). In MySQL, you can write:…