Scripts Index
Popular Trends
Trending Topics
Python Database Tools  

SQLAlchemy

download download home home   report broken
important script information
company name:
sourceforge.net
license: Free
minimum requirements: Python
functional limitations:
SQLAlchemy description


SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language. SQL databases behave less and less like object collections the more size and performance start to matter; object collections behave less and less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accommodate both of these principles.

SQLAlchemy doesn't view databases as just collections of tables; it sees them as relational algebra engines. Its object relational mapper enables classes to be mapped against the database in more than one way. SQL constructs don't just select from just tables—you can also select from joins, subqueries, and unions. Thus database relationships and domain object models can be cleanly decoupled from the beginning, allowing both sides to develop to their full potential. Different parts of SQLAlchemy can be used independently of the rest. You can use the connection pool by itself and deal with raw connections; or you can use the SQL construction language by itself, either in direct conjunction with one or more database connections or as standalone constructs which return their string-compiled contents. While SQLAlchemy has a great ORM provided, the other parts have no dependency on it; its usage is completely optional. Simpler facades for the ORM can be used as well, such as the ActiveMapper and SqlSoup extension modules. SQLAlchemy is architected in an open style that allows plenty of customization, supporting user-defined datatypes, custom SQL extensions, and a plugin system which can augment or extend any functionality including SQL expressions and ORM behavior.



Relates:
Database - Sql - Toolkit - Database Tool - Database Access - Sql Toolkit
Similar scripts
DBF reader and writer (Popularity: ) : In this script the reader iterates over records in Dbase or Xbase files and the writer creates dbf files from Python sequences.
OraSchemadoc (Popularity: ) : OraSchemadoc provides "JavaDoc" style detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static html files.Features:- data about all tables, including columns- table constraints(check, unique and referential)- indexes, including functional ...
MS SQL Server Database Mover (Popularity: ) : This script automates the movement of databases from one Microsoft SQL Server to another. It is designed to detach, copy, and reattach database files with a single call. It could be used to move databases with a minimum of downtime. ...
Create table statements for MS Access tables (Popularity: ) : This script parses the output of MS Access's documenter report and generates sql create table statements for the tables in the report.
Python Hyperschema (Popularity: ) : Python Hyperschema is an open source public domain project that creates very useful HTML hypermaps from SQL database schema, which consists of two small PL/SQL files and one Python (or C) source code file. The thus generated HTML pages have ...
Dump a database file to a pickle (Popularity: ) : This script converts the database file given on the command line to a pickle representation.The default is hash. If a pickle file is named it is opened for write access (deleting any existing data). If no pickle file is named, ...
SICKnotes (Popularity: ) : SICKnotes which is a short form for site inventory, configuration and knowledge is a web tool which is based on the permissions that assists with inventory, system changes, contact info, and knowledge for anything from a small startup to a ...
MS SQL Server log monitor (Popularity: ) : MS SQL Server log monitor is a script that gathers errors, warnings, and failures from Micrsoft SQL Servers and SQL Server Agents. It creates a single HTML file from multiple server logs.It could be used as a quick daily check to determine ...
Book Database (Popularity: ) : Book Database script allows you to learn programming database applications.
Read tabular data from Excel spreadsheets (Popularity: ) : Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC mxODBC), ...
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Similar Software
SQLAlchemy (Popularity: ) : SQLAlchemy is a SQL toolkit and object relational mapper for Python.

The Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, ...

sqlautocode for Linux (Popularity: ) : sqlautocode is an SQLAlchemy extension to create a Python code model for a database.

This is a slightly different approach to SqlSoup, that lets you use tables without explicitly defining them.

Call autocode.py --help for a list of available self explaining options.

Example:

autocode.py ...

SchemaBot (Popularity: ) : SchemaBot is a database schema version control library for SQLAlchemy.. chrismiles / SchemaBot / wiki / Home — bitbucket.org.
gozerplugs (Popularity: ) : gozerplugs is a Python module that contains a gozerbot plugin.

About gozerbot

gozerbot is the Python IRC bot and Jabber bot in one.

Why gozerbot?

* provide both IRC and Jabber support
* user management by userhost .. bot will not respond if ...

BlastOff (Popularity: ) : BlastOff is a Python module that offers template. Applications created from it will have no dependency on BlastOff after creation. The application will be a standard Pylons project with a number of pre-configured dependencies to help accelerate development of Pylons ...
Lamson for Mac (Popularity: ) : Lamson is a pure Python SMTP server designed to create robust and complex mail applications in the style of modern web frameworks such as Django.

Unlike traditional SMTP servers like Postfix or Sendmail, Lamson has all the features of a web ...

pyHed (Popularity: ) : pyHed its a framework created to help developers to create desktop aplications cross-plataform using Python. Using pyQT and sqlAlchemy, the pyHed framework transforms the job of creating and support aplications much more easy and fast. pyHed Team
PyCharm for Mac OS X 2.6 B (Popularity: ) : JetBrains PyCharm OCo Python IDE with complete set of tools for productive development with Python programming language. In addition, the IDE provides high-class capabilities for professional Web development with Django framework. Coding Assistance Code faster and with more pleasure in ...
PyCharm for Linux 2.6 B (Popularity: ) : JetBrains PyCharm OCo Python IDE with complete set of tools for productive development with Python programming language. In addition, the IDE provides high-class capabilities for professional Web development with Django framework. Coding Assistance Code faster and with more pleasure in ...
PyCharm 2.6 B (Popularity: ) : JetBrains PyCharm OCo Python IDE with complete set of tools for productive development with Python programming language. In addition, the IDE provides high-class capabilities for professional Web development with Django framework. Coding Assistance Code faster and with more pleasure in ...
ad


Rate me
supported os
All
stats
downloads 2
version 0.3.7
size in Kb
popularity   
812/377128
user rating 5/10
New Scripts
Popular Scripts
Latest Reviews