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
1answer
14 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 ...
0
votes
0answers
84 views

How to find Whatsapp's ChatStorage.sqlite in a local iPhone backup on Mac?

I want to export my WhatsApp chats from my iPhone without resorting to a closed-source freeware software. So I made an iPhone backup with iTunes and now I have a backup at ~/Library/Application ...
0
votes
0answers
42 views

Are there tests I can run to check if a Windows 10 computer flushes buffers when told to do so?

I'm currently investigating SQLite database corruptions caused by power failures. I read that corruptions could happen if a disk drive does not sync exactly when it's asked to do so from the ...
2
votes
0answers
60 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 ...
0
votes
0answers
19 views

How to delete all permissions for a site in Firefox?

Firefox stores site permissions in permissions.sqlite within the profile folder. Besides using an SQLITE database manager, is there any way to remove all permissions for a site without removing ...
0
votes
1answer
146 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,...
0
votes
0answers
65 views

SQLite Database in Intellij on a windows machine

I have a Spring boot project running in local. It parses data and content loads into SQLite Database (In memory). The same program runs well on Mac machine , populates the SQLite database file in ...
0
votes
0answers
28 views

Web UI for SQL like ArangoDB

I recently came across ArangoDB and I really like the GUI. It is simple, intuitive and powerful. Now, I don't really need or have time to learn nosql but could use something like it. Is anyone aware ...
0
votes
0answers
232 views

Class 'SQLite3' not found in /mnt/c/Users/username/working_dir

I'm trying to run a php server on my localhost via Windows 10 Ubuntu Subsystem. I'm able to run it just fine on Mac OS by running php -S localhost:8000 from the working directory, but when I try it on ...
0
votes
0answers
86 views

One step SQL Server Compact (CE) to SQLite conversion?

I have the following situation: Input is a SQL Server Compact CE .sdf file (large: ~400MB) Output needs to be SQLite file (for use in a Mac-Setup) I have tried SQL Server Management 17.9 with the ...
0
votes
0answers
19 views

ManicTime & SQLite

I have manictime server on several connected devices, but I'm not seeing their data populated onto my SQLite query results (just my own device data). I have the SQLite connection setup using the path ...
0
votes
0answers
632 views

Python won't compile with a new sqlite3 on CentOS 7

su! I need to run some python scripts on a CentOS 7 machine that makes sqlite3 requests, among which is WITH, which had been added relatively recently. My problem is that no matter what I do, Python ...
0
votes
0answers
20 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 ...
1
vote
0answers
13 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
1answer
50 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
vote
0answers
453 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
1answer
372 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
2answers
6k 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 ...
0
votes
2answers
573 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 ...
0
votes
1answer
274 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, ...
0
votes
1answer
13 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
vote
1answer
277 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 ...
0
votes
0answers
626 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 ...
0
votes
1answer
332 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 ...
0
votes
1answer
24 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
1answer
159 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 ...
2
votes
1answer
2k 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?
1
vote
0answers
43 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 ...
0
votes
0answers
284 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 ...
0
votes
1answer
797 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 ...
8
votes
1answer
409 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 ...
2
votes
0answers
462 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 ...
1
vote
0answers
1k 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 ...
0
votes
0answers
634 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: ...
2
votes
0answers
177 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 ...
0
votes
0answers
191 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
votes
1answer
4k 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 ...
0
votes
0answers
63 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 ...
0
votes
1answer
62 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 ...
0
votes
1answer
152 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 ...
2
votes
2answers
1k 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/...
0
votes
1answer
528 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
2answers
171 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 ...
0
votes
0answers
704 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....
4
votes
2answers
8k 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 ...
1
vote
1answer
567 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/...
0
votes
0answers
109 views

Solution for copying fields between SQLite records

How can I copy and paste multiple selected fields between SQLite records in a single operation? Copy Paste I've tried a number of SQLite tools inc. SQLite Expert, SQLiteSpy, SQLite Database Browser,...
4
votes
0answers
2k views

SVN 1.8.9 with vmware shared folders

This is my setup: Running on a vmware debian wheezy Shared folder is on windows, accessed with vmware-tools I'm using the latest TortoiseSVN on the windows side of things, so downgrading svn is not ...
0
votes
1answer
2k views

View a deleted row in a sqlite db?

I deleted a few rows by accident. Is there something that exist to view/dump recently deleted sqlite rows? I should have made a back up
2
votes
0answers
281 views

SQLite GUI for my grandma

I created a SQLite database for my grandmother to store all her poems because I was tired to see her search/copy/paste across many different Word documents. Yet I have still to convince her to use it. ...