Skip to main content
Unix & Linux

Questions tagged [sqlite]

Ask Question

SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.

77 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
1 answer
84 views

I have a number of collections in Zotero (a bibliography manager). I would like to be able to open the associated PDFs using rofi or dmenu, and have a list of entries to choose from of the following ...
Rastapopoulos's user avatar
  • 1,909
1 vote
1 answer
128 views

General overview I have a `history.csv CSV file of urls formated like this: <url>;<title>;2024-03-30T12:00:00;2024-03-30T12:00:00 (The 2024-03-30T12:00:00 is the same) The goal is to get ...
fauve's user avatar
  • 1,529
1 vote
1 answer
140 views

Over the past year or two I've been using sqlite3 a lot for web development projects. Invariably I would stumble upon a problem where suddenly, the history of commands would no longer work (when ...
raddevus's user avatar
  • 123
0 votes
2 answers
122 views

I posted here. Here is my last-url.sh #!/bin/bash rm -rf /tmp/db.sqlite cp ~/.mozilla/firefox/*.default-esr/places.sqlite /tmp/db.sqlite ; LAST_URL=`sqlite3 /tmp/db.sqlite "...
r01_mage's user avatar
  • 1
0 votes
1 answer
456 views

I use sqlite3 for a PHP app. The functions I use are from the Sqlite3 package built in to PHP. I do not normal CRUD actions, including restarting the DB for testing. This includes dropping tables and ...
Vinn's user avatar
  • 236
0 votes
1 answer
152 views

OS: RockyLinux 8.5 This command works wonderfully: sqlite3 files.db "select file from A;" | rsync -R -av --files-from=/dev/stdin /SOURCE /DESTINATION/Out result without pipe: sqlite3 files....
Gary Schermer's user avatar
  • 1
0 votes
0 answers
183 views

I have a device running an embedded OS (Custom Linux buildroot). It is offline and has no package manager (apt, yum, et al.) and Python has several missing modules, one of which is key for our ...
WhiteRau's user avatar
  • 255
0 votes
1 answer
84 views

Is it possible to create tables based on a columns data? I currently have a table named Exchange which contains numerous columns ID:NAME:PRICE 1:Stick:12 2:Stone:20 3:Water:1 4:Water:1 But I want to ...
sql's user avatar
  • 1
1 vote
1 answer
4k views

I was asked to improve existing code to query SQLite databases. The original code made a lot of separate calls to the database and filtered the results in Python. Instead, I opted to re-write the ...
Bram Vanroy's user avatar
  • 183
0 votes
1 answer
1k views

the /var/cache directory keeps filling frequently due to yum metadata in centos 7.5 server. most of the space utilized by the below files. i have set keep cache to 0 in /etc/yum.conf as well. but ...
subash ct's user avatar
  • 1
0 votes
1 answer
3k views

I wish to run a bash script that asks for a variable to be then used in a sqlite query. I have no real experience in scripting, anyway I've tried something like the following but it doesn't work. ...
M.I.'s user avatar
  • 1
0 votes
3 answers
1k views

I have two bash variables $FNAMES and $LNAMES that I want to insert into a table in sqlite and I'm not quite sure how to do it. Here's a mwe: #!/usr/bin/env sh FNAMES="John Paul George Ringo&...
Brian Fitzpatrick's user avatar
  • 2,919
10 votes
1 answer
3k views

How would you modify function csv_to_sqlite so that sqlite3 command .import reads directly from standard input instead of from a temporary named pipe? #!/bin/bash function csv_to_sqlite() { local ...
Derek Mahar's user avatar
  • 567
0 votes
1 answer
1k views

I'm trying to figure out how to store the table names containing a geometry field from a sqlite3 database into a bash array that I can loop on afterwards. Here's what I have but it's empty for the ...
s.k's user avatar
  • 521
1 vote
1 answer
663 views

SQLite3 sets PRAGMA FOREIGN_KEYS = OFF by default. This is, of course, an invitation to problems. I know that I can turn on the PRAGMA permanently by placing the command in ~/.sqliterc, but the ...
Paddy Landau's user avatar
  • 346
0 votes
1 answer
1k views

I need help with installing a software. In general: I try to install PostGIS on a cluster (CentOS) and do not have admin rights. There is a sqlite3 installation (connected to the error), but this ...
jan's user avatar
  • 1
