I have downloaded the latest version of the DSL and it shows two applications used in the screenshots. A dictionary and the SQLite Book but how do I start them?Be sure to grab v0.6.2. They are on the menu. Look under office for Sqlite Book and Net Dictionary Look under tools for the net man pages.
Also note that Sqlite Book was written by our very own, John. It is amazing
Quote (roberts @ Mar. 23 2004,21:04)
Also note that Sqlite Book was written by our very own, John. It is amazing
Hey Roberts, is "John" still around?
I'm trying to access SQLite using Perl but cannot for the life of me find out how to connect to the database using IO::Socket (like John did.) All the info I have found (even on sqlite.org) for connecting to databases uses something like the DBI module all of which are not included with DSL.
Your PHP examples are great - but using PHP is not really an option for me on this project.
I am pretty much just looking for the section of code that John used to create the Socket handle - something like this:
But any additional help would be greatly appreciated, as well.
UPDATE: I've spent almost the entire last two days searching for further info and trying other options. I have searched every Google combination I can think of and cannot find anyone else who has used IO::Socket with SQLite - everyone uses DBI.
I have also spent much time trying to install the DBI module into DSL...alas, despite reading much of the Wiki, searching this forum, and scouring the Debian and KNOPPIX sites I have not found a combination of install steps that will work.
If anyone has been able to use Perl 5.8.0 to connect with SQLite or has successfully imported Perl modules into DSL, I would be ever appreciative of some help.Update: I never was able to get IO::Socket to connect with SQLite. However, I did get ActivePerl-5.8 to install to /opt/ and then ran my perl scripts using #! /opt/ActivePerl-5.8/bin/perl (instead of /usr/bin/perl)
I went with ActivePerl after trying many different ways to install DBI and DBD::SQLite. (manual make, apt, dpkg, cpan module, etc.) None of those methods worked - I often got a "can't mkdir, not enough space on device" error. Which was weird because I could go and make the directory manually and it was fine - not to mention installing 20+ megs of ActivePerl later wasn't a problem.) I also tried these methods on two different machines using both DSL 2.4 and DSL 3.3.
Installing ActivePerl made for a large backup file, but it comes with the DBI and DBD::SQLite modules already installed so I was able to easily connect with SQLite.
FYI, here is how I installed ActivePerl: First installed these mydsl extensions: dsl-dpkg.dsl gcc1-with-libs.dsl gnu-utils.dsl gtk2-0705.dsl (be sure to right-click on desktop and select /MyDSL/Update_to_GTK2 after the install) tcltk8.3.dsl