Questions about the database program sqlite and also those programs that use sqlite databases.

learn more… | top users | synonyms

0
votes
0answers
16 views

Is it Possible to recover tor browser history? Lost btc

Earlier today I deposited a descent amount of btc into an online casino https://playt.in . This site has a "quick registration" feature that allows one to create an account with one click, and then ...
0
votes
0answers
8 views

Are Live Bookmarks in Places.sqlite?

In reading about Places.sqlite, it's not clear to me whether or not that includes Live Bookmarks. How can I access, either through sqlite or by other means, the Live Bookmarks? I've installed the ...
2
votes
1answer
58 views

How should I see the skype chat history from the file main.db located at ~/.Skype/SKYPEUSERNAME/?

I'm using Ubuntu 12.04 LTS and Skype 4.3 on my machine. I've taken a file named main.db from the location on my machine ~/.Skype/SKYPEUSERNAME/ Now I want to see the chat history from that file with ...
0
votes
1answer
133 views

How to install sqlite SQLite 3.7.11 on Ubuntu 12.04

According to this question, to get code my code work on this 12.04 machine I need to upgrade the version of SQLite to 3.7.11. However, on Ubuntu 12.04 the installed version of sqlite is > sqlite3 ...
0
votes
1answer
53 views

sqlite3 on precise pangolin: installed but not found?

vagrant@precise64:~$ sudo apt-get install sqlite3 Reading package lists... Done Building dependency tree Reading state information... Done The following extra packages will be installed: ...
0
votes
0answers
59 views

sqlite3 command line tool tab completion

Does sqlite3 command line tool have "tab" autocompletion, and, if it does, how can I enable it? For example, if I have a sqlite3 database file.db with table "verylongtablename", I want to execute ...
1
vote
1answer
44 views

Recover a file which has lost 5 minutes ago

Is it possible to recover a file which removed 5 minutes ago? I was working with sqliteman and suddenly it saved an empty database on my database file. It would be greatly appreciated if you suggest ...
3
votes
2answers
1k views

SQLite header and source version mismatch

I had the Ubuntu repositories of SQLite3 with v3.7.17. But it doesn't have the .save command as newer versions. To update I did: sudo apt-get purge sqlite3 Download SQLite 3.8.4.3 Install it with ...
0
votes
0answers
83 views

Export Thunderbird messages to sqlite database

I have seen a lot of posts about how to backup e-mails from the .thunderbird directory, but the truth is that I find the format of the messages quite awful, and I was wondering if there was any tool ...
0
votes
0answers
229 views

PHP sqlite not working in 13.10

According to >ls /etc/php5/mods-available/ I have a pdo.ini pdo_mysql.ini pdo_sqlite.ini sqlite3.ini for example sqlite.ini contains: ; configuration for php SQLite module ; priority=20 ...
1
vote
1answer
930 views

svn SQLite compiled for 3.7.17, but running with 3.6.1

Trying to update a svn working copy using svn update . I get the following error: svn: E200029: Couldn't perform atomic initialization svn: E200030: SQLite compiled for 3.7.17, but running with ...
0
votes
0answers
38 views

Is Zeitgeist broken in Ubuntu 13.10?

Running Ubuntu 13.10. About a month ago I looked at the size of the zeitgeist files in ~/.local/share/zeitgeist and found the -wal and -shm sqlite files to be over 4GB in total. As this is ...
0
votes
1answer
107 views

Shotwell photos lose edits when files are missing

I have my photos stored on my desktop computer, using Shotwell. I recently went on an extended holiday and wanted to take my laptop to edit and organise photos with Shotwell, so I copied all the ...
2
votes
0answers
200 views

Issue Backporting SQLite 3.8.1 to Ubuntu Precise from Trusty

I'm pretty new to all of the packaging of Ubuntu applications and what not so this may not be the correct place to ask this question or there may be a more appropriate place to re-ask this question. ...
0
votes
0answers
170 views

How to manage sqlite database with ubuntu server 12.04

I have installed php and sqlite in my Ubuntu server running nginx. I'm in doubt in how I should manage the SQL database. How should I install something like phpmyadmin that would work in these ...
0
votes
0answers
60 views

Cannot Access my localhost/version.php ? in Ubuntu 13.04 ,,,

