Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
5
votes
0answers
323 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 ...
7
votes
1answer
11k 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
1k 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 ...
48
votes
6answers
35k 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
235 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 ...