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.

learn more… | top users | synonyms

1
vote
2answers
53 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 ...
2
votes
1answer
72 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 ...
0
votes
1answer
42 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
53 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
2answers
61 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
279 views

SQLite JDBC Driver

I am trying to make a WebApp with Tomcat and SQLite. I managed to install Tomcat. It is running fine. I also managed to make an App. But when deploying it to the Raspi, xerial's JDBC driver jar ( ...
0
votes
0answers
83 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
1answer
316 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 ...
0
votes
0answers
476 views

Store records to SQLite database from Raspberry PI's PHP

I would like to seek help on storing data to SQLite database using PHP. I have designed a web control interface and wanted to store data of what time is been switch on or off whenever the user click ...
0
votes
2answers
1k 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 ...
-1
votes
1answer
188 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
236 views

How to display database in plain html or php from python [closed]

I would like to seek urgent help on just display what's in my database on plain html or php without any GUI interface or layout, just plain database display. Is it possible cause I'm new to it and ...
1
vote
1answer
208 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 ...
1
vote
1answer
788 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: ...
1
vote
4answers
1k 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 ...
0
votes
1answer
2k 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
vote
1answer
497 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 ...
17
votes
1answer
2k 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.