http://zetcode.com/db/sqlitephp/ (the tutorial in this link)... Seriously can anyone help me with the PHP and SQLite3..assist me on how to link with sqlite3 and php...i already installed all the ...
0
votes
0answers
114 views

Can't listen to port 4445; sqlite3

So I have a dedicated machine running Ubuntu 12.04 server with FreePBX 2.9. Earlier I was attempting to familiarize myself with SQL via sqlite3, but I received this dreaded error: SQLite header and ...
2
votes
2answers
337 views

phpliteadmin cant find sqlite3

I installed sqlite3 using sudo apt-get install sqlite3. I also installed phpliteadmin in the var/www folder. When I go on phpliteadmin, it says it cant find sqlite3 and sqlite3database. How do I fix ...
3
votes
2answers
3k views

How to use a SQLite database from QML? [duplicate]

I have not been able to find a working example in QT creator or gallery to use SQLite offline storage API for an Ubuntu touch application.
1
vote
0answers
112 views

How do I transfer .db files from android phones to ubuntu system?

How do I transfer .db files from android phones to ubuntu system? I have created a application which stores data in sqlite. Now I have to view that .db file in the system.
2
votes
1answer
9k views

sqlite installation

I'm installing sqlite like this SQLite - Installation I get this error, anyone know what to do? anonymous@Anonymous:~/sqlite-autoconf-3080001$ make install make[1]: Entering directory ...
1
vote
1answer
921 views

How install sqlite3 from scratch

I'm trying to install sqlite3, but so far I'm unsuccessful. I tried following command sudo apt-get install sqlite3 but I get the following error: I've tried the solution in "Need help installing ...
1
vote
0answers
81 views

Activity Sqlite Conversion - Ubuntu 12.04

How to split or convert .sqlite datastore in a .sql/.json schema format? I am trying to use an analytic engine for the activity.sqlite datastore generated by zeitgeist.
0
votes
1answer
2k views

AttributeError: 'tuple' object has no attribute 'translate'

I am developing this program and for some reason, I keep getting this error. Is this an Ubuntu caused error, or something in my code that it crashing my program? I am accessing a database and trying ...
0
votes
1answer
381 views

sqlite3 timestamp (current_timestamp) one hour off

I run a small crawler on a virtual ubuntu server, initiated by crontab hourly. Datetime is inserted by defaulting the date filed to TIMESTAMP DEFAULT CURRENT_TIMESTAMP. Table creation looks like ...
5
votes
1answer
2k views

Cannot install sqlite3

OS: Ubuntu 12.04 LTS $sudo apt-get install libsqlite3-dev The following packages have unmet dependencies: libsqlite3-dev : Depends: libsqlite3-0 (=3.7.9-2ubuntu1) but 3.7.9-2ubuntu1.1 is to be ...
1
vote
0answers
59 views

SQLite encryption what package

I have an application witch uses an encrypted sqllite db with AES 128.I receive the error : File is encrypted or not a database. It is an ok database because on windows I can read it using the same ...
5
votes
3answers
2k views

How to install SpatiaLite 3 on 12.04?

I'm having some problems to install SpatiaLite 3 on Ubuntu 12.04, those are the steps to I did: 1) sudo apt-get install libsqlite3-dev libgeos-dev 2) libspatialite-3.0.0-stable$ ./configure ...
0
votes
1answer
395 views

sqlite2 does not work in 11.10

I have configured Ubuntu 11.10 in my PC. I have installed php 5.3.6-13ubuntu3.8. My problem is that after PC upgrade, sqlite2 is not supported in PHP. Also sqlite3 database is locked whenever I have ...
1
vote
1answer
2k views

Call to undefined function sqlite_open() in CLI mode

12.04 AMD 64 apt-get install sqlite php5-cli php5-sqlite php -r '$x = sqlite_open();' PHP Fatal error: Call to undefined function sqlite_open() in Command line code on line 1
2
votes
1answer
2k views

Missing ODBCConfig for SQLite and LibreOffice Base

I have used OpenOffice Base as a front end for SQlite databases, in 10.04 linked via ODBC. I am updating to 12.04, so I loaded LibreOffice Base, looks just like OObase. I have 12.04 on one drive and ...
1
vote
1answer
205 views

