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
71 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,909
1 vote
1 answer
113 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
1 answer
420 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
0 answers
171 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
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
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
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
1 vote
1 answer
647 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