Raspberry Pi Stack Exchange
Raspberry Pi Stack Exchange

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
20
votes
1 answer

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.
CPRitter
  • 1,061
  • 10
  • 15
4
votes
3 answers

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 banging my head for the last couple of days. I'm…
Julia_arch
  • 241
  • 1
  • 2
  • 8
3
votes
1 answer

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 when I compiled on x86 - localmachine: My SQLite…
brhmbzky
  • 31
  • 2
3
votes
1 answer

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/Database$ sqlite3 MyVideos75.db SQLite version…
3cheesewheel
  • 2,177
  • 6
  • 27
  • 32
2
votes
1 answer

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 the past I have used SQLite3 on my RPi so I am…
Kookaburra
  • 123
  • 1
  • 2
  • 10
2
votes
1 answer

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 soon be moving to a different setup and I was…
atallest
  • 31
  • 2
2
votes
1 answer

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
Universe Explained
  • 21
  • 1
  • 1
  • 2
1
vote
1 answer

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.cpp src/radio/radio.cpp src/radio/sx1276/sx1276.cpp…
MrBit
  • 141
  • 5
1
vote
0 answers

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)" NAME="Raspbian GNU/Linux" VERSION_ID="9" VERSION="9…
Emmanuel Mendoza
  • 111
  • 2
1
vote
1 answer

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 1 out of 1 (pi) Exception during scan:…
TheTourer
  • 57
  • 1
  • 6
1
vote
2 answers

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 made it with following step by step this tutorial.…
herlambang rizky
  • 13
  • 2
1
vote
1 answer

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:…
Greek2015
  • 11
  • 1
1
vote
1 answer

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 query would look like this. SELECT * FROM sensors…
Deac Karns
  • 225
  • 1
  • 2
  • 8
1
vote
2 answers

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 current project uses SQLite to store variables…
Bobys
  • 143
  • 3
1
vote
1 answer

Operational error when writing to database in Raspberry Pi's Python

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 34, in Blink (int(iterations),…
user3127380
  • 95
  • 3
  • 14
1
2 3