attached database

  1. R

    Android Question Problem copying table to attached DB

    Trying to copy a table from the main SQLite database (main) to an attached database. I am using SQLCipher. The table I am copying has this DDL: CREATE TABLE [ADDRESSES]([EMIS_NUMBER] INTEGER PRIMARY KEY, [HOUSE] TEXT, [STREET] TEXT, [LOCALITY] TEXT, [TOWN] TEXT, [POSTCODE] TEXT, [HOME_PHONE]...
  2. luc-dev

    iOS Question SQLite : How to set WAL mode and avoid database lock

    Hi, I'm trying to use SQLite WAL mode to avoid locks while running several nested SQL statements like "Insert into MyDb from (select from MyattachedDb where...)". These queries need to be managed by a global transaction because several related tables are updated at the same time. I didn't...
    • luc-dev
    • Thread
    • attached database database lock sqlite wal mode
    • Replies: 11
    • Forum: iOS Questions
Top