Questions tagged [sqlite]

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

89 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
16
votes
3 answers

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/anonymous/sqlite-autoconf-3080001' /bin/mkdir -p…
leon
  • 161
13
votes
5 answers

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 it? Hoping for a GUI app.
K7AAY
  • 17,735
10
votes
1 answer

How to execute query to a DB from a terminal and store output to a file?

I want to access this DB and I use this to access the SQLite DB: sqlite3 .mozilla/firefox/profile_name/places.sqlite The query that I want to execute to this DB and store the output in a text file is SELECT moz_places.url FROM moz_places How do I do…
Nitin Venkatesh
  • 22,809
10
votes
1 answer

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 installed $sudo apt-get install libsqlite3-0 Building…
CodeFarmer
  • 213
10
votes
2 answers

How can I install SQLite to be used with OpenOffice?

My GPS uses a SQLite database. I would like to access this data using OpenOffice to look at the relationship between data entries. Is there a way to install SQLite with OpenOffice?
RunningUtes
  • 3,972
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
  • 1
  • 3
8
votes
1 answer

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 each of the contact. For it I installed Sqliteman…
PHPLover
  • 1,807
7
votes
1 answer

SQLite binary file does not work on my Ubuntu,

I'm new to sqlite , I just got the binary of sqlite by using wget http://www.sqlite.org/sqlite-shell-linux-x86-3071300.zip , then extract sqlite3 from the zip file, it does not work, it's driving me crazy, please HELP. My OS is Ubuntu 12.04 64-bit,…
vicd
  • 511
6
votes
1 answer

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 to remove the following characters from output:…
RPiAwesomeness
  • 9,941
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
3 answers

How can I restore a corrupted Shotwell db?

While I was importing photos from a SD card in Shotwell, my laptop has crashed (shutdown because of over-heating). Now, I can no longer launch Shotwell: $ shotwell ** ERROR:x86_64-linux-gnu/db/VersionTable.c:104:version_table_construct: assertion…
Yann Dìnendal
  • 346
5
votes
3 answers

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 ./configure && make && sudo make install But now…
Lucio
  • 19,199
5
votes
2 answers

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: configure: error: cannot find proj_api.h, bailing…
Terra
  • 151
5
votes
2 answers

Tracker-miner-fs keeps crashing on Ubuntu 22.04

I'm managing a fleet of 25 Ubuntu 22.04 systems. On one of them (possibly more I haven't discovered yet), tracker-miner-fs keeps crashing, and I can't figure out how to get control of that. I have Ubuntu 22.04 with all the latest updates installed.…
Kevin Keane
  • 207
1
2 3 4 5 6