Tag Archives: development

Through trial and error, I have done a quick setup of Redmine + SVN on Windows. This does not use Apache and WebDAV. The Ruby on Rails webserver, Mongrel, is used, and SVN is accessed through svnserve (svn://). If you need a full deployment of Redmine, with automatic generation of SVN repositories and SVN accounts, this can be a starting point (let me know how you got it to work!). If you want a quick and dirty setup, this may be the only guide you need!

Information on using SQLite for local storage on Cocoa isn’t all that easy to find. The best resource, as always, is Google, and you can find a few tutorials with step by step instructions and code samples on how to use it. Well, here’s another basic step by step set of instructions, but rather than including code samples, I have written a couple of wrapper classes for creating databases, making queries, and getting results.

Steps:

1: Include the SQLite framework in your project. It’s usually located somewhere like “/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS2.1.sdk/usr/lib/libsqlite3.0.dylib” (why is developer in there twice?)

2: Create a base sqlite database file, and modify SQLite.m so that the filename method refers to it. Place it in your main resource path. This will be copied out of your bundle into your application’s Documents directory. If you need help on creating one of these and managing it, there is a fantastic FireFox extension that does it for you!

NSArray columnNames contains NSStrings of all the names.
NSArray columnTypes contains NSStrings of all the types.
NSArray rows contains NSArrays, where each of these contains NSStrings of all the row values in that row.