[sqlalchemy] Re: PickleType too small
Now that I have succeeded to write in my Pickle type into a database I have another problem. When I read it from the database how do I convert it to my original data (since I get pickle-file-like data after reading a row)? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: new docs new docs new docs
Ladies and Gentlemen: I present to you Michael Bayer, the amazing multitalented developer of SQLAlchemy--getting more done in one week than the average team of developers does in a month!! Not only is he a very fast coder, but he writes comprehensive documentation for his code--an unheard-of combination of willingness and ability in an open-source developer. Seriously, thanks for the excellent library and documentation Mike. It's truly excellent. ~ Daniel On Jan 20, 2007, at 5:40 PM, Michael Bayer wrote: hey list - trying to wrap up as much as i can for the next release, just wanted to highlight some new doc sections and improvements, since i know everyone just loves my docs and their various typos, careless flubs, and great endorsement of the insurance industry: SQLAlchemy is Two Libraries in One http://www.sqlalchemy.org/docs/tutorial.myt#tutorial_twoinone Configuring Logging http://www.sqlalchemy.org/docs/dbengine.myt#dbengine_logging Creating Joins Using selectby() - added a note about the new feature (in the trunk until 0.3.4) which lets you select_by(somerelation=someinstance) http://www.sqlalchemy.org/docs/ datamapping.myt#datamapping_selectrelations_relselectby Working with Large Collections http://www.sqlalchemy.org/docs/ adv_datamapping.myt#advdatamapping_properties_working Mapper Options - complete and alphabetical http://www.sqlalchemy.org/docs/ adv_datamapping.myt#advdatamapping_mapperoptions Relation Options - complete and alphabetical http://www.sqlalchemy.org/docs/ adv_datamapping.myt#advdatamapping_properties_relationoptions Combining Eager Loads with Result Set Mappings http://www.sqlalchemy.org/docs/ adv_datamapping.myt#advdatamapping_resultset_combining --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: InvalidRequestError: This transaction is inactive
not sure about that, i thought maybe the multiple flush()es are breaking something but I just added a test case and it doesnt reproduce. make sure youre on the most recent versions since that was broken a few versions back... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Extracting date parts from datetime with postgresql
date_part is a synonym for extract w/ more normal syntax
so you could write func.date_part('year', mydatetime)
On 1/22/07, laurent rahuel [EMAIL PROTECTED] wrote:
Hi,
Here is my little trouble. I want to extract some parts of a datetime
field in a postgresql database.
I played around with the func.year(), func.month() but it sounds like
postgresql doesn't understand the resulting query. For example, a
func.year() call is converted into :
select year(myDateTime) from mytable;
This works with MySQL but not with Postgresql. The error is function
year(timestamp without time zone) doesn't exist
I guess the resulting Postgresql query should be :
select EXTRACT (year FROM myDateTime) from mytable;
Any clue ???
Regards,
Laurent
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---
[sqlalchemy] memcache integration
Hi Chaps, I'm working on a web project which will be hosted over a couple of webservers, with one db server sitting out back. I am wondering if I can integrate memcache with sqlalchemy, in order to minimise db reads from both webservers, and automatically invalidate the cache on writes... Has anyone else contemplated this? Is there anything inherently wrong with this idea? -Sw. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: new docs new docs new docs
I present to you Michael Bayer, the amazing multitalented developer of SQLAlchemy--getting more done in one week than the average team of developers does in a month!! Not only is he a very fast coder, but he writes comprehensive documentation for his code--an unheard-of combination of willingness and ability in an open-source developer. Fully seconded. I take SQLAlchemy as a boon to IT industry - particularly while talking Agile development. I can't think agile python frameworks entering enterprise level without it. sanjay --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
