Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
119 questions
0
votes
1
answer
63
views
How to find files that come along with a book? [closed]
Where can I find the companion files for the James R Groff 3rd edition book (SQL The Complete Reference)?
I have tried using the link in the book to get this files but they are not available on site.
0
votes
0
answers
63
views
How to import the keywords table (web data) back into Chrome without all search engine data being wiped out?
I'm trying to backup the search engine parameters in my Chrome.
From other posts, I've seen I can export the keywords table (to a CSV file) from the web data file and then re-import the CSV file into ...
- 1
2
votes
0
answers
383
views
Cannot use arrow keys with BASH / Konsole / sqlite
I'm having a problem with Bash / Konsole / sqlite. When I enter sqlite and hit the up arrow key I get
sqlite> ^[[A
If I su into another user from the same Konsole session all is OK.
I've looked at ...
- 121
1
vote
0
answers
3k
views
ModuleNotFoundError: No module named '_sqlite3'
I use python 3.9.18 as an virtual environment, I've been trying to set up my local environment for airflow. When I run airflow standalone command, I constantly get ModuleNotFoundError: No module named ...
- 11
0
votes
1
answer
656
views
No Firefox cookies.sqlite file found. Use -c COOKIEFILE
I try to execute the code by using this command in my Kali Linux python3 ./cookies.py
then I got this message No Firefox cookies.sqlite file found. Use -c COOKIEFILE.
what does the message mean and ...
- 11
0
votes
0
answers
4k
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
1
answer
941
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 ...
- 10.4k
3
votes
2
answers
4k
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 ...
- 10.4k
1
vote
1
answer
2k
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
1k
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....
- 343
4
votes
2
answers
5k
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 ...
- 372
0
votes
1
answer
616
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
458
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 ...
- 1,128
0
votes
1
answer
52
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
963
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