Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sqlite]

SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.

0
votes
1answer
11 views

How to generate a virtual field in sqlite [on hold]

Many thanks for your support in advance. Let me summarize my little problems with the following example, I have an application using sqlite engine with 3 tables: User table with several fields (id, ...
0
votes
0answers
12 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
0answers
6 views

Getting “java.sql.SQLException: Values not bound to statement” exception [migrated]

I recently upgraded from sqlite-jdbc-3.7.2.jar to sqlite-jdbc-3.26.0.jar. I observed that the insert query in my code are failing with “java.sql.SQLException: Values not bound to statement” exception. ...
0
votes
0answers
18 views

SQLite malformed database error when connecting over MTP [closed]

I have written an android app that stores data in an SQLite database. I am trying to write a java app on my linux box to access the same database so that I can do data entry on a regular keyboard, ...
0
votes
0answers
7 views

Python sqlite3 library can't use URIs, even though sqlite3 version should be able to [migrated]

I have the most recent sqlite3 installed on my machine: $ sqlite3 --version 3.26.0 2018-12-01 12:34:55 bf8c1b2b7a5960c282e543b9c293686dccff272512d08865f4600fb58238b4f9 And, in python, the sqlite3 ...
0
votes
1answer
25 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
0answers
13 views

SQLAlchemy not connecting (first time user)

I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need ...
0
votes
0answers
10 views

How do i query chrome cookies info using sqlite3? [duplicate]

When i go to chrome://settings/siteData the i look for the info: for example : I can see the value of the content for the session id manually. I tried to do the same from command line and the value ...
0
votes
0answers
15 views

Multi-threaded concurrent INSERT on SQLite3 DB

The SQLite3 documentation seems to clearly indicate multiple concurrent threads can read from the same SQLite3 database at the same time, but it is not so clear about writes. Can I write (INSERT/...
0
votes
0answers
119 views

DB Browser for SQLite doesn't show Chrome autofill data

I'm trying to get my email autofill data from Chrome's Web Data file in %LOCALAPPDATA%\Google\Chrome\User Data\Default\Web Data by importing it into an SQL browser. I followed these steps but when I ...
0
votes
1answer
16 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
131 views

How do I split directory addresses (recusively) 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 ...
1
vote
1answer
550 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
26 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
159 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
482 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
378 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
267 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
467 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
135 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
147 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
3k 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
61 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
52 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
133 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 ...
1
vote
2answers
984 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
427 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
161 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
539 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....
2
votes
2answers
6k 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
409 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
105 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,...
3
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
264 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. ...
0
votes
1answer
91 views

Adding URLs to firefox visited history links [duplicate]

Is there any way to add links to firefox history like bookmarks? I want Firefox remember those as visited links without opening them
0
votes
2answers
11k views

Where are Google chrome passwords stored in windows?

I know that Google Chrome stores the login data at LocalAppData\Google\Chrome\User Data\Default\Login Data but this doesn't shows the password, password value shows as the single special character. I ...
2
votes
1answer
9k views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
0
votes
1answer
321 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
1
vote
0answers
773 views

“Compacting” a SQL database after deleting records with SQLiteMan

I'm using SQLiteMan to edit/delete Skype message history, as described in numerous guides on the Net. I.e. I open Skype's main.db file in my profile folder using SQLiteMan and selectively delete some ...
2
votes
0answers
115 views

SQL Server is not started in windows 8

I created the local service. My server name is like sqlitesync.com. In my database folder created the configuration (web.config) and WCF web service (AuroraSyncService.svc). When I test this service ...
4
votes
2answers
3k views

SQLite Database Browser fails to open Firefox cookie database

I downloaded SQLite Database Browser to preview cookies of Google Chrome and Firefox. I could successfully preview Chrome's cookies, however cannot manage to preview Firefox cookies. I'm trying open ...
0
votes
3answers
3k views

Ubuntu: SQLite header / source mismatch (and making SVN use the installed SQLite installation)

I have the annoying SQLite header and source version mismatch problem when trying to run SQLite3 on Ubuntu 13.04. I've done in various orders (and all multiple times): apt-get remove sqlite3 ...
1
vote
1answer
274 views

Removing libsqlite3-0 deletes Ubuntu

I have Ubuntu 13.04 in a Virtualbox, and getting SQLite header and source version mismatch In fact, for completeness, it's part of a wider problem with SVN, where svn update responds with E200029: ...
-1
votes
1answer
1k views

database structure “customers” table having several orders per customer and several items per order [closed]

I want to create a database that has several customers and many orders per each customer and each order has several items in it. I was thinking of creating a table for each order and populate each ...
2
votes
2answers
3k views

Skype: Decode time stamps

I'm trying to extract the chat history between myself and my SO on Skype for OSX. I've managed to pull out the information and strip out the unnecessary XML formatting with the following command: ...
0
votes
1answer
150 views

Debian install without internet

My aim is to install debian with mono, xsp2 and sqlite without using internet. First I made the 3 debian DVDs and Downloaded manually the packages of mono, sqlite and xsp2, after Checking the ...
0
votes
1answer
2k views

SQLite not available with Python 3.3.0 on Debian

When i type >>>import sqlite3 It pops me the following error ImportError: No module named '_sqlite3' My setup : Debian 6.0.7 Python installed by default is 2.6.6 (import sqlite3 works ...
0
votes
1answer
476 views

How to tell if SQLite is frozen?

I have created a file with a list of approximately 8 million import statements to be imported into an SQLite database. I have been redirecting errors to a file. Every few thousand lines there is an ...