Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Almost any function (except for <code>require</code>) which takes file paths as an argument, will at one point use functions from the <code>fs</code> module to read from or write to them. </p> <p><a href="http://nodejs.org/api/fs.html">Node.js documentation for fs module</a> says:</p> <blockquote> <p>Relative path to filename can be used, remember however that this path will be relative to process.cwd().</p> </blockquote> <p>When you think about it, it would require major trickery to have these functions behave any differently. After all, the fs functions are regular Javascript and they don't have special access to information about the caller. The only <code>__dirname</code> they could access would be the <code>__dirname</code> of their own module (the core fs module).</p> <p>The fact that the <code>require</code> function <em>can</em> resolve paths relative to the current <code>__dirname</code>, without specifying this explicitly, is because <code>require</code> is a unique function for every single file it appears in. This way, it has access to the current module's specifics, and in particular its path.</p> <p>The reason your code happens to work is that currently, the <code>app.js</code> (or similar) the code above appears in happens to be in the same directory as what <code>process.cwd()</code> currently is. I.e. starting the app with <code>node app.js</code> would work, while starting the app with <code>node myappdir/app.js</code> (ran from its parent directory) would not. <code>process.cwd()</code> would be different.</p> <p>As long as you keep in mind that relative paths will be resolved via <code>process.cwd()</code>, then you could use the shorter syntax. In some cases it can be an advantage. It does make your code dependent on how it's called though. I personally prefer using <code>__dirname</code>, because it's somewhat more transparent as to what's happening, and the relative paths consistent with the paths you use in a <code>require</code> statement for the same file.</p>
    singulars
    1. This table or related slice is empty.
    1. PONode js/Express js relative paths (dot or __dirname or without any prefix)?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMyrne Stol
    1. USMyrne Stol
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PONode js/Express js relative paths (dot or __dirname or without any prefix)?
      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. COThanks, very informative. So if I understand: `require` will always be relative to the current file (using `dot` or `__dirname`). All other paths - which probably go through `fs`, can be relative to the process with a `dot`, and relative to the calling-file if passed with `__dirname`
      singulars
      1. PO
      1. USRaekye
    2. COExactly. But doing `__dirname + "some path"` is just regular string concatenation. It's a special way of calling a function or so. It results in an absolute path, leaving out any room for interpretation.
      singulars
      1. PO
      1. USMyrne Stol
 

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