Search Members Help

» Welcome Guest
[ Log In :: Register ]

Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic
 

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic new topic new poll
Topic: SqLite book & dictionary, Can't find the apps?< Next Oldest | Next Newest >
juman Offline





Group: Members
Posts: 1
Joined: Mar. 2004
Posted: Mar. 24 2004,00:11 QUOTE

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?
Back to top
Profile PM 
roberts Offline





Group: Members
Posts: 4983
Joined: Oct. 2003
Posted: Mar. 24 2004,02:04 QUOTE

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
Back to top
Profile PM WEB 
fodder Offline





Group: Members
Posts: 28
Joined: June 2006
Posted: May 15 2007,01:32 QUOTE

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.
Back to top
Profile PM 
fodder Offline





Group: Members
Posts: 28
Joined: June 2006
Posted: June 02 2007,00:24 QUOTE

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 .
Back to top
Profile PM 
3 replies since Mar. 24 2004,00:11 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

 
reply to topic new topic new poll
Quick Reply: SqLite book & dictionary

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code