Not long ago, I posted a list of DBD modules that do not require you to have a separate RDBMS. Today I note Python moving in a similar direction, including doing some work with SQLite. Interesting that as folks here keep saying they'd like to see more done with SQLite (Slash on SQLite! Bundle it with Perl and Perl will include a complete database! etc., etc.), Python folks are noticing the same need.
For some time now, I've been saying I'd like to implement a complete RDBMS in Perl. My coworkers always said I was crazy, and I agreed. But I did have a copy of Fundamentals of Database Systems, recommended reading for PostgreSQL hackers [not people who write apps with PostgreSQL ... people who write PostgreSQL], written by a professor from my university from whom I am taking a graduate databases class this semester. The idea seemed quite possible, although I wouldn't expect it to have the greatest efficiency. Now this article comes out and it turns out somebody has already done this in Python, and it's called Gadfly. Anyone want to step up to the plate for Perl? I threw together a simple Table.pm awhile back that handled single-field indexes and single-table selects. Fun work. :)
I haven't really looked at the source code for SQLite, but would it be possible to re-implement it in Perl? The doc states explicitely that "Sources are in the public domain. Use for any purpose."
