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.
63
questions
0
votes
0
answers
18
views
PostgreSQL directory on SSD
I have a Raspberry Pi 3 on my network with PostgreSQL installed on it.
At first, I had some tables installed on it, and saved on SD, and it worked perfectly. I had enabled entrance from the network ...
- 1
2
votes
0
answers
815
views
Postgres ERROR: SSL SYSCALL error: Connection timed out
I wanted to develop an app with Python that would run on a Raspberry and be remote controlled. This app should control (switch on and off) 2 leds based on the current day, time and the user's ...
- 21
0
votes
0
answers
45
views
Raspberrry Pico and ODBC
We are looking for an ODBC driver for Raspberry Pico W.
Is there one at all?
- 1
1
vote
0
answers
39
views
will rpi4 be powerful enough to handle my db queries
Hello I’m thinking of buying the rpi4 with 8gb ram.
I’m primarily going to be using it as a database for personal queries. I’m new to databases and I’m currently researching many options.
I would have ...
- 11
0
votes
0
answers
31
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'...
- 121
-1
votes
1
answer
1k
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)...
- 1
0
votes
0
answers
82
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 ...
-1
votes
2
answers
129
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 ...
0
votes
1
answer
3k
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 ...
- 1,063
1
vote
0
answers
56
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 ...
- 111
4
votes
2
answers
3k
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 ...
- 65
1
vote
0
answers
28
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 ...
- 11
1
vote
1
answer
162
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 ...
1
vote
0
answers
2k
views
Is raspberry pi zero w powerful enough for Mysql? [closed]
Is raspberry pi zero w powerful enough for hosting a Mysql database?
- 11
1
vote
1
answer
433
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 ...
- 119
1
vote
1
answer
702
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). ...
- 111
0
votes
2
answers
573
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 ...
- 9
1
vote
1
answer
131
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 ...
- 11
0
votes
0
answers
322
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" ...
- 1
1
vote
1
answer
46
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/...
- 11
1
vote
0
answers
576
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 ...
- 287
1
vote
1
answer
159
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 ...
- 11
1
vote
1
answer
724
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 ...
- 23
2
votes
0
answers
866
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 ...
- 131
-1
votes
1
answer
672
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,...
- 141
1
vote
0
answers
151
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 ...
- 11
0
votes
1
answer
3k
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
<?...
- 35
0
votes
1
answer
195
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 ...
- 11
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?
0
votes
0
answers
600
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 ...
- 5
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
...
- 101
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 ...
- 163
2
votes
0
answers
913
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 ...
- 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 ...
- 149
7
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 ...
- 121
2
votes
1
answer
8k
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
- 201
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 ...
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 ...
0
votes
1
answer
168
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 ...
- 1
-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 ...
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 ...
- 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 ...
- 193
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 ...
- 141
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 ...
- 463
-1
votes
1
answer
561
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
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..
- 333
0
votes
1
answer
310
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 ...
- 111
11
votes
5
answers
24k
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: ...
- 313
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.
- 1,220
3
votes
1
answer
4k
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).
...
user11286