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

learn more… | top users | synonyms

0
votes
1answer
750 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
0answers
613 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 ...
3
votes
1answer
2k views

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
4
votes
0answers
1k 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 2....
0
votes
1answer
760 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
308 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
2k 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
4answers
965 views

Is there a GUI interface for sqlite? [closed]

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

How to run XPI files without Firefox?

Is it possible to run SQLite Manager, or other XPI, outside Firefox?
0
votes
3answers
944 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
587 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
533 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
1k 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
2answers
19k 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 ...
5
votes
4answers
7k 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
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 ...
0
votes
1answer
1k 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
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 ...
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
0answers
105 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
100 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
3k 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
4answers
1k 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
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? ...
19
votes
6answers
22k views

Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?

Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio? Right now we have a process that will grab the data from a Microsoft SQL Server database ...
2
votes
2answers
638 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?
1
vote
2answers
6k 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 ...
10
votes
3answers
12k 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 ...
1
vote
1answer
198 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 ...
3
votes
1answer
1k 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 ...
7
votes
4answers
574 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
1answer
2k 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 ...
13
votes
3answers
3k 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 ...