QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("database");

//    db.setHostName("localhost");

if (db.open("admin", "admin")) {
  if (!db.tables().contains("app_settings")) {
    QSqlQuery q = db.exec("CREATE TABLE app_settings "
    "( "                    
    "    key_column text NOT NULL, "                                
    "    value_column text, "
    "    CONSTRAINT app_settings_pk PRIMARY KEY (key_column) "
    ")");
    if (q.lastError().isValid())
      qDebug() << q.lastError().text();
    }
  QtSqlSettings *settings = new QtSqlSettings(db.connectionName());
  settings->setValue("New Value", QStringList() << "First line" << "SecondLine");

  settings->setValue("group1/value1", QVariantList() << 1 << 3);

  settings->setValue("bytearray", QByteArray("bytearray", 9));

  settings->save();

  delete settings;