title: How to view the content of .db file?
body: <p>I am using Xcode 6.4, developing apps for iOS 8 that need to use database. I inserted some information into my database ("something.db" file). I want to see the content of "something.db" to see what I inserted. How can I view its content?</p>
  
  <p><strong><em>This is my code for creating the database "company.db" and table "Staff"(ID PK, NAME TEXT, AGE INTEGER):</em></strong></p>
  
  <pre><code>-(void) createOrOpenDB {
      NSArray *path = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
      NSString *docPath = [path objectAtIndex:0];
      dbPathString = [docPath stringByAppendingPathComponent:@"company.db"];
      char *error;
      NSFileManager *fileManager = [NSFileManager defaultManager];
      if(![fileManager fileExistsAtPath:dbPathString]) {
          const char *dbPath =[dbPathString UTF8String];
           if(sqlite3_open(dbPath, &amp;personDB)==SQLITE_OK) {
              const char *sql_stmt = "CREATE TABLE IF NOT EXISTS Staff (ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT, AGE INTEGER)";
              sqlite3_exec(personDB, sql_stmt, NULL, NULL, &amp;error);
              sqlite3_close(personDB);
          }
       }
  }
  </code></pre>
  
  <p><strong><em>This is my code for inserting information into the table "Staff":</em></strong></p>
  
  <pre><code>- (IBAction)addPersonButton:(id)sender {
      char *error;
      if(sqlite3_open([dbPathString UTF8String], &amp;personDB) == SQLITE_OK) {
          NSString *insertStmt = [NSString stringWithFormat:@"INSERT INTO Staff (NAME, AGE) values ('%s', '%d')", [self.nameField.text UTF8String], [self.ageField.text intValue]];
          const char *insert_stmt = [insertStmt UTF8String];
          if(sqlite3_exec(personDB, insert_stmt, NULL, NULL, &amp;error) == SQLITE_OK) {
              NSLog(@"Person added");
              Person *person = [[Person alloc] init];
              [person setName:self.nameField.text];
              [person setAge:[self.ageField.text intValue]];
              [arrayofPerson addObject:person];
          }
  
          sqlite3_close(personDB);
      }
  }
  </code></pre>
  
  <p>The code works well because I was able to display the information of the "Staff" table in the tableview. But how to view that information in the .db file? </p>
  
  <p>p/s: I changed it to "something.xls" but Excel does not display human readable information. I also downloaded Fileviewpro but did not know how to use. Someone helps me please!</p>
  
  <p>Thank you very much! </p>