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
0 votes
1 answer
97 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 ...
user avatar
0 votes
0 answers
32 views

Disk write on USB drive gives a disk I/O error operation not supported on linux on Chromebook

I am using this code https://www.codeproject.com/Articles/5261771/Golang-SQLite-Simple-Example When I run it on the Linux volume of my chromebook, it works fine. When I run it on a usb hard drive ...
user avatar
0 votes
0 answers
438 views

Bash script for sqlite commands

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. ...
user avatar
  • 1
0 votes
3 answers
238 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&...
user avatar
6 votes
1 answer
863 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 ...
user avatar
0 votes
1 answer
253 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 ...
user avatar
  • 213
1 vote
1 answer
168 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 ...
user avatar
0 votes
1 answer
243 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 ...
user avatar
  • 1
2 votes
1 answer
20k 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 /...
user avatar
2 votes
0 answers
166 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 ...
user avatar
  • 121
0 votes
0 answers
2k 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 ...
user avatar
  • 1
1 vote
2 answers
154 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, ...
user avatar
0 votes
2 answers
782 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?
user avatar
  • 115
0 votes
1 answer
102 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 ...
user avatar
  • 1
1 vote
1 answer
315 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 ...
user avatar
  • 503
2 votes
3 answers
959 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": "...
user avatar
  • 43
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 ...
user avatar
2 votes
1 answer
2k 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&...
user avatar
  • 615
2 votes
1 answer
140 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. ...
user avatar
  • 27
-1 votes
3 answers
65 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 ...
user avatar
  • 3
2 votes
1 answer
12k 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 ...
user avatar
0 votes
2 answers
1k 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 ...
user avatar
9 votes
4 answers
8k 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 ...
user avatar
  • 16.4k
1 vote
0 answers
474 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 admin@example.com ...
user avatar
  • 351
0 votes
2 answers
23k 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 &...
user avatar
12 votes
4 answers
14k 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 = ...
user avatar
  • 733
2 votes
1 answer
944 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?
user avatar
  • 3,510
1 vote
0 answers
791 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 ...
user avatar
  • 293
2 votes
1 answer
208 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 ...
user avatar
2 votes
3 answers
1k 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, ...
user avatar
20 votes
1 answer
10k 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,...
user avatar
2 votes
2 answers
3k 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 ...
user avatar
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 ...
user avatar
1 vote
1 answer
3k 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 ...
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 ...
user avatar
  • 105
1 vote
1 answer
642 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: $ ...
user avatar
1 vote
2 answers
850 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 ...
user avatar
  • 63
1 vote
2 answers
2k views

Convert sqlite 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 ...
user avatar
1 vote
1 answer
471 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 ...
user avatar
2 votes
0 answers
327 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 ...
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 ...
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 ...
user avatar
1 vote
0 answers
737 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 ...
user avatar
  • 225
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 ...
user avatar
  • 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 ...
user avatar
3 votes
1 answer
539 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 ...
user avatar
  • 11.3k
1 vote
1 answer
2k views

I`ve installed sqlite. Now where should i find it? How to make connection from java? [closed]

I have Linaro 12.07 (Ubuntu 3) I`ve made sudo apt-get install sqlite3 libsqlite3-dev libxml2-dev g++ ncurses-dev and Linaro says: libncurses5-dev is already the newest version. libxml2-dev is ...
user avatar
2 votes
1 answer
2k views

PAM Authentication and SSH access based on user info stored in sqlite3

I have an application that runs on a Linux box. The application stores all its user information (like - username, password, ssh-allowed, etc) in an sqlite3 database as follows. username ...
user avatar
4 votes
1 answer
4k views

Problems with unixODBC and SQLite [closed]

I installed unixodbc, sqlite3 and libsqliteodbc. odbcinst.ini looks like this: [SQLite] Description=SQLite ODBC Driver Driver=libsqliteodbc.so Setup=libsqliteodbc.so UsageCount=2 [SQLite3] ...
user avatar
5 votes
2 answers
12k views

How to redirect sqlite3 output to a file

I installed sqlite3 and want to use it to recover information from stylish.sqlite which is located in my Firefox profile folder and is generated by the Stylish extension: $ cd ~/.mozilla/firefox/...
user avatar