Object-Relational Bridge for python

Grok Headline matches for Object-Relational Bridge for python

Apache Releases Object Relational Bridge

Apache Releases Object Relational Bridge 04/05/2005 06:56 PM

Object Relational Membrane 1.0

Object Relational Membrane 1.0 07/01/2004 06:52 PM
A small but efficient interface between Python objects and SQL tables.

Object relational mappings are
over-rated...

Object relational mappings are
over-rated... 01/01/2004 06:18 PM

... At least according to Tim Bray:

Lots of architects have learned, painfully, that you usually can't magick relational rows away behind object/class abstractions. The right way to think about a database is as a set of normalized tables that are designed to be addressed with SQL strings.

This brings in to focus something I've been thinking about for quite a while. I always try to abstract away the details of the data storage layer behind some kind of interface, so that none of my front end code ever has to make a direct database call, instead calling methods on my application objects with names like "get_user_by_id" or "get_blog_entries_for_date". The idea is that I could, if I wanted to, completely switch out the underlying data source. I should also be able to write new front-end functionality that calls the existing application layer methods without having to change anything in the data access code.

There are a couple of problems here. Firstly, I've already got a data abstraction layer in the form of SQL. Although there are many discrepancies between implementations, basic SQL statements such as selects and joins should work on pretty much any database. Additionally, in my three years of building web applications I can't think of a single time I've needed to change the data layer for an existing application.

Modern database features such as stored procedures and constraints allow you to move huge chunks of application logic that relates to data coherency in to the database itself. In fact, PostgreSQL even allows you to write stored procedures in third party languages such as Python or Perl. With carefully written stored procedures, much of the important application logic could live in the database along with the data itself - a concept comparable to object oriented programming where the data and the methods that can be run on the data are encapsulated together.

I certainly haven't made up my mind one way or the other, and at the end of the day the best approach is the one that gets a project completed in a reasonable time frame and that results in easily maintainable code. Plenty of food for thought, in any case.

Cayenne Object-Relational Framework

Cayenne Object-Relational Framework 06/16/2004 12:33 AM
Cayenne Article on TheServerSide.com

JGrinder Object/Relational Mapping

JGrinder Object/Relational Mapping 07/06/2004 01:51 PM
JGrinder - Initial JDO Support

JDBF (Object-Relational mapping system)

JDBF (Object-Relational mapping system) 01/06/2005 07:21 AM
Release Candidate 0.1.1 has been released

Versant to Buy Object-Relational Mapping
Tool

Versant to Buy Object-Relational Mapping
Tool 06/30/2004 02:46 PM
Its purchase of JDO Genie, a mapping product that also includes a set of design-time tools, will allow it to help enterprises cope with the flurry of standards being introduced into the data-access space, officials said.

Microsoft bridging relational, object,
XML data models

Microsoft bridging relational, object,
XML data models 03/22/2005 07:27 PM
Microsoft Research has had 7,000 downloads of its Comega programming technology, which is intended to bridge the gap between relational, object, and XML data models.

Two open source object-relational
projects afoot in Eclipse

Two open source object-relational
projects afoot in Eclipse 04/19/2005 08:38 AM
A tale of dueling open source projects for object-relational mapping may be brewing within Eclipse, with similar proposals floated by Versant and Oracle.

Two open source object-relational
projects afoot in Eclipse (InfoWorld)

Two open source object-relational
projects afoot in Eclipse (InfoWorld) 04/19/2005 08:45 AM
InfoWorld - A tale of dueling open source projects for object-relational mapping may be brewing within Eclipse, with similar proposals floated by Versant and Oracle.

SyberWorks Selected by the American
Contract Bridge League to Develop Online
Bridge Education Content through the
SyberWorks Hosted e-Learning Solution

SyberWorks Selected by the American
Contract Bridge League to Develop Online
Bridge Education Content through the
SyberWorks Hosted e-Learning Solution 06/05/2005 10:52 PM
SyberWorks, a leader in custom e-Learning Solutions and the Learning Management System industry, announced today it has been selected by the American Contract Bridge League to develop online bridge education content and host its online bridge training programs using the SyberWorks Hosted e-Learning Solution. [PRWEB May 23, 2005]

Python and XML: XML Namespaces Support
in Python Tools, Part Two

Python and XML: XML Namespaces Support
in Python Tools, Part Two 05/13/2004 07:55 PM
In his latest Python and XML column, Uche Ogbuji continues his tour of XML namespaces support in Python tools, focusing this time on 4Suite.

