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
1 answer
30 views

Notification when a record in an SQLITE database gets too low

I'd like to be notified when inventory in an sqlite database drops below a certain level. The amount drops by a set number every day, and I update the database via a cron job in the evening. The cron ...
  • 857
0 votes
2 answers
85 views

zdb.Connect: zdb requires SQLite 3.35.0 or newer

I'm trying to install goatcounter on Ubuntu 20.04. There's no help at Github goatcounter issues https://github.com/arp242/goatcounter/issues I'm getting the error "zdb.Connect: zdb requires ...
0 votes
0 answers
140 views

Sqlite is a read only database error

I want to run manic time server on my Ubuntu server but when I run manic time I get this error how can I solve this? Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 8: 'attempt to ...
  • 1
0 votes
0 answers
237 views

Is it possible to rebuild Python3.8 installed by "apt install"?

I am facing module missing issue. https://stackoverflow.com/questions/43993890/modulenotfounderror-no-module-named-sqlite3 After some survey, the only way to fix it (as far as I know) is "install ...
  • 101
2 votes
0 answers
154 views

E: Sub-process /usr/bin/dpkg returned an error code (1) (When installing sqlite on a raspberry pi running ubuntu 18.04)

I am trying to install sqlite onto the raspberry pi I have been using. The following error code appears and any attempts to fix it have failed so far. I have tried reinstalling python3.6, purging the ...
  • 21
1 vote
1 answer
2k 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, ...
0 votes
0 answers
217 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
0 answers
101 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
0 answers
33 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
1 answer
116 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
1 answer
161 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 ...
  • 3
0 votes
2 answers
4k 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, ...
  • 1
0 votes
0 answers
332 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 ...
  • 151
1 vote
0 answers
36 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
4 answers
4k 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
1 answer
554 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
0 answers
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
1 answer
1k 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 ...
  • 295
0 votes
1 answer
267 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
1 answer
180 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
1 answer
2k 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 ...
  • 475
0 votes
2 answers
888 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 ...
2 votes
2 answers
9k 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
0 answers
509 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
1 answer
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
  • 938
0 votes
1 answer
703 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....
  • 229
0 votes
1 answer
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 ...
  • 151
-1 votes
1 answer
72 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
1 answer
86 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
1 answer
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 ...
  • 123
0 votes
0 answers
103 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 ...
  • 829
2 votes
1 answer
4k 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?
  • 4,067
2 votes
2 answers
5k 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 ...
  • 1,222
36 votes
1 answer
66k 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 ...
user avatar
0 votes
1 answer
232 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. ...
  • 4,067
1 vote
0 answers
274 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 ...
  • 420
2 votes
1 answer
137 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(":...
  • 173
5 votes
1 answer
6k 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 ...
user avatar
0 votes
1 answer
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
1 answer
357 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 ...
  • 1,861
0 votes
2 answers
8k 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
1 answer
698 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'...
1 vote
1 answer
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
1 answer
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.
  • 393
-1 votes
2 answers
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 ...
2 votes
1 answer
2k 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
5 answers
16k 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 ...
  • 16.4k
0 votes
1 answer
268 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-...
  • 23.6k
2 votes
0 answers
218 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 ...
  • 4,363
8 votes
1 answer
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 ...
  • 1,711