The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
6 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": ...
1
vote
0answers
39 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
26 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
65 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
146 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
84 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
647 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
68 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
269 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
92 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
115 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
60 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
21 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 ...
3
votes
2answers
959 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
2answers
1k 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
130 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 ...
-1
votes
1answer
232 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 ...
1
vote
1answer
286 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
57 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
47 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. ...
0
votes
1answer
449 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 ...
0
votes
1answer
95 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 ...
1
vote
2answers
64 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. ...
5
votes
1answer
554 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 ...
6
votes
3answers
4k 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?
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 ...
1
vote
3answers
1k 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
279 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 ...
3
votes
2answers
349 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 ...
1
vote
0answers
517 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
237 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> ...
1
vote
2answers
160 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) ...
2
votes
1answer
2k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
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 ...
0
votes
1answer
418 views

Sqlite2 graphical tool

I have a (non-trivial) sqlite2 database that I would like to view graphically through a tool similar to the SQLite manager for Firefox or PHPMyAdmin for MySQL. Problem is everything I find is ...
2
votes
1answer
1k views

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
3
votes
0answers
799 views

Free Tool to Generate Diagram of SQLite Database

I tried using openoffice via ODBC, and it connected properly, but when I tried to use tools->Relationships... , it gave me the error message "The database does not support relations." I'm using OOo ...
0
votes
1answer
579 views

How to extract SQLite file from Android SD card

My Galaxy S was having an error on the notification bar "SD Card blank or has unsupported file system" then I was required to format my SD card... however I couldn't format it using the phone and my ...
2
votes
1answer
268 views

Can't find sqlite3 in this ruby/rails version using rvm

I installed rvm and am using 1.9.2 with rails 3.05. I was able to create a new application but once I moved into the directory and tried to start the server ("rails s"), I got this error message ...
0
votes
1answer
1k views

Open SQLite database with SQLite Manager

I have Firefox plugin SQLite Manager installed on my computer and have SQLite database. Is it possible to open SQLite database by double click on it with SQLite Manager within the Firefox add-on?
3
votes
3answers
521 views

Is there a GUI interface for sqlite?

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
3
votes
2answers
9k 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?
3
votes
2answers
606 views

How to run XPI files without Firefox?

Is it possible to run SQLite Manager, or other XPI, outside Firefox?
0
votes
3answers
576 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?
0
votes
2answers
474 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 ...
4
votes
1answer
401 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 ...
5
votes
3answers
695 views

SQLite: Data entry interface?

I'd to like to use SQLite to start tracking a few things. I won't have any trouble setting up the database itself, but I'd struggle at programming an interface. Is there any kind of open source ...
3
votes
2answers
10k views

Open SQLite db in Microsoft Access?

Are there any tools to allow using sqlite databases from Microsoft Access? Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would ...
3
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 ...