Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
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 (Chancellor) 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 chanting in the Monastery: (11)
As of 2015-07-07 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls