Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Matts (1087)

Matts
  (email not shown publicly)

I work for MessageLabs [messagelabs.com] in Toronto, ON, Canada. I write spam filters, MTA software, high performance network software, string matching algorithms, and other cool stuff mostly in Perl and C.

Journal of Matts (1087)

Monday July 28, 2003
06:19 PM

On SQLite

[ #13740 ]

It seems DBD::SQLite is my most popular module now. Everyone at YAPC::Eu that I spoke to was using it for something - whether it be prototyping or really using it in anger for something. And that's fantastic, as for me it was really just an experiment to learn how to write a DBI driver!

And thanks for all the patches and bug reports everyone.

On a similar note, I came across a great tip on the SQLite mailing list today about how to use an index with a LIKE query:

  > I have a
  >
  > table directry (id integer, name varchar, address varchar)
  >
  > and an index on name. I want to access records by name via the
  > following query:
  >
  > select id from directry where name like 'john%';
  >
  > It turns out that my query does not make use of the index on the
  > field name ( as opposed to the query "...where name ='john doe';" ).
  >
  > Do you know if there is any way to make the query lookup the index on
  > the field name?
  >

  SELECT id FROM directory WHERE name>='john' AND name < 'joho'

  __END__

Hacky, but kinda cool.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.