Comments on: SQLite Database on a Raspberry Pi

By: Sara Santos

Sara Santos — Tue, 05 Jul 2022 09:13:05 +0000

In reply to dave.

Hi.
Take a look at this tutorial: https://randomnerdtutorials.com/sqlite-with-node-red-and-raspberry-pi/
I hope it helps.
Regards,
Sara

By: dave

dave — Mon, 04 Jul 2022 22:45:46 +0000

I have been trying to learn how to save (4) DS18b20 and (1) BME280 data into an SQLite.

it seems there is a massive conspiracy to tell people how to install SQLite and then show one simple, single node save to the DB.

Please add a tutorial on Node-Red and SQLite on how to read multiple MQTT inputs, then save them to an SQLite database

By: Sara Santos

Sara Santos — Fri, 04 Oct 2019 09:35:51 +0000

In reply to Jessica Woods.

Hi Jessica.
We haven’t tried that.
Regards,
Sara

By: Jessica Woods

Jessica Woods — Thu, 03 Oct 2019 23:34:09 +0000

Starting my first project on a raspberry pi using sensor data. Does SQLite work well with photo storage?

By: Sara Santos

Sara Santos — Mon, 03 Jun 2019 10:47:31 +0000

In reply to Cezary Mikowski.

Hi.
Here is the tutorial: https://randomnerdtutorials.com/esp8266-publishing-dht22-readings-to-sqlite-database/
Regards,
Sara

By: Cezary Mikowski

Cezary Mikowski — Mon, 03 Jun 2019 09:42:49 +0000

Thank you for this tutorial. Have you managed to write announced sensor reading ESP8266 database update?

“In the next blog post, we will publish sensor readings with the ESP8266 that will be stored in the database and displayed in your Python web server.”

By: Rui Santos

Rui Santos — Thu, 15 Nov 2018 17:52:21 +0000

In reply to Shahbaz Anshari.

You’re welcome!
Thanks for reading,
Rui

By: Shahbaz Anshari

Shahbaz Anshari — Wed, 14 Nov 2018 08:47:22 +0000

Thanks for the useful tutorial to use the database on the raspberry pi.

By: Rui Santos

Rui Santos — Thu, 16 Feb 2017 22:07:03 +0000

In reply to Minh. I don't have the procedure for Centos...

By: Minh

Minh — Tue, 14 Feb 2017 22:50:19 +0000

I was playing with the SQLite as introduced here and have a few questions:
I run this on Centos 6x
– When I tried to yum install sqlite, I get a bunch of ERROR 6 – “Couldn’t resolve host ‘ bla bla bla’. How do I install sqlite on Centos?
– Though I am not sure if it will work correctly, but I was able to download the SQLite zip file for Linux and run it directly on the Centos host without installing it.

Does anyone have the same problem or any comment?