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
0
votes
2 answers

Database password error in Owncloud migrating from SQLite to MySQL/MariaDB

In a Fedora system, I need to convert the Owncloud's SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ mysql_secure_installation then $ mysql -u root -p CREATE USER…
Germano Massullo
  • 213
  • 2
  • 5
  • 17
0
votes
1 answer

Jenkins fighting with Django over permissions

I've got a Jenkins/Nginx server running. But I get the error from Django: attempt to write a readonly database So I solved this problem by changing the ownership of the project folder to the default user: chown -R joren . Now Django is working…
user236239
0
votes
1 answer

Unbuntu 14.04 + Nginx + PHP5-FPM + sqlite3 : pdo sqlite could not find driver

phpinfo() says I have SQLite 3.x driver for PDO. php.ini only mentions sqlite like so: [sqlite] ; http://php.net/sqlite.assoc-case ;sqlite.assoc_case = 0 [sqlite3] ;sqlite3.extension_dir = I tried running sudo apt-get install php5-sqlite3 and it…
Rayhan Muktader
  • 103
  • 1
  • 3
0
votes
1 answer

I cannot find the SQLite Instance on Haskell / Snap based server

I have inherited a Haskell based server (on Ubuntu) on which SQLite is being used for authentication through the Snap SQLite-Auth module. After searching the server I am unable to locate the SQLite "instance" (I know it really isn't an instance). I…
Jay Blanchard
  • 117
  • 7
0
votes
1 answer

Empty Asterisk 12 CDRs in SQLite3 database

Using: CentOS 6 Asterisk 12 cdr_sqlite3_custom.so cdr_sqlite3_custom.conf (deliberately simplified): [master] table=>cdr columns=>calldate, clid, test values=>'${CDR(start)}','${CDR(clid)}','test' Resulting in database lacking CDR…
Paul Basov
  • 163
  • 7
0
votes
1 answer

SQLite on latest PHP (>= 5.4)

http://www.php.net/manual/en/sqlite.installation.php Beginning with PHP 5.4, this extension is available only via PECL. http://pecl.php.net/package/SQLite This package is not maintained anymore and has been superseded. So, how am I supposed to…
Ansis Māliņš
  • 175
  • 1
  • 10
0
votes
1 answer

Which db managment software can copy from one sqlite3 table to another for fields which are common in both?

We are looking for db management software which can copy from one sqlite3 table to another for fields which are common to both tables. For example, if table A has column name and address. Table B has name , address and contact. The db management…
user938363
  • 97
  • 2
  • 11
0
votes
0 answers

Can't listen to port 4445; sqlite3

So I have a dedicated machine running Ubuntu 12.04 server with FreePBX 2.9. Earlier I was attempting to familiarize myself with SQL via sqlite3, but I received this dreaded error: SQLite header and source version mismatch So I saw a possible fix…
b0dhi_
  • 1
  • 2
0
votes
2 answers

database on SSD: data only or the DBM program too?

I plan on moving the data I use for statistical analysis (100-ish Gb) onto an SSD. The data is either sqlite single-file db's, or postgresql-managed data. The SSD is 240 Gb, 550 MB/s read and 520 MB/s write. Should I reserve that space for the data…
simone
  • 1,281
  • 2
  • 10
  • 11
0
votes
1 answer

undefined symbol: sqlite3_initialize

When I try to deploy my Rails application to an Apache server using Passenger, I get the following error in the logs: undefined symbol: sqlite3_initialize I get the same error when just running webrick using "rails s". How do I fix this? I'm using…
johntheripper
  • 23
  • 3
0
votes
1 answer

cron to merge xml into sqlite every two hours - lamp

I'm looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql table would also be fine.) xml: …
Jeffrey
  • 103
  • 1
0
votes
1 answer

Install PHP5 with SQLite3 on Debian Lenny

There is no apt-get install php5-sqlite3, as its refereed by php5-sqlite thus, i did: apt-get install sqlite3 and then apt-get install php5-sqlite Restarted apache2. When I run echo sqlite_libversion(); it returns 2.8.17. I tried…
ParoX
  • 302
  • 1
  • 7
  • 21
0
votes
4 answers

Installing newer version of installed RPM from source (CentOS)

I've got sqlite 3.3.6 installed through ''yum'', but I need 3.6+. There's no RPM to be found for it, so I decided to install from source. That was simple enough, but now I have both versions installed, which is problematic. I'd like to get rid of…
Trevor Burnham
  • 364
  • 2
  • 3
  • 16
0
votes
2 answers

sqlite3 support on centos with PECL?

i just realized that the rpm version of php that i have installed on the server don't have sqlite support (well it have the PDO support but for some reason don't work) so i installed as a PECL extension, and now it show the support on the phpinfo()…
shadow_of__soul
  • 376
  • 1
  • 6
  • 16
0
votes
3 answers

An SQLite/STDIN Conundrum, Specific to AIX

I'm been playing around with SQlite at work, specifically with trying to get the sqlite3 command line tool to accept stdin instead of a file. Sounds easy enough, on linux you can execute a command like: echo 'test' | sqlite3 test.db '.import…
mikfreedman
1 2 3 4 5
6
7