From: <sub...@co...> - 2005-02-17 16:00:29
|
Author: phd Date: 2005-02-17 16:00:19 +0000 (Thu, 17 Feb 2005) New Revision: 615 Modified: trunk/SQLObject/docs/FAQ.txt Log: Mentioned BLOBCol and PickleCol in section "Binary values". Modified: trunk/SQLObject/docs/FAQ.txt =================================================================== --- trunk/SQLObject/docs/FAQ.txt 2005-02-17 08:12:15 UTC (rev 614) +++ trunk/SQLObject/docs/FAQ.txt 2005-02-17 16:00:19 UTC (rev 615) @@ -107,9 +107,9 @@ anyway). -There is also another kind of inheritance. See Inheritance.txt_ +There is also another kind of inheritance. See Inheritance.html_ -.. _Inheritance.txt: Inheritance.txt +.. _Inheritance.html: Inheritance.html Composite/Compound Attributes @@ -188,7 +188,14 @@ have a widely-implemented way to express binaries as literals, and there's differing support in database. -A possible way to keep this data in a database is by using encoding. +The module sqlobject.col defines validators and column classes that +to some extent support binary values. There is BLOBCol that extends +StringCol and allow to store binary values; currently it works only +with PostgreSQL and MySQL. PickleCol extends BLOBCol and allows to store +any object in the column; the column, naturally, pickles the object upon +assignment and unpickles it upon retrieving the data from the DB. + +Another possible way to keep binary data in a database is by using encoding. Base 64 is a good encoding, reasonably compact but also safe. As an example, imagine you want to store images in the database: |