Skip to content
  1. Mar 30, 2019
  2. Mar 29, 2019
    • Yuanle Song's avatar
      fix a file name error in doc string. · ea9665e2
      Yuanle Song authored
      ea9665e2
    • Yuanle Song's avatar
      v0.101.0 redesign use of main and user database. · 8b6cf027
      Yuanle Song authored
      the old design have flaws and limitations. see :id001: and :id002: in
      operational file.
      
      new design:
      
      open :memory: db readwrite, this will be the m_db handler.
      
      try attach main db at known path (readonly if possible) to "maindb".
      if failed, try next known path,
      if all failed, initDB() should return false and gave up.
      
      try attach user db at known path to "userdb" schema, if failed,
      create :memory: db and initialize it as user db. attach it as "userdb"
      schema.
      
      update all query against main db to query from maindb.* table.
      update all SQL against user db to run again userdb.* table.
      
      benefits:
      - access to user db is concurrent safe. multiple libpyzy app won't overwrite
        user's user db file and lose data.
      - there is no need to saveUserDB() using timer in the bg.
      - there is no need to copy data from user db to :memory:, if user db is
        large, this can lower memory usage.
      8b6cf027
  3. Mar 28, 2019
    • Yuanle Song's avatar
      v0.100.1 code review for Database.cc · 95b8f0b6
      Yuanle Song authored
      - add error handling for all db operations
      - refactoring Database.cc to make it more readable.
        add doc for Database.cc
        extract method copyDB(), initUserDB(), setPragmaOnMainDB()
      - fix old timeoutCallback(), now named cb_saveUserDB()
        saveUserDB() should not be in the condition, because save can fail endlessly
        if file system have problem.
      - no longer require main db to be a regular file. symlink should work fine.
      - drop the dreaded overly reused class variable m_buffer. use meaningful names
        in current context.
      - escape string in SQL statements
      - update meson.build
        add prefix in PKGDATADIR
        define glib logging domain
        disable glib asserts for release build
      - I will use so file version in git log.
      95b8f0b6
  4. Dec 17, 2012
  5. Jun 11, 2012
  6. Jun 06, 2012
  7. May 08, 2012
  8. Mar 27, 2012
  9. Nov 15, 2011
  10. Nov 09, 2011
  11. Oct 24, 2011