Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
121 views

SQLite WAL concurrent write performance on UNIX systems

I have two setups: one runs on windows 10 (ntfs partition), the other on debian (ext4 partition). The R source code is the same. The main process starts 8 child-processes (P-SOCKS) -- on 8 vcores -- ...
0
votes
1answer
1k views

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 ...
0
votes
0answers
653 views

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 ...
0
votes
0answers
193 views

How can I setup an SQLite database for serverless Cloud Functions?

I have some Serverless Lambda Functions and I would like to host an SQLite database with about a GB of data for free or very cheaply (1 USD per month). My initial thought is to use Amazon Elastic ...
0
votes
0answers
81 views

Asterisk auto removed ps_contacts data when unregistered device

I tried changing the database from MySQL to SQLite3. Then I tried to use Zoiper to register using the registered pjsip number. Problems arise when unregistered devices. Data on ps_contacts is not ...
0
votes
0answers
53 views

Does PHP-FPM cache my Sqlite3 database file?

We have a large Sqlite3 database file (90+ GB!) which is read by a PHP script many times during the day; so it is only ever in read-only mode. We need to update this file every so often and on this ...
0
votes
1answer
65 views

Ubuntu 14.04 php7.1 sqlite driver could not find to install

My Laravel application has test environment to run on sqlite database but it's says the driver is missing and I could not find any solution to install the driver. Would someone help? I have the ...
0
votes
0answers
87 views

Update SQLite3 in PHP

I just checked my server's PHP 7.3.8 SQLite and its way old, 3.7.17, compared to the latest SQLite 3.29.0. Is there a stable way to include the new sqlite into PHP? PHP.INI doesn't have any ...
1
vote
0answers
125 views

How to fix the Sqlite3 differing versions using Python?

I had sqlite version 3.7.17 on centOS. I then installed from source code 3.28.0. Unfortunately the sqlite3 python module is still using version 3.7.17. Do I have to recompile python? [root@jenkins ~...
0
votes
0answers
593 views

ASP .NET CORE 2.0 web application on IIS showing sqlite error 14 “unable to open database file”

So I had run into a problem when I attempted to host a web application. Everything works fine in visual studio and when I use IIS express for debugging, but when I publish it and upload it to my ...
0
votes
1answer
165 views

How to convert a MediaWiki installation using MySQL to SQLite?

We're running a small own MediaWiki installation based on MySQL here. For simplicity reasons it would be great to convert this installation to an SQLite variant as it then would not require a separate ...
0
votes
1answer
2k views

How to update sqlite3 from python? [closed]

How to update sqlite3 from python? I am having problems with the old version of Slite3 for python3.6. I need to upgrade for version 3.22.0 or last root@server01# python3.6m Python 3.6.7 (default, ...
1
vote
2answers
208 views

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

What are the options to “atomically” stage different files (not having ZFS)

I need to take a backup of an SQLite3 DB matching the state of other applications writing to disk, besides a vault using the filesystem as a backend. I need to do this in a system with no ZFS so no ...
4
votes
1answer
14k views

Enabling sqlite3 in php7

I want to enable sqlite3 in php.ini but when I try to load a PHP script this error happens: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/20151012/sqlite.so' - /usr/lib/php/...
-3
votes
1answer
120 views

Teamspeak 3 Database Error

I am working on a project for a 'redudant' teamspeak server wtih aws. Ive got most of what I need done, however I'm running into a snag. Teamspeak A is the primary server, and is running fine. I need ...
0
votes
0answers
379 views

Fedora26 PHP 7.1.10 PDO_SQLITE Startup Warning: Unable to load dynamic library

php -v responds with : PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64 /php/modules/pdo_sqlite.so' - /usr/lib64/php/modules/pdo_sqlite.so: undefined symbol: ...
0
votes
1answer
408 views

Class 'Database\\SQLite3' not found

I've encoutered some problems with SQLite3 for PHP 7 on Ubuntu 16.04 LTS. After installing the module via sudo apt-get install php-sqlite3. Now, im trying to run this code: <?php namespace ...
0
votes
1answer
741 views

SQLite3 is crashing the JVM

I am using sqlite-jdbc 3.7.2 when i run my application, SQLLite is crashing the JVM. It is not happening consistently but it happened twice. Please help to find the issue. A fatal error has been ...
3
votes
2answers
3k views

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 ...
0
votes
0answers
94 views

Does Microsoft SQL Server have something similar to 'sqlite:///:memory:'?

Python 2.7 SQLAlchemy Microsoft SQL Server Management Studio 10.50.2500.0 Microsoft Analysis Services Client Tools 10.50.2500.0 Microsoft Data Access Components ...
8
votes
2answers
24k views

Install sqlite latest version on Centos6.7

I'm trying to install the latests versions of sqlite (> 3.7.5) under Centos 6.7. So when I launch install command : yum install sqlite I get the following Message : Package sqlite-3.6.20-1.el6_7....
5
votes
1answer
1k views

How can I test whether fcntl() locks work with my NFS setup?

From the SQLite FAQ: Can multiple applications or multiple instances of the same application access a single database file at the same time? … SQLite uses reader/writer locks to ...
0
votes
0answers
353 views

Upgrade SQLite Library for php 5.4

My php version is 5.4 This is what I get in phpinfo pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.6.20 I really need to update this driver. On PHP 5.3 you could do this with ...
2
votes
1answer
368 views

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 ...
3
votes
2answers
17k views

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 ...
0
votes
1answer
421 views

Deploy MySQL/MariaDB on demand in a C# application

I'm creating a lightweight bug tracker, and I'm really having difficulties with people that don't know how to deploy and connect to a MySQL database on their own. What they should do is to create ...
3
votes
2answers
4k views

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

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 $ ...
3
votes
1answer
3k views

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" ...
1
vote
1answer
115 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
2
votes
2answers
8k views

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 ...
0
votes
1answer
269 views

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 ...
0
votes
1answer
9k views

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 ...
1
vote
1answer
1k views

yum list showing wrong version

I am trying to install freeswitch and while configuring it, it spits out the message. "checking for sqlite3 >= 3.6.20... Package sqlite3 was not found in the pkg-config search path. Perhaps you ...
0
votes
1answer
101 views

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 "...
1
vote
1answer
121 views

Distributing load from Django App

I am currently approaching stages to move my first large-scale application out of development. I have talked with some CTOs who know what they're talking about, and I have been advised to do the ...
1
vote
0answers
957 views

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 ...
1
vote
2answers
990 views

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 ...
0
votes
1answer
741 views

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)...
0
votes
1answer
1k views

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 ...
0
votes
1answer
414 views

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 ...
0
votes
0answers
252 views

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 ...
9
votes
1answer
17k views

How can I convert an MS Access database (.mdb) file to a Sqlite database (.db) file? [closed]

Can anybody help me convert an MS Access (.mdb) file to an Sqlite database (.db) file? I need to convert all the tables and dump the data inside. Are there any tools available, or is there any API ...
0
votes
1answer
560 views

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

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 ...
1
vote
1answer
4k views

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 ...
2
votes
1answer
160 views

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

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, ...
1
vote
1answer
970 views

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 ...