Ask Ubuntu
Ask Ubuntu

Questions tagged [sqlite3]

36 questions
50
votes
1 answer

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 me what I want. So how exactly do you use this…
user364819
36
votes
1 answer

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 let me go.
senaps
  • 503
  • 1
  • 5
  • 12
9
votes
4 answers

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 update past 3.22. I have attempted: Using apt…
pkiller162
  • 191
8
votes
4 answers

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 to Ubuntu and many apps use it. If its safe to do,…
J.D. Corbin
  • 81
5
votes
1 answer

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 source code provided on that page is available here:…
user390136
5
votes
2 answers

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/libtracker-data.so.0: undefined symbol:…
Lorena Malpica
  • 51
4
votes
1 answer

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 apt-get install php7.0-sqlite3 Reading package…
Grigory Ilizirov
  • 175
4
votes
3 answers

Installing DBSqlite Browser on Ubuntu

I tried to install DBSqlite Browser for Ubuntu and Derivatives. After installation, I enter the command to open Ubuntu in the terminal: "sqlitebrowser" and the following crashes: qt.qpa.xcb: could not connect to display qt.qpa.plugin: Could not…
IlVin
  • 41
  • 1
  • 4
3
votes
1 answer

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
Britto
  • 149
2
votes
1 answer

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?
vico
  • 4,717
  • 23
  • 66
  • 89
2
votes
1 answer

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 to use the functions declared in it. It shows…
user3636470
  • 29
2
votes
0 answers

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 the terminal console it throws up a thunderbird…
MajorTom
  • 21
2
votes
1 answer

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 enable them. I found that the compiled shared…
xpt
  • 1,197
2
votes
2 answers

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. Thanks in addvance.
Sruly
  • 133
1
vote
2 answers

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 ocamlfuse: sudo google-drive-ocamlfuse Or if I…
Eduardo Flores
  • 11
1
2 3