Super User Stack Exchange
Super User 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, serverless, 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.

111 questions
43
votes
8 answers

Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?

Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio? Right now we have a process that will grab the data from a Microsoft SQL Server database and put it into a SQLite database file that will be…
Brian T Hannan
  • 981
  • 4
  • 14
  • 26
24
votes
5 answers

How to install the SQLite PDO extension on Ubuntu

The default Ubuntu PHP package does not include the PDO SQLite extension. How can I install the SQLite PDO extension? Is there a package that one can easily install via apt-get?
wowpatrick
  • 3,709
  • 7
  • 27
  • 38
23
votes
4 answers

SQLite with readline support on Ubuntu

I had the sqlite3 package installed on Ubuntu and there's no support for readline. That means there's no command history and those other nifty features readline gives you. Is this a configuration or a packaging problem? Is there a different package…
agentofuser
  • 6,857
  • 11
  • 36
  • 33
23
votes
2 answers

Enable autocomplete in an sqlite3 interactive shell

I am using sqlite3 on a machine where I can use tab completion (ie .read abc will autocomplete to .read abcdefghij.db. I would like to know how to enable this on my personal machine. Both machines are ubuntu linux and the shell is bash. I am…
CoatedMoose
  • 333
  • 2
  • 8
21
votes
7 answers

Search via all Skype history

How to search given string at all chat histories? СTRL+F - search inside one chat, but I have a lot them, so I want find something in all saved chats?
coms
  • 313
  • 1
  • 2
  • 7
18
votes
5 answers

How do I repair a corrupted Firefox places.sqlite database?

I had some problems with my RAM (bluescreen several times, Windows XP) and now are my Firefox databases damaged. Firefox is working, but my history is gone and it's reporting several inconsistencies and errors when executing pragma integrity_check…
Bobby
  • 8,804
  • 3
  • 36
  • 44
10
votes
3 answers

Open SQLite db in Microsoft Access?

Are there any tools to allow using sqlite databases from Microsoft Access? Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would helpful too. I'm using Access 2007 x64.
matt wilkie
  • 4,764
  • 21
  • 54
  • 81
8
votes
1 answer

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
maurox
  • 181
  • 1
  • 4
8
votes
1 answer

Identify SQL time format

I found this representation of a date (and time?) in an SQLite database. I don't recognize it as anything standard like UNIX timestamp, can anybody help me to identify it? 498586831.475129 or 497469155.776235 sometimes however, it is only one number…
Xaser
  • 716
  • 2
  • 9
  • 18
7
votes
4 answers

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing with these databases - is there any software…
littlejim84
  • 123
  • 1
  • 4
7
votes
3 answers

SQLite: Data entry interface?

I'd to like to use SQLite to start tracking a few things. I won't have any trouble setting up the database itself, but I'd struggle at programming an interface. Is there any kind of open source data entry interface to SQLite? (not just…
Tommy O'Dell
  • 223
  • 2
  • 8
7
votes
4 answers

Using SQLite3 with Cygwin

I'm trying to use sqlite3.exe command shell with a mintty terminal in cygwin. I tried the program from a windows command prompt and it works. When I try to use it from the cygwin mintty terminal it seems like the program hangs. I can see the…
jmq
  • 409
  • 3
  • 7
  • 15
6
votes
7 answers

Easy and simple SQLite database GUI?

I'm looking for a really simple GUI that interfaces with an SQLite database to facilitate editing/searching a single table, which includes: Editing the table in tabular format, like a spreadsheet (not requiring the extra clicks to edit individual…
Jason S
  • 6,952
  • 14
  • 57
  • 79
4
votes
2 answers

Update a sqlite database while select into a while loop

There is a bash script that will do "some magic"™ to files which will be referenced to a sqlite database and after doing "some magic"™ the database should be updated. Here are the simplified code sqlite3 database.db "select NUMBER from table WHERE…
UsersUser
  • 423
  • 4
  • 12
4
votes
0 answers

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 really my favorite option This is the…
Kethryweryn
  • 141
  • 5
1
2 3 4 5 6 7 8