Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
55
questions
0
votes
0answers
14 views
Error after installing Shinobi on Linux Mint
I just installed Shinobi CE (https://gitlab.com/Shinobi-Systems/Shinobi)
On my linuxmint machine. Everything got installed properly, i selected sqlite. I tried logging in (The log in screen shows up) ...
1
vote
1answer
97 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 ...
2
votes
3answers
290 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": "...
0
votes
1answer
444 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 ...
2
votes
1answer
903 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&...
2
votes
1answer
105 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. ...
-1
votes
3answers
56 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 ...
2
votes
1answer
4k 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
2answers
806 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
...
2
votes
1answer
3k 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 ...
1
vote
0answers
226 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
...
-2
votes
2answers
6k 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
&...
2
votes
2answers
5k 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 = ...
2
votes
1answer
641 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?
0
votes
0answers
548 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 ...
2
votes
1answer
190 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 ...
2
votes
3answers
825 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, ...
7
votes
1answer
6k 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,...
1
vote
1answer
1k 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
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 ...
1
vote
1answer
808 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 ...
1
vote
1answer
507 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
2answers
780 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
370 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 ...
2
votes
0answers
252 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 ...
5
votes
2answers
1k 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 ...
1
vote
1answer
945 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
0answers
671 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 ...
2
votes
1answer
1k 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 ...
-1
votes
1answer
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 ...
3
votes
1answer
375 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 ...
1
vote
1answer
1k 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 ...
2
votes
1answer
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 ...
4
votes
1answer
3k 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]
...
4
votes
2answers
8k 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/...
0
votes
2answers
1k views
how to run .dump command in linux? [closed]
I want to create dump file of sqlite database from java but I can't run the below command from linux. I got the help of windows and I tried with linux but it appears one terminal nothing more than ...
1
vote
1answer
289 views
OfflineIMAP tells me SQLite isn't installed, even though it is
Whenever I run OfflineIMAP v6.5.3.1 I get an error for every folder (i.e. tag and folder in Gmail) which tells me there was a problem and then right after it tells me:
SQLite backend chosen, but no ...
9
votes
2answers
7k views
Installed sqlite3 v3.8, but mac terminal still runs old version 3.6 by default
I have a Mac running OS X 10.6.8, which comes pre-installed with SQLite3 v3.6. I installed v3.8 using homebrew. But when I type "sqlite3" in my terminal it continues to run the old pre-installed ...
2
votes
0answers
167 views
multithread handling in AM1808 using embedded Linux
I am using AM1808 ARM9 based board using GCC compiler (UBUNTU 10.04) .
I am using Sqlite3 database management.
I have some requirement regarding handling threads in background having access on ...
4
votes
2answers
3k views
Couldn't perform atomic initialization SQLite error with Subversion on Eclipse
I'm trying to check out some code from my company's svn repository and I get this message on the console:
checkout https://svn.[company]/[repo]/Trunk/[project] -r HEAD \
--depth=infinity --force
...
0
votes
2answers
614 views
GUI for newsbeuter?
Is there a GUI for the feed reader newsbeuter?
Or would there be an easy way to create one for it?
Or is there any other graphical feed reader that could use the cache.db database (SQLite) of ...
0
votes
0answers
10k views
SVN error message: “E200030: sqlite: database disk image is malformed” on checkout
The .svn folder doesn't exist yet. I tried deleting it after it was created, but I get the same issue again
@:/var/www/htdocs$ svn checkout https://host/svn/trunk/ .
svn: E200030: sqlite: database ...
1
vote
1answer
199 views
How do I count the exact total of created and deleted sqlite journal files?
I'm trying to figure this out. Scenario is this:
A threaded tcp socket daemon with a sqlite back-end stores information in a unique sqlite2 file per IMEI ID, in an unique sub-directory per day (...
2
votes
4answers
4k views
pysqlite install error on FreeBSD in virtualenv
I am trying to install pysqlite using pip under a virtualenv in FreeBSD 7.3, with
Python version 2.6.2.
I didn't have any issues for installing other packages like Django, PIL etc. All of them I ...
0
votes
2answers
294 views
sqlite fts quoting problem
I can do this in sqlite tool:
sqlite> select caption from notes_fts where notes_fts MATCH '"perl install"';
but cannot from the Linux shell i.e., this fails:
user@host:~$ sqlite3 sqldb "select ...
7
votes
3answers
5k views
Fast way to determine if a file is a SQLite database
I am looking for a way to determine file types in a folder with thousands of files. File names do not reveal much and have no extension, but are different types. Specifically, I am trying to determine ...
2
votes
1answer
1k views
Parsing SQLite output
Using -line Option I get this output from SQLite:
row1_column1 = valueA
row1_column2 = valueB
row2_column1 = valueC
row2_column2 = valueD
So one line for each column value and result rows are ...
2
votes
2answers
622 views
Import single rows from SQLite to MySQL?
I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script (...
