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

learn more… | top users | synonyms

1
vote
0answers
23 views

Linux python install missing module sqlite3

Due to an issue where we can't natively update python from version 2.4, I am required to install my own python 2.7.5 in my home directory. This creates an issue where I don't have the correct headers (...
1
vote
0answers
5 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 ...
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 ...
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 ...
-1
votes
1answer
66 views

Convert SQL Server queries to SQLite queries [closed]

What is the best converter to convert the SQL query to sqlite query? I have a script file which have lot of scripts written in SQLServer. I want to convert it to SQLite queries. Please suggest me a ...
0
votes
0answers
23 views

15 MB SQLite database file from Chrome history shown blank

I accidentally removed the profile from my Chrome on Windows and everything disappeared. Except I was able to recover 15 MB history file from my hard drive it said the file was not corrupted. But ...
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 ...
14
votes
5answers
11k 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?
0
votes
0answers
9 views

SQLite upper arrow to show previous command

I am using sqlite3 on Debian from command line interface. In the cli if I press upper arrow it will print "^[[A". But I want it to show previous command instead. How can I change the setting such that ...
0
votes
0answers
16 views

Firefox external onfly interaction

Background: I'm trying to make a set of scripts to allow myself edit stylish themes in external editor (vi in my case). In order to do that I store styles.css as external file, edit it and upload with ...
0
votes
0answers
14 views

sqlite3 doesn't produce any output in the gitbash or cygwin [duplicate]

I'm trying to use sqlite (cli 3.10.1) with cygwin or gitbash on windows 10 64. However, when I run it, nothing happens, i.e. sqlite produces no output. Everything's alright in cmd.exe
0
votes
1answer
27 views

basic manipulation of sqlite tables

I have two tables in my .sqlite. These two tables are almost identical in terms of structure/content and I want one column of the first table to be replaced by one column of the second table. This is ...
0
votes
1answer
84 views

Win 7 Home Premium & Firefox & sqlite stall system by handling of HDD or SSD after some time. What to do? NT Kernel & System up to 25/26% cpu usage

The answer in short to spare you any misleading in this case: It's three known bugs: In sqlite, and/or in Firefox's handling of sqlite, and in the operating system Win 7. (Win 7 shouldn't allow ...
3
votes
2answers
5k 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 ...
0
votes
2answers
412 views

View a deleted row in a sqlite db?

I deleted a few rows by accident. Is there something that exist to view/dump recently deleted sqlite rows? I should have made a back up
0
votes
0answers
57 views

Hoping to open a SQLite Manger in-memory database from the OS X command line

I like Firefox's SQLite Manager plugin because it's easy to show people how to use it. But ideally, I would like to be able to move seamlessly between SQLite Manager and the sqlite command line. If ...
8
votes
2answers
2k 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 ...
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 ...
0
votes
0answers
13 views

csv file Add one more column and row in existing table using Ubuntu 14.4

CSV file already created,I want to add one more column and table, how can I add, If I add one more column, these file getting error. With out modified, its working.
0
votes
0answers
12 views

How do you:set sqlite_unicode to true

I am in Ah over the new switch for me to --Debian-jessie_X64,, yet alot is different. My Question is How do you "set sqlite_unicode to true" ?
0
votes
0answers
53 views

Solution for copying fields between SQLite records

How can I copy and paste multiple selected fields between SQLite records in a single operation? Copy Paste I've tried a number of SQLite tools inc. SQLite Expert, SQLiteSpy, SQLite Database ...
0
votes
0answers
284 views

Merging two sqlite3 databases into one database file

I would like to combine two sqlite3 database files (*.db) into a single database. Both databases have the same tables. Is there any easy way to do this?
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 ...
0
votes
2answers
111 views

fedora 21 lets a user overwrite a file he does not have access to

I reproduced this problem on two fedora 21 machines. I would like that sqlite3 does not write the ~/.sqlite_history file. I couldn't find an option but said, no matter, I'll make it that it can't ...
1
vote
2answers
238 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/...
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.
0
votes
1answer
50 views

Adding URLs to firefox visited history links

Is there any way to add links to firefox history like bookmarks? I want Firefox remember those as visited links without opening them
0
votes
1answer
80 views

How to edit FF passwords without extensions (directly in FF config files)?

How to edit FireFox 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 ...
0
votes
1answer
221 views

Vsftpd with sqlite3 as PAM

Long Version I have a vsftpd server setup on my Raspberry Pi (running "Raspbian GNU/Linux 7" a flavour of Debian Wheezy). I would like to setup accounts using PAM. If possible I would use sqlite3 ...
0
votes
0answers
252 views

Dumping an SQLite database stored as dll file?

A little background first: I need to extract a database from an SQLite dll file for my client who has burned bridges with the previous dev. I have these 4 files sitting on my desktop: System.data....
1
vote
0answers
617 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
3k 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
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
1answer
102 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
1answer
95 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
0answers
614 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 ...
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 ...
1
vote
0answers
1k 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 ...
1
vote
2answers
1k 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: ...
4
votes
2answers
2k 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 ...
1
vote
0answers
171 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. ...
0
votes
2answers
651 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 ...
1
vote
1answer
7k 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 ...
0
votes
1answer
181 views

How to access SQLite database?

I have run BinDiff on two binary files, and stored the results in a .BinDiff file. (Which the manufactures assure me is just an SQLite database. How would I open and access this database?
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?
2
votes
0answers
104 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 ...
1
vote
1answer
230 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 E200029:...
-1
votes
1answer
774 views

database structure “customers” table having several orders per customer and several items per order [closed]

I want to create a database that has several customers and many orders per each customer and each order has several items in it. I was thinking of creating a table for each order and populate each ...
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?
7
votes
4answers
575 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 ...