Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
115
questions
0
votes
0
answers
1k
views
How to recover passwords from Google Chrome login data file
I have removed a standard user password on a windows machine with administrator user from console management; after removing the password of standard user when i open google chrome i don't see the ...
- 101
5
votes
0
answers
254
views
Optimizing Firefox I/O regarding storage-sync-v2.sqlite-wal file (storage-sync-v2.sqlite database write ahead log file)
In my experience, Firefox creates a storage-sync-v2.sqlite database in each of its profile folders. This appears to happen even if profile syncing is disabled (and has never been enabled).
What's odd ...
3
votes
2
answers
770
views
How to flush Firefox storage SQLite database files to eliminate large SQLITE-WAL files?
I've noticed that the WAL (Write Ahead Log) files (*.sqlite-wal) associated with the SQLite databases (*.sqlite) used by the Firefox web browser often get quite large. They literally can get over 150 ...
1
vote
1
answer
779
views
Database Corruption - Disk Image Is Malformed - Unraid - Plex
I am not sure where a question like this really falls as it is from an Unraid Linux server, with a Plex Media Server container, which utilizes SQLite (looking for troubleshooting at the root level). I ...
Kevin P.
0
votes
0
answers
528
views
Update or disable built-in library sqlite3 on MacOS?
On MacOS Monterey I installed subversion with brew install svn.
When I do an svn checkout in a terminal I get:
svn: E200029: Couldn't perform atomic initialization
svn: E200030: SQLite compiled for 3....
- 333
0
votes
2
answers
1k
views
How to fix the font sizes of DB browser for sqlite, which got tiny due to remote Windows server update?
Recently after an update in Windows server 2016 OS (64-bit), few apps font size went too tiny to be able to read. Currently my interest is for "DB browser for sqlite". Tried to fix it with ...
- 312
0
votes
1
answer
221
views
Convert a comma seperated string to an array to use in bash, append a value, sort the array, then convert back to string to store in the database
EDIT: OK, I've been convinced that an array is not a good idea!
#!/bin/bash
# /bin/sh cannot be used with this script as "=~" is bash only
[snip]
sqlite $database "create table ports (...
- 1
0
votes
1
answer
283
views
bash complains file not found for existing sqlite3 executable
I get a strange file not found error when running precompiled sqlite3 binary:
/tmp/sqlite> ./sqlite-tools-linux-x86-3380000/sqlite3
bash: ./sqlite-tools-linux-x86-3380000/sqlite3: No such file or ...
0
votes
1
answer
26
views
Firefox (cannot save history), PgAdmin4 sqlite issue, Signal, ... may be caused by kernel >5.13 and wrong F2FS file system check
If you face not working Firefox webDeveloperTools or some history issue, or pgAdmin4 complaining about some weird sqlite issue and even Signal messenger doesn't start, then the problem isn't related ...
- 101
0
votes
1
answer
504
views
Why do I have a `SQLITE_AUTOINDEX` index for my primary key? I thought that's what a table already was
I've got this table:
CREATE TABLE hash (
id INTEGER PRIMARY KEY NOT NULL,
base32 TEXT UNIQUE NOT NULL
);
CREATE INDEX hash_base32 ON hash(base32);
and sqlite3_analyzer gives me this:
*** Page ...
- 109
2
votes
2
answers
6k
views
get row number along results from a sqlite query
I am doing
sqlite file.db "select ... " | nl
To number every row in the resultset. How do I get rid nl ? in other words, how do I do it in sql ?
- 453
1
vote
0
answers
1k
views
Why does SQLite work on CephFS but not NFS
They're both network based filesystem protocols. So why can I mount SQLite databases on CephFS, but not using NFS?
I've had no issues with SQLite on CephFS, but when I mount stuff that uses SQLite on ...
- 722
1
vote
0
answers
575
views
How to efficiently distribute large, incrementally updated sqlite database?
What is an efficient way to transfer deltas from a large sqlite database?
Note: this question is NOT about how to copy/distribute a "live" database. I.e. I am not concerned about corrupted ...
- 111
0
votes
1
answer
124
views
Append specific text from an SQLite database to multiple files
Here's what I have:
An SQLite database main.db
A set of 10,000x HTML files named 1.html, 2.html, 3.html ... 10000.html.
main.db has a table with 2 columns:
id | name
1 | apple
2 | banana
...
- 115
2
votes
0
answers
70
views
Are applications limited when screen is put to sleep?
I am tracing a bug in our software which happens so far only on MacOS computers (software runs on Windows, Mac and iOS). It manifests as a timout on starting a transaction in our SQLite database which ...
- 21
0
votes
1
answer
581
views
How Can I Install Microsoft.EntityFrameworkCore.Sqlite in Visual Studio 2019?
I'm trying to install SQlite from Nuget but I got an error. I'm using NET Core 2.1.
What should I do?
Microsoft.EntityFrameworkCore.Sqlite 3.0.0 is not compatible with netcoreapp2.1 (.NETCoreApp,...
- 101
0
votes
0
answers
37
views
Does appending to a SQLite table modify the file header?
I'm coding a raspbery pi project which gathers data from temperature sensors.
I decided to use SQLite to manage my collected data. I collect the data every 30 seconds and append it to my database.
I ...
0
votes
0
answers
36
views
Problems Importing a Library into Xcode
I am trying to import SQLite into an app in Xcode. The library has worked in previous iterations, but now I get an error that says "No such module SQLite" when I try to import the library at the top ...
0
votes
1
answer
105
views
has sqlite been renamed to sqlite3?
I use sqlite for lightweight programming here and there in the Ruby language. I've noticed something odd. I use ruby gem sqlite3 to interact with the sqlite db.
I recently checked out the ...
- 1
1
vote
1
answer
2k
views
How to read google Filestream content_cache folder?
I have problem with Google Filestream.
User data was not synchronized to cloud for months. After uninstalling and reinstalling the FS client sync is now working fine...but all locally saved files are ...
3
votes
1
answer
1k
views
How do I get Atom to highlight SQL embedded within python multiline comments?
I'm using atom editor for python with embedded SQL similar to this:
import sqlite3
conn = sqlite3.connect('spider.sqlite')
cur = conn.cursor()
cur.execute('''SELECT COUNT(from_id) AS inbound, ...
4
votes
3
answers
13k
views
Where does django look for SQLite instance? (SQLite 3.8.3 or later is required (found 3.7.17))
I've cloned a django project to a vps and I'm trying to run it now, but I get this error when trying to migrate:
$ python manage.py migrate
django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 ...
- 143
0
votes
2
answers
2k
views
Where does Chrome for Mac store its saved usernames (not passwords)?
I tried to log into this site (superuser) today but when I clicked the username box, an email I didn't recognize popped down below mine... this is a work computer but nobody at my workplace recognizes ...
- 1
0
votes
1
answer
985
views
Need help setting up phpLiteAdmin
I'm trying to set up phpLiteAdmin with no knowledge of PHP, but I'm stuck. My Apache/PHP install is working (I already run myWebSQL), and I deployed the phpLiteAdmin with the sqlite file next to it, ...
- 233
0
votes
1
answer
48
views
Store and compare UNIX time or expiration days
I’m thinking of a project where I’ll use a SQL database to store rows with an expiration date measured in days. Every day I’ll clean the database of expired rows. I’m considering two solutions:
1
...
- 1,063
1
vote
1
answer
994
views
Are there drawbacks to sqlite as archivation format?
I have a few huge folders of small files I want to archive for long term storage (about 200GB).
Instead of just using something like gzip/tar/dar/7zip I am considering to use sqlite
sqlite3 ...
- 123
0
votes
0
answers
792
views
How to make python use latest SQLite
I already did the following:
1. Going over to this url: https://sqlite.org/download.html I will download 'sqlite-autoconf-3260000.tar.gz' which is version 3.26.0
2. assuming it's in my Downloads ...
- 1
0
votes
1
answer
483
views
Updating folder path in Windows 10 Photo App
After several weeks work putting together a holiday video using the Windows 10 Photo App when I now open the app it can no longer find any of my photos. Every file in the Storyboard shows the sad ...
- 1
0
votes
1
answer
39
views
How to add SQLite manage
I remove it by mistake from my Addons.
Now i can't add and this message is displayed: "This add-on is not compatible with your version of Firefox.".
What can i do.
0
votes
1
answer
364
views
How do I split directory addresses recursively in a batch file?
I have folders of audio samples, and I'm about to delete what I don't use, but I'd like to have a record of the original contents in an SQLite database.
Currently, I'm writing directly to the ...
- 119
3
votes
1
answer
4k
views
Add or edit entry in Firefox history
Deleting an entry in the Firefox history is a simple matter, but how can I add or edit a URL (or URI) in the history?
- 3,471
1
vote
0
answers
53
views
Avoiding repetition in this SQLite query?
I'm using SQLite to modify and error-check data that isn't easily accessible via the GUI, out of an Adobe program. Unusually helpfully for Adobe, they're using absolutely standard SQLite 3 db so it's ...
- 1,655
0
votes
0
answers
542
views
How to link data from DB3 to excel?
The .db3 database download daily data from the web and I need to analyze those data using an excel file.
the file I use to set the analysis must be an excel file because I use data coming from ...
- 746
0
votes
1
answer
931
views
Python sqlite3: Update all records with sum of passed parameter and current field value
Trying to update all records with the sum of each existing field value plus a parameter being passed. If the field in record A = 4 and record B = 5, I want to update all records so A = 4 + X and B = 5 ...
- 299
8
votes
1
answer
439
views
Identify SQL time format
I found this representation of a date (and time?) in an SQLite database. I don't recognize it as anything standard like UNIX timestamp, can anybody help me to identify it?
498586831.475129 or ...
- 806
5
votes
1
answer
742
views
Can I change GROUP_CONCAT Limit in SQLite?
I am thinking about switching from MySQL to SQLite,
but in the MySQL Server I set the variable group_concat_max_len = 1000000;
Before I switch everything to the SQLite engine I want to know if there ...
- 83
1
vote
0
answers
2k
views
how to find deleted viber messages on PC
I use both viber on smartphone (android) and in PC. I deleted some messages in chats from my phone. Then I extracted viber.db on my PC and using DB browser for SQLite tried to find those deleted ...
- 11
1
vote
0
answers
910
views
access to AppData/Roaming is denied
Visual Studio 2010 makes the solution in two Configurations: x86 & x64. In x86 configuration, I've no problem. In x64 configuration I get the following error:
SQLitePureImageCache, moving data: ...
- 141
2
votes
0
answers
200
views
Format sqlite3 .schema command output
I created some sqlite tables schema using python. When I use the sqlite3 client and issue the .schema command, I can see the output is pre-formated as in the SQL source file I used as argument for the ...
- 169
0
votes
0
answers
273
views
15 MB SQLite database file from Chrome history shown blank
I accidentally removed the profile from my Chrome on Windows and everything disappeared.
Except I was able to recover 15 MB history file from my hard drive it said the file was not corrupted.
But ...
- 1
-1
votes
1
answer
6k
views
Convert SQL Server queries to SQLite queries [closed]
What is the best converter to convert the SQL query to sqlite query? I have a script file which have lot of scripts written in SQLServer. I want to convert it to SQLite queries. Please suggest me a ...
- 121
0
votes
0
answers
64
views
Firefox external onfly interaction
Background: I'm trying to make a set of scripts to allow myself edit stylish themes in external editor (vi in my case). In order to do that I store styles.css as external file, edit it and upload with ...
- 1,249
0
votes
1
answer
65
views
basic manipulation of sqlite tables
I have two tables in my .sqlite.
These two tables are almost identical in terms of structure/content and I want one column of the first table to be replaced by one column of the second table.
This is ...
- 1
0
votes
1
answer
179
views
Win 7 Home Premium & Firefox & sqlite stall system by handling of HDD or SSD after some time. What to do? NT Kernel & System up to 25/26% cpu usage
The answer in short to spare you any misleading in this case:
It's three known bugs: In sqlite, and/or in Firefox's handling of
sqlite, and in the operating system Win 7. (Win 7 shouldn't allow ...
- 219
2
votes
2
answers
2k
views
Python3 fails import sqlite3
I just transferred a python module from my OS X system to Ubuntu. The module runs on the Mac just fine, but fails on the Ubuntu system with the following error:
import sqlite3
File "/usr/...
- 121
0
votes
1
answer
732
views
Vsftpd with sqlite3 as PAM
Long Version
I have a vsftpd server setup on my Raspberry Pi (running "Raspbian GNU/Linux 7" a flavour of Debian Wheezy). I would like to setup accounts using PAM. If possible I would use sqlite3 ...
0
votes
2
answers
182
views
fedora 21 lets a user overwrite a file he does not have access to
I reproduced this problem on two fedora 21 machines.
I would like that sqlite3 does not write the ~/.sqlite_history file. I couldn't find an option but said, no matter, I'll make it that it can't ...
- 497
0
votes
0
answers
878
views
Dumping an SQLite database stored as dll file?
A little background first: I need to extract a database from an SQLite dll file for my client who has burned bridges with the previous dev.
I have these 4 files sitting on my desktop:
System.data....
- 823
4
votes
2
answers
10k
views
Update a sqlite database while select into a while loop
There is a bash script that will do "some magic"™ to files which will be referenced to a sqlite database and after doing "some magic"™ the database should be updated. Here are the simplified code
...
- 423
2
votes
2
answers
771
views
MediaWiki with SQLite: Where are pages stored?
Where does mediawiki-1.20.2 with SQLite 3.7.13 store the content of pages? I want to dump the markdown code. I want to get all pages as shown when the "edit" button has been hit.
The maintenance/...
- 373