I was working on a good write-up on how to use SQLite in C# (since the most popular package install for SQLite on C# is kinda broken in Visual Studio 2010), but thought this might be a good data point for folks.<\/p>\n
So, the short answer?\u00a0 Yes, you can build SQLite databases on Windows, copy them across to your Mac, and then use them in iPhone applications without any issues. How do I know?\u00a0 I did it last night. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" I was working on a good write-up on how to use SQLite in C# (since the most popular package install for SQLite on C# is kinda broken in Visual Studio 2010), but thought this might be a good data point for folks. So, the short answer?\u00a0 Yes, you can build SQLite databases on Windows, copy them across to your Mac, and then use them in iPhone applications without any issues. You should open the database with the proper character formatting\u00a0…<\/p>\n
\nYou should open the database with the proper character formatting\u00a0 ( sqlite3_open([dbPath UTF8String], &database)<\/code>),
\nbut other than that the SQL files can be just copied straight across the devices from Win 7->Mac->iPhone and the same select\/delete\/etc commands work like a champ.<\/p>\n