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.
34
questions
1
vote
1
answer
48
views
install DBD::SQLite Freezes on aarch64-linux-gnu-gcc sqlite3.c
I'm trying to use IDrive backup on a raspberry pi with raspbian bullseye (see os-release output below). To setup idrive you download some (perl) scripts, install some pre-requisites and then login to ...
- 113
1
vote
0
answers
47
views
will rpi4 be powerful enough to handle my db queries
Hello I’m thinking of buying the rpi4 with 8gb ram.
I’m primarily going to be using it as a database for personal queries. I’m new to databases and I’m currently researching many options.
I would have ...
- 11
2
votes
1
answer
4k
views
Python 3.11.0 Import sqlite not found
I've tried
python -m pip install -U sqlite
it returns
No matching distribution found for sqlite
I'm using python 3.11.0
0
votes
1
answer
196
views
Storing Database or installing program on USB drive
I am planning to use by old Raspberry Pi Model B for webscraping with a python script. The data stored will eventually get huge (in GBs). So my SD card will run out quickly. I have a larger capacity ...
0
votes
0
answers
55
views
I cannot save data sent from Arduino Uno to Raspberry Pi
I am trying to send sensor reading from Arduino Uno to raspberry pi and I want to save this incoming sensor reading to SQLite which I downloaded to Raspberry pi. I used lm35 sensor on Arduino Uno and ...
1
vote
1
answer
2k
views
sqlite3 cannot find -lsqlite3
I'm using raspberry pi 2B with raspbian lite.
I'm trying to add an sqlite3 library on my C++ program.
Without starting adding any piece of code, using the flag -lsqlite3 I get the error.
src/main....
- 141
1
vote
0
answers
957
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)"
...
- 111
0
votes
2
answers
384
views
sqlite gigabyte database on RPi3B+ [closed]
I need r/w access to a sqlite database of several GBytes. Putting it on the SD card is out of the question as the writing would wear out the SD too quickly. This is why I was thinking of network file ...
- 239
0
votes
1
answer
199
views
How do I use Raspberry Pi to create a web application for my sensors? [closed]
I recently bought many sensor to use with my pi, using the GPIO. All the scripts to retrieve data are ready, but now, I would like to store it in a database, and then thanks to an API, use it to ...
- 11
1
vote
1
answer
497
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 ...
- 57
0
votes
2
answers
931
views
trouble installing SQLite
using a Raspberry Pi 3B with Raspbian Jessie I get this error when installing sqlite3 with
sudo apt-get install sqlite3
Reading package lists... Done
Building dependency tree
Reading state ...
- 313
0
votes
1
answer
733
views
MySQL vs SQLite on OSMC (Kodi) install
A python app has been successfully configured with the MySQL connector to write records to a small table to demonstrate a concept (very low volume of writes).
I will need to write to a database and ...
- 637
1
vote
2
answers
260
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
2
answers
8k
views
Package 'sqlite3' must not be downloaded from pypi
I am quite new to this so these type of errors just leave me blank..
I saw another question in which the answer is, do sudo apt install sqlite3. I tried that and the error message says I need to ...
2
votes
1
answer
9k
views
Error while installing a 'sqlite3' Python package
I have been trying to install several packages on my newly reformatted RPi and came across this error:
Command python setup.py egg_info failed with error code 1 in /tmp/pip-build-d1xgrryi/sqlite3
In ...
- 113
0
votes
1
answer
598
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 ...
- 161
1
vote
1
answer
646
views
Cannot install pg on Raspberry Pi
I have been trying to install pg to run my web application (Ruby on Rails).
I use a pg database.
With bundle install, it fails.
The output is:
current directory: /home/pi/.rvm/gems/ruby-2.3.3/gems/...
- 11
0
votes
0
answers
1k
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. ...
- 119
4
votes
3
answers
19k
views
Apache server "403 forbidden, you don't have permission."
I followed this tutorial Building an SQLite temperature logger.
The python files work perfectly, no errors at all. However, I am not able to see the webpage, I get a 403 - forbidden error.
I've been ...
- 241
3
votes
1
answer
1k
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 ...
- 31
0
votes
1
answer
342
views
PL/SQL in Raspberry Pi
Is there any way, by which I can execute PL/SQL commands in Raspberry Pi?
I know that MySQL, and SQLite doesn't support PL/SQL, so are there any other means by which I can execute PL/SQL commands in ...
- 387
0
votes
1
answer
505
views
Is there any way to read/get pin mode using python (and wiringPi) [closed]
I have a database with table pins with atributes pinNo, pinMode and pinState. I'm trying to read these raspberry pi's atributes using wiringPi in python script, and to write that data into the table ...
- 137
0
votes
2
answers
118
views
Extend my project to multiple remote Pis
My project is a home security system. Until now everything is embedded on one device. But I would like to use multiple Pi's, for example RFID reader on different spots without the need of cables.
The ...
- 133
0
votes
0
answers
363
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 ...
2
votes
1
answer
441
views
Hosting NAS, a sql database, and streaming to chromecast all over a home network
First of all sorry if this isn't the right type of question for here, but I didn't know where else to ask.
I have raspberry pi that I've worked with before (although not that extensively) but I'll ...
- 31
0
votes
2
answers
5k
views
How to create a REST services using Node.JS in Raspberry PI?
I would like to seek help on how to create a REST services using Node.JS in Raspberry PI. A simple REST services which can gather data from the sensors and write to SQLite database or Windows Azure's ...
- 95
-1
votes
1
answer
1k
views
Could not find driver when I trying to display my PHP
After going through a few tutorials of displaying data to php from python and my sqlite database, I keep getting this error and don't know how to fix it. I'm in need of urgent help.
Error Message
...
- 95
-2
votes
1
answer
1k
views
How to display database in plain HTML or PHP from Python [closed]
How do I just display what's in my database in plain HTML or PHP without any GUI interface or layout, just plain database display? Is it possible?
This is my Python code:
import sqlite3
import RPi....
- 95
1
vote
1
answer
540
views
Operational error when writing to database in Raspberry Pi's Python [closed]
I'm having an operational error when trying to run IDLE program (Python) in Raspberry Pi and it prompt me an error sentences:
Traceback (most recent call last):
File "/var/www/Sensor-LED.py", line ...
- 95
3
votes
1
answer
3k
views
raspbmc: Unable to exit sqlite3 after incorrect syntax even with semicolon
I was using sqlite to connect to MyVideos75.db when I noticed that the usual method of getting "un-stuck" from the sqlite prompt (entering a semicolon) wasn't working:
pi@raspbmc:~/.xbmc/userdata/...
- 2,147
1
vote
4
answers
3k
views
Best way to store temperature data offline
I am currently building offline logger - every 10 seconds the application will save GPS location + temperature and humidity.
And now comes the question: what is the best way to store these data on ...
- 166
0
votes
1
answer
4k
views
SQLITE/PHP on Raspberry Pi
Wondering if this would be easy/possible. I know MySQL is commonly used but I want to make a sort of web server that can access the Raspberry Pi or more important an External Drive attached to it.
...
user5439
1
vote
1
answer
1k
views
Python SQLite3 select with and operator
I'm pretty new to python and SQLite but have done substantial work with MySQL and php.
I'm trying trying to do a conditional select on some data and would like to use the AND operator.
The MySQL ...
- 225
20
votes
1
answer
3k
views
Is there an alternative to MySQL?
I'd like a lightweight database for my lightweight RaspPi. MySQL seems a bit of overkill and involves too much administration. I'll need one with a perl API.
- 1,051