Python and XML: XML Namespaces Support
in Python Tools, Part Three

Python and XML: XML Namespaces Support
in Python Tools, Part Three 06/30/2004 07:31 PM
In this month's Python and XML column Uche Ogbuji examines the namespace support in ElementTree, PyRXPU, and libxml.

Information Bridge Framework Document:
Introducing the Microsoft Office
Information Bridge Framework

Information Bridge Framework Document:
Introducing the Microsoft Office
Information Bridge Framework 05/19/2004 11:41 PM
Learn about the Microsoft Office Information Bridge Framework from an organizational perspective, including the rationale for exposing line-of-business data to desktop systems and the benefits to the information workers who rely on this data to perform their daily work. In addition, review the Information Bridge architecture and the advantages that this architecture offers for both deployment and maintenance of solutions.

OOD vs Relational

OOD vs Relational 05/10/2004 05:54 PM

I am currently working on a Handheld application which will interface with a web application via SOAP. We are currently in the design phase. Over the past years, I have grown from a pure relational database guy, to an Object Oriented Developer. I am learning a lot about the design decisions I used to make from a relational point of view. My Handheld application is OO, and the backend is Relational. So I want to synchronize data using objects, and the client is more comfortable just sending data tables of records which have changed.

We had a confusing, yet productive design meeting yesterday. The main issue revolved around Relational Integrity. There are some items which I would view as a complete object and I wanted the webservice to return full objects. However, it is possible to change a single field of data, such as a status label within the database which could affect hundreds of records. Downloading 100 changed objects is not efficient, especially on a handheld.

We netted out with a denormalized intermidiate stucture, which collapse some dozens of tables into less than 15, but ended up with more than the 5 objects which will be utilized on the handheld. This provided us with efficiency, and prevented the handheld from requiring a relation datastore.

Relational Filesystem

Relational Filesystem 07/28/2004 07:46 AM
RelFS first prototype released!

A Relational Model of Programming

A Relational Model of Programming 11/19/2003 04:42 PM
I can't help but write a brief introduction to the basics of a relational model of programming, to hopefully spark some interesting discussion. It is a model developed by Ákos Fóthi, and it fascinated me since the first couple of his lectures.

Tcl Relational Algebra Library

Tcl Relational Algebra Library 04/20/2004 11:32 PM
Getting Started

Web Services & Relational Databases

Web Services & Relational Databases 05/01/2004 10:31 AM
DDJ May 1 2004 2:13PM GMT

SQL, XML, and the Relational Database
Model

SQL, XML, and the Relational Database
Model 06/28/2004 04:19 PM

Backporting from Python 2.3 to Python
2.2

Backporting from Python 2.3 to Python
2.2 06/08/2004 11:18 PM

We have a home-grown templating system at work, which I intend to dedicate an entry to some time in the future. We originally wrote it in Python 2.2, but upgraded to Python 2.3 a while ago and have since been evolving our code in that environment. Today I found a need to load the most recent version of our templating system on to a small, long neglected application that had been running the original version ever since it had enough features to be usable.

Unfortunately, this application was running on a server that only had Python 2.2. Installing Python 2.3 would have been somewhat more painful here than on other servers we run for reasons I won't go in to, so I decided to have a go at getting our current code to run under the older Python version.

In the end, I only had to make three minor changes, all at the top of the file in question.

1. I added from __future__ import generators as the very first line of the file. We use generators (with the yield statement) in a few places - this feature was only properly added in Python 2.3, but was made available in Python 2.2 as a "future enhancement" through the aforementioned obscure import.

2. I added True, False = 1, 0 on the next line down. Surprisingly, Python 2.2 had no support for a boolean type and instead used a test for non-zero instead. The above line defines constants that behave enough like Python 2.3's True and False to avoid any problems.

3. I defined an enumerate function, which was introduced for real in Python 2.3. Here's the code I used:

   
   def enumerate(obj):
       for i, item in zip(range(len(obj)), obj):
           yield i, item 
   

All in all it only took around ten minutes to put the above together, after which the script worked just fine. It was interesting to see how our code had grown to rely on Python 2.3 features without us realising it.

How Relational Databases Changed the
World

How Relational Databases Changed the
World 02/25/2003 12:19 PM
Computer History Museum panel discussion with Chris Date, Herb Edelstein, Bob Epstein, Ken Jacobs, Pat Selinger, Roger Sippl and Michael Stonebraker, with moderator George Schussel.

