Questions tagged [sqlite]
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
104
questions
0
votes
0
answers
80
views
PHP to use specific SQLite version
Default PHP 8.2.1 on Centos includes SQLite 3.7.17. I am able to upgrade it to the latest SQLite with the aid of this article.
The problem is now this is a production server I wouldn't want to change ...
1
vote
0
answers
34
views
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 ...
- 553
0
votes
2
answers
227
views
Does exim4's `${sqlite_quote ... }` expansion de-taint the expanded value?
I'm upgrading an exim4 installation which has some custom filters, to Debian 11. (Specifically, the filters are this.)
Since that uses Exim 4.94, I've now run into the new-ish "tainted variables&...
- 115
2
votes
2
answers
677
views
On a system with fapolicyd enabled, how do I permit Java to run sqlitejdbc.so, which has a unique filename at each start?
My issue is fairly similar to this one: I have a Java application running on Rhel 8 that relies on an sqlite-jdcb driver. Unlike in that issue, my issue isn't with my filesystem being mounted with ...
- 116
0
votes
0
answers
65
views
Particular Email DB In Users Folder In Roundcube
I am trying to make db for every particular mail in user folder but when I use getenv('HOME') and getenv('_RCUBE') it shows me unable to connect with db.
This is how I use it
$config['db_dsnw'] = '...
- 101
1
vote
1
answer
109
views
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 ...
- 111
8
votes
1
answer
884
views
Linux/ext4/sqlite: Can touching a file while it's being written to cause a race condition?
For context: I need to be able to reliably update the timestamp on some sqlite DB files which get intermittent updates on an ext4 filesystem.
Can using the touch command (to update the last ...
- 1,203
0
votes
2
answers
801
views
Cannot execute sqlite statement with Ansible command module - [Errno 2] No such file or directory: b'sqlite3'"
I am trying to run a simple query on many servers. I know 100% that the file and directory in question exist.
I can do simple commands, such as ls, pwd, whoami, etc, and I can run the sqlite command ...
- 328
0
votes
1
answer
595
views
script backups sqlite database, when ran as a cron the db and names are mangled
I have a crontab:
* * * * * /home/ipa/web/backup.sh > /dev/null 2>&1
(No it doesn't run every minute just testing here)
The backup.sh has this:
#!/usr/bin/env sh
sqlite3 /home/ipa/web/...
- 97
-2
votes
1
answer
302
views
PHP 7.4 with last version of sqlite3
CentOS8 is distributed with sqlite3 version 3.26.
I would like to build a php 7.4 RPM with the version 3.35 of sqlite3.
Do you any advice to do so ?
- 97
0
votes
1
answer
352
views
A (cron) job to run if file has changed
I need to backup a live sqlite db by running a command once a day. Only if the db file has changed since last backup. How could it be achieved on Centos 8 ?
- 732
1
vote
1
answer
4k
views
SQLSTATE[HY000]: General error: 8 attempt to write a readonly database
(maybe this question is suited for SO, but I don't think it's linked to my code).
I'm using SQLite3 as a database engine for my Web app.
I freshly deployed it on the production server, and it's not ...
- 388
0
votes
1
answer
497
views
Postfix + SASL SQLite gives auxprop error on CentOS 7
I am receiving an unknown password verifier(s) auxprop error when trying to use SQLite for SASL authentication in Postfix on CentOS 7. It seems that the SQLite SQL engine is not found.
Contents of /...
- 1,405
0
votes
1
answer
225
views
How can I use the django shell while the server is running?
I have a django server deployed on digitalocean with gunicorn and nginx.
I followed a tutorial, I think it was this one.
Because of the tutorial I have django only installed in a virtualenv.
When I ...
- 135
1
vote
1
answer
447
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 -- ...
- 125
3
votes
1
answer
9k
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 ...
- 163
2
votes
0
answers
2k
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 ...
- 665
0
votes
0
answers
1k
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 ...
google-cloud-platform
0
votes
1
answer
180
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
0
answers
270
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
0
answers
275
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 ~...
- 423
0
votes
0
answers
2k
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 ...
- 1
0
votes
1
answer
340
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 ...
- 103
0
votes
1
answer
4k
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, ...
- 111
2
votes
2
answers
603
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-...
- 31
1
vote
0
answers
53
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 ...
- 558
6
votes
1
answer
22k
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/...
user472823
-3
votes
1
answer
352
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 ...
- 1
0
votes
0
answers
584
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: ...
- 11
0
votes
1
answer
1k
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 ...
- 148
0
votes
1
answer
1k
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 ...
- 103
4
votes
2
answers
5k
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
0
answers
121
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 ...
- 525
8
votes
2
answers
29k
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....
- 183
5
votes
1
answer
2k
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 ...
- 4,761
0
votes
0
answers
419
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
1
answer
582
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 ...
- 121
3
votes
3
answers
23k
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
...
- 713
0
votes
1
answer
499
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 ...
- 183
4
votes
3
answers
6k
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 ...
- 141
0
votes
2
answers
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
$ ...
- 213
3
votes
1
answer
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" ...
- 153
1
vote
1
answer
118
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 ...
- 113
2
votes
2
answers
10k
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 ...
- 527
0
votes
1
answer
306
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 ...
user236239
0
votes
1
answer
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 ...
- 103
1
vote
1
answer
2k
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 ...
- 115
0
votes
1
answer
108
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 "...
- 117
1
vote
1
answer
177
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 ...
- 113
1
vote
0
answers
1k
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 ...
- 455