PUBLIC MARKS from roberto with tag sql

Decimail is a pair of email applications: * Decimail Webmail is a web-based email client. It uses predominantly client-side code - i.e. Javascript in you web browser - to deliver a highly-responsive application. * Decimail Server is an IMAP email server that uses a PostgreSQL database for message storage. Mailboxes are defined by SQL queries, making complex message searchng and categorisation possible. Both applications use the standard email protocols, IMAP and SMTP. So although Webmail and Server can be used together, this is not necessary: subject to bugs, Webmail can be used with any IMAP server and Server can be used with any IMAP client.

The usual way to make a request to a database is to write a string with the SQL syntax, then execute this request and get the result as a list with cursor.fetchall() or cursor.fetchone() Python has list comprehensions to select items in an iterable if a certain condition is true ; this is very similar to database requests This recipe wraps a table of a DB-API compliant database in a class that implements the iteration protocol, so that you can use the for ... in ... if ... syntax

This chapter covers a variety of topics that should round out your knowledge of PostgreSQL.

Beautiful.

A convenience wrapper for SQLObject.