What do I need to do to DataMapper to have a persistent sqlite database?
Try putting the full path in there (note there are 3 forward slashes):
DataMapper.setup(:default, "sqlite:///path/to/my/database/my.db")
Then you should see my.db
under /path/to/my/database/