An interesting talk by some of the founders of this industry. I particular liked the question they posed Bob Epstein, Sybase co-founder. Microsoft SQL Server got its start as a software licensed from Sybase - would Bob have done this deal again given hindsight - he said: Yes!

Requires real player.

"zeldman.dm2"

Implementing a relational database using
MySQL

Implementing a relational database using
MySQL 04/06/2005 12:17 PM
When properly implemented, a relational database can greatly enhance the availability of data and information for an enterprise's decision makers. However, deploying a relational database on almost any scale requires a thorough understanding of the fundamental concepts and rules that govern their behavior.

Firebird Relational Database 1.5 RC7
(Development)

Firebird Relational Database 1.5 RC7
(Development) 12/09/2003 12:28 AM
A relational database offering many ANSI SQL-92 features.

Firebird Relational Database 1.5.1 RC1
(Development)

Firebird Relational Database 1.5.1 RC1
(Development) 05/20/2004 11:31 AM
A relational database offering many ANSI SQL-92 features.

Using Topic Maps to Extend Relational
Databases

Using Topic Maps to Extend Relational
Databases 03/11/2003 01:22 AM
Relational databases are fast and efficient ways to store data, but they can often be inflexible when application requirements change. Augmenting them with the capabilities of Topic Maps can solve this problem, and enhance interoperability between databases.

Firebird Relational Database 1.5.1 Final
(Stable)

Firebird Relational Database 1.5.1 Final
(Stable) 07/17/2004 09:38 AM
A relational database offering many ANSI SQL-92 features.

Firebird Relational Database 1.5 Beta 4
(Development)

Firebird Relational Database 1.5 Beta 4
(Development) 03/14/2003 03:38 PM
A relational database offering many ANSI SQL-92 features.

Firebird Relational Database 1.5.1
Release Candidate 3 (Development)

Firebird Relational Database 1.5.1
Release Candidate 3 (Development) 06/25/2004 01:26 PM
A relational database offering many ANSI SQL-92 features.

Firebird Relational Database 2.00 Alpha
01 (Development branch)

Firebird Relational Database 2.00 Alpha
01 (Development branch) 04/19/2005 04:19 AM
Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. It offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

---

Changes:
This release features derived tables, support for Execute Block, increased table sizes, an improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimizer improvements, enhanced security features, and support for on-line incremental backups. Many other improvements and bugfixes were made.

Obitury: Edgar F. Codd, creator of the
relational database

Obitury: Edgar F. Codd, creator of the
relational database 04/29/2004 01:59 AM
PublicTechnology.net Apr 29 2004 5:23AM GMT

Linux biggest gainer in relational
database market

Linux biggest gainer in relational
database market 05/28/2004 10:51 AM
ZDNet UK May 28 2004 3:48PM GMT

Remembered: Edgar F. Codd, creator of
the relational database

Remembered: Edgar F. Codd, creator of
the relational database 04/29/2004 04:58 AM
PublicTechnology.net Apr 29 2004 9:26AM GMT

Solid Demonstrates Advanced MP3
Distribution System Based on Relational
Data Management

Solid Demonstrates Advanced MP3
Distribution System Based on Relational
Data Management 09/22/2004 02:13 AM
Solid Information Technology Corp., the first to provide an Autonomic Data Management Platform, will demonstrate the media data management and distribution capabilities of its BoostEngine database server with a simple but powerful MP3 management and distribution system at the Mobile Content World 2004 trade show at ExCeL, London, on Tuesday, September 21st and Wednesday, September 22nd. [PRWEB Sep 22, 2004]

XML and relational data in WebSphere
Studio (WebSphere Developer's Journal)

XML and relational data in WebSphere
Studio (WebSphere Developer's Journal) 10/25/2002 07:23 AM

Convert data between XML and relational,
LDAP data (Advisor.com)

Convert data between XML and relational,
LDAP data (Advisor.com) 10/11/2002 07:56 AM

Convert data between XML and relational,
LDAP data (Advisor.com)

Convert data between XML and relational,
LDAP data (Advisor.com) 10/09/2002 10:47 AM

VSS Bridge 1.3

VSS Bridge 1.3 09/15/2004 03:47 PM
Commandline access to MS Visual Source Safe.

Delkin USB Bridge - USB without PC

Delkin USB Bridge - USB without PC 05/13/2004 04:56 AM
I4U May 13 2004 9:05AM GMT
Grok Description matches for Object-Relational Bridge for python
GrokA matches for Object-Relational Bridge for python

Object-Relational Bridge for python

The following phrases have been identified by the grok system as matching this entry: