Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not sure I understand exactly what your situation is, but I can think of a few possibilities.</p> <ul> <li>The two databases are <strong><em>exactly</em></strong> the same. If run a checksum on both directories the hashes match.</li> </ul> <p>In this case, why do you need the two copies? You can run multiple q processes off the same copy of the database. In fact, this is preferable because you benefit from the shared caching provided by the OS disk cache. Just delete one of the copies and point all q processes to the same directory.</p> <ul> <li>The two databases contain data loaded from the same source, but are otherwise not the same. If I query each of the databases with the same query, I may get the same result but the checksums of the files do not match.</li> </ul> <p>This can happen if the databases were created independently but with the same source data. Unless you actually made a copy of the files, you can't really assume the databases are the same. An obvious example is that you had a bunch of files that you loaded into each database but the order of the files loaded were different for each database. In this case you <strong><em>cannot</em></strong> use the same sym file! Doing so will make the data <strong><em>look</em></strong> OK at first glance, but all your sym values are wrong. If you do want to combine the two databases for some reason, you will need to take data from one database and load it into the other. This is the only reliable way to be 100% certain you don't corrupt your data.</p> <ul> <li>You have two different database that each contain the exact same table (in the checksum sense, maybe you copied the table files from one directory to another).</li> </ul> <p>This probably will not work unless by some miracle the sym values all match, which they won't if the rest of the database is different. This is because the enumerated sym values are global and dependent on all sym values in the database. If you want the table in both databases, you will need to reenumerate the sym columns for whichever database you copy to.</p>
    singulars
    1. This table or related slice is empty.
    1. POMerging sym files for splayed tables
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USmpud
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMerging sym files for splayed tables
      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. COThe databases aren't exactly the same they just contain the same data format. So looks like I will have to read one and save it to the other. Thank you for your help.
      singulars
      1. PO
      1. USGeoffrey Absalom
 

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