Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>A UUID created by <code>CFUUIDCreate</code> <em>is</em> unique if a user uninstalls and re-installs the app: you will get a new one each time.</p> <p><strike>But you might want it to be <em>not</em> unique, i. e. it should stay the same when the user uninstalls and re-installs the app. This requires a bit of effort, since the most reliable per-device-identifier seems to be the MAC address. You could <a href="https://stackoverflow.com/questions/677530/how-can-i-programmatically-get-the-mac-address-of-an-iphone">query the MAC</a> and use that as UUID.</p> <p><strong>Edit:</strong> One needs to always query the MAC of the same interface, of course. I guess the best bet is with <code>en0</code>. The MAC is always present, even if the interface has no IP/is down.</strike></p> <p><strong>Edit 2:</strong> As was pointed out by others, the preferred solution since iOS 6 is <a href="http://developer.apple.com/library/ios/documentation/uikit/reference/UIDevice_Class/Reference/UIDevice.html#//apple_ref/occ/instp/UIDevice/identifierForVendor" rel="noreferrer">-[UIDevice identifierForVendor]</a>. In most cases, you should be able use it as a drop-in replacement to the old <code>-[UIDevice uniqueIdentifier]</code> (but a UUID that is created when the app starts for the first time is what Apple seems to want you to use).</p> <p><strike><strong>Edit 3:</strong> So this major point doesn't get lost in the comment noise: do not use the <em>MAC</em> as UUID, create a <em>hash using the MAC</em>. That hash will always create the same result every time, even across reinstalls and apps (if the hashing is done in the same way). Anyways, nowadays (2013) this isn't necessary any more except if you need a "stable" device identifier on iOS &lt; 6.0.</strike></p> <p><strong>Edit 4:</strong> In iOS 7, Apple now always returns a fixed value when querying the MAC to specifically thwart the <em>MAC as base for an ID</em> scheme. So you now really should use <a href="http://developer.apple.com/library/ios/documentation/uikit/reference/UIDevice_Class/Reference/UIDevice.html#//apple_ref/occ/instp/UIDevice/identifierForVendor" rel="noreferrer">-[UIDevice identifierForVendor]</a> or create a per-install UUID.</p>
    singulars
    1. This table or related slice is empty.
    1. POUIDevice uniqueIdentifier Deprecated - What To Do Now?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USDarkDust
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUIDevice uniqueIdentifier Deprecated - What To Do Now?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODoes the mac address not change depending on whether the user is connected via Wifi or not?
      singulars
      1. PO
      1. USOliver Pearmain
    2. CONo, the IP does, but not the MAC. The [MAC is unique to the interface](http://en.wikipedia.org/wiki/MAC_address).
      singulars
      1. PO
      1. USDarkDust
    3. CO@DarkDust: but since the active interface changes when you switch from wifi to cellular modem, the MAC address of the active interface should also change; unless you always pick a particular interface to get the MAC
      singulars
      1. PO
      1. USuser102008
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload