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

learn more… | top users | synonyms

1
vote
1answer
24 views

How to identify programically in QML app, where is located my sqlite database file

I have QML application which use as well C++ . From C++ I need to connect to DB ( sqlite ) . For this I need to know the exact name and location of the database file . How to identify it ? Or how to ...
0
votes
1answer
43 views

Django and SQLite3 doesn't work

My problem is following, I'm starting with tutorial https://docs.djangoproject.com/en/1.8/intro/tutorial01/ , and after I type in terminal python manage.py runserver I'm getting an error: Traceback ...
0
votes
1answer
45 views

Was Installing Syncevolution, when I came across the following messages!

I was trying to build syncevoltion, and I came across the following error after ./configure checking for SQLITE3... configure: error: Package requirements (sqlite3) were not met: No package ...
0
votes
1answer
665 views

“No module named 'pysqlite2'” Error

I am trying to run server,but I get this error: (Demo)user@mylaptop:~/Demo/Demo$ python manage.py runserver Traceback (most recent call last): File ...
0
votes
1answer
42 views

How can I change the mode of Sqlite Database?

I want to add some record in my database it is read_only by default, how I can change its mode to add the record. I want some linux command, I was trying gfix but it failed to execute.
-1
votes
1answer
184 views

class SQLite3 not found

After struggling through a lot of pages and answers i am still unable to use sqlite with php. i am using fresh install of Ubuntu, Apache 2, SQLite3 and Php5. I am still getting class SQLite3 not ...
0
votes
1answer
99 views

sqlite make test fails because of “tcl.h not found” or “undefined reference to Tcl_Free”

I have obtained the sqlite source code with: sudo apt-get install fossil mkdir sqlite cd sqlite fossil clone http://www.sqlite.org/cgi/src/doc/trunk a fossil open a rm a and compiled it with the ...
3
votes
3answers
128 views

Which apps read/write an SQLite 3 database in Ubuntu?

Have an app on another device which exports an SQLite v3 database. I wish to read and alter the content of that .db file. Tried Libre Office Base, no joy. Which apps will read that .db file, and edit ...
0
votes
1answer
47 views

Why is mysql run in server-client model?

From http://stackoverflow.com/questions/11657829/error-2002-hy000-cant-connect-to-local-mysql-server-through-socket-var-run Please make sure that you have installed the mysql-server, not the ...
0
votes
0answers
127 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 ...
1
vote
0answers
41 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
3k 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
1k 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
122 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: ...
1
vote
1answer
59 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 ...
5
votes
2answers
3k 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 ...
1
vote
1answer
2k 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
1answer
201 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 ...
3
votes
0answers
281 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. ...
2
votes
2answers
615 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
5k 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.
2
votes
1answer
16k 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 ...
2
votes
1answer
2k 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 ...
0
votes
1answer
4k 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
598 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
3k 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 ...
5
votes
3answers
3k 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
492 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
3k 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
3k 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
231 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
257 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? ...
4
votes
3answers
8k 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
82 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
357 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
14k 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
295 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
561 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
591 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 ...
2
votes
1answer
4k 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
176 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
626 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
6k 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?