Where should I place my sqlite database for proper packaging?

I built my first application with quickly uses a sqlite database file. It contains all the settings of the program. While developing I simply put it into the root folder of the app. quickly package ...
1
vote
1answer
1k views

SQLite binary file does not work on my Ubuntu,

I'm new to sqlite , I just got the binary of sqlite by using wget http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip, then extract sqlite3 from the zip file, it does not work, it's driving me ...
2
votes
1answer
200 views

How to get the procedural interface back?

Setting up a new machine, I just discovered the procedural interface to SQLite3 seems to be gone: PHP Fatal error: Call to undefined function sqlite3_open() Is there any way to get that back again? ...
3
votes
3answers
7k views

SQLite stopped working after upgrade

As many of you did, I upgraded from Lucid to Precise this week and almost everything seems to work find. everything except… SQLite, which was working well before but not anymore. I checked ...
2
votes
2answers
75 views

Need database selection advise

I know this is considered a bad question since there is no correct answer, but I need to decide on a database for embedded linux (DaVinci 368 based) hardware and I've never had to produce a design ...
1
vote
1answer
2k views

configuration of Eclipse (C++ version) for running SQLite?

I need to run C++ code via eclipse which has SQlite. I can run it via terminal with typing g++ test.cpp -lsqlite3 . but how can I run it via Eclipse? how should pur the command "-lsqlite3" in its ...
2
votes
2answers
342 views

Error while installing rails

Following this tutorial here, to install ruby on rails on ubuntu 11.10 with sqlite3 when I run the following command sudo gem install rails I get the following error : ERROR: Could not find a ...
1
vote
2answers
12k views

Get a SQLite3 db in LibreOffice (via ODBC). Using Ubuntu 11.04 (64bit)

I'm stuck with this. I had SQLite working with OpenOffice in the past. But since then i reinstalled my machine and so... Now I can't get it to work. i pretty much followed this guide: ...
0
votes
1answer
289 views

Why do I get these strange errors when running PHP scripts?

I installed PHP and the SQLite extension using: sudo apt-get install php5-cli php5-sqlite However, each time PHP starts up, I get the message: PHP Warning: PHP Startup: Unable to load dynamic ...
0
votes
2answers
523 views

Accessing Sqlite3 via php not working?

my local web server on one machine running Ubuntu 11.04 works fine using php5 to access sqlite3 - however on a new machine running Ubuntu 11.10 the same code, same structure, does not work at all - ...
1
vote
2answers
1k views

How do I set SQLite data browser as the default application for .sqlite3 files?

When I try to open a .sqlite3 file, I get the following error: There is no application installed for SQLite3 database files When trying to select a default application, the SQLite database browser ...
4
votes
3answers
3k views

How can I restore a corrupted Shotwell db?

While I was importing photos from a SD card in Shotwell, my laptop has crashed (shutdown because of over-heating). Now, I can no longer launch Shotwell: $ shotwell ** ...
0
votes
1answer
509 views

Is there a binary package for php5-sqlite3 with fts3 enabled?

I would like to have PHP with SQlite with FTS3 extension enabled, as noted in Manual:SQLite - MediaWiki. I'm somewhat confused about FTS3 support in the default Ubuntu packages; from Bug #229003 ...
1
vote
1answer
2k views

How to execute query to a DB from a terminal and store output to a file?

I want to access this DB and I use this to access the SQLite DB: sqlite3 .mozilla/firefox/profile_name/places.sqlite The query that I want to execute to this DB and store the output in a text file is ...
2
votes
2answers
156 views

How do I finish the installation of a program from source?

I compiled sqlite3 from source code, version 3.6.16. I used --prefix=/usr/bin as my only compiling option. The binaries compiled and installed correctly, but at the directory /usr/bin/sqlite3/bin. So ...
3
votes
2answers
576 views

sqlite-ruby gem problem

I am trying to get my ruby on rails up and running but i can't seem to install sqlite3-ruby gem . When i run it i get this error : Fetching: sqlite-ruby-2.2.3.gem (100%) Building native ...
9
votes
2answers
5k views

How can I install SQLite to be used with OpenOffice?

My GPS uses a SQLite database. I would like to access this data using OpenOffice to look at the relationship between data entries. Is there a way to install SQLite with OpenOffice?