Questions tagged [sqlite3]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

phpliteadmin won't accept my directory

I have a system-wide apt install of phpliteadmin 1.9.8.2 on Ubuntu 22.10. In my /etc/phpliteadmin.config.php file I've tried to give a directory $directory = '/home/homedir/Dropbox/org/databases'; ...
  • 2,115
0 votes
1 answer
41 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 ...
  • 1,031
0 votes
0 answers
25 views

Sqlite3 editor - viewer

is there any (free) program for sqlite3 viewer. I used db browser for sqlite3 but it doesn't have all available sqlite3 data types (datetime,varchar,...)
  • 179
0 votes
0 answers
529 views

Installing libsqlite3-0 and libsqlite3-dev from sources on Ubuntu 18.04

So I have Ubuntu 18.04 under which the newest version of sqlite3 (and libsqlite3-dev and libsqlite3-0) that can be installed with apt is 3.22.0. And I want to install v3.25.0 or higher because it ...
  • 101
0 votes
1 answer
591 views

sqlite3_error in Ubuntu20.04

I met a strange problem when using Ubuntu 20.04 LTS. When I type any non-meaning word in the command line, such as a letter A, it returns something related to python3.8 with "ImportError: /usr/...
  • 1
2 votes
0 answers
110 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 ...
2 votes
1 answer
1k views

Using Json1 Extension with sqlite3

The docs says, that The json1 extension is a loadable extension for sqlite3, and the loadable extensions need to be compiled as shared libraries (source). I searched a lot and I don't know how to ...
  • 883
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
0 answers
689 views

error when compiling sqlite

I received this error when compiling sqlite: Makefile:743: recipe for target 'alter.lo' failed make[4]: * [alter.lo] Error 1 CMakeFiles/external_sqlite.dir/build.make:113: recipe for target '...
0 votes
1 answer
169 views

problem installing sqlite3 using apt-get install

Installation hangs at 4% completion due to a prompt requesting acceptance of Oracle's license agreement. No way to respond interactively.
2 votes
2 answers
138 views

How do I invoke the sqlite3-doc package

I installed the package but can't figure out how to use/start it. What I'm am looking for is a interactive help/docs for sqlite3 I assumed that what this package does but I don't know how to start it. ...
  • 123
1 vote
1 answer
1k views

Installing qgis in ubuntu 18.04 error with sqlite tables, can no longer use apt

I'm getting the following error: $ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass Reading package lists... Done Building dependency tree Reading state information... ...
  • 1,590
5 votes
2 answers
2k views

nautilus: symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/libtracker-data.so.0: undefined symbol: sqlite3_bind_pointer

I upgraded to Ubuntu 18.04 and I can't get Nautilus to work. I get the following error when I launch it from the command line: nautilus: symbol lookup error: /usr/lib/x86_64-linux-gnu/tracker-2.0/...
1 vote
2 answers
1k views

I messed up ocamlfuse by using sudo command "Error: Sqlite3 error: READONLY"

I started using ocamlfuse to access google drive with Nautilus and it was functioning perfectly fine. The thing is, at some point I used, by accident, the sudo command, I'm not shure if it was to run ...
0 votes
1 answer
715 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
4 votes
1 answer
25k views

Install Ubuntu package, php7.0-sqlite3 missing

Ubuntu with php7 Error occurs when trying to use SQLite3 from php: PHP Fatal error: Class 'SQLite3' not found in /var/www/html/index.php on line 1 I've tried to install php7.0-sqlite3 : $ sudo ...
0 votes
0 answers
3k views

Error package 'sqlite3>=3.7.11' not found

I clone a project from github and run cmake, but I get the message: -- checking for module 'sqlite3>=3.7.11' -- package 'sqlite3>=3.7.11' not found CMake Error at /usr/share/cmake-2.8/Modules/...
  • 101
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,247
37 votes
1 answer
70k 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
56 views

How do I re-enter a sqlite database that I already created?

I am using sqlite3 and created a new database in the terminal by using: sqlite3 test.db I then created some tables in this database but then I closed sqlite3. How can I re enter my test.db? Do I ...
31 votes
1 answer
56k views

How to Exit sqlite3 in terminal

I have ran sqlite3 from terminal but have problem exiting it. this is how i have ran it: sqlite3 database.db i have tried CTRL+C but it wont exit, i have tried ESC, close(), exit() and it doesn't ...
  • 453
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
7 votes
4 answers
17k views

Can SQLite3 be upgraded on Ubuntu?

I would like to upgrade SQLite3 on my Ubuntu instance that is running version 3.8.2. The current release is 3.11.1.x. I wanted to know if there is any risk in doing so since SQLite3 is a core tool ...
0 votes
1 answer
1k views

Unable to acess SQLite database in Ubuntu using PHP under Apache

I am having trouble using SQLite3 with PHP in Ubuntu but it works well with Windows. In Ubuntu I have installed the php-sqlite package and the SQLite database is made using SQLite3.
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
700 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'...
2 votes
1 answer
4k views

SQLite >= 3.8.3 version on Ubuntu 14.04

Please, is there a simple way to install SQLite >= 3.8.3 on Ubuntu 14.04 LTS. By now, is impossible to do this via apt-get because only SQLite 3.8.2 it's available at the "Trusty" repositories. I need ...
  • 151
3 votes
1 answer
3k views

SQLite 3.8.8 in Ubuntu 14.04 via apt-get

How to install the SQLite 3.8.8 in Ubuntu 14.04 via apt-get? The default installation is for 3.8.2. Thanks, Christian
  • 151
-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
651 views

Not able to include sqlite3 in c program

I installed libsqlite3-dev from ubuntu software center and after the installation, i found the sqlite3.h file in usr/include folder. There was no error in including that header file, but i am not able ...
1 vote
1 answer
929 views

Custom compile sqlite as php so

In Compile sqlite with soundex feature I learned how to do a custom compile of sqlite. While this was a step towards my goal of using sqlite's soundex in a functional test, I find I'm not there yet. ...
  • 147
0 votes
1 answer
633 views

Compile sqlite with soundex feature

In 14.04 LTS: I'm trying to build a functional test of a Symfony application that uses the soundex() function in MySQL. The test environment uses sqlite, which by default does not compile its soundex(...
  • 147
0 votes
1 answer
356 views

sqlite3 - humongous dependency list?

$ sudo apt-get install sqliteman* sqlite3* gives me a display that includes this: ... Recommended packages: bacula-sd-mysql bacula-sd-tools cl-sql-backend ada-reference-manual gdb-minimal php-...
  • 4,375