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
1
vote
0 answers

pysqlite for python 3.3.5 on Centos 6.5

I have compiled python 3.3.5 from source in the /opt folder as follows: yum install sqlite-devel ./configure --prefix=/opt/python3 make make install ln -s /opt/python3/bin/python3 /usr/bin/python3 I then installed easy install as follows: wget…
user2284355
  • 455
  • 2
  • 10
  • 24
1
vote
2 answers

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id but the id in previous table before compacting.…
user938363
  • 97
  • 2
  • 11
1
vote
1 answer

How do I back up my rails database on the fly?

I have been looking for a way to back up my app's database which is hosted by heroku. It uses an sqlite database. What I am looking for is a way to add a button on my site which will allow me to download the database as an sqlite file. I am sure…
Danny Dyla
  • 153
  • 4
1
vote
1 answer

Not Installing Sqlite 3 on CentOS correctly

I need to get sqlite 3 installed for php on a CentOS but its still telling that it's not installed. I did the command and got this message: yum install sqlite Package sqlite-3.6.20-1.el6.x86_64 already installed and latest version I looked into…
MCHam
  • 125
  • 1
  • 3
1
vote
1 answer

DB encryption for Django web app without storing key on server

We are setting up a virtual private server (not hosted by us), on which we will be user testing our Django-based web application. The user-generated content produced in these tests will be very sensitive. We would like to keep this content…
Xun Yang
  • 111
  • 2
1
vote
3 answers

PHP enable sqlite phpinfo states --without-sqlite

I've seen similar questions but none that address my situation adequately. I'm running Apache and PHP 5.3.6 on a amazon cloud server. phpinfo keeps stating that sqlite is disabled. At least that what it seems from the configure line: './configure'…
James John McGuire 'Jahmic'
  • 259
  • 1
  • 5
  • 14
1
vote
2 answers

How to install precompiled binaries in linux

I am trying to install a pre-compiled sqlite version 3 (sqlite3) binary in linux. I created a directory /home/username/src and I placed the zip file in the directory then unzipped the file. What I was left with was sqlite3. When I try to use it I…
princess
1
vote
1 answer

How do I install php with sqlite support in AWS EC2?

I'm trying to run an AWS EC2 instance for a facebook app. I chose the micro Amazon linux 32-bit as my OS. I'm able to SSH in and install PHP with yum, but when I run phpinfo() I see --without-sqlite in the configuration. Also, my sqlite php page…
James
  • 113
  • 1
  • 4
1
vote
2 answers

Installing sqlite gem fails on AWS Linux instance with sqlite-devel libraries installed

I'm running an instance built off ami-595a0a1c. I am trying to install the sqlite3 (or sqlite) gem and it's failing with the below error: $ sudo gem install sqlite3 Building native extensions. This could take a while... ERROR: Error installing…
Scott
  • 11
  • 1
  • 3
1
vote
3 answers

How do I activate SQLite3 on PHP 5.3.3 Centos 5?

I have reviewed the previous questions on this and they don't seem to cover what exactly I'm looking for, before I start, I'm no server admin. I'm trying to help get this server up and active and I have got it all going with exception to the…
user58553
1
vote
1 answer

sqlite and php enabling

I have a fresh install of fedora 12 and am trying to get php and sqlite working I installed php through: yum install php php-devel php-pdo and restarted apache. Php pages are working just fine but whenever I try to load a page that uses sqlite the…
jcb344
  • 683
  • 2
  • 7
  • 8
1
vote
1 answer

svnadmin: SQLite is required to be compiled and run in thread-safe mode

I've used apt-get to install Subversion and SQLite on my Ubuntu VPS, however, I'm getting this error when I try to use svn: svnadmin: SQLite is required to be compiled and run in thread-safe mode Does anyone know why this might be happening? I…
kenny99
1
vote
1 answer

weird text appearing when using PHPBB >v3.0.1 XAMPP windows SQLite

This is the strangest, most baffling problem I have ever encountered. Basically when I use any PHP forum software other than phpbb it works fine but when I use any version of phpbb greater than 3.0.1 it goes all weird and any file that has any sort…
Neddy
1
vote
0 answers

Use flock to back up sqlite?

I want to back up an SQLite database file without making a local copy to avoid flash memory wear. I'd also like to avoid moving the partition to a snapshottable file system like LVM. I figured I could just run flock database.db rsync ... but when I…
AndreKR
  • 551
  • 1
  • 3
  • 17
1
vote
1 answer

How can I safely stop postfix being picky about group permissions of sqlite database?

Background I set up an example postfix server using sqlite to store the aliases and mailbox details, (so that they could be updated live and have a single source of truth being the database.) I have the parts of postfix running chroot where possible…
Alexx Roche
  • 111
  • 6
1 2 3
4
5 6 7