LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 11-21-2011, 06:38 AM   #1
ted_chou12
Member
 
Registered: Aug 2010
Location: Zhongli, Taoyuan
Distribution: slackware, windows, debian (armv4l GNU/Linux)
Posts: 421
Blog Entries: 28

Rep: Reputation: 2
sqlite package for 2.1 database


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
 
Old 11-22-2011, 12:48 AM   #2
EricTRA
Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 18 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290
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
 
Old 11-23-2011, 12:17 AM   #3
ted_chou12
Member
 
Registered: Aug 2010
Location: Zhongli, Taoyuan
Distribution: slackware, windows, debian (armv4l GNU/Linux)
Posts: 421
Blog Entries: 28

Original Poster
Rep: Reputation: 2
Quote:
Originally Posted by EricTRA View Post
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
 
Old 11-23-2011, 12:37 AM   #4
EricTRA
Guru
 
Registered: May 2009
Location: Gibraltar, Gibraltar
Distribution: Fedora 18 with Awesome WM
Posts: 6,805
Blog Entries: 1

Rep: Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290Reputation: 1290
Hi,

Thank you for sharing Ted. Have fun with Linux.

Kind regards,

Eric
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
qdevelop can't connect database and needs sqlite support. mei0fei Linux - Software 1 08-26-2011 07:59 PM
LXer: Sqlite-Commander - A ncurses based tool to display the records and tables of a sqlite database LXer Syndicated Linux News 0 01-02-2011 08:11 AM
Sqlite Database image malformed ravindranvasudevan Programming 6 08-10-2009 03:37 AM
[python] sqlite: Can you combine two database files? BrianK Programming 6 09-11-2008 06:59 AM
SQLite database backup ddpicard Linux - Software 2 11-01-2004 06:54 PM


All times are GMT -5. The time now is 09:06 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration