Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. how do i sync two places.sqlite..?

how do i sync two places.sqlite..?

Scheduled Pinned Locked Moved C / C++ / MFC
questionsqlitetools
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Y Offline
    Y Offline
    yogish293
    wrote on last edited by
    #1

    mozilla firefox will store all bookmarks in places.sqlite file... i am writing small utility which will sync two places.sqlite file bookmarks....

    L N 2 Replies Last reply
    0
    • Y yogish293

      mozilla firefox will store all bookmarks in places.sqlite file... i am writing small utility which will sync two places.sqlite file bookmarks....

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      If I understand your question rgith, there is no need to have any knowledge of the internals in this case. The easiest thing to do would be to compare the file date and replace the oldest one with the newer.

      Y 1 Reply Last reply
      0
      • L Lost User

        If I understand your question rgith, there is no need to have any knowledge of the internals in this case. The easiest thing to do would be to compare the file date and replace the oldest one with the newer.

        Y Offline
        Y Offline
        yogish293
        wrote on last edited by
        #3

        no... original file also modified or added with some bookmarks and copied file also modified with some other bookmarks in that we cannot just replace ...

        1 Reply Last reply
        0
        • Y yogish293

          mozilla firefox will store all bookmarks in places.sqlite file... i am writing small utility which will sync two places.sqlite file bookmarks....

          N Offline
          N Offline
          Niklas L
          wrote on last edited by
          #4

          I'm guessing it's an SQLite database file. Standard procedure is to use SQL. Connect to the database and execute your queries. There are also C APIs[^] for doing this, still needing SQL though. It's well documented and there are plenty of samples around. Use sqlite3_open_v2()[^] to open the file, and sqlite3_exec()[^] to execute your queries. Good luck!

          home

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups