Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The OP's question is simple enough, but as @Pekka mentioned (or hijacked), this could be a much deeper question (requiring a more substantial answer). Yes, Python's syntax is easy enough to learn without a book, but like any other language, it still takes quite a bit of time to master.</p> <p>The suggest of Dive Into Python is valid, although the Python 3 version is only for newbies with no baggage (meaning no existing Python code, no libraries/dependencies that haven't been ported to Python 3 yet, etc.). Sadly Mark has removed most of his online content. Here is one archive of his Python 3 book: <a href="http://www.diveintopython3.net" rel="nofollow noreferrer">http://www.diveintopython3.net</a> ... it is a very good high-level introduction to the language by immersing you into coding bits right away.</p> <p>If you are looking for something slightly more comprehensive, I wrote <a href="http://corepython.com" rel="nofollow noreferrer">Core Python Programming</a> specifically targeted towards programmers already literate in another high-level language like Java, C/C++, PHP, Ruby, etc., who need to learn Python as quickly and as in-depth as possible... it's more like a "deep dive" than a "quick dive." For pure reference books that you can pull off the shelf as necessary, I would suggest either Beazley's <a href="http://dabeaz.com/per.html" rel="nofollow noreferrer">Python Essential Reference</a> or Martelli's <a href="http://oreilly.com/catalog/9780596100469/" rel="nofollow noreferrer">Python in a Nutshell</a>... both are excellent, altho Alex's book is not rev'd to the latest Python releases yet. I'm sure he's working on it tho. ;-)</p> <p>[UPDATED Jun 2015] Back on hijacked topic, there are several options when it comes to developing web apps on Python, the most popular currently is <a href="http://djangoproject.com" rel="nofollow noreferrer">Django</a>. That is a full-stack web framework that is the closest thing that Python has to Ruby on Rails. It has templating, an ORM, can run on various core components (RDBMSs, webservers, JavaScript libraries, etc.), comes with an amazing admin interface, and a whole lot more. For even more functionality, also take a look at <a href="http://pinaxproject.com" rel="nofollow noreferrer">Pinax</a>. An alternative to Django is <a href="http://pylonsproject.org" rel="nofollow noreferrer">Pyramid</a>. Instead of a single monolithic framework, Pyramid/Pylons act more like glue, tying together best-of-breed components, i.e., <a href="http://jinja.pocoo.org" rel="nofollow noreferrer">Jinja2</a> for templating, <a href="http://www.sqlalchemy.org/" rel="nofollow noreferrer">SQLAlchemy</a> for the ORM, <a href="http://www.mochikit.com/" rel="nofollow noreferrer">MochiKit</a> as the JS library, etc. The 3rd option, primarily for high-trafficked, low-latency, scalable apps is <a href="http://cloud.google.com/appengine" rel="nofollow noreferrer">Google App Engine</a>. You write your apps in Python (or Java, PHP, or Go) and upload to Google to run your app on their infrastructure. Most of the development will be similar to developing web apps on a standard LAMP stack, <em>except</em> for the datastore. Based on Google's <a href="http://research.google.com/archive/bigtable.html" rel="nofollow noreferrer">BigTable</a>, it's a non-relational distributed object database, so the largest hurdle is overcoming thinking in a relational DB way; also released independently as <a href="http://cloud.google.com/datastore" rel="nofollow noreferrer">Google Cloud Datastore</a>. There's also a relational MySQL-compatible alternative called <a href="http://cloud.google.com/sql" rel="nofollow noreferrer">Google Cloud SQL</a> should you prefer that instead of a NoSQL solution. BigTable is also available as a standalone technology from App Engine and available as <a href="http://cloud.google.com/bigtable" rel="nofollow noreferrer">Google Cloud Bigtable</a>. That enough options for you?!? :-)</p> <p>Hope this helps!</p> <p>ps. If you're looking for an upcoming <a href="http://cyberwebconsulting.com" rel="nofollow noreferrer">comprehensive 3-day course in Python</a>, talk to me. :-)</p>
    singulars
    1. This table or related slice is empty.
    1. POLearning Python coming from PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USwescpy
    1. USwescpy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLearning Python coming from PHP
      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. COYet another great example of pythonist nice.
      singulars
      1. PO
      1. USHugo Estrada
 

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