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

102 questions
4
votes
2 answers

How to convert a postgres database to sqlite

We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but on the server (linux) we use postgres. We'd like to be able to import the production database into our development process, so I'm wondering if…
luqui
  • 143
  • 1
  • 1
  • 6
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
  • 163
  • 1
  • 9
3
votes
7 answers

Rsync / Sqlite database

Does anyone have ever tried rsync'ing sqlite database? Is it possible to access the data while it gets syncronised?
mnml
  • 327
  • 1
  • 7
  • 21
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
  • 683
  • 1
  • 9
  • 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

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
  • 9,973
  • 37
  • 104
  • 160
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,989
  • 3
  • 30
  • 47
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
  • 665
  • 1
  • 7
  • 9
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
  • 904
  • 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
  • 7
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
  • 22
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
2
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
  • 191
  • 1
  • 3
  • 8
2
votes
1 answer

How can I enable encryption for SQLite3 in PHP5.3?

The php manual for SQLite3::open has this information: public bool SQLite3::open ( string $filename [, int $flags = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE [, string $encryption_key ]] ) Opens an SQLite 3 Database. If the build…
meouw
  • 123
  • 1
  • 5
1
2
3 4 5 6 7