The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
1 views

Trying to install sqlite through PECL results in phpize error

Running OS X Mavericks, trying to get the PHP libraries installed to interact with SQLite but end up with the following error: # pecl install sqlite ...
2
votes
0answers
440 views

Join multiple consecutive SQLite database dump files into 1 common database? Purpose: Search through ENTIRE Chrome Browsing History

Google Chrome 's default web browsing history search engine only lets you access the records of the recent 100 days. Nevertheless in your application data, Chrome keeps your entire browsing history in ...
0
votes
0answers
22 views

In which sqlite database does Opera store Tampermonkey scripts?

I recently had issues with my desktop pc and had to dismantle it - now I'm on debian 7.6 on a netbook. Thing is, my desktop installation was winxp and I foolishly wrote my userscripts on Opera's ...
0
votes
3answers
2k 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 ...
0
votes
0answers
25 views

Solution for copying fields between SQLite records

How can I copy and paste multiple selected fields between SQLite records in a single operation? E.g. copy http://i.imgur.com/dNOJ7Ca.png , paste http://i.imgur.com/Ggfnl3L.png I've tried a number of ...
0
votes
0answers
45 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 ...
6
votes
3answers
6k views

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies ...
16
votes
5answers
12k views

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio? Right now we have a process that will grab the data from a microsoft sql server database and put ...
1
vote
2answers
342 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: ...
3
votes
2answers
1k 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
1answer
22 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
0
votes
0answers
32 views

firefox DownThemAll how to dump data from dta_queue.sqlite

I want to dump the data contained in the dta_queue.sqlite file. But if I execute the following command $ sqlite dta_queue.sqlite .dump I get the error: Unable to open database "dta_queue.sqlite": ...
6
votes
3answers
5k views

Search via all Skype history

How to search given string at all chat histories? СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?
1
vote
0answers
49 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
30 views

Adding URLs to firefox visited history links

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
0answers
101 views

SQLite3 header and source version mismatch plus Skype Clash

I am using Ubuntu 12.04 LTS, and I am trying to use SQLite3. After installation, I get $ sqlite3 SQLite header and source version mismatch 2011-11-01 00:52:41 ...
0
votes
2answers
180 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 ...
0
votes
0answers
130 views

Where does Dropbox store its SQLite files?

I've just downloaded a SQLite viewer and tried to open Dropbox's .db files at random. Of those I've tried, only C:\Users\me\AppData\Roaming\Dropbox\config.db was recognized as a SQLite file, but it ...
1
vote
1answer
907 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
69 views

How to edit FF passwords without extensions (directly in FF config files)?

How to edit FireFox passwords manually ? Here I've been given answer how to do this with extension: Saving passwords for pages that redirect on login ( Chrome and FF ) How to do this without ...
0
votes
1answer
84 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?
0
votes
3answers
611 views

Is there any disadvantage of vacuuming sqlite dbs?

Are there any disadvantages of vacuuming sqlite databases? If not, why don't applications vacuum their dbs?
1
vote
0answers
311 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 ...
0
votes
0answers
106 views

Adding modules to bundled php in OS Mavericks

I am using the bundled php on my macbook to run some php through the terminal. But my scripts throw a fatal error when trying to use SQLite Classes. I checked with php -m and there is no module named ...
0
votes
0answers
143 views

[Chromium] Restore deleted synchronization information

I will try to explain carefully my concrete problem. I synchronize all my chromium data with my google account since about two years ago. But today I've tried to get access to the chrome information ...
2
votes
0answers
70 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 ...
0
votes
0answers
23 views

automatically type the fields when creating a table / loading data from file?

Very often I use mysql and sqlite in an ad hoc manner: quickly create a few tables, retrieve the information I need, then delete the tables beause I will never use them again. I wonder if it is ...
1
vote
1answer
144 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 ...
5
votes
1answer
638 views

Enable autocomplete in an sqlite3 interactive shell

