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

2
votes
0answers
50 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
39 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
1answer
50 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
23 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
49 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
37 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
0answers
15 views

My SQLite Database in RPi to Windows Azure's SQLdatabase

Sorry to disturb you guys but I needed urgent help for my project. After finishing my database and coding using Python in Raspberry Pi, I would like to know that how do I connect to Windows Azure's ...
0
votes
1answer
75 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: ...
0
votes
4answers
234 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
1k 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
363 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 ...
16
votes
1answer
1k 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.