Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: Opening a SQLite DB after accessing it w/ DBI module

by Riales (Hermit)
on Feb 25, 2012 at 06:19 UTC ( #956066=note: print w/ replies, xml ) Need Help??


in reply to Re: Opening a SQLite DB after accessing it w/ DBI module
in thread Opening a SQLite DB after accessing it w/ DBI module

Ah, your note solved the problem. Using sqlite3 instead of sqlite worked. Thanks so much! I wonder what the difference between the two is...


Comment on Re^2: Opening a SQLite DB after accessing it w/ DBI module
Select or Download Code
Re^3: Opening a SQLite DB after accessing it w/ DBI module
by roboticus (Canon) on Feb 25, 2012 at 06:39 UTC

    Riales:

    Good question. I don't seem to have sqlite on my system, only sqlite3, which is why I assumed that's what you meant. ;^)

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

      Made me wonder too...

      A little exploration revealed that on Win|Active State 5.014, there is no sqlite.exe or sqlite3.exe in Perl's directories. Rather, C:\>dir sqlite*.* /s/a tells us:

      Directory of C:\Perl\lib\auto\DBD 01/29/2012 07:38 PM <DIR> SQLite 0 File(s) 0 bytes Directory of C:\Perl\lib\auto\DBD\SQLite 10/07/2011 04:27 PM 0 SQLite.bs 10/07/2011 04:27 PM 487,542 SQLite.dll 10/07/2011 04:27 PM 804 SQLite.exp 10/07/2011 04:27 PM 2,170 SQLite.lib 4 File(s) 490,516 bytes Directory of C:\Perl\lib\auto\share\dist\DBD-SQLite 10/07/2011 04:27 PM 4,438,903 sqlite3.c 10/07/2011 04:27 PM 306,213 sqlite3.h 2 File(s) 4,745,116 bytes Directory of C:\Perl\lib\CPANPLUS\Internals\Source 01/29/2012 07:38 PM <DIR> SQLite 04/22/2011 02:42 PM 9,627 SQLite.pm 1 File(s) 9,627 bytes Directory of C:\Perl\lib\DBD 01/29/2012 07:38 PM <DIR> SQLite 05/30/2011 12:30 AM 67,126 SQLite.pm 1 File(s) 67,126 bytes

      The list continues with instanges from other packages -- Adobe Reader 9, for instance, has a .dll (no version number in the filename) about half the size of that provided by DBI; LibreOffice has still another that runs to 400K.

      Interestingly (to me anyway) is that yet another program -- a commercial package for syncing my fone with an old Palm PIM -- has two .dll's:

      503,202 sqlite3_3_6_16.dll 559,244 sqlite3_3_7_5.dll

      Tentative conclusion: providers, including AS, pick and chose which version of sqlite3 they utilize... and may rename to their own taste.

      Afterthought speculation: Were my Linux box not still recouperating from a drive transplant and other surgery, I'd bet on finding a standalone version of "sqlite3.exe" there (as I do on another drive on the Win7 box) ... but by the name of "sqlite" -- perhaps others will check names and versions on RedHat, Debian, etc....

Re^3: Opening a SQLite DB after accessing it w/ DBI module
by Marshall (Prior) on Feb 26, 2012 at 01:04 UTC
    There are some differences between versions in terms of how the data is stored. That might be an issue here. As a tip, I use the Firefox plugin - SQLite Manager which so far I've found easier than the command line. Well actually I don't even have the command line installed! I just installed DBD::SQLite and the Firefox plug-in and that worked well enough..

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://956066]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2014-09-22 00:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (176 votes), past polls