Yes, Apple have changed the default journal mode to WAL for iOS7.
You can specify the journal mode by adding the NSSQLitePragmasOption to the options when calling addPersistentStoreWithType:configuration:url:options:error.  E.g. to set the previous default mode of DELETE:

    NSDictionary *options = @{ NSSQLitePragmasOption : @{@&quot;journal_mode&quot; : @&quot;DELETE&quot;} };

In my experience WAL gives better performance, but also see this post:

https://stackoverflow.com/questions/17487306/ios-coredata-are-there-any-disadvantages-to-enabling-sqlite-wal-write-ahead

I want to make an app which records the incoming and outgoing calls and it run automatically when user get or make any call.

How to record phone calls in android?

What is the project structure you end up with when using MVVM in WPF?

From the tutorials I saw now, they usually have folders: Model, ViewModel and
View. 

In Model you put classes like Person for example that capture data
and logic. 

In ViewModel you instantiate classes defined in Model. The View contains
.xaml files.

Edit: I edit my original post to send an example project structure.
I have question related to this. How do I organize these:
App.config
App.xaml
MainWindow.xaml

Should I leave them outside like they are now or should I put them in some folder?

![enter image description here][1]


  [1]: http://i.stack.imgur.com/KLjhT.png

Project structure for MVVM in WPF

I&#39;m preparing an update for a Core Data based app for fixes with iOS 7. I use Xcode 5 and iOS 7 SDK GM. However I realized a different behavior of the persistent store (which is a `UIManagedDocument`): Prior to iOS 7 builds there was only one file `persistentStore` in the documents folder (sometimes there was a second one `persistentStore-journal`).

In iOS 7 builds (clean installation) there are now three files for the persistent store:

 - `persistentStore`
 - `persistentStore-wal` and
 - `persistentStore-shm`

Did Apple change the journal mode by default to WAL now? I wonder if there is an impact on my app (think of users how update from the last version)? Would it be best to disable WAL - and if so, how can I do this with iOS 7/`UIManagedDocument`?

Core Data and iOS 7: Different behavior of persistent store

I'm preparing an update for a Core Data based app for fixes with iOS 7. I use Xcode 5 and iOS 7 SDK GM. However I realized a different behavior of the persistent store (which is a <code>UIManagedDocument</code>): Prior to iOS 7 builds there was only one file <code>persistentStore</code> in the documents folder (sometimes there was a second one <code>persistentStore-journal</code>).
In iOS 7 builds (clean installation) there are now three files for the persistent store:
<ul>
<li><code>persistentStore</code></li>
<li><code>persistentStore-wal</code> and</li>
<li><code>persistentStore-shm</code></li>
</ul>
Did Apple change the journal mode by default to WAL now? I wonder if there is an impact on my app (think of users how update from the last version)? Would it be best to disable WAL - and if so, how can I do this with iOS 7/<code>UIManagedDocument</code>?

I&#39;ve implemented a custom table view cell class that inherit from `UITableViewCell`. The tableview contains a background image, so I want cell&#39;s background to be transparent. It looks great before iOS7.

However, in iOS7, the cell is always shown with a white background.

---

Even for Xcode7, 2015, there **is a bug in storyboard**: you have to set the background color of a cell in code. 

UITableViewCell show white background and cannot be modified on iOS7

Starting in iOS7, there is additional space at the top of my `UITableView`&#39;s which have a style `UITableViewStyleGrouped`. 

Here is an example:

![enter image description here][1]

The tableview starts at the first arrow, there are 35 pixels of unexplained padding, then the green header is a `UIView` returned by `viewForHeaderInSection` (where the section is 0).

Can anyone explain where this 35-pixel amount is coming from and how I can get rid of it without switching to `UITableViewStylePlain`? 

---

# Update (Answer):
In iOS 11 and later: 

    tableView.contentInsetAdjustmentBehavior = .never

  [1]: http://i.stack.imgur.com/yNYTL.png

Why is there extra padding at the top of my UITableView with style UITableViewStyleGrouped in iOS7

Is there a way to disable UINavigationBar Translucency for an entire application?

