Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sqlite]

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

0
votes
0answers
12 views

Unmet dependencies, broken packages (sqlite3) [duplicate]

The problem I have : I am running bash from windows 10. When I do this command : sudo apt-get install sqlite3 sqlite3-doc I get this message : Reading package lists... Done Building ...
1
vote
0answers
72 views

Ubuntu 18.04, PHP 5.3 installing

I have on my server Ubuntu 18.04 LTS 64bit with Plesk the PHP 5.3 with the instructions Can I install PHP 5.3.5 on Ubuntu Server 18.04 LTS? Installed So far, he has carried out the installation ...
0
votes
0answers
43 views

“Error: unable to open database” when creating sqlite3 database in terminal

The other questions I've seen deal with this have to do with creating databses through Django or some other Python framework. I am simply trying to create a database with $sqlite3 database.db. It ...
0
votes
1answer
42 views

db browser sqlite on 16.04

I recently upgraded from ubuntu 14.04 to 16.04. And found db browser for sqlite to be version 3.7.0 While it was 3.9.99 with 14.04 (and current version is 3.10.1) Any reason it was switched back to ...
3
votes
1answer
70 views

Why is SQLite compiled with the OMIT_LOOKASIDE option in Ubuntu 18.04?

I am working on a project using SQLite and I need an option enabled that is not enabled in the version installed on my Ubuntu 18.04.1 box. No big deal - I can easily grab the source and build my own ...
0
votes
1answer
392 views

How to install SQLite backend for GnuCash on Ubuntu 18.04?

I was using GnuCash without problem on Ubuntu 16.04. Now I am not able to open GnuCash file after switching to 18.04. It give this message: No suitable backend was found for... If I remember ...
0
votes
2answers
102 views

How to upload sqlite3 database to webserver? [closed]

I am very new to this. There is tuptime.db file which has records of uptime in my computer(local server). How can I upload it to web server and show the database content in a website. I want something ...
0
votes
2answers
1k views

How to open and read SQLite files

I am trying to recover something from Mozilla Firefox history, and grep returns lots of binary files, I think they come from sqlite content. How can I view them in human-readable form, as text? At the ...
1
vote
0answers
164 views

Undefined symbol error

I'm working on a base project by someone else and I'm kind of new to the Linux system. I know how to use sqlite3 in Windows' Visual Studio, however in Linux it's not working. I've come to the ...
1
vote
1answer
900 views

How to recover deleted SQLite database files?

How to recover deleted SQLite database files? Using magicrescue tool with the following params simply extracts the SQL query files instead: sudo magicrescue -r sqlite -d ~/output /dev/hdb1
-1
votes
1answer
495 views

Which sqlite database uses new Skype for Linux?

Skype for Linux version 4.3 stores data on ~/.Skype/<user>/main.db. I installed recently a new version 5.5.0.1 that changes completely its GUI. Note: I also tested Skype Insider version 8.x.x....
0
votes
1answer
691 views

sqlite database locking

I would like to know about the locking method in sqlite. I am using some python scripts using sqlalchemy to write to sqlite db. There are lot of scripts writing to the db simultaneously and I am ...
-1
votes
1answer
58 views

PHP warning files

I installed php 5.6 in ubuntu 16.04 and I installed package sqlite but now I have this problem
-3
votes
1answer
60 views

Where to find 'libodb-sqlite' package for 14.04? [closed]

I am a user of Ubuntu 14.04 and need to install the package libodb-sqlite. However, this is not yet available for my version of Ubuntu. I have seen if for the later Ubuntu version 16.04. What shall I ...
2
votes
1answer
421 views

“Unmet dependencies” when installing SQLite driver in PHP7 on 16.04

This is a bit of a weird one. When I run sudo apt-get install php7.0-sqlite3 I get told that Some packages could not be installed. This may mean that you have requested an impossible situation or if ...
0
votes
0answers
52 views

Background process no longer has access to .db file after I log out

I have a java application which I start with... nohup java -cp MyServer.jar > log.txt 2> errors.txt < /dev/null & The application is just a web-service that provides a few methods to ...
2
votes
1answer
1k views

Install command line tool sqlite3

Trying to install sqlite3 command line tool with : sudo apt-get install sqlite3 libsqlite3-dev But I still can't run ./sqlite3 - nu souch file How to solve this problem?
1
vote
1answer
2k views

SQLite error after COTURN installation on Ubuntu Server 16.04.1

I'm Installing COTURN on Ubuntu Server 16.04.1 according instructions from here. All steps done well but when trying to run turnserver this error happens: Error retrieving SQLite DB information: file ...
13
votes
1answer
19k views

How to properly view a .sqlite file using sqlite?

I have installed the program sqlite in order to view file types with that extension, however even after reading its help documentation and its manpage, I am still confused about how I get it to show ...
0
votes
1answer
192 views

Open SQL Light DB from Unity

I have installed sqlitebrowser to browse database. But when I try to open db from Unity I have only one option Open with gedit When I choose open With Other Application... I cant find sqlitebrowser. ...
1
vote
0answers
220 views

Sqlite, DB clients & BLOB's: Practical DB Use

I'm looking for a client that helps me to make practical use of a DB. I'm looking at SQLite since it's simple, embedded (stored in a file rather than accessed via a server) and has a shell interface ...
3
votes
1answer
91 views

How can I use sqlite3 in my Ubuntu Phone app? (C++ backend)

I want to create an app, which has a C++ backend and uses sqlite3. I can connect to an Database in memory using the following code:m_db = QSqlDatabase::addDatabase("QSQLITE"); m_db.setDatabaseName(":...
3
votes
1answer
3k views

How do I install sqlite3 ODBC drivers with unixODBC?

According to the unixODBC drivers page (straight out of the 90s), I should download the SQLite3 drivers from: http://www.ch-werner.de/sqliteodbc The instructions for building sqliteodbc from the ...
0
votes
1answer
2k views

running sqlite from php5-sqlite install

I have installed php5 and sqlite3 by using: sudo apt-get install -y php5 php5-sqlite unzip But when I run sqlite (or sqlite3) in the terminal, it says that I need to install it using apt-get. I ...
0
votes
1answer
280 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
2answers
5k 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
128 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 'sqlite3'...
0
votes
1answer
6k views

“No module named 'pysqlite2'” Error

I am trying to run a server, but I get this error: $ python manage.py runserver Traceback (most recent call last): File "/home/user/Demo/lib/python3.4/site-packages/django/db/backends/sqlite3/base....
0
votes
1answer
954 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
2answers
2k 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 ...
1
vote
1answer
665 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 ...
9
votes
4answers
10k 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
248 views

Why is mysql run in server-client model?

From https://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 mysql-...
2
votes
0answers
172 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 ...
7
votes
1answer
25k 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 ...
2
votes
1answer
3k 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
494 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: libsqlite3-...
1
vote
1answer
154 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
7k 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
5k 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 3.6....
0
votes
1answer
458 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
401 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. I'...
2
votes
2answers
3k 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
8k 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.
12
votes
3answers
46k 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 `/home/...
2
votes
1answer
4k 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 "Unable to locate package ...
6
votes
1answer
27k 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
1k 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 ...
8
votes
1answer
5k 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
2answers
4k 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 Result:...