Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The <a href="https://github.com/igbinary/igbinary" rel="noreferrer"><code>igbinary</code> <sup><strong>PHP extension</strong></sup></a> does offer a new session serialize/deserialize handler that differs from PHP's own implementations, namely <code>php</code> and <code>php_binary</code>.</p> <p>To answer your question: <strong>These handlers do not compare at all, they are totally different.</strong> The differences <em>igbinary</em> introduces are documented within the projects readme.</p> <p>I assume you're asking the question because you found the word <em>binary</em> within the two: ig<i>binary</i> and php_<em>binary</em>. However that's not saying much. Compare the <code>php</code> with the <code>php_binary</code> handler first: </p> <p>The <code>php_binary</code> session serialize/deserialize handler is nearly identical with the default <code>php</code> handler. They differ only how the variable names that are within the session are encoded.</p> <p><code>php_binary</code> will prefix all session variable names with the binary length of the name. While with <code>php</code> each variable name has a suffix of the <code>|</code> character (<code>\x7C</code>, decimal <code>124</code>). From what I know, the serialization of the variable's values does not differ at all.</p> <p>So the serialization of values is identical between the <code>php</code> and <code>php_binary</code> handler.</p> <p>So next to the little difference in pre-/suffix of session variable names, the question actually asks about how does <code>igbinary</code> compare with php serialization (which is used in the session data). Those differences are outlined in the <a href="https://github.com/igbinary/igbinary#readme" rel="noreferrer"><code>igbinary</code> readme</a>. It fairly well describes what's done and why.</p> <p>If you like to use <code>igbinary</code> serialization as well for serialize/unserialize, the extension offers two replacement functions:</p> <p><code>igbinary_serialize</code> and <code>igbinary_unserialize</code> - used like their php cousins.</p> <p>If you are concerned about some specifics of the differences, please ask.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat is the php_binary serialization handler?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UShakre
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat is the php_binary serialization handler?
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for the answer! No, I'm pretty clear on how igbinary works, I just couldn't find any information on php_binary when I googled it.
      singulars
      1. PO
      1. USToxikman
    2. CO@Toxikman: Okay, fine then. Most documentation is within "source" :). Both, the `php` and `pbp_binary` formats are not much described in the PHP Manual. You can always look into the C sourcecode and/or reverse engineer the formats.
      singulars
      1. PO
      1. UShakre
    3. COYeah, but that would have taken be 10 times longer than googling the answer, and then by posting a question on StackOverflow about it, and thanks to you, the answer is now readily available for anyone to find on the internets. :-)
      singulars
      1. PO
      1. USToxikman
 

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