Questions tagged [sqlite]
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
103
questions
75
votes
9
answers
288k
views
Why do I get sqlite error, "unable to open database file"?
Using my Django app, I'm able to read from the database just fine. When the application didn't have permission to access the file, it gave me this error:
attempt to write a readonly database
Which ...
- 5,126
32
votes
1
answer
46k
views
How can I verify that a SQLite db3 file is valid/consistent
I have some sqlite version3 db3 files I copied off a live running production system (I know bad sysadmin bad sysadmin) for various reasons. Is there some sqlite command I can run that will verify that ...
- 2,172
13
votes
4
answers
117k
views
How do I enable SQLite on Linux/Apache/PHP?
To enable SQLite on my Windows/Apache/PHP setup, I uncomment the following lines in the php.ini file and restart Apache:
extension=php_pdo.dll
extension=php_pdo_sqlite.dll
Now I have a VPS with Suse ...
- 1,209
10
votes
1
answer
20k
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 ...
- 101
8
votes
1
answer
916
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,193
8
votes
2
answers
30k
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
8
votes
5
answers
6k
views
SQLite on a production server? [closed]
I have known about SQLite for a long time and I know it is blazing fast, but I have never tried it in a production server. I was never able to find a solid estimate on how much traffic it could handle ...
- 305
8
votes
2
answers
7k
views
How to Link an SQL Server 2008 Server to an SQLite Server?
I want to "Link" an SQLite server with an SQL Server 2008 server. E.g. using the sp_addlinkedserver command. How do I do this?
I have searched far and wide, but found no solution for this problem. ...
- 181
7
votes
8
answers
5k
views
Is this idea about distributed database server with centralized storage feasible?
I often use SQLite for creating simple programs in companies. The database is placed on a file server. This works fine as long as there are not more than about 50 users working towards the database ...
- 447
6
votes
4
answers
5k
views
Can SQLite be used with GlusterFS?
I want to build a distributed storage based on GlusterFS with Automatic File Replication (AFR) to store users files in a fault-tolerant way.
But I also want to access an SQLite3 database stored on ...
- 197
6
votes
1
answer
23k
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
6
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
5
votes
9
answers
27k
views
Why class 'SQLiteDatabase' is not found in /var/www/*.php?
I am trying to use sqlite from PHP. I have the following simple code:
<?php
$db = new SQLiteDatabase("test2.sdb");
unset($db);
?>
As the result of this code (which I execute in the command ...
- 2,579
5
votes
2
answers
13k
views
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 ...
- 153
4
votes
7
answers
8k
views
Rsync / Sqlite database
Does anyone have ever tried rsync'ing sqlite database?
Is it possible to access the data while it gets syncronised?
- 337
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 ...
google-compute-engine
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
3
votes
2
answers
3k
views
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 ...
- 10.3k
3
votes
3
answers
24k
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
3
votes
2
answers
24k
views
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 ...
3
votes
1
answer
10k
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 ...
- 173
3
votes
2
answers
483
views
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 ...
- 4,987
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
2
votes
2
answers
6k
views
Enabling Sqlite3 for php on fedora
I am trying to get php with sqlite working on my fedora server. In the phpinfo is see that ./configure was set with the option --without-sqlite3. From what I have read these means that I might have to ...
- 683
2
votes
2
answers
652
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
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 ...
- 537
2
votes
4
answers
2k
views
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 ...
- 914
2
votes
1
answer
626
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
2
votes
2
answers
670
views
Why do I get a PHP 5.2.6 segmentation fault when using PDO_SQlite?
This is an installation on ModWest's shared hosting. I have enabled both PDO and PDO_sqlite on the server and phpinfo() verifies both are running. When I access PDO itself, I'm fine, and getting a ...
- 131
2
votes
1
answer
6k
views
What should I change in php.ini to enable usage of sqlite from PHP?
At the moment I cannot use sqlite from PHP. Probably I need to change something in my php.ini file. In my php.ini file I found 2 lines containing "sqlite":
[sqlite]
;sqlite.assoc_case = 0
Does ...
- 2,579
2
votes
2
answers
1k
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
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 ...
- 675
2
votes
1
answer
163
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 ...
- 121
2
votes
0
answers
854
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, pointing ...
- 121
2
votes
2
answers
408
views
What database app is best for including in a distributable app?
MySQL versus SQLite, for example? I understand that MySQL is harder to setup and configure... Would SQLite or another db be better suited in this regard?
- 48
2
votes
1
answer
424
views
Request Tracker sqlite to mysql migration
I'm planning to migrate request tracket 3.6 from present server. The rt is running on sqlite and the new one will be mysql. Is there any way to migrate sqlitedb to mysql server.
Thanks in Advance.
- 1,132
2
votes
1
answer
2k
views
Can't get php+sqlite working
I'm struggling all morning to make php work with an sqlite database. Here is a piece of php code that I try to execute:
#less /var/www/html/test.php
<?php
$db=new PDO("sqlite:/var/www/test....
- 1,368
2
votes
1
answer
4k
views
How can I enable encryption for SQLite3 in PHP5.3? [closed]
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 ...
- 123
1
vote
1
answer
5k
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
1
vote
2
answers
12k
views
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 ...
princess
1
vote
1
answer
855
views
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
...
kenny99
1
vote
1
answer
131
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
1
vote
1
answer
181
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
1
answer
5k
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 ...
- 125
1
vote
1
answer
469
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
1
vote
2
answers
1k
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 ...
- 97
1
vote
1
answer
602
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 ...
- 153
1
vote
1
answer
3k
views
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 ...
- 113
1
vote
2
answers
3k
views
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 ...
- 11
1
vote
3
answers
11k
views
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 ...
user58553