TBF: you don't. The moment you care about any shortcoming of SQLite, move away. One of the cool things about it, is that SQLite is very lax about what it accep

TBF: you don't. The moment you care about any shortcoming of SQLite, move away. One of the cool things about it, is that SQLite is very lax about what it accepts (mostly in the datatype area). You can write your SQL statements targeting whatever database you think you'll move to later and they'll work while you're still on SQLite. I believe having this migration work seamlessly towards PostreSQL is one of the advertised features.