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.

Filter by
Sorted by
Tagged with
19
votes
1answer
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.
4
votes
3answers
12k 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 ...
3
votes
1answer
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/...
3
votes
1answer
944 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 ...
2
votes
1answer
396 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 ...
2
votes
1answer
7k 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 ...
1
vote
4answers
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 ...
1
vote
2answers
111 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 ...
1
vote
1answer
326 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/...
1
vote
1answer
986 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 ...
1
vote
0answers
271 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)" ...
1
vote
1answer
394 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 ...
0
votes
1answer
151 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....
0
votes
2answers
192 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 ...
0
votes
1answer
113 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 ...
0
votes
2answers
597 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 ...
0
votes
1answer
243 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 ...
0
votes
1answer
401 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 ...
0
votes
1answer
451 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 ...
0
votes
2answers
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 ...
0
votes
2answers
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 ...
0
votes
1answer
294 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
415 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
890 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
2answers
104 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 ...
0
votes
0answers
283 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 ...
0
votes
1answer
3k 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. ...
-1
votes
1answer
911 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 ...
-2
votes
1answer
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....