Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
51 votes
8 answers
101k 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 ...
Brian T Hannan's user avatar
25 votes
5 answers
112k 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?
wowpatrick's user avatar
  • 4,379
24 votes
4 answers
6k 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 ...
agentofuser's user avatar
  • 7,387
23 votes
2 answers
8k 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 ...
CoatedMoose's user avatar
21 votes
7 answers
26k 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?
coms's user avatar
  • 313
19 votes
5 answers
32k 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 ...
Bobby's user avatar
  • 8,974
10 votes
7 answers
13k views

Easy and simple SQLite 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 (...
Jason S's user avatar
  • 7,665
10 votes
3 answers
43k 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 ...
matt wilkie's user avatar
  • 5,133
8 votes
1 answer
453 views

Identify SQL time format

I found this representation of a date (and time?) in an SQLite database. I don't recognize it as anything standard like UNIX timestamp, can anybody help me to identify it? 498586831.475129 or ...
Xaser's user avatar
  • 846
8 votes
1 answer
4k views

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
maurox's user avatar
  • 181
7 votes
4 answers
12k 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 ...
jmq's user avatar
  • 419
7 votes
3 answers
4k 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 ...
Tommy O'Dell's user avatar
7 votes
4 answers
762 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 ...
littlejim84's user avatar
5 votes
0 answers
465 views

Optimizing Firefox I/O regarding storage-sync-v2.sqlite-wal file (storage-sync-v2.sqlite database write ahead log file)

In my experience, Firefox creates a storage-sync-v2.sqlite database in each of its profile folders. This appears to happen even if profile syncing is disabled (and has never been enabled). What's odd ...
End Anti-Semitic Hate's user avatar
5 votes
1 answer
795 views

Can I change GROUP_CONCAT Limit in SQLite?

I am thinking about switching from MySQL to SQLite, but in the MySQL Server I set the variable group_concat_max_len = 1000000; Before I switch everything to the SQLite engine I want to know if there ...
Martini002's user avatar
5 votes
2 answers
5k 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 ...
ST3's user avatar
  • 755
4 votes
4 answers
7k views

Is there a GUI interface for sqlite? [closed]

Is there a lightweight GUI interface for sqlite databases? Preferably Windows based.
Keltari's user avatar
  • 73.2k
4 votes
1 answer
12k 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 ...
Thach Xuyen's user avatar
4 votes
1 answer
4k views

Add or edit entry in Firefox history

Deleting an entry in the Firefox history is a simple matter, but how can I add or edit a URL (or URI) in the history?
palswim's user avatar
  • 3,521
4 votes
2 answers
11k 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 ...
UsersUser's user avatar
  • 423
4 votes
3 answers
14k views

Where does django look for SQLite instance? (SQLite 3.8.3 or later is required (found 3.7.17))

I've cloned a django project to a vps and I'm trying to run it now, but I get this error when trying to migrate: $ python manage.py migrate django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 ...
SIMMORSAL's user avatar
  • 143
4 votes
2 answers
4k 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 ...
D R's user avatar
  • 510
4 votes
1 answer
2k 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? ...
d-cubed's user avatar
  • 289
4 votes
1 answer
724 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 ...
osgx's user avatar
  • 6,807
4 votes
0 answers
2k 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 ...
Kethryweryn's user avatar
3 votes
2 answers
1k views

How to run XPI files without Firefox?

Is it possible to run SQLite Manager, or other XPI, outside Firefox?
Jader Dias's user avatar
3 votes
2 answers
7k views

get row number along results from a sqlite query

I am doing sqlite file.db "select ... " | nl To number every row in the resultset. How do I get rid nl ? in other words, how do I do it in sql ?
ychaouche's user avatar
  • 471
3 votes
2 answers
1k views

How to flush Firefox storage SQLite database files to eliminate large SQLITE-WAL files?

I've noticed that the WAL (Write Ahead Log) files (*.sqlite-wal) associated with the SQLite databases (*.sqlite) used by the Firefox web browser often get quite large. They literally can get over 150 ...
End Anti-Semitic Hate's user avatar
3 votes
2 answers
687 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 ...
Alex's user avatar
  • 150
3 votes
1 answer
3k 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 while....
Andrew's user avatar
  • 14.9k
3 votes
1 answer
1k views

How do I get Atom to highlight SQL embedded within python multiline comments?

I'm using atom editor for python with embedded SQL similar to this: import sqlite3 conn = sqlite3.connect('spider.sqlite') cur = conn.cursor() cur.execute('''SELECT COUNT(from_id) AS inbound, ...
Bella Strange's user avatar
3 votes
1 answer
2k 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 ...
netvope's user avatar
  • 5,325
3 votes
1 answer
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?
user avatar
3 votes
0 answers
3k views

Free Tool to Generate Diagram of SQLite Database [closed]

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....
andyortlieb's user avatar
2 votes
1 answer
5k 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. ...
Samir's user avatar
  • 20.8k
2 votes
2 answers
50k 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 ...
user301088's user avatar
2 votes
3 answers
2k 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 ...
Dan's user avatar
  • 498
2 votes
2 answers
859 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?
user avatar
2 votes
1 answer
10k 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 ...
ultrapenguin's user avatar
2 votes
2 answers
824 views

MediaWiki with SQLite: Where are pages stored?

Where does mediawiki-1.20.2 with SQLite 3.7.13 store the content of pages? I want to dump the markdown code. I want to get all pages as shown when the "edit" button has been hit. The maintenance/...
user2964971's user avatar
2 votes
1 answer
10k 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 Support/Google/Chrome/...
Ryan's user avatar
  • 221
2 votes
1 answer
471 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 ...
Michael's user avatar
  • 645
2 votes
0 answers
1k views

Why does SQLite work on CephFS but not NFS

They're both network based filesystem protocols. So why can I mount SQLite databases on CephFS, but not using NFS? I've had no issues with SQLite on CephFS, but when I mount stuff that uses SQLite on ...
cclloyd's user avatar
  • 752
2 votes
0 answers
694 views

How to efficiently distribute large, incrementally updated sqlite database?

What is an efficient way to transfer deltas from a large sqlite database? Note: this question is NOT about how to copy/distribute a "live" database. I.e. I am not concerned about corrupted ...
thegreatemu's user avatar
2 votes
0 answers
71 views

Are applications limited when screen is put to sleep?

I am tracing a bug in our software which happens so far only on MacOS computers (software runs on Windows, Mac and iOS). It manifests as a timout on starting a transaction in our SQLite database which ...
Daniel's user avatar
  • 21
2 votes
0 answers
213 views

Format sqlite3 .schema command output

I created some sqlite tables schema using python. When I use the sqlite3 client and issue the .schema command, I can see the output is pre-formated as in the SQL source file I used as argument for the ...
Stéphane's user avatar
  • 169
2 votes
2 answers
2k views

Python3 fails import sqlite3

I just transferred a python module from my OS X system to Ubuntu. The module runs on the Mac just fine, but fails on the Ubuntu system with the following error: import sqlite3 File "/usr/...
user96's user avatar
  • 121
2 votes
0 answers
119 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 ...
Arut's user avatar
  • 121
2 votes
2 answers
4k 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: ...
NOP's user avatar
  • 363
2 votes
0 answers
742 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 ...
porg's user avatar
  • 369