Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sqlite]

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

Think of SQLite not as a replacement for Oracle but as a replacement for fopen()

Executive Summary

103 questions
4
votes
2 answers

SQLite on Google Cloud Persistent Disk

Does Google's Persistent Disk have proper reader/writer locks for concurrent access (many virtual machines accessing data from a single Persistent Disk) which is required for SQLite? According to the SQLite FAQ: SQLite uses reader/writer locks to…
Jon
  • 143
  • 1
  • 5
4
votes
3 answers

Inserting multiple lines into a sqlite column with bash script

I am trying to insert a value into my sqlite DB that consists of multiple lines and special characters. For example: { "foo"="$BAR" } I have been using the sqlite3 command but I dont know how to get this in. Also within my bash script I have…
JpaytonWPD
  • 141
  • 1
  • 7
3
votes
1 answer

sqlite3 module in python3.7 on CentOS

I'm trying to get a working version of Python 3.7 on CentOS, and the sticking point seems to be the built-in sqlite3 module. I'm building Python as follows (using a Dockerfile here for reproducibility): FROM centos:7.6.1810 RUN yum update -y RUN yum…
Ken Williams
  • 173
  • 1
  • 11
3
votes
3 answers

SVN Checkin Failure(sqlite[S5]: database is locked)

I am facing this issue intermittently when I am trying to check-in files svn ci -m "commit message" file Warning: post commit FS processing had error: sqlite[S5]: database is locked Some more info Server side OS --> Centos6.5 and svn version…
Prashant Lakhera
  • 713
  • 2
  • 10
  • 25
3
votes
1 answer

Graphite SQLite3 DatabaseError: database is locked

While going through the initial installation and set up of Graphite on CentOS 6.4 using Apache mod_wsgi via the stock graphite-web rpm, I'm getting the following "DatabaseError: database is locked" message: mod_wsgi (pid=9009): Target WSGI script…
havoc1
  • 153
  • 2
  • 7
3
votes
2 answers

PHP install sqlite3 extension

We are using PHP 5.3.6 here, but we used the --without-sqlite3 command when compiling PHP. (It stands in the 'Configure Command' column). But, it is very risky to recompile PHP on that server; there are many visitors. How can we install/use…
www.data-blogger.com
  • 201
  • 1
  • 3
  • 10
3
votes
2 answers

How to dump sqlite database to ascii?

For some reason Firefox won't let me see more than 1 month of history, despite I have set to to remember for 90 days. places.sqlite is 18MB so I would like to dump the content of it, and see if I can find the missing history. Does anyone know how to…
Sandra
  • 10,303
  • 38
  • 112
  • 165
3
votes
2 answers

Adobe Acrobat Sqlite errors with Mac OS X network accounts

We have set up network accounts for our Snow Leopard Users on several Macs, which work great except for applications that use a local Sqlite database for their preferences/cache. The biggest problem being Acrobat reader which launches and crashes…
Jon Rhoades
  • 4,987
  • 3
  • 31
  • 48
2
votes
0 answers

Upgrading sqlite on Centos 7

I'm installing a Django app on a Centos 7 server. The app uses Django 2.2, which requires SQLite 3.8.3 or newer. Centos comes with SQLite 3.7 from 2013. When I compile SQLite 3 from sources and run make install, it installs the new SQLite in…
zmbq
  • 675
  • 1
  • 7
  • 9
2
votes
2 answers

Using SQLite through PHP without completely disabling SELinux

I'm trying to access an SQLite file on a CentOS7 box using PHP and the PDO library. I was getting read-only errors just like this question - https://stackoverflow.com/questions/3319112/sqlite-read-only-database And per that question, the answer was…
Pipupnipup
  • 31
  • 4
2
votes
4 answers

Best system to serve sqlite databases to webservers over a network?

I am helping in setting up a web service in which user data will be stored in sqlite databases on a server running perhaps Samba, and one or more web servers will read and write to those databases on the backend. I would like advice as to which…
jberryman
  • 914
  • 2
  • 10
  • 25
2
votes
1 answer

Inconsistent "unable to open database file" error from a CGI program using SQLite

I've been running a task program for a psychology experiment on my virtual private server with lighttpd 1.4.28 and Ubuntu 12.04. The experiment is a CGI program written in Perl using a Perl module I wrote, presenting a web interface over Mechanical…
Kodiologist
  • 121
  • 8
2
votes
2 answers

Graphite SQLite3 DatabaseError: attempt to write a readonly database

Running graphite under apache httpd, with slqite database, I have the correct folder permissions [root@liaan55 httpd]# ls -ltr /var/lib | grep graphite drwxr-xr-x. 2 apache apache 4096 Aug 23 19:36 graphite-web and [root@liaan55…
Anadi Misra
  • 527
  • 2
  • 9
  • 23
2
votes
1 answer

Sqlite enabling in PHP 5

I know similar questions have been posted but they don't answer my question as far as I can tell. I have PHP 5.3 that is supposed to have sqlite3 extension installed php.ini does NOT have sqlite3 extension like commented so it should work. However…
user123959
  • 121
  • 1
2
votes
0 answers

Can you use SQLite 64 bit odbc from powershell

I have installed 64 bit ODBC driver for SQLite, downloaded from this page. I am running PowerShell version 2 on Windows 7. In the ODBC configuration I create a system DSN with name LoveBoat, pointing to a valid file. I don't have any "real" apps…
Levin Magruder
  • 121
  • 4
1
2
3 4 5 6 7