[sqlalchemy] SA 0.8.0 UnicodeDecodeError with Postgres 9.1.9

Hi there, I receive the following weird UnicodeDecodeError after copying our production database into a testing environment. On the production server everything is working fine, on the testing server I get this error. Both installation including OS are basically identically (except SA 0.8.0b2

[sqlalchemy] Re: SA 0.8.0 UnicodeDecodeError with Postgres 9.1.9

Problem seems to be related how I moved the database (pg_dump + pg_restore). After moving the database files directory I can no longer reproduce this error. -aj On Friday, April 19, 2013 8:36:58 AM UTC+2, Andreas Jung wrote: Hi there, I receive the following weird UnicodeDecodeError after

Re: [sqlalchemy] SA 0.8.0 UnicodeDecodeError with Postgres 9.1.9

On Apr 19, 2013, at 08:54 , Andreas Jung j...@lpcnv.com wrote: Problem seems to be related how I moved the database (pg_dump + pg_restore). After moving the database files directory I can no longer reproduce this error. I would guess you loaded your database dump into a database with a

[sqlalchemy] Which is the best way for saving or updating json data?

I have some requirements like this. One table model is: class Demo(Base): jsondata = Column(Text) This column jsondata is used for saving json data. And this Model would be used anywhere by many developers. I want to load it to a Python object when I query and dump it to string when I

Re: [sqlalchemy] sqlalchemy and firebird; quotes around table/column names

Hi, i changed the names to lower case and now it works perfect. thanks. Kind regards, Holger Am Freitag, 19. April 2013 01:55:47 UTC+2 schrieb Michael Bayer: specify __tablename__ as an all lower case name, which indicates that it's case insensitive. It will not be quoted, provided it

Re: [sqlalchemy] Which is the best way for saving or updating json data?

http://www.sqlalchemy.org/trac/wiki/UsageRecipes/JSONColumn :) On 04/19/2013 04:50 AM, garcheck wrote: I have some requirements like this. One table model is: class Demo(Base): jsondata = Column(Text) This column jsondata is used for saving json data. And this Model would be used

Re: [sqlalchemy] views declarative?

On Wed, Apr 17, 2013 at 2:59 PM, Michael Bayer mike...@zzzcomputing.comwrote: James Hartley jjhart...@gmail.com writes: Is it possible to map Table instances back to classes defined through declarative_base()? the typical form is: Base = declarative_base() some_table =

Re: [sqlalchemy] creating transaction

Thanks for your great explanation, I think I would help, but I must describe some additional information in my using: I try to create a proof-of-concept for a database builder eg http://www.liquibase.org/ I use for my project SCons ( http://www.scons.org ) like a build toolkit and would like to

Re: [sqlalchemy] creating transaction

On Apr 19, 2013, at 11:13 AM, Philipp Kraus philipp.kr...@flashpixx.de wrote: Thanks for your great explanation, I think I would help, but I must describe some additional information in my using: I try to create a proof-of-concept for a database builder eg http://www.liquibase.org/ I use

Re: [sqlalchemy] views declarative?

On Apr 19, 2013, at 11:01 AM, James Hartley jjhart...@gmail.com wrote: On Wed, Apr 17, 2013 at 2:59 PM, Michael Bayer mike...@zzzcomputing.com wrote: James Hartley jjhart...@gmail.com writes: Is it possible to map Table instances back to classes defined through declarative_base()? the