Questions tagged [sqlite]

SQLite is a relational database management system contained in a small (~350 KB)[4] C programming library. This tag is for questions about how to install SQLite, how to debug issues with it, and how to use it most efficiently on the Pi.

4 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
285 views

Unable to install a Map Tile Server on Raspberry Pi

I have a Raspberry Pi 3 B+ running Raspbian uname -a Linux raspberrypi 4.14.98-v7+ #1200 SMP Tue Feb 12 20:27:48 GMT 2019 armv7l cat /etc/os-release PRETTY_NAME="Raspbian GNU/Linux 9 (stretch)" ...
0
votes
1answer
307 views

Raspbian - SQLite, Nextcloud - file locked

I have a Rpi 3b+ on raspbian setup on sqlite and nextcloud. I run the below command: sudo -u www-data php /var/www/html/nextcloud/occ files:scan --all get the below output: Starting scan for user ...
0
votes
0answers
900 views

saving GPIO data to sqlite using python, retrieving dynamically using php

I am try to make a game for my son, it has 2 vibration sensors that represent Balls and Strikes (for baseball). When a sensor is hit I have a loop that adds a tick to either the strike or the ball. ...
0
votes
0answers
284 views

Intermittent Slow SQLite Inserts

Using a test script with test data, the average time to complete an insert, with SQLite3, is about 10ms. But about 3% of the time I do an insert it takes between 1 and 3 seconds to complete. I'm ...