[SOLVED] sqlite package for 2.1 database

ted_chou12 · 11-21-2011, 06:38 AM

Hi, I am looking for sqlite program that edits a sqlite 2.1 database. Because I have a "file.db" and when I open it,it says:

Quote:

** This file contains an SQLite 2.1 database **

I remember there was a package that gives prompt:
sqlite>
sqlite>
...
There are overabundant packages when I do an apt-cache search sqlite. I think it would take to much time to try all of them out.
Thanks,
Ted

EricTRA · 11-22-2011, 12:48 AM

Hello,

To stay in the spirit of the open community that LQ is, could you please post what solution you've found? Since you marked your thread as solved, I assume you have a solution. In sharing that solution with the community you're helping others that encounter themselves in similar situations. Thanks in advance.

Kind regards,

Eric

ted_chou12 · 11-23-2011, 12:17 AM

Quote:

Originally Posted by EricTRA

Hello,

To stay in the spirit of the open community that LQ is, could you please post what solution you've found? Since you marked your thread as solved, I assume you have a solution. In sharing that solution with the community you're helping others that encounter themselves in similar situations. Thanks in advance.

Kind regards,

Eric

There are two packages of the sqlite prompt line, one is called sqlite3 and the other is sqlite, the sqlite is the one that edits and reads sqlite 2.x databases.
Thanks,
Ted

EricTRA · 11-23-2011, 12:37 AM

Hi,

Thank you for sharing Ted. Have fun with Linux.

Kind regards,

Eric