The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
53 views

Firefox/Icecat: SQLite Version Error: The application has been updated, but your version of SQLite is too old and the application cannot run

Update: The error was caused by a software called Hipchat which I installed because I needed a package from it. It not just made Firefox, Icecat and Thunderbird stop running, but also caused my ...
2
votes
1answer
214 views

Debian(amd64) Wheezy downgrading libsqlite3-0

benben@debian:~/goagent$ sudo apt-get install sqlite3 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may ...
-1
votes
1answer
285 views

Sqlite Browser NOT opening on Centos 6.5

When I try to open an .exe file in centOS (Release 6.5) by double clicking, it is not opening. I am creating an app which requires databases. I cannot check whether the data has gone in database or ...
2
votes
0answers
40 views

rlwrap-like tool with command autocompletion

I am often using rlwrap sqlite database.sqlite to browse an SQLite table. It works great but I would like to have a tool that would create an index tables (and possible its columns as well) and let me ...
1
vote
1answer
215 views

I`ve installed sqlite. Now where should i find it? How to make connection from java? [closed]

I have Linaro 12.07 (Ubuntu 3) I`ve made sudo apt-get install sqlite3 libsqlite3-dev libxml2-dev g++ ncurses-dev and Linaro says: libncurses5-dev is already the newest version. libxml2-dev is ...
2
votes
1answer
294 views

PAM Authentication and SSH access based on user info stored in sqlite3

I have an application that runs on a Linux box. The application stores all its user information (like - username, password, ssh-allowed, etc) in an sqlite3 database as follows. username ...
1
vote
1answer
295 views

Problems with unixODBC and SQLite

I installed unixodbc, sqlite3 and libsqliteodbc. odbcinst.ini looks like this: [SQLite] Description=SQLite ODBC Driver Driver=libsqliteodbc.so Setup=libsqliteodbc.so UsageCount=2 [SQLite3] ...
1
vote
1answer
466 views

How to redirect sqlite3 output to a file

I installed sqlite3 and want to use it to recover information from stylish.sqlite which is located in my Firefox profile folder and is generated by the Stylish extension: $ cd ...
0
votes
2answers
283 views

how to run .dump command in linux? [closed]

I want to create dump file of sqlite database from java but I can't run the below command from linux. I got the help of windows and I tried with linux but it appears one terminal nothing more than ...
1
vote
1answer
176 views

OfflineIMAP tells me SQLite isn't installed, even though it is

Whenever I run OfflineIMAP v6.5.3.1 I get an error for every folder (i.e. tag and folder in Gmail) which tells me there was a problem and then right after it tells me: SQLite backend chosen, but no ...
4
votes
2answers
1k views

Installed sqlite3 v3.8, but mac terminal still runs old version 3.6 by default

I have a Mac running OS X 10.6.8, which comes pre-installed with SQLite3 v3.6. I installed v3.8 using homebrew. But when I type "sqlite3" in my terminal it continues to run the old pre-installed ...
1
vote
0answers
83 views

multithread handling in AM1808 using embedded Linux

I am using AM1808 ARM9 based board using GCC compiler (UBUNTU 10.04) . I am using Sqlite3 database management. I have some requirement regarding handling threads in background having access on ...
0
votes
2answers
1k views

Couldn't perform atomic initialization SQLite error with Subversion on Eclipse

I'm trying to check out some code from my company's svn repository and I get this message on the console: checkout https://svn.[company]/[repo]/Trunk/[project] -r HEAD \ --depth=infinity --force ...
0
votes
2answers
284 views

GUI for newsbeuter?

Is there a GUI for the feed reader newsbeuter? Or would there be an easy way to create one for it? Or is there any other graphical feed reader that could use the cache.db database (SQLite) of ...
0
votes
0answers
3k views

SVN error message: “E200030: sqlite: database disk image is malformed” on checkout

The .svn folder doesn't exist yet. I tried deleting it after it was created, but I get the same issue again @:/var/www/htdocs$ svn checkout https://host/svn/trunk/ . svn: E200030: sqlite: database ...
1
vote
1answer
139 views

How do I count the exact total of created and deleted sqlite journal files?

I'm trying to figure this out. Scenario is this: A threaded tcp socket daemon with a sqlite back-end stores information in a unique sqlite2 file per IMEI ID, in an unique sub-directory per day ...
1
vote
4answers
1k views

pysqlite install error on FreeBSD in virtualenv

I am trying to install pysqlite using pip under a virtualenv in FreeBSD 7.3, with Python version 2.6.2. I didn't have any issues for installing other packages like Django, PIL etc. All of them I ...
0
votes
2answers
176 views

sqlite fts quoting problem

I can do this in sqlite tool: sqlite> select caption from notes_fts where notes_fts MATCH '"perl install"'; but cannot from the Linux shell i.e., this fails: user@host:~$ sqlite3 sqldb ...
6
votes
3answers
1k views

Fast way to determine if a file is a SQLite database

I am looking for a way to determine file types in a folder with thousands of files. File names do not reveal much and have no extension but are different types. Specifically I am trying to determine ...
2
votes
1answer
513 views

Parsing SQLite output

Using -line Option I get this output from SQLite: row1_column1 = valueA row1_column2 = valueB row2_column1 = valueC row2_column2 = valueD So one line for each column value and result rows are ...
2
votes
2answers
459 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
3
votes
0answers
168 views

Enable sqlite FTS Enhanced Query Syntax in python in RHEL6?

SQLite's full text search engine offers a simple query syntax (with AND and OR operators and -term for negation), as well as an enhanced query syntax which also allows parenthesis and NEAR — as well ...
1
vote
1answer
2k views

perform remote sqlite command

If this should be moved to the DBA exchange, I apologize. Feels more like linux than DB to me, so here goes: I've got some machines that run scheduled cron jobs every night and email me the output. ...
1
vote
2answers
396 views

sqlite3 bash grep username

#!/bin/bash username=$(sqlite3 db.sl3 "select user from main";) yad --list --column="#" "$username" --height 200 I want to display the usernames of my db in a list and then select one of theme. The ...
6
votes
4answers
5k views

Is there any (good) SQLite GUI for Linux?

I'm looking for a SQLite graphical administration utility for Linux but I can't seem to find any (I found an extension for Firefox I'm not a user of that browser). Is there any that you know of?
4
votes
2answers
163 views

check patterns that don't exist in sqlite

I explained a similar situation with plain text files on Grep huge number of patterns from huge file. Many people there said I should, so now I'm migrating my data to a sqlite database: I have a file ...