Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [sqlite]

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

SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

SQLite is a relational database management system contained in a small (~350 KB) C programming library. In contrast to other database management systems, SQLite is not a separate process that is accessed from the client application, but an integral part of it.

SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.

70 questions
64
votes
6 answers

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?
Jimmy
  • 643
  • 1
  • 5
  • 4
24
votes
1 answer

SQLite3 command line: how do you cancel a command?

I made a mistake writing a command at the SQLite command prompt, which I now want to abort, this is how my command line looks sqlite> select * from todos' ...> ' ...> ;^C In this case, likely because I have opened a quote, I can't even hit…
the_velour_fog
  • 11,840
  • 16
  • 64
  • 109
12
votes
4 answers

how to pass multiple commands to sqlite3 in a one liner shell command

I'm trying to save clipboard content into an sqlite database. Created database and tables. I don't want it to create journal file in every clipboard change, so I tried to pass PRAGMA journal_mode = OFF; flag. But it's tricky to pass those commands…
kenn
  • 733
  • 2
  • 11
  • 22
10
votes
3 answers

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 if a file is a sqlite database. When using the…
dmars
  • 113
  • 1
  • 7
9
votes
2 answers

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 version. Any help? Not sure if PATH variable has…
BandfuzzAlex
  • 93
  • 1
  • 5
9
votes
4 answers

How to insert CSV data into an SQLite table via a shell pipe?

I have written a program that outputs the result to the standard output in strict pure CSV form (every line represents a single record and contain the same set of comma-separated fields, fields only contain lowercase English letters, numbers and…
Ivan
  • 17,368
  • 35
  • 93
  • 118
8
votes
1 answer

How can SQLite command ".import" read directly from standard input?

How would you modify function csv_to_sqlite so that sqlite3 command .import reads directly from standard input instead of from a temporary named pipe? #!/bin/bash function csv_to_sqlite() { local database_file_name="$1" local table_name="$2" …
Derek Mahar
  • 505
  • 3
  • 13
8
votes
1 answer

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. I do not want emails for things like this. In…
LVLAaron
  • 1,715
  • 8
  • 28
  • 31
6
votes
2 answers

How does one determine when a process or machine is IO bound?

I have a node.js process which writes to many different sqlite databases. Sqlite can handle only one concurrent write per database, which is fine since there will be only one write per database at a time, but writes to multiple different databases…
Kaizer Sozay
  • 739
  • 3
  • 13
  • 19
5
votes
0 answers

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 as using NOT instead of the -term syntax. The…
mattdm
  • 39,535
  • 18
  • 99
  • 133
5
votes
2 answers

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 ~/.mozilla/firefox/w4wcp85s.default $ sqlite3 stylish.sqlite SQLite…
user15760
4
votes
2 answers

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 Couldn't perform atomic initialization svn:…
gtludwig
  • 873
  • 3
  • 12
  • 22
4
votes
2 answers

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 from which I extract about 10,000 patterns. Then…
admirabilis
  • 4,642
  • 9
  • 41
  • 57
4
votes
1 answer

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] Description=SQLite3 ODBC…
Dánjal Salberg Adlersson
  • 429
  • 5
  • 11
3
votes
4 answers

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 installed after activating virtualenv only. But I get…
Vishnu Kumar
  • 262
  • 4
  • 11
1
2 3 4 5