Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
72
questions
0
votes
1
answer
69
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
46
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 ...
- 213
0
votes
1
answer
41
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
2k
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
888
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
2k
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
730
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,785
8
votes
1
answer
2k
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 ...
- 505
0
votes
1
answer
662
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 ...
- 429
1
vote
1
answer
395
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 ...
- 316
0
votes
1
answer
853
views
Libtool searches wrong directory while path specified
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 ...
- 1
2
votes
1
answer
42k
views
ModuleNotFoundError: No module named '_sqlite3'
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 /...
- 248
2
votes
0
answers
246
views
Using subversion on an CIFS mounted share
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 ...
- 121
0
votes
0
answers
3k
views
Updating Sqlite3 on Centos7 64bit
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 ...
- 1
1
vote
2
answers
249
views
How to install sqldiff tool in Fedora 31
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, ...
- 121
0
votes
2
answers
2k
views
How do I find all sqlite databases inside a bunch of files without file endings?
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?
- 145
0
votes
1
answer
195
views
How to exchange sqlite3 executable with latest version on my raspberry pi?
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 ...
- 1
2
votes
1
answer
477
views
Using 'rpm -i' to install a package on CentOS6 but getting dependency error, even though I have installed the dependency, why?
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 ...
- 563
0
votes
1
answer
9k
views
Migrate nextcloud sqlite database to mysql inside docker
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 ...
- 28.2k
3
votes
4
answers
2k
views
Generating unique IDs for json content indexing
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": "...
- 53
0
votes
2
answers
2k
views
Replacing non printable characters with hex numerical values
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 ...
3
votes
1
answer
3k
views
sqlite3 command line - how to set mode and import in one step
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&...
- 695
2
votes
1
answer
152
views
Sqlite: replace a string modelID1/modelID2/modelID3 with name1/name2/name3/
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. ...
- 27
-1
votes
3
answers
67
views
sed or awk reformatting a line by copying part of it to the end of the line
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 ...
- 3
3
votes
1
answer
14k
views
Updating the SQLite version used by Python 3 on CentOS 7
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 ...
0
votes
2
answers
2k
views
SQLite3 Query storing IP address syntax error
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
...
10
votes
4
answers
10k
views
How to insert CSV data into an SQLite table via a shell pipe?
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 ...
- 17.5k
1
vote
0
answers
605
views
Apache DBD with sqlite3
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]
...
- 351
2
votes
2
answers
29k
views
How to write sqlite commands in a shell script?
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
&...
- 51
13
votes
4
answers
19k
views
how to pass multiple commands to sqlite3 in a one liner shell command
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 = ...
- 753
2
votes
1
answer
1k
views
How to open listchanges.db file in Debian?
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?
- 4,147
1
vote
0
answers
966
views
sqlite3-dev - can conda (of Anaconda) install it instead of apt-get?
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 ...
- 293
2
votes
1
answer
217
views
Dynamic webpages on BCHS
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 ...
- 217
2
votes
3
answers
2k
views
change location of .sqlite_history file
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, ...
- 443
24
votes
1
answer
12k
views
SQLite3 command line: how do you cancel a command?
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,...
- 12.1k
2
votes
2
answers
4k
views
SQLite command line: How do you pipe output to a UNIX utility?
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 ...
- 12.1k
1
vote
2
answers
2k
views
How to specify PRAGMAs in an sqlite3 command line call?
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 ...
- 8,095
1
vote
1
answer
4k
views
How to pull database file from physically connected android device
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 ...
- 21
1
vote
1
answer
1k
views
How to populate a database in sqlite3 using shell script while extracting data from files
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 ...
- 105
1
vote
1
answer
741
views
Ubuntu, lua, nmap and sqlite3 - module 'luasql.sqlite3' not found
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:
$ ...
1
vote
2
answers
915
views
Installing ownCloud with NGINX and SQLite
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 ...
- 63
2
votes
3
answers
2k
views
Convert SQLite CSV output to JSON
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 ...
- 3,415
1
vote
1
answer
519
views
CGI error while trying to retrieve from sqlite3
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 ...
- 139
2
votes
0
answers
470
views
Unable to insert records on sqlite on a Linux environment
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 ...
- 121
6
votes
2
answers
3k
views
How does one determine when a process or machine is IO bound?
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 ...
- 739
1
vote
1
answer
1k
views
Processing output from an sqlite db into a ksh array with spaces
I am querying an SQLite3 database like so:
input=$(-separator "," "SELECT field1,field2,field3 FROM table1")
and get this result:
Red,Yellow is a color,Blue
I need to insert this into an array, is ...
1
vote
0
answers
757
views
Firefox/Icecat: SQLite Version Error: The application has been updated, but your version of SQLite is too old and the application cannot run
Update:
The error was caused by a software called Hipchat which I installed because I needed a package from it. It not just made Firefox, Icecat and Thunderbird stop running, but also caused my ...
- 235
2
votes
1
answer
2k
views
Debian(amd64) Wheezy downgrading libsqlite3-0
benben@debian:~/goagent$ sudo apt-get install sqlite3
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may ...
- 255
-1
votes
1
answer
2k
views
Sqlite Browser NOT opening on Centos 6.5
When I try to open an .exe file in centOS (Release 6.5) by double clicking, it is not opening. I am creating an app which requires databases. I cannot check whether the data has gone in database or ...
- 1
3
votes
1
answer
610
views
rlwrap-like tool with command autocompletion
I am often using rlwrap sqlite database.sqlite to browse an SQLite table. It works great but I would like to have a tool that would create an index tables (and possible its columns as well) and let me ...
- 12.2k