Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>yeah there are some pitfalls, but most of the time, in practice, they turn out to be enemy <a href="http://en.wikipedia.org/wiki/Tilting_at_windmills" rel="noreferrer">windmills of the Quixotic style</a>, i.e. imaginary, and nothing to worry about in reality. </p> <p>I would estimate that the pitfalls one is <em>most likely to encounter</em> are (including mitigating steps identified):</p> <ol> <li><p><strong>working with others a.k.a. collaboration</strong> </p> <p>a. if you have others which for whatever reason refuse to adhere to <a href="http://www.python.org/dev/peps/pep-0008/" rel="noreferrer">PEP 8</a>, then it could become a pain to maintain code. I've never seen this in practice once I point out to them the almost universal convention for python is <strong>indent level == four spaces</strong> </p> <p>b. get anyone/everyone you work with to accept the convention and have them figure out how to have their editor automatically do it (or better yet, if you use the same editor, show them how to configure it) such that copy-and-paste and stuff <em>just works</em>. </p></li> <li><p><strong>having to invest in a "decent" editor other than your current preferred one, if your current preferred editor is not python friendly</strong> -- not really a pitfall, more an investment requirement to avoid the other pitfalls mentioned associated with copy-and-paste, re-factoring, etc. stop using Notepad and you'll thank yourself in the morning.</p> <p>a. your efficiency in editing the code will be much higher under an editor which understands <code>python</code></p> <p>b. most <em>modern</em> code editors handle python decently. I myself prefer GNU Emacs, and recent versions come with excellent <code>python-mode</code> support out-of-the-box. The are plenty of <a href="http://wiki.python.org/moin/PythonEditors" rel="noreferrer">other editors to explore</a>, including many free alternatives and <a href="http://wiki.python.org/moin/IntegratedDevelopmentEnvironments" rel="noreferrer">IDEs</a>.</p> <p>c. python itself comes out of the box with a "smart" python editor, <code>idle</code>. Check it out if you are not familiar, as it is probably already available with your python install, and may even support <code>python</code> better than your current editor. <a href="http://wxpython.org/py.php" rel="noreferrer">PyCrust</a> is another option for a python editor implemented in python, and comes as part of wxPython.</p></li> <li><p><strong>some code generation or templating environments that incorporate python (think HTML generation or python CGI/WSGI apps) can have quirks</strong></p> <p>a. most of them, if they touch python, have taken steps to minimize the nature of python as an issue, but it still pops up once in a while.</p> <p>b. if you encounter this, familiarize yourself with the steps that the framework authors have already taken to minimize the impact, and read their suggestions (<em>and yes they will have some if it has ever been encountered in their project</em>), and it will be simple to avoid the pitfalls related to python on this.</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POAre there any pitfalls with using whitespace in Python?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USpopcnt
    1. USpopcnt
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAre there any pitfalls with using whitespace in Python?
      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. VTUpMod
    1. CO+1: 1. PEP 8. 2. ALl modern editors handle Python indent-outdent. Point 3 is so obscure as to be a non-concern -- I like the irony of picking something really obscure.
      singulars
      1. PO
      1. USS.Lott
    2. CO@S. Lott: thanks for the feedback. yeah, I felt like I was stretching with #3. mostly because the other two "pitfalls" are also mentioned above, but IMHO do not usually amount to anything in the "real world"...
      singulars
      1. PO
      1. USpopcnt
 

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