[development] Form field maxlengths vs. database field sizes

Pat Collins pat at linuxcolumbus.com
Thu Feb 9 19:33:29 UTC 2006

On Thu, 9 Feb 2006 11:23:07 -0800, Adrian Rossouw <adrian at bryght.com> wrote :

> On 08 Feb 2006, at 8:28 PM, Chris Johnson wrote:
> > It does not presently, but Drupal could know the field sizes in the  
> > database tables.  However, is that worth doing?  (I'm presently  
> > developing a database abstraction layer for my employer where the  
> > db layer figures out the metadata, like field sizes, on the fly so  
> > that the applications need not know anything at all about it.)
> I want to do this for 4.8.
> it simplifies the install files (which are in core now), and allows  
> us to possibly automate some of the _update_x function creation.
> essentially
> db_create_table('name', array('field' => 'type', 'field' => 'type');
> etc.
> keeping track of all the columns in the database is important for  
> stuff like views and relationships too.

It would also make supporting other database engines easier.  Imagine
optimized sql for each db.  Wouldn't that be great.


More information about the development mailing list