Databases
StackOverflow2013
Usersdbo
USMosty Mostacho
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMosty Mostacho
    primarykey
    data
    text
    <h1>Useful online tools for StackOverflow</h1> <p><strong>SQL</strong></p> <p><a href="http://sqlfiddle.com/#!2/a2581/1" rel="nofollow noreferrer">SQLFiddle</a><br> <a href="http://data.stackexchange.com/stackoverflow/query/new" rel="nofollow noreferrer">StackOverflow MSSQL</a><br> <a href="http://sqlize.com" rel="nofollow noreferrer">SQLize</a><br> <a href="http://sqlzoo.net/create_view.htm" rel="nofollow noreferrer">SQLZoo</a> </p> <p><strong>Regex</strong></p> <p><a href="http://regexpal.com" rel="nofollow noreferrer">RegexPal</a> (Generic)<br> <a href="http://www.regexr.com" rel="nofollow noreferrer">Regexr</a> (Generic)<br> <a href="http://regex101.com" rel="nofollow noreferrer">Regex101</a> (Generic)<br> <a href="http://rubular.com" rel="nofollow noreferrer">Rubular</a> (Ruby)<br> <a href="http://regex.larsolavtorvik.com" rel="nofollow noreferrer">LarsoLavtorvik</a> (PHP)<br> <a href="http://myregextester.com" rel="nofollow noreferrer">MyRegexTester</a> (.NET, PHP, JS, JAVA)</p> <p><strong>Programing Languages</strong></p> <p><a href="http://ideone.com" rel="nofollow noreferrer">IDEOne</a> </p> <p><strong>Others</strong></p> <p><a href="http://ondras.zarovi.cz/sql/demo/" rel="nofollow noreferrer">Table modeller</a><br> <a href="http://www.sensefulsolutions.com/2010/10/format-text-as-table.html" rel="nofollow noreferrer">Text as table</a><br> <a href="http://json.parser.online.fr" rel="nofollow noreferrer">Json Parser</a><br> <a href="http://videlibri.sourceforge.net/cgi-bin/xidelcgi" rel="nofollow noreferrer">XPath</a></p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. POHow to address multiple columns as one in MySQL?
      singulars
      1. PTQuestion
    1. POGetting last occurrence of a string using regular expressions
      singulars
      1. PTQuestion
    2. POSimple Django validation with multiple parameters issue
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat is the best database schema to support values that are only appropriate to specific rows?
      1. USMosty Mostacho
      1. VTFavorite
    2. VO
      singulars
      1. POMySQL How do I create this subquery?
      1. USMosty Mostacho
      1. VTBountyStart
    3. VO
      singulars
      1. POHow to generate data in MySQL?
      1. USMosty Mostacho
      1. VTFavorite
    1. COOh. Download Firefox, download Tamper Data plugin, disable javascript and play around... you'll see what I a talking about. Then remove the Referer item and you'll see what I mean ;) That's all no more commenting it is getting loooong
      singulars
      1. PO
      1. USMosty Mostacho
    2. COThen you should follow step by step what that url does: It first returns an HTTP result of 302 with a location "/srtcache/blahblah.srt". Then it gets redirected to that location hitting the file. See that? Now, as of my few tries, you WON'T be able to fech the file if you do not set the proper REFERER header to the HTTP request (fake it as if you were a browser), and that should be enough. I've used Referer=http://www.addic7ed.com/serie/Supernatural/4/6/addic7ed
      singulars
      1. PO
      1. USMosty Mostacho
    3. CONo, I mean this: URL url = new URL("http://www.addic7ed.com/srtcache/Supernatural/Supernatural%20-%2004x06%20-%20Yellow%20Fever.720p%20CTU.English.orig.Addic7ed.com.srt");
      singulars
      1. PO
      1. USMosty Mostacho
 

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