The tag has no wiki summary.

learn more… | top users | synonyms

17
votes
5answers
13k 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 ...
7
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?
7
votes
4answers
493 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 ...
6
votes
3answers
7k 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 ...
5
votes
2answers
13k 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?
5
votes
3answers
784 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 ...
5
votes
1answer
760 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 ...
4
votes
2answers
2k views

SQLite with readline support on Ubuntu

I had the sqlite3 package installed on Ubuntu and there's no support for readline. That means there's no command history and those other nifty features readline gives you. Is this a configuration or ...
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 ...
4
votes
2answers
11k 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 ...
4
votes
1answer
440 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 ...
3
votes
2answers
696 views

How to run XPI files without Firefox?

Is it possible to run SQLite Manager, or other XPI, outside Firefox?
3
votes
3answers
620 views

Is there a GUI interface for sqlite?

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

Firefox “auto-complete” is very slow

Firefox version: 3.6 My places.sqlite is rather big (114MB, after being optimized by SpeedyFox.) If I turn on auto-complete, it may take 1 or 2 seconds for Firefox to accept a newly typed URL. To ...
3
votes
0answers
872 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 ...
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 ...
2
votes
1answer
3k 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
3answers
1k 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 ...
2
votes
2answers
618 views

Sqlite database on Mac

How can i download and install sqlite database on Mac? Also does Mac OS X come with sqlite database preinstalled? If yes then how can i find it?
2
votes
1answer
4k 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 ...
2
votes
1answer
278 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 ...
2
votes
1answer
1k views

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
2
votes
1answer
1k views

Problem installing SQLite3 RubyGem on Ubuntu

I am having a problem trying to install the SQLite3 RubyGem. Here's what I'm doing: $ sudo gem install --remote sqlite3-ruby Here's the output: Building native extensions. This could take a ...
2
votes
0answers
77 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 ...
2
votes
0answers
459 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 ...
1
vote
1answer
161 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
vote
2answers
172 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
3answers
1k 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?
1
vote
2answers
4k views

Problem with installing sqlite3 module for python 2.6 on an ubuntu system

I need to run the sqlite3 module on python 2.6 in an ubuntu system. How do I install this module for Python 2.6? Somehow I don't have this module, it raises the error: Python 2.6.5 (r265:79063, Mar ...
1
vote
1answer
2k 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. ...
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 ...
1
vote
1answer
1k 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 ...
1
vote
2answers
77 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
193 views

Can't find .db or .log files on Vista

I have a cross platform program I wrote in Qt which creates log files (MyProg.log) and a sqlite3 database (myprog.db). I'm installing the program on Windows with Inno Setup. On Windows XP, the log ...
1
vote
0answers
72 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. ...
1
vote
0answers
376 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 ...
1
vote
2answers
456 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
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
1answer
2k 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
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?
0
votes
1answer
631 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 ...
0
votes
1answer
948 views

PHP and SQLite V2 extension for Fedora 14

How can I add support for the PHP SQLite V2 extension on Fedora 14?
0
votes
3answers
955 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 ...
0
votes
2answers
153 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 ...
0
votes
1answer
114 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
360 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
3answers
655 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?