Skip to main content

Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
1 vote
1 answer
40 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 ...
fauve's user avatar
  • 1,288
1 vote
1 answer
41 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 ...
raddevus's user avatar
  • 123
0 votes
2 answers
42 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 "...
r01_mage's user avatar
0 votes
1 answer
106 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 ...
Vinn's user avatar
  • 186
0 votes
1 answer
111 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....
Gary Schermer's user avatar
0 votes
0 answers
108 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 ...
WhiteRau's user avatar
  • 245
0 votes
1 answer
45 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 ...
sql's user avatar
  • 1
1 vote
1 answer
3k 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 ...
Bram Vanroy's user avatar
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 ...
subash ct's user avatar
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. ...
M.I.'s user avatar
  • 1
0 votes
3 answers
920 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&...
Brian Fitzpatrick's user avatar
9 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 ...
Derek Mahar's user avatar
0 votes
1 answer
820 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 ...
s.k's user avatar
  • 471
1 vote
1 answer
489 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 ...
Paddy Landau's user avatar
0 votes
1 answer
1k 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 ...
jan's user avatar
  • 1
2 votes
1 answer
47k 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 /...
vikrant rana's user avatar
2 votes
0 answers
291 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 ...
monatsend's user avatar
  • 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 ...
Ari's user avatar
  • 1
1 vote
2 answers
310 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, ...
Radek Daniluk's user avatar
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?
303's user avatar
  • 145
0 votes
1 answer
213 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 ...
Edward's user avatar
  • 1
2 votes
1 answer
517 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 ...
MarkMark's user avatar
  • 583
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 ...
rubo77's user avatar
  • 29.4k
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": "...
Anna's user avatar
  • 53
0 votes
2 answers
3k 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 ...
user28226's user avatar
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&...
dot's user avatar
  • 715
2 votes
1 answer
155 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. ...
spazek's user avatar
  • 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 ...
Blindy's user avatar
  • 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 ...
linux_confusion's user avatar
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 ...
Matthew Hodder's user avatar
10 votes
4 answers
11k 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 ...
Ivan's user avatar
  • 18k
1 vote
0 answers
685 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] ...
Flavius's user avatar
  • 351
2 votes
2 answers
30k 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 &...
Ahmad Fatehi's user avatar
15 votes
4 answers
21k 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 = ...
kenn's user avatar
  • 783
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?
mYnDstrEAm's user avatar
  • 4,398
1 vote
0 answers
1k 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 ...
nate's user avatar
  • 293
2 votes
1 answer
234 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 ...
ArchNemSyS's user avatar
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, ...
Martin Vegter's user avatar
26 votes
1 answer
13k 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,...
the_velour_fog's user avatar
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 ...
the_velour_fog's user avatar
1 vote
2 answers
3k 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 ...
Nicolas Raoul's user avatar
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 ...
e.kenny67's user avatar
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 ...
tom's user avatar
  • 105
1 vote
1 answer
766 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: $ ...
Sebastian Rockefeller's user avatar
1 vote
2 answers
929 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 ...
LJD200's user avatar
  • 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 ...
michelemarcon's user avatar
1 vote
1 answer
529 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 ...
Tasdik Rahman's user avatar
2 votes
0 answers
505 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 ...
Edper's user avatar
  • 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 ...
Kaizer Sozay's user avatar
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 ...
Carl Lindgren's user avatar