Re: Spatialite prefix request

On Tue,  9 Aug 2011 01:05:40 -0000, "Greg Sabino Mullane"
<[email protected]> wrote:

> > Did you have a prefix in mind that is not already in use?  Would 'sl_' be
> > appropriate, for example?   You can find the current list of assignments at
> > about line 320 in DBI.pm, and 'sl_' appears to be available.  (The longest
> > current prefix is 'monetdb_'; if you requested 'spatialite_' as the prefix,
> > that would be 3 characters longer than the current longest.)
> 
> I'd like to see the trend go the other way, and use the full name, just 
> like many other DBDs do. Characters are cheap, and "sl" not only gives no 
> clue as to what driver is meant to the viewer of code that uses it, but 
> risks future collisions as well. So +1 to using 'spatialite_'

+1 from me on spatiale_ too (or spatle_ if you want to stay withing the
current max 6 letters).

sl already means "shared library" (at least on my HP-UX systems), and
I'd never "guess" spatiale from it. Oracle is big enough to make ora_
automatically trigger "Oracle", but MySQL already has 5 letters.

Here is the current full list:

my $dbd_prefix_registry = {
  ad_      => { class => 'DBD::AnyData',        },
  ado_     => { class => 'DBD::ADO',            },
  amzn_    => { class => 'DBD::Amazon',         },
  best_    => { class => 'DBD::BestWins',       },
  csv_     => { class => 'DBD::CSV',            },
  db2_     => { class => 'DBD::DB2',            },
  dbi_     => { class => 'DBI',                 },
  dbm_     => { class => 'DBD::DBM',            },
  df_      => { class => 'DBD::DF',             },
  f_       => { class => 'DBD::File',           },
  file_    => { class => 'DBD::TextFile',       },
  go_      => { class => 'DBD::Gofer',          },
  ib_      => { class => 'DBD::InterBase',      },
  ing_     => { class => 'DBD::Ingres',         },
  ix_      => { class => 'DBD::Informix',       },
  jdbc_    => { class => 'DBD::JDBC',           },
  monetdb_ => { class => 'DBD::monetdb',        },
  msql_    => { class => 'DBD::mSQL',           },
  mvsftp_  => { class => 'DBD::MVS_FTPSQL',     },
  mysql_   => { class => 'DBD::mysql',          },
  mx_      => { class => 'DBD::Multiplex',      },
  nullp_   => { class => 'DBD::NullP',          },
  odbc_    => { class => 'DBD::ODBC',           },
  ora_     => { class => 'DBD::Oracle',         },
  pg_      => { class => 'DBD::Pg',             },
  pgpp_    => { class => 'DBD::PgPP',           },
  plb_     => { class => 'DBD::Plibdata',       },
  po_      => { class => 'DBD::PO',             },
  proxy_   => { class => 'DBD::Proxy',          },
  ram_     => { class => 'DBD::RAM',            },
  rdb_     => { class => 'DBD::RDB',            },
  sapdb_   => { class => 'DBD::SAP_DB',         },
  solid_   => { class => 'DBD::Solid',          },
  sponge_  => { class => 'DBD::Sponge',         },
  sql_     => { class => 'DBI::DBD::SqlEngine', },
  sqlite_  => { class => 'DBD::SQLite',         },
  syb_     => { class => 'DBD::Sybase',         },
  sys_     => { class => 'DBD::Sys',            },
  tdat_    => { class => 'DBD::Teradata',       },
  tmpl_    => { class => 'DBD::Template',       },
  tmplss_  => { class => 'DBD::TemplateSS',     },
  tuber_   => { class => 'DBD::Tuber',          },
  uni_     => { class => 'DBD::Unify',          },
  vt_      => { class => 'DBD::Vt',             },
  wmi_     => { class => 'DBD::WMI',            },
  x_       => { }, # for private use
  xbase_   => { class => 'DBD::XBase',          },
  xl_      => { class => 'DBD::Excel',          },
  yaswi_   => { class => 'DBD::Yaswi',          },
  };

> Greg Sabino Mullane [email protected]


-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using 5.00307 through 5.14 and porting perl5.15.x on HP-UX 10.20, 11.00,
11.11, 11.23 and 11.31, OpenSuSE 10.1, 11.0 .. 11.4 and AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/