The sqlite tag has no wiki summary.
1
vote
2answers
267 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 ...
0
votes
2answers
109 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 ...
0
votes
1answer
204 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
...
2
votes
3answers
589 views
Is there any (good) SQLite GUI for Linux?
Helo, 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 ...
0
votes
2answers
96 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
386 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 ...
0
votes
2answers
442 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 ...
1
vote
1answer
78 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
1answer
261 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 ...
6
votes
3answers
315 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
0answers
107 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
447 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
177 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 ...
4
votes
2answers
113 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 ...