2 votes
1 answer
49k views

We have different python version installed and specifically using python3.7 so I have edited my .bashrc file. We are using Centos7 with Linux server. # .bashrc # Source global definitions if [ -f /...
Vikrant Singh Rana's user avatar
  • 252
2 votes
0 answers
360 views

I am setting up an ubuntu svn/apache2 server for our production environment. Also, it is mandatory, that the actual data is saved on a centralized location in our environment(different server, mounted ...
monatsend's user avatar
  • 121
0 votes
0 answers
4k views

I need to update Centos7's sqlite version to play nice with python3. By default Centos7 comes with sqlite 3.7 and I cant overwrite is since Centos7 uses it for other things. I tried to use this ...
Ari's user avatar
  • 1
1 vote
2 answers
432 views

I want to compare two sqlite databases, but there seems to be no sqldiff tool in sqlite package. I also can't find any other package providing sqldiff. I'm quite new to Fedora. Forgive my ignorance, ...
Radek Daniluk's user avatar
  • 121
0 votes
2 answers
3k views

I have a bunch of files that have just hashes as names and no file endings. (It's an iPhone backup to be precise.) I know there are SQLite databases amongst these files. How do I find them?
303's user avatar
  • 145
0 votes
1 answer
248 views

I needed the generated columns feature that has just been added to sqlite3 in the latest release. I managed to get it working in my python application on windows by simply replacing the relevant ...
Edward's user avatar
  • 1
2 votes
1 answer
554 views

Operating System = CentOS 6 I'm trying to install a package as follows: rpm -i package_name.rpm But I get the following error: error: Failed dependencies: sqlite >= 3.7.15 is needed by ...
MarkMark's user avatar
  • 603
0 votes
1 answer
10k views

migrate sqlite to mariadb inside a docker image? I installed the docker-compose example from the nextcloud readme (the base version with apache) but that one still uses sqlite, although there is ...
rubo77's user avatar
  • 30.6k
3 votes
4 answers
2k views

I am looking for effective and simple ID generation for the following content using bash script: {"name": "John", "surname": "Gates", "country": "Germany", "age": "20", "height": "180"} {"name": "...
Anna's user avatar
  • 53
0 votes
2 answers
3k views

I have a badly corrupted Sqlite file The usual trick of dumping everything into a sql file and loading it into a fresh file doesn't work, but with a hex editor I can see that the data I need to ...
user28226's user avatar
  • 3
5 votes
1 answer
3k views

I need to be able to do this via command line in one step: lab-1:/etc/scripts# sqlite3 test.db SQLite version 3.8.10.2 2015-05-20 18:17:19 Enter ".help" for usage hints. sqlite> .mode csv ; sqlite&...
dot's user avatar
  • 755
2 votes
1 answer
174 views

My goal is to read the macOS Photos.app database to find out the paths of the included photos. The album and the parent folder whose name is in the RKFolder table can be determined for each photo. ...
spazek's user avatar
  • 27
-1 votes
3 answers
73 views

I have a CSV file I wish to edit before importing it into a SQLITE DB. It has thousands of lines in it and I want to copy part of the line and append it to the end with a pipe "|" so that it can ...
Blindy's user avatar
  • 3
3 votes
1 answer
15k views

I've installed Python 3.6 on a Centos 7.4 box, and need an updated version of SQLite (I'm using some new features). The SQLite version that comes with it is very old: 3.7.17. How is this done? On ...
linux_confusion's user avatar
  • 31
1 vote
2 answers
2k views

I'm trying to run a sqlite3 query against a small DB to update a table. While the script is more complicated, for testing I set the following variables: DN=123 UP=123 downlocalip=10.1.2.3 ...
Matthew Hodder's user avatar
  • 13
10 votes
4 answers
13k views

I have written a program that outputs the result to the standard output in strict pure CSV form (every line represents a single record and contain the same set of comma-separated fields, fields only ...
Ivan's user avatar
  • 18.5k
1 vote
0 answers
812 views

I'm trying to make apache load basic auth credentials from a sqlite3 database. The configuration I've tried (and many other variations) is: <VirtualHost *> ServerAdmin [email protected] ...
Flavius's user avatar
  • 351
2 votes
2 answers
31k views

I want to write a shell script that firstly opens sqlite and then makes a copy of a table and finally deletes the contents of that table. How can I do it in a shell script? >>cd /var/www/dbs &...
Ahmad Fatehi's user avatar
  • 51
15 votes
4 answers
24k views

I'm trying to save clipboard content into an sqlite database. Created database and tables. I don't want it to create journal file in every clipboard change, so I tried to pass PRAGMA journal_mode = ...
kenn's user avatar
  • 783
2 votes
1 answer
1k views

I'm trying to open the listchanges.db file located under /var/lib/apt/ with DB Browser for SQLite under Debian 9.1 with KDE and it says: "Invalid file format." How can I open it?
mYnDstrEAm's user avatar
  • 4,980
1 vote
0 answers
1k views

Since I installed Anaconda, and use sqlite3 within it, I've been trying to write some C++/sqlite3 codes. However, I would like to also utilize the dev files for sqlite3 but would rather not install ...
nate's user avatar
  • 293
2 votes
1 answer
267 views

Ok now that I have generously coated myself in flame-war retardant. I have an existing webapp/server written in c++/qt. Having selected OpenBSD as the hosting OS for security reasons. If I use ...
ArchNemSyS's user avatar
  • 217
2 votes
3 answers
2k views

sqlite3 stores command history in .sqlite_history, which is by default created in: $HOME/.sqlite_history How can I change this location to somewhere else? This is possible for example with mysql, ...
Martin Vegter's user avatar
  • 898
27 votes
1 answer
15k views

I made a mistake writing a command at the SQLite command prompt, which I now want to abort, this is how my command line looks sqlite> select * from todos' ...> ' ...> ;^C In this case, ...
the_velour_fog's user avatar
  • 12.8k
2 votes
2 answers
5k views

The SQLite documentation for its command line client indicates that its possible to filter output of SQLite queries through UNIX utilities: The default output mode is "list". [...] List mode is ...
the_velour_fog's user avatar
  • 12.8k
1 vote
2 answers
3k views

I create a SQLite file like this: sqlite3 output.db < myinserts.sql Unfortunately it takes hours, so I want to speed it up by using the following PRAGMAs: PRAGMA synchronous=OFF PRAGMA ...
Nicolas Raoul's user avatar
  • 8,485
1 vote
1 answer
4k views

I am trying to copy WeChat database file called EnMicroMsg.db so I can view it in SQLite browser. With my Nexus 7 tablet rooted and physically connected, the usb debugging checked I ran the following ...
e.kenny67's user avatar
  • 21
1 vote
1 answer
1k views

I have many .dat files containing specific fields such as <Overall>, <Content>, <Cleanliness> all with a number next to them. I have the code to be able to extract the data from ...
tom's user avatar
  • 105
1 vote
1 answer
839 views

I need to work with nmap and sqlite3 and I installed lua 5.1 and lua-sql-sqlite3 on an ubuntu machine: sudo apt-get install lua5.1; sudo apt-get install lua-sql-sqlite3 Now, when I'm doing this: $ ...
Sebastian Rockefeller's user avatar
  • 123
1 vote
2 answers
990 views

I have a distro based on Debian Jessie running on an ARM device. How can I install a simple, secure ownCloud 8.2.2 installation that uses NGINX and SQLite without installing Apache and MySQL? Many ...
LJD200's user avatar
  • 63
2 votes
3 answers
2k views

I want to format SQLite output in JSON format from the command line. Currently, I have CSV output that looks like this: label1,value1 label2,value2 label3,value3 ... Now I'd like to have it formatted ...
michelemarcon's user avatar
  • 3,593
1 vote
1 answer
554 views

I am trying to build a very simple login page, which asks the user for his register_no, username and password. And when he presses the submit button. I am trying to check whether it is an existing ...
Tasdik Rahman's user avatar
  • 139
2 votes
0 answers
538 views

I tested a simple Php program using Sqlite3 instead of mySQL on my own computer and it works fine. What the program does is simple insert of record into a certain table. Now, when I try to do that on ...
Edper's user avatar
  • 121
6 votes
2 answers
3k views

I have a node.js process which writes to many different sqlite databases. Sqlite can handle only one concurrent write per database, which is fine since there will be only one write per database at a ...
Kaizer Sozay's user avatar
  • 749

1
2