Table of Contents

1. Introduction
   • Basic Structure
   • Simple Example
   • Design Goals
   • Obtaining and Installing
   • Compared To Other Database Wrappers
2. Application Designers: Using Geniusql to construct a model
   • The Database Object
   • Schemas
     • Automatic Table Classes
   • Tables
     • Creating Tables in the Database
   • Columns
     • The datetime.datetime type
     • ID Columns
     • Column Metadata
     • Sequencing
   • Rows
     • Single Rows
     • Multiple Rows
   • References between Tables
   • Indices
3. Application Developers: Using Geniusql to manage data
   • Expressions
     • The Expression class
     • Early binding
     • External functions within Expressions
     • Using filter to form Expressions
     • Using comparison to form Expressions
     • Combining Expressions
     • Specifying types for Expression kwargs
     • Exporting the logic module
   • Select
     • Keyword arguments
     • Table.select
     • Table.select_all
     • Database.select
   • insert_into
   • Query Objects
     • Joins
       • Argument Order
   • Transactions
4. Deployers: Configuring Storage
   • Providers
     • Microsoft SQL Server / Microsoft Access (Jet)
     • PostgreSQL (pyPgSQL)
     • PostgreSQL (psycopg2)
     • MySQL (MySQLdb)
     • SQLite (pysqlite/sqlite3)
     • Firebird (kinterbasdb)
     • Common Database Attributes
   • Provider Comparison Chart
5. Advanced Topics
   • Passing through SQL
   • Custom Providers
     • Generic Database Wrappers
       • Type Mapping
       • DatabaseTypes
       • Adapters
       • Decompiler
       • Database/Table/IndexSet
     • Legacy Database Wrappers