Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
77 questions
1
vote
1
answer
64
views
Open reference from Zotero using rofi / dmenu
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 ...
- 1,889
1
vote
1
answer
114
views
Add list of urls to the Qutebrowser’s sqlite3 history
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 ...
- 1,529
1
vote
1
answer
110
views
Why doesn't my sqlite3 history work after I run a dotnet core web app?
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 ...
- 123
0
votes
2
answers
91
views
places.sqlite buggy? seems to behave abnormally. How to get $LAST_VISITED_URL?
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 "...
- 1
0
votes
1
answer
403
views
SQLite3 randomly changes file permissions and owner
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 ...
- 236
0
votes
1
answer
130
views
Pipe sql query to find command
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....
0
votes
0
answers
168
views
how to install missing python modules offline without managers
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 ...
- 255
0
votes
1
answer
70
views
Sqlite table creation
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 ...
- 1
1
vote
1
answer
4k
views
What exactly is being cached when opening/querying a SQLite database
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 ...
- 183
0
votes
1
answer
1k
views
/var keeps filling due to yum cache
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 ...
0
votes
1
answer
3k
views
Bash script for sqlite commands [duplicate]
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. ...
- 1
0
votes
3
answers
1k
views
Can the words in these bash strings efficiently be inserted into an sqlite table?
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&...
- 2,917
10
votes
1
answer
3k
views
How can SQLite command ".import" read directly from standard input?
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 ...
- 567
0
votes
1
answer
1k
views
Store sqlite3 table names in a bash array
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 ...
- 521
1
vote
1
answer
642
views
Can I pass a PRAGMA to sqlite3 using an environment variable (Bash)?
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 ...
- 346