The sqlite tag has no wiki summary.
-2
votes
0answers
19 views
Using SQLite for Mediawiki [closed]
I have a mediawiki that I am trying to setup. When I get to the welcome screen it says it can't find a database driver. I downloaded the zip file for php from PHP for Windows, and my Apache server is ...
1
vote
1answer
40 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
13 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
0answers
24 views
Creating SQLite database from postinst script
is it possible to create an SQLite database from a postinst script? I tried this:
sqlite3 /usr/bin/awenko_xrf.db
create table recorditems (oid text, panid text, elementident text, value real, ...
0
votes
1answer
25 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
0answers
153 views
Recover possibly dropped table from an SQLite3 database
I have an SQLite database file: the address book (AddressBook.sqlitedb) from an iPhone 3GS of a friend of mine with iOS 3.1.3. I have obtained this file from an unencrypted iTunes-generated backup. ...
0
votes
1answer
109 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
44 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
42 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?
0
votes
0answers
90 views
Merge multiple sqlite databases containing duplicates
I have a series of multiple backups of an sqlite database, and I wish to merge them into one single file but removing the duplicate entries.
How could I go about doing this on linux?
1
vote
1answer
367 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.
...
0
votes
0answers
201 views
How to update the SQLite3 for Mac OS X Snow leopard?
Currently, I am working with the databases using terminal in my Mac OS X Snow leopard.
Now, I want to update the SQLite version from 3.6.12 to 3.7.14 in my terminal, in order to use foreign keys as ...
3
votes
0answers
146 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 ...
0
votes
0answers
232 views
firefox - rebuild bookmarks - places.sqlite.corrupt systematically appears
I try to restore my friefox bookmarks that I have lost with a crash.
I have restored the places.sqlite file by following this fix :
http://blog.ummwhat.com/2009/11/firefox-bookmarks-corruption/
I ...
0
votes
0answers
38 views
How to edit FF passwords without extensions (directly in FF config files)?
How to edit FF 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 extension ?
...
0
votes
0answers
39 views
Import multivalued Access 2010 to SQLite
I'm trying to import a MS Access 2010 file (.accdb) that contain multivalued field to SQLite using Navicat. The import went well, however I notice that any cell that is a multivalued cell doesn't ...
1
vote
3answers
551 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
149 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
198 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
296 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
79 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> ...
0
votes
2answers
115 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)
...
1
vote
1answer
880 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
2k 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
175 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
709 views
2
votes
0answers
497 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
376 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
226 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
762 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?
2
votes
3answers
297 views
Is there a GUI interface for sqlite?
Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
3
votes
2answers
4k 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
390 views
How to run XPI files without Firefox?
Is it possible to run SQLite Manager, or other XPI, outside Firefox?
0
votes
2answers
403 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
359 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
307 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
481 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 ...
2
votes
2answers
6k 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 ...
2
votes
4answers
2k 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 ...
2
votes
3answers
811 views
Restore sqlite3 on Mac OS X for Google Chrome
I was stupid enough to compile sqlite3 from source and install it to /usr, overriding default library.
This being done, Google Chrome doesn't launch anymore, crashing with this output:
Dyld Error ...
0
votes
1answer
820 views
PHP and SQLite V2 extension for Fedora 14
How can I add support for the PHP SQLite V2 extension on Fedora 14?
3
votes
2answers
2k views
Reading the *.sqlite files stored in the firefox profile
How would one go about reading the data in the *.sqlite files in one's profile?
Trying to read them with sqlite3 was unsuccessful.
$ sqlite3
SQLite version 3.7.4
Enter ".help" for instructions
...
0
votes
1answer
1k views
How can I import a CSV file into an SQLite table that doesn't allow null values?
I've been using the SQLite Manager extension for Firefox to edit my Chrome web data file in order to restore my keyword searches, and I think I have everything in place except that when I import a CSV ...
0
votes
0answers
97 views
SQLite DB borked when opened on a different machine
I'm using SQLite to store some data. The primary database is on a NAS (Debian Lenny, 2.6.15, armv4l) since the NAS runs a script which updates the data every day. A typical "select * from tableX" ...
0
votes
1answer
76 views
Arado Websearch - Lookup the URL-Bookmark Database within SQL, any tool available?
installed Arado Websearch ( http://arado.sf.net ) and entered some URLs and my Bookmarks into the Database, which is SQL, is there any tool available to look the Bookmarks up again in the Sql file?
0
votes
2answers
2k views
How to install sqlite from source on Mac?
I have seen this question on the source code of SQLite. However, I can not make sense on how to build SQLite on my Mac OS 10.6 from scratch, esp. an old version. What steps do I need?
1
vote
3answers
627 views
What is default admin for SQLite?
Workbench is MySQL default. Correct me if I'm wrong. I dont believe SQLite has it own default admin. Is there any recommendation for the admin?
0
votes
3answers
646 views
Delete old records from firefox sqlite databases
I have some big sqlite3 databases in ~/.mozilla/firefox/profilename
Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB).
Is it possible to truncate them and wipe out the oldest records ...
3
votes
1answer
885 views
how to enable command line autocomplete after sqlite
Once upon a time when I started sqlite from the command line I could using the tabbing autocomplete to enter the database name. This has not worked for a while now.
Any suggestions on how to do this? ...
12
votes
5answers
7k 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 ...
