Questions tagged [database]

an organized collection of data. The term is usually also used for a database management system (DBMS), the software application that allows the user to interact with the database, including definition, creation, querying, update, and administration of databases.

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

oneM2m - An IoT service layer

Has anybody used a oneM2M IoT service Layer? http://www.onem2m.org/ Does anybody know about this? If anybody has worked upon this please can you share the details of how to implement and what are ...
1
vote
1answer
37 views

How to connect a geophone to RaspberryPi?

I'm a seismic geophysicist and would like to attach a geophone - which is basically a transducer - to any type of RP. The types and costs of geophones are both variable and extensive (in some cases). ...
0
votes
2answers
106 views

How can Rpi3B+ read the output of the 801s vibration sensor module?

Currently I'm trying to do a project using rpi 3b+ with 801s vibration sensor using this tutorial https://github.com/Shmoopty/rpi-appliance-monitor#notification-settings I'm beginner with rpi and ...
1
vote
1answer
31 views

Share data between different

I'm building a floor heating control with raspberry pis. Until now I have two Pis working, one which controls the valves via relays and another which works as "central" with a webinterface to adjust ...
0
votes
0answers
66 views

“Error establishing a database connection” with Wordpress and LAMP Server

I'm attempting to complete a beginner's project from raspberrypi.org's projects page. However, after following the project directions I keep receiving an "error establishing a database connection" ...
0
votes
1answer
26 views

What database should I use for an application that will be deployed on both Linux (raspb pi) and Android

I'm building an application that will be deployed on two different platforms simultaneously (Linux (raspb pi) and Android/web). I'm using Python for Linux and either Python or JavaScript for Android/...
1
vote
0answers
144 views

How to install Couchbase onto a Raspberry Pi 3

I am making a discord bot, and I want to use Couchbase as my Database option. (So I can get some practise on it, since work is switching to it) However, Couchbase does not officially target the ARM ...
0
votes
0answers
92 views

Data transfer from Raspberry Pi to Microsoft Azure Cloud

