Questions tagged [sqlite]
SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine.
116
questions
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 ...
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?
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 ...
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 ...
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?
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 ...
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 (...
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 ...
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 ...
8
votes
1
answer
4k
views
Does SQLite come with Mac OS X?
Is SQLite pre-installed on Mac OS X or not?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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.
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 ...
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?
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
...
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 ...
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
...
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? ...
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 ...
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 ...
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?
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 ?
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 ...
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 ...
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....
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, ...
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 ...
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?
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....
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.
...
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 ...
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 ...
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?
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 ...
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/...
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/...
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
...
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 ...
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 ...
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 ...
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 ...
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/...
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 ...
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:
...
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 ...