That's exactly the use case for SQLite - as a part of a desktop application that is entirely local and needs features from relational databases. If you're running a web server, using Postgres is straightforward enough that you might as well start with that. Especially in a Rails environment.