Super User
Super User

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.

119 questions
51
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
  • 1,131
25
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
  • 4,559
24
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
  • 7,677
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 followed by TAB this 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…
CoatedMoose
  • 333
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
19
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
  • 9,032
13
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
  • 7,944
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
  • 5,324
8
votes
1 answer

Does SQLite come with Mac OS X?

Is SQLite pre-installed on Mac OS X or not?
maurox
  • 181
8
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
  • 429
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
  • 956
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
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
5
votes
2 answers

SQLite Database Browser fails to open Firefox cookie database

I downloaded SQLite Database Browser to preview cookies of Google Chrome and Firefox. I could successfully preview Chrome's cookies, however cannot manage to preview Firefox cookies. I'm trying open this file…
ST3
  • 785
5
votes
1 answer

Optimizing Firefox I/O regarding storage-sync-v2.sqlite-wal file (storage-sync-v2.sqlite database write ahead log file)

In my experience, Firefox creates a storage-sync-v2.sqlite database in each of its profile folders. This appears to happen even if profile syncing is disabled (and has never been enabled). What's odd (and perhaps a bug) is that Firefox also creates…
Amazon Dies In Darkness
  • 9,990
1
2 3 4 5 6 7 8