I&#39;m aware that using `[self.navigationController.navigationBar setTranslucent:NO]` can fix this issue for a single controller, but I have a lot of UINavigationBars in my application and this is a pretty tedious solution.

I&#39;ve tried `[[UINavigationBar appearance] setTranslucent:NO]`, but that functionality is surprisingly not supported.  Doing that results in `Terminating app due to uncaught exception &#39;NSInvalidArgumentException&#39;, reason: &#39;*** Illegal property type, c for appearance setter, _installAppearanceSwizzlesForSetter:&#39;`

If I HAVE to, I can go through my entire app setting UINavigationBars to disable translucency one by one, but there must be some more elegant solution to this issue...


iOS 7 : Disable UINavigationBar Translucency For Entire App

Launching apps from Xcode 5 to the iOS simulator (multiple OS versions) fails with `SpringBoard failed to launch application with error: -3`. I can get around the problem by &#39;turning it off and back on again&#39; (quitting the simulator and relaunching, uninstalling and redeploying the app, etc.), but it seems to come back again later and in other projects.

Can someone help me understand what the real problem here is and if there is a permanent fix?

How to permanently fix Xcode 5 SpringBoard failed to launch application with error: -3

I&#39;ve been reading up on how to transfer data between iOS devices over Bluetooth using GameKit.  I&#39;m not writing a game, per se, but do have a need to transfer a small amount of binary data between two devices.  Between two iOS devices, this is easy enough.  However, I was wondering if it is possible to transfer data between an iOS device and an Android device via the same mechanism.  

Has anyone come across documentation/tutorial that would explain how to do this?  Is it even technically possible?  Or has Apple put in some sort of restriction that would prevent this?

The other option I discovered was Bonjour over Bluetooth.  Would this be a more suitable option for this type of operation?

Transfer data between iOS and Android via Bluetooth?

I need to check to see if a column exists and if it doesn&#39;t exist add it.  From my research it looks like sqlite doesn&#39;t support IF statements and case statement should be used instead. 

Here is what I have so far: 

    SELECT CASE WHEN exists(select * from qaqc.columns where Name = &quot;arg&quot; and Object_ID = Object_ID(&quot;QAQC_Tasks&quot;)) = 0 THEN ALTER TABLE QAQC_Tasks ADD arg INT DEFAULT(0);

But I get the error: Near &quot;ALTER&quot;: Syntax error.

Any ideas?

Check if a column exists in SQLite

I have a set of data in an SQLite database. I need to view the database on a device. How do I do that?

I have checked in ddms mode. The data in file explorer is empty.


How do I view the SQLite database on an Android device?

I have 2 tables and like to update one of them with the values from the other.

    software
    ---------
    id ,
    purchprice

    softwarecost
    ------------
    id ,
    purchprice

I&#39;ve tried these queries but, SQLite doesn&#39;t support JOINS with UPDATE.anybody out there who can come up with  a query for this.thanks for your help.

    UPDATE software 
    SET software.purchprice=softwarecost.purchprice 
    WHERE software.id=softwarecost.id

    UPDATE software 
    INNER JOIN softwarecost on software.id=softwarecost.id 
    SET software.purchprice=softwarecost.purchprice 

Update with Join in SQLite

