postgresAndPython_v1.0

What's Changed

• Connecting to the PostgreSQL #88 by @oldoc63 in #89
• create a table using Python psycopg2 #88 by @oldoc63 in #90
• To modify a table include .commit() #88 by @oldoc63 in #91
• Retrieve data from a table #88 by @oldoc63 in #92
• Creating a new table #93 by @oldoc63 in #94
• This syntax requires to remember the order of the columns #95 by @oldoc63 in #96
• Alternatively you can list the columns explicitly #95 by @oldoc63 in #97
• list columns in a different order or even omit some columns #95 by @oldoc63 in #98
• • is a shorthand for all columns #99 by @oldoc63 in #100
• Write expressions, not just simple column references, in the select l… by @oldoc63 in #101
• WHERE claus specifies which rows are wanted #99 by @oldoc63 in #102
• results of a query can be returned in sorted order #99 by @oldoc63 in #103
• Sort fully specified #99 by @oldoc63 in #104
• Duplicate rows can be removed from the result of a query #99 by @oldoc63 in #105
• Consistent results by using DISTINCT and ORDER BY #99 by @oldoc63 in #106
• with closes automatically cursor but not conexion #99 by @oldoc63 in #107
• Improving modify_table #95 by @oldoc63 in #108
• Join: accesses multiple rows of the same or different tables at one t… by @oldoc63 in #110
• Better to list the output columns explicitly rather than using * #109 by @oldoc63 in #111
• qualify the column names #109 by @oldoc63 in #112
• INNER JOIN alternatively #109 by @oldoc63 in #113
• This kind of query is called an outer join #109 by @oldoc63 in #114
• We can also join a table against itself #109 by @oldoc63 in #115
• use aliases to save some typing #109 by @oldoc63 in #116
• Computes a single result from multiple input rows #117 by @oldoc63 in #118
• WHERE has to be evaluated before aggregate functions are computed #117 by @oldoc63 in #119
• Aggregates in combination with GROUP BY #117 by @oldoc63 in #120
• We can filter these grouped rows using HAVING #117 by @oldoc63 in #121
• If we only care about cities whose names begin with 'S' #117 by @oldoc63 in #122
• Update existing rows using the UPDATE command #123 by @oldoc63 in #124
• New state of the data #123 by @oldoc63 in #125
• We are no longer interested in the weather of Hayward #126 by @oldoc63 in #127
• Views can be used in almost as a table #128 by @oldoc63 in #129
• Maintaining the referential integrity of your data #130 by @oldoc63 in #131
• city in weather references cities(name) #130 by @oldoc63 in #132
• Violates foreign key constraint #130 by @oldoc63 in #133
• Using commit and rollback #134 by @oldoc63 in #135
• Transactions are all or none #134 by @oldoc63 in #136
• Two sentences one transaction: all or none #134 by @oldoc63 in #137
• Using with to avoid .commit() #134 by @oldoc63 in #138

Full Changelog: contextManager...postgresAndPython_v1.0