I am trying to send the data measured by my Smart Plug into the Microsoft Azure Cloud so that I can visualize it there later. I have a python program (the original is from BeardMonkey https://www....
1
vote
1answer
53 views

How can I display data in a table (through software or a webpage)?

I want to send a text file from my Raspberry Pi (Raspbian Jessie) to my PC (Windows) via GSM, this file contains about twenty parameters of a vehicle (ex: level = 20 L). After that I want to display ...
1
vote
1answer
34 views

Host MP3 streaming website on raspberry pi

I (as I am sure most people do) have loads of MP3s and CDs from pre Spotify days (other services are available). In particular I have quite a few that aren't on Spotify. So I have decided that I would ...
2
votes
0answers
371 views

Database for Raspberry pi [closed]

I'm working on Home Automation project using Raspberry pi and i'm making android app for controlling home appliances like fan and bulb. I also want to make website for admin to see status of ...
-1
votes
1answer
227 views

Data logging in Raspberry Pi

I have made a C++ program which communicates with an RFM95 LoRa module and listens to messages from a various transmitters nearby. Those transmitters transmits sensors' data like temperature, humidity,...
1
vote
0answers
85 views

Running cockroachdb on a Raspberry pi 2 model b (32-bit) as a docker container

I'm trying to run cockcroachdb on a Raspberry Pi within a docker container, but they only provide 64-bit versions of cockroach as they explained it here . But I do see references of running cockroach ...
0
votes
1answer
1k views

Sending Rpi local data to an online Server (MySQL

I'm using a raspberry Pi zero w with temperature sensor, i don't have a continuous connection that's why i'm saving the temperature data on a local MySQL database using the following command <?...
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
1answer
27 views
0
votes
0answers
280 views

How to collect data from server to LibreOffice Calc

I have Mosquitto and Node-Red installed on my Pi 3. I want to be able to log the data into a spreadsheet of some sort. Is there a way to do this with Calc or a spreadsheet of some sort on the Pi? The ...
0
votes
0answers
2k views

Connecting Raspberry Pi 3 to MSSQL Server using pyodbc

I am currently trying to get my raspberry pi 3 with Raspbian Stretch Lite (November 2017) connecting to an MSSQL Server. I was following this guide and replaced the Driver and the Setup fields with ...
2
votes
2answers
1k views

How to install CouchDB 2 on Raspberry Pi

I've tried installing CouchDB 2.1.0 and 2.1.1 on Raspbian Stretch following the instructions in this blog: http://andyfelong.com/2017/09/couchdb-2-1-on-raspberry-pi-raspbian-stretch/ However when I ...
2
votes
0answers
481 views

MySQL suddenly broken after restart

I restarted my raspberry pi and now then I got this error on my website: SQLSTATE[HY000] [2002] No such file or directory I look at sudo service mysql status and I can see this. Jan 09 17:34:45 ...
4
votes
4answers
7k views

Install Postgre SQL in Raspbian Stretch

Anoyone try to install postgresql in Raspbian Stretch? I follow the instructions to the postgresql'site, but when in type sudo apt-get update, returns the follow error: N: Skipping acquire of ...
3
votes
2answers
2k views

Is it possible to use MariaDB data on an external USB hard drive?

I have a rpi3 and successfully installed MariaDB / PHP7 / Nginx server combination. How ever i want to keep the data on a USB HD. Security of the data is not critical, but the amount of writes to the ...
1
vote
1answer
4k views

GUI for Mariadb on the Raspberry Pi

Are there any GUIs for Mariadb on the Raspberry Pi besides phpmysql? I'm hoping for something that's as easy to install as sudo apt-get install mariadb-server
0
votes
0answers
1k views

Automatic sending RFID tag ID to MSSQL on a PC through Raspberry Pi using Pymssql

A RFID-RC522 connected to Raspberry Pi and a python script which reads RFID tag and prints out the result of the reading. And the aim of the project is to transfer the ID of the RFID tag to a ...
2
votes
1answer
5k views

Send RFID Tag ID to MSSQL on a PC through Raspberry Pi?

I have a RFID-RC522 connected to Raspberry Pi and a python script which reads my RFID tag and prints out the result of the reading. I want to transfer the ID of the RFID tag to a Microsoft SQL Server ...
0
votes
1answer
153 views

Python: `python DT22logger.py` error using PUTTY

I have done configuring some of the commands in making the DHT22 Temperature Sensor work. I have done configuring some codes in config.json now I am up to this python DHT22logger.py but I am getting ...
-2
votes
1answer
62 views

Problem with too much data in txt file and database

Hi guys once again I got serious problem with my project. I wanted to make a system which register measurement from tilt sensor(which can be high or low) after that it is saved in txt file and then ...
0
votes
1answer
2k views

Connecting to MySQL database running on Raspberry Pi using Windows Laptop/PI (LAN cable)

I am sorry if this sounds funny as I am a complete noob when it comes to database configuration. I have been trying to access my Pi's MySQL database from my laptop/or another PI. I have successfully ...
4
votes
1answer
7k views

Which database on Raspberry for 100,000+ Entries?

I am having the following situation: On an embedded linux board (a Raspberry Pi - but might be replaced in future by a SBC with similar h/w-specs) a Python application is reading sensor data every ...
3
votes
1answer
4k views

Which data base consume less resources? [closed]

I have a question, result that we have a Raspberry Pi with 1GB of RAM, and we need run a service of database, but we have various resources in the moment run. Now our question is, which database can ...
2
votes
2answers
2k views

How to remotely access a database on the Raspberry Pi?

I installed PhpPgAdmin on the Pi and want to access its database from my laptop. If I type on my laptop's browser http://192.168.1.97/phppgadmin, 192.168.1.97 being the inet adress of my Pi, I get a ...
-1
votes
1answer
497 views

How do we interface barcode reader and raspberry pi [closed]

I am developing a project to use a barcode reader to read information from id and put them into a database and i have used the pi for simple projects i have never done such a project any help please? ...
5
votes
2answers
1k views

looking for a compiled version of postgreSQL 9.5 for rpi 2

Has anyone installed postgres 9.5, the new release on a raspberry pi? sudo apt-get install postgres installs 9.4.5 at the moment..
0
votes
1answer
204 views

Stream replication of a postgres database on one raspberrypi2

does anyone know how to make a PostgreSQL database replica on one raspberrypi2? Perhaps partitioning what is left of my mmcblk0p1 partition into 2, one containing the master and the other one the ...
11
votes
5answers
16k views

locale settings Issues

I'm trying to connect to psql using the below command but receiving message about unset local setting how could one solve it. pi@raspberrypi ~/develop/radar $ psql -U postgres perl: warning: ...
6
votes
1answer
6k views

How to install InfluxDB and Grafana?

How to install InfluxDB and Grafana on my Raspberry Pi (1) / Raspbian Wheezy? As new release as possible.
3
votes
1answer
3k views

How can I use sql Lite Database in IoT

I normally use DataTables with SQl Lite in my C# desktop Apps. Using Raspberry Pi 2 with Windows IoT and C# the DataTable does not exist anywhere in this framework (searched using Object Browser). ...
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 ...
1
vote
1answer
331 views

Database/Webserver Alternatives

I have a Rasp pi project currently in the works for a college class... Everything is going great, but I really don't feel like my Pi (2B) will be able to handle being.. 1.) Appache Web Server (CSS / ...
1
vote
2answers
7k views

Database for raspbian accessed with the same raspberry pi

Here's what it want to do. I'm using my raspberry pi kind-of as another computer. I'm not using it as a server. I'm not accessing it remotely. And I don't care to do either of those as of this ...
-1
votes
1answer
1k views

Which graph database can ran on a Pi for small website? [closed]

I'm running a small website on a Pi B with tomcat / apache / mysql I wish to migrate database to a graph db, Neo4J seems good on "real" server but not on Pi as poorly mentionned here OhmDB seems to ...
0
votes
1answer
687 views

Webserver wth phpMyAdmin running. How Do I Connect to the database I created? [closed]

I have my raspberry pi running a webserver publicly with a domain name. I also successfully installed phpMyadmin and created a database with the tables I need and also a server following a few ...
0
votes
0answers
2k views

Insert data to phpMyAdmin mySQL database from Shell Script

I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK to ...
1
vote
1answer
738 views

Logging faces with OpenCV

I'm pretty new to OpenCV. Basically I want my RPi to do facial recognition with OpenCV and then log (save only the face as a picture) and store it in a database. How would I achieve this? I also want ...
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 ...
-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 ...
1
vote
1answer
1k views

How to configure a Web Server that can display data from my Raspberry PI?

I would like to know how to configure a web server that can display data. The data would come from the Raspberry Pi and Windows Azure.
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
votes
1answer
641 views

cloud raspberry pi

Basically, on the cloud, I want to execute a query and then take/emit result of the evaluation. To simplicity, I want use raspberry Pi as cloud server which stores database tables and can execute ...
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.