Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
225 views

How can I start SQLiteStudio on Ubuntu?

I've seen the other threads on installing .tar.xy files, but SQLite Studio doesn't come with an installer. From the website - "All files are portable packages (no installer, just download, ...
1
vote
0answers
120 views

sqliteman no longer available?

Just upgraded to Kubuntu 20.04. Been putting it off for ages. It appears my favorite sqlite3 front-end won't install anymore? Any way around this? I use it all the time.
2
votes
0answers
65 views

Thunderbird wont start. Crash reporter says sqlite version error

my Dad cant get thunderbird to start. This started after he got tired of the nag screens and updated ubuntu. He is now running ubuntu 20.04.1 and thunderbird 68.10.0 Whenever he types thunderbird at ...
1
vote
0answers
27 views

Desktop freeze when using the desktop as destination path for a sqlite database (Ubuntu 20.04)

i wrote a little php testscript. The script insert 10000 numbers into a sqlite database. (I know, it is stupid and senseless to do 10000 insert statements in a loop.) But, when i using the home-...
0
votes
1answer
91 views

Where is the database for feedreader?

It's implied: https://code.launchpad.net/~eviltwin1/feedreader/sqlite that feedreader uses sqlite or that it can be configured to do so. I looked in the .config folder, but didn't see anything ...
0
votes
1answer
88 views

Should I always use the terminal for a portable program?

I got the portable version of SQLite Studio from the website https://sqlitestudio.pl/. I am a new ubuntu user and wonder. Should I always go to the file location and run the executable file to launch ...
0
votes
1answer
3k views

Problem with installing sqlite browser

Unfortunately I am unable to install sqlite browser. The issue that pops up is :"Unable to install sqlite browser: no snap revision on specified channel". Can anyone help me with proceeding? Cheers, ...
0
votes
0answers
202 views

Thunderbird: How to recover email passwords if master-password is known?

I forgot one of my email passwords. And it's still saved in Thunderbird that ran on Kubuntu. But now my Kubuntu is broken, and I cannot open thunderbird's GUI. The only thing I know is username and ...
1
vote
0answers
27 views

How to get Sqlite with PHPBB to work with apache2

I was wondering if anyone knew the steps/modules I needed in order for PHPBB to work with sqlite? I've got mysql working, but I want to intigrate it with another piece of software that uses only ...
8
votes
4answers
2k views

Is it possible to install SQLite 3.24+ on Ubuntu 18.04?

I am trying to update my SQLite version to 3.24 or above so that a Python app can make use of the new "UPSERT" queries. I have been trying for a few hours to do this with little success; it refuses to ...
0
votes
1answer
352 views

How to install specific(older) version of sqlite

I want to install a previous version of SQLite(<=3.26.0). And so far I am not able to find a way to do so in ubuntu. As my current version is causing me bugs with a Django project.
1
vote
0answers
2k 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
1answer
873 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
211 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
152 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 ...
1
vote
1answer
1k 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
702 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
6k 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
376 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
2k 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
0
votes
1answer
657 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
1k 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
71 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
83 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
1k 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
98 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
3k 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?
2
votes
2answers
4k 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 ...
28
votes
1answer
51k 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
223 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
249 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 ...
2
votes
1answer
116 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(":...
5
votes
1answer
5k 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
3k 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
323 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
7k 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
645 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
7k 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
2k 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
3k 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
1k 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 ...
14
votes
5answers
15k 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
262 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
199 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 ...
8
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
4k 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
573 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
213 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
3answers
9k 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
6k 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....