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

0
votes
0answers
36 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
0answers
136 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
181 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
223 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
45 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
86 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
81 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
229 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
548 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
402 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
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.