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
0 answers
22 views

Read RFID tag and display chart via HDMI

I'm a beginner in Raspberry Pi developing, I'm more familiar with embedded programming. But now, I have got a project, where I definitely need the performance and GUI of an Raspberry Pi :) Overview I'...
user avatar
  • 121
-1 votes
1 answer
655 views

Install Oracle on Raspberry

0 I need help!! I'm doing a school project where we have to install Oracle on our Rapberry pi 3. We have already download from Oracle website Basic Package(RPM) -SQL*Plus Package(RPM) -SDK Package(RPM)...
user avatar
  • 1
0 votes
0 answers
75 views

How can I re-create this on my Rasberry PI?

I want to do something similar to Kiwix. Can anybody tell me how I could re-create this myself, or at least the main steps needed to build a similar project? https://www.kiwix.org/en/ It sounds like ...
user avatar
-1 votes
2 answers
71 views

Raspberry Pi 4 as server with connection to two networks [closed]

I want to use my raspberry as a server. The Raspberry Pi is connected via Ethernet to the router. ESP32, a WiFi enabled Microcontroller, is connected via WiFi t the Raspberry. I want my esp32 to write ...
user avatar
0 votes
1 answer
2k views

Can't connect to a remote MySQL Database

I am running 2 Raspberry Pi3 (STRETCH, JESSIE) and a web server (PHP5, MySQL, PHPMyadmin, Apache2) on stretch. I have everything working as expected. However, I need to be able to connect to my MySQL ...
user avatar
  • 1,022
1 vote
0 answers
45 views

Redundant PiServer and Database

I'm running a Raspberry Pi with PiServer from which 5 Raspberry Pi clients boot over network. On the PiServer machine is also a database (mariaDB) that holds some information which is displayed on the ...
user avatar
4 votes
2 answers
2k views

Is there any way I can get the latest version of postgresql onto my pi?

I'm a noob to linux and pi so may just be missing the obvious but it appears the latest version available for the pi is 11.x which does not support generated columns. I am in the process of porting an ...
user avatar
  • 65
1 vote
0 answers
27 views

Send data from PC to RPi although theyre not in the same LAN

i'm planning a school project that should represent a two-factor authentication. I already made a user interface to type in information to log in like email address and password. My plan was to ...
user avatar
  • 11
1 vote
1 answer
150 views

Should I avoid using WP with some sort of visual composer when hosting on my Rapberry Pi 4? Is there a better and equally easy approach?

I've been told a WP-install can easily consume 2 Gigs of memory when editing in visual composers in WP. When my Pi only has 4 GB available and on top on that I'm running MariaDB (NOT Nginx), then ...
user avatar
1 vote
0 answers
999 views

Is raspberry pi zero w powerful enough for Mysql? [closed]

Is raspberry pi zero w powerful enough for hosting a Mysql database?
user avatar
1 vote
1 answer
293 views

How to make a system that uses a mobile sim and that acts on a relay by ringing the sim

I want to create a system that has an internet connection via a mobile sim and allows owners of enabled telephone numbers to switch a relay by ringing the device sim. The system must be able to ...
user avatar
  • 119
1 vote
1 answer
550 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). ...
user avatar
  • 111
0 votes
2 answers
462 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 ...
user avatar
  • 9
1 vote
1 answer
70 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 ...
user avatar
0 votes
0 answers
294 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" ...
user avatar
  • 1
1 vote
1 answer
44 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/...
user avatar
1 vote
0 answers
528 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 ...
user avatar
1 vote
1 answer
111 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 ...
user avatar
  • 11
1 vote
1 answer
545 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 ...
user avatar
  • 23
2 votes
0 answers
853 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 ...
user avatar
  • 131
-1 votes
1 answer
597 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,...
user avatar
  • 131
1 vote
0 answers
144 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 ...
user avatar
0 votes
1 answer
2k 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 <?...
user avatar
0 votes
1 answer
163 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 ...
user avatar
0 votes
1 answer
27 views

Hi, I have falshed o/s for my rasberry pizero W on my 32gb sd card which contained my lots of data,So all I want to ask can I recover it back? [closed]

I want to know that does flashing formats existing data,if no how do I get it back?
user avatar
0 votes
0 answers
540 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 ...
user avatar
0 votes
0 answers
3k 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 ...
user avatar
2 votes
2 answers
2k 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 ...
user avatar
2 votes
0 answers
748 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 ...
user avatar
  • 143
4 votes
4 answers
9k 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 ...
user avatar
6 votes
3 answers
4k 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 ...
user avatar
2 votes
1 answer
7k 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
user avatar
0 votes
0 answers
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 ...
user avatar
2 votes
1 answer
6k 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 ...
user avatar
0 votes
1 answer
167 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 ...
user avatar
-2 votes
1 answer
67 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 ...
user avatar
0 votes
1 answer
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 ...
user avatar
  • 31
5 votes
1 answer
10k 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 ...
user avatar
3 votes
1 answer
7k 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 ...
user avatar
2 votes
2 answers
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 ...
user avatar
-1 votes
1 answer
557 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? ...
user avatar
5 votes
2 answers
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..
user avatar
0 votes
1 answer
274 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 ...
user avatar
  • 111
11 votes
5 answers
23k 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: ...
user avatar
6 votes
1 answer
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.
user avatar
  • 1,210
3 votes
1 answer
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). ...
user avatar
0 votes
1 answer
320 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 ...
user avatar
1 vote
1 answer
542 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 / ...
user avatar
1 vote
2 answers
8k 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 ...
user avatar
  • 13
-1 votes
1 answer
2k 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 ...
user avatar
  • 119