Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>After some research, I think the best answer is <a href="http://xerces.apache.org/" rel="noreferrer">Xerces</a>, as it implements all of XSD, is cross-platform and widely used. I've created a <a href="https://github.com/amouat/xsd-validator" rel="noreferrer">small Java project on github</a> to validate from the command line using the default JRE parser, which is normally Xerces. This can be used on Windows/Mac/Linux. </p> <p>There is also a <a href="https://xerces.apache.org/xerces-c/" rel="noreferrer">C++ version of Xerces</a> available if you'd rather use that. The <a href="http://xerces.apache.org/xerces-c/stdinparse-3.html" rel="noreferrer">StdInParse utility</a> can be used to call it from the command line. Also, a commenter below points to this <a href="http://jmvanel.free.fr/xsd/" rel="noreferrer">more complete wrapper utility</a>.</p> <p>You could also use xmllint, which is part of <a href="http://xmlsoft.org/" rel="noreferrer">libxml</a>. You may well already have it installed. Example usage:</p> <pre><code>xmllint --noout --schema XSD_FILE XML_FILE </code></pre> <p>One problem is that libxml doesn't implement all of the specification, so you may run into issues :(</p> <p>Alternatively, if you are on Windows, you can use <a href="http://msdn.microsoft.com/en-us/library/ms763742.aspx" rel="noreferrer">msxml</a>, but you will need some sort of wrapper to call it, such as the GUI one described in this <a href="http://www.ddj.com/architect/184416391" rel="noreferrer">DDJ article</a>. However, it seems most people on Windows use an XML Editor, such as Notepad++ (as described in <a href="https://stackoverflow.com/a/1088659/4332">Nate's answer</a>) or <a href="http://www.microsoft.com/en-us/download/details.aspx?id=7973" rel="noreferrer">XML Notepad 2007</a> as <a href="https://stackoverflow.com/a/3915105/4332">suggested by SteveC</a> (there are also several commercial editors which I won't mention here).</p> <p>Finally, you'll find different programs will, unfortunately, give different results. This is largely due to the complexity of the XSD spec. You may want to test your schema with several tools.</p> <p><strong>UPDATE</strong>: I've expanded on this in a <a href="http://www.adrianmouat.com/bit-bucket/2013/11/xml-schema-validation/" rel="noreferrer">blog post</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POXML Schema (XSD) validation tool?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USAdrian Mouat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POXML Schema (XSD) validation tool?
      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. COI found the following helpful: http://jmvanel.free.fr/xsd/README.html
      singulars
      1. PO
      1. USMatthew Hegarty
    2. COAn example StdinParse usage (on linux) migth be useful: StdInParse -n -s -f -v=always < XML_FILE . XML_FILE should include schema location. For me it gives more complete results than xmllint.
      singulars
      1. PO
      1. UShelcim
 

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