[development] A little pgsql help

[Piotr Krukowiecki]

On Thu, Mar 09, 2006 at 10:21:53AM -0500, Dan Ziemecki wrote:
> 
> If 'text' works for serialized objects, then that's probably what I need.

Unless you have binary data somewhere, I think.


> Maybe in mySQL, too.  I was just concerned that a text field would top out
> at 255 characters, and I wasn't sure how many I'd end up with.

In postgres TEXT has unlimited length (well, almost ;)). In mysql it can
have 65K bytes.


> I would suggest changing 'uid' name to something else, as it's reserved
> > name.

Hmm a small explanation: 'uid' is reserved in oracle and gives a lot of
problems to people wanting to support oracle
(http://drupal.org/node/39260)

 
> Good point.  Is 'type" ok? I've seen it elsewhere (e.g. Nodes) but I wasn't
> sure...

It's ok (I don't suppose we'll ever support to DB2 ;)). There's a nice
web tool on
http://www.petefreitag.com/tools/sql_reserved_words_checker/


> > Those are also good, if you really want comments.
> 
> Why wouldn't you? Is there a cost?  Otherwise, anything that explains what's
> going on can only help in later troubleshooting, no?

No no, I don't know about any problems with comments, I just never used
them ;)


-- 
Piotrek
irc: #debian.pl
Mors Drosophilis melanogastribus!