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.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
883 views

Where is my SQLite database location on RPi2 SD card (Windows IOT OS)?

My SQLite project is working on Raspberry Pi 2 (with all function insert, delete, update ..) but where are my SQLite database files located? I followed this way I found my SQLite database location on ...
1
vote
0answers
137 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
239 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
1answer
89 views

Error 500 when executing Flask Webserver

Straight to the point. I'm using flask web server to build my monitoring garden. with this tutorial: https://www.instructables.com/id/From-Data-to-Graph-a-Web-Jorney-With-Flask-and-SQL/ finally, I ...
0
votes
1answer
370 views

How can I check a DB file from a bash script?

I need to create a bash script that checks the Epiphany's browser history and if the last URL visited is 192.168.8.1 then redirect to another URL. So, the Epiphany's browser history is shown in the ...
0
votes
0answers
840 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
266 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 ...