use Perl

• Third party support (Score:1)

  by lachoy (1663)

  The next version of SPOPS, which will come out whenever I wake up -- I have a strict no-bleary-eyed CPAN release policy -- includes support for SQLite. (Oracle too, but let's keep on message.)

  One thing I noticed is that SQLite doesn't seem to like table definitions with an explicit 'NULL' declaration. For instance, the following will fail:

  CREATE TABLE testme (
  id int not null primary key,
  name varchar(20) null
  )

  with a DBD::SQLite::db do failed: near "null": syntax error at ...

  Other tha
  • Re:Third party support (Score:2)

    by Matts (1087)

    Watch out for the memory leaks though :-D
    
    I've got a fix for some of them, but I'm still seeing slight leaks. I'm wondering if that's not in the underlying library though, since leaking 1 scalar per request would see more leakage than I've seen so far.
    • Re:Third party support (Score:1)

      by lachoy (1663) <chris.winters@gmail.com> on 2002.02.23 12:57 (#4993) Homepage Journal

      I'm glad I checked the latest CPAN releases before releasing this version of SPOPS -- I see you put the $dbh->last_insert_rowid method in, which means that I don't have to use the random string key generation method :-)

      Reply to This

      Parent