It's not that large of a lock-in, you can fairly painlessly move from sqlite -> postgres. They share a lot of commonality.

I have no experience moving from sqlite -> mysql, but I imagine it's only a bit more difficult.

But I agree with thechao's comments also.