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 ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Thursday January 23, 2003
02:46 PM

Python databases

[ #10146 ]

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. :)

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.
  • I've been thinking about implementing a _real_ RDBMS in Perl for a while. By real, I mean really relational, as opposed to the godawful crap we see today. This means no SQL, except via a portability layer.

    A good reference for what this would look like is CJ Date & Hugh Darwen's "Third Manifest" book. I don't like the syntax of their Tutorial D language, but that's not a big deal, since they themselves say that their syntax is just one possible implementation of a "valid D" language.
  • If you were very wedded to the SQL DBMS "model" (it's not a model, it's a mess), you should check out the Alzabo code. There's a lot of code in there that could be really useful in implementing a SQL DBMS in Perl.
  • 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."

    --
    mirod