• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Problem: sqlite3 and .sqlite-journal files
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problem: sqlite3 and .sqlite-journal files


  • Subject: Re: Problem: sqlite3 and .sqlite-journal files
  • From: Chris Hanson <email@hidden>
  • Date: Fri, 17 Apr 2009 15:50:00 -0700

On Apr 17, 2009, at 12:47 PM, Тимофей Даньшин wrote:

However, a strange thing happens: when the user _creates_ a database, everything is stored as hoped. But when the user _opens_ an existing database, nothing is stored in it, and a new file gets created, which name coincides with the name of the database the user opened with "-journal" in the extension. (I did read about that on the sqlite3 site, but it didn't seem to help).

That file is, as its name implies, the "journal" file for the database. It's used by SQLite to implement its transactional data- integrity guarantees.


  -- Chris

_______________________________________________

Cocoa-dev mailing list (email@hidden)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Problem: sqlite3 and .sqlite-journal files (From: Тимофей Даньшин <email@hidden>)

  • Prev by Date: Re: NSSavePanel and file formats
  • Next by Date: Re: Reading in dictionary from txt file: options for speed
  • Previous by thread: Problem: sqlite3 and .sqlite-journal files
  • Next by thread: SQLite 3 crash report - debugging help needed
  • Index(es):
    • Date
    • Thread