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
2answers
231 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/...
0
votes
2answers
408 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
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 ...
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?
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
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
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
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
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
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?
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....
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 ...
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 ...
1
vote
0answers
18 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 ...
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
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. ...
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
0answers
604 views

Synchronising a medium sized sqlite database over several computers

I have an SQLite database that is about 10MiB in size. Every few minutes a new record is inserted. Now I'd like to synchronise this file over several computers, with a remote server in between. But ...
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 ...
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
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
274 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?
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 ...
0
votes
0answers
251 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....
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
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" ...