I have an SQLite database. I am trying to insert values (`users_id`, `lessoninfo_id`) in table `bookmarks`, only if both do not exist before in a row.

    INSERT INTO bookmarks(users_id,lessoninfo_id) 
    VALUES(
        (SELECT _id FROM Users WHERE User=&#39;&quot;+$(&#39;#user_lesson&#39;).html()+&quot;&#39;),
            (SELECT _id FROM lessoninfo 
            WHERE Lesson=&quot;+lesson_no+&quot; AND cast(starttime AS int)=&quot;+Math.floor(result_set.rows.item(markerCount-1).starttime)+&quot;) 
            WHERE NOT EXISTS (
                SELECT users_id,lessoninfo_id from bookmarks 
                WHERE users_id=(SELECT _id FROM Users 
                WHERE User=&#39;&quot;+$(&#39;#user_lesson&#39;).html()+&quot;&#39;) AND lessoninfo_id=(
                    SELECT _id FROM lessoninfo
                    WHERE Lesson=&quot;+lesson_no+&quot;)))

 

This gives an error saying:

&gt;db error near where syntax.

&quot;Insert if not exists&quot; statement in SQLite

Can someone tell me how to install the sqlite3 module alongside the most recent version of Python?
I am using a Macbook, and on the command line, I tried:

    pip install sqlite

but an error pops up.

How can I add the sqlite3 module to Python?

I use Xcode for iOS development. I have some entity (for example, User), and I need to set unique constraint for his name, but I can&#39;t find how I can do it through visual editor. Is it possible to do it through GUI? Or it&#39;s possible through code only? I will be glad to get some screenshot.


How to add unique constraints for some fields in Core Data

**Update for Xcode 8:**

In Xcode 8, one needs to go to the Core Data Model Editor and Show the File Inspector. Near the bottom is an option for code generation. Select Swift.

**Edit**: I found the solution to generate a Swift model from Core Data entity:

On Xcode:

*Editor &gt; Create NSManagedOjbect &gt; Click button &quot;Next&quot; &gt; Click button &quot;Next&quot; &gt; Select &quot;Swift&quot; Langage &gt; Click button &quot;Create&quot;*

---

I tried Swift langage by creating a new Swift project on Xcode 6 beta using Core Data.

When I generate my models from my Core Data&#39;s entities, Xcode creates Objective-C models.

Is there a way to generate Swift model rather than Obejctive-C model with Core Data ?

Thanks !


Generating Swift models from Core Data entities

Typically, the sqlite store file for core data apps is located in 

&gt; Library&gt;Application Support&gt;iPhone Simulator&gt;7.1(or whichever version you are using)&gt;Applications&gt;(Whichever folder contains your app)&gt;Documents 

folder, but I can&#39;t find it in IOS 8.  I would assume they would just add an 8.0 folder inside the iPhone Simulator folder, but it&#39;s not there.  Has anybody been able to locate it?



Sqlite File Location Core Data

In Xcode 6, I have an app I&#39;m using Core Data in, but there is no folder in Application Support for the iOS 8 iPhone Simulator. Where are my files and Core Data sqlite database being stored?

Xcode 6 iPhone Simulator Application Support location

In CoreData I have defined an *unordered* to-many relationship. This relationship is defined in Swift like this:

    @NSManaged var types : NSMutableSet

However, to use Swift at it&#39;s best, I want to use a normal Swift array like `Type[]`. However, CoreData forces me to use `NS(Mutable)Set`. How can I type-cast / convert the `NSSet` to `Array&lt;Type&gt;[]`?

Convert NSSet to Swift Array

In my .plist file, I have &quot;*View controller-based status bar appearance*&quot; set to `NO`. But after `UIImagePickerController`, my app behaves as if the option is set to `YES`.


In my app, I present a VC that presents a `UIImagePickerController`.

The problem happens like this:

 - After photo picker is presented, when a photo library is picked, the color of the status bar text changes. 
 - Then once, `UIImagePickerController` is dismissed, status bar spacing
   changes for the rest of my app and all the navigation bar for other controllers displays under the status bar.

Is there a way to solve this without managing status bar in my view controllers?



UIImagePickerController breaks status bar appearance

For some web pages we use the swipe left and right functionality of iPhone to pull up the menus. 
Now with iOS7, they have introduced the ability to go back and forward to previous and next pages of browser history on swipe left and right motions.

But is there a way to disable it for specific pages so as to not have conflicting behavior on the swipe actions?

Content Type	Original Author	Original Content on Stackoverflow
Question	FrankZp	View Question on Stackoverflow
Solution 1 - Ios	Andy Etheridge	View Answer on Stackoverflow

Core Data and iOS 7: Different behavior of persistent store

Ios Problem Overview

Ios Solutions

Solution 1 - Ios

Project structure for MVVM in WPF

How to record phone calls in android?

Attributions