SqLite book & dictionary

Forum: Apps
Topic: SqLite book & dictionary
started by: juman

---

Posted by juman on Mar. 24 2004,00:11

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?

---

Posted by roberts on Mar. 24 2004,02:04

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

---

Posted by fodder on May 15 2007,01:32

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:

Code Sample

$sock = IO::Socket::INET->new(                                 LocalAddr => 'localhost',                                 LocalPort => 9000,                                 Proto     => 'tcp');

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.

---

Posted by fodder on June 02 2007,00:24

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

I then downloaded the current .deb file from: < http://activestate.com/products/activeperl/ >
and installed using:
dpkg -i ActivePerl-5.8.8.820-i686-linux.deb

Lastly, I added /opt/ActivePerl-5.8 to .filetool.lst .

---