I am using sqlite3 on a machine where I can use tab completion (ie .read abc will autocomplete to .read abcdefghij.db. I would like to know how to enable this on my personal machine. Both machines ...
-1
votes
1answer
258 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 ...
5
votes
2answers
11k views

How to install the SQLite PDO extension on Ubuntu

The default Ubuntu PHP package does not include the PDO SQLite extension. How can I install the SQLite PDO extension? Is there a package that one can easily install via apt-get?
7
votes
4answers
473 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
3
votes
3answers
569 views

Is there a GUI interface for sqlite?

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
0
votes
1answer
61 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
48 views

Corrupted database disk image [duplicate]

I have a corrupted sqlite .db file which cannot be opened in java because "the disk image is corrupted". I'd like a way to repair the database and recover as much data as I can, and make it openable. ...
4
votes
4answers
4k views

Using SQLite3 with Cygwin

I'm trying to use sqlite3.exe command shell with a mintty terminal in cygwin. I tried the program from a windows command prompt and it works. When I try to use it from the cygwin mintty terminal it ...
1
vote
2answers
164 views

MacPorts Invalid Entry

I am stuck upgrading my MacPorts. I seem to have a registry issue. I filed a ticket here. When I do sudo port upgrade outdated I get these errors: DEBUG: Executing org.macports.uninstall (iso-codes) ...
0
votes
1answer
516 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 ...
3
votes
2answers
371 views

SQLITE3 for dummies - solved (sort of)

I'm trying to learn the SQLite with "sqlite3 -interactive" shell (under Cygwin). For supposedly all legal reasons the sqlite3 shows the following prompt every time I forget to add a semicolon at the ...
0
votes
1answer
106 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 ...
0
votes
1answer
928 views

PHP and SQLite V2 extension for Fedora 14

How can I add support for the PHP SQLite V2 extension on Fedora 14?
1
vote
2answers
67 views

Kubuntu - how to find out what DB is installed

I'm newbie in linux, I installed latest kubuntu release. I was told that it already has sqlite on it/ How can I find out is it installed and what version of SQLite is on it?
1
vote
1answer
1k views

How to write an SQL query for SQLite Manager for Firefox places.sqlite?

I am using SQLite Manager which is an extension for Firefox. I use this to inspect the places.sqlite database. I am trying to find the earliest visit date for a specific URL in the Firefox history. ...
2
votes
1answer
3k views

How Can I Edit Google Chrome's 'History Provider Cache' File?

I'm interested in editing (not completely deleting) contents of some of Google Chrome's cache files. In particular, the 'History Provider Cache' (found in ~/Library/Application ...
1
vote
3answers
2k views

easy simple sqlite table database GUI?

I'm looking for a really simple GUI that interfaces with an SQlite database to facilitate editing/searching a single table, which includes: editing the table in tabular format, like a spreadsheet ...
0
votes
0answers
307 views

Synchronising a medium sized sqlite database over several computers

I have an SQLite database that is about 10MiB in size. Every few minutes a new record is inserted. Now I'd like to synchronise this file over several computers, with a remote server in between. But ...
1
vote
0answers
568 views

Restore SQLite DB from WAL

Is it possible to restore deleted rows or dropped tables provided the WAL and shm files are still intact and contain the data you want to restore? Example scenario where vast swathes of content have ...
0
votes
1answer
299 views

How to abort a partially-typed SQLite command without executing it?

If I start typing a multi-line command on the SQLite shell, and change my mind mid-way, how do I get back to shell prompt again without causing SQLite to execute the current command? sqlite> ...
4
votes
1answer
415 views

Can I limit intensity of fsync's of webappstore(localstorage) sqlite db?

Modern browsers have local storage, which is stored in webappstore.sqlite (for firefox) and localstorage.sqlite (for chrome). There is a third-party script, (online messenger), which uses local ...
0
votes
2answers
491 views

Trac Migration: Version difference -> problem with database?

I need to migrate trac from an old server to a new Ubuntu 10.04 LTS server. The old server has version Trac 0.11.1 and the installation is pretty messy and runs on an outdated unsupported debian ...