Raspberry Pi Stack Exchange
Raspberry Pi Stack Exchange

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.

61 questions
20
votes
1 answer

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.
CPRitter
  • 1,061
  • 10
  • 15
11
votes
5 answers

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: Setting locale failed. perl: warning: Please…
Jorge Vidinha
  • 313
  • 1
  • 5
  • 13
7
votes
3 answers

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 database I think would kill the SD card. I have…
Simon Markham
  • 121
  • 1
  • 5
6
votes
1 answer

How to install InfluxDB and Grafana?

How to install InfluxDB and Grafana on my Raspberry Pi (1) / Raspbian Wheezy? As new release as possible.
Christian
  • 1,230
  • 1
  • 13
  • 25
5
votes
1 answer

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 five seconds. I want to extend the application by…
Simon Kemper
  • 193
  • 1
  • 2
  • 7
5
votes
2 answers

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..
Clémentine
  • 353
  • 2
  • 4
  • 15
5
votes
2 answers

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 app from windows which relies on generated…
Edward
  • 75
  • 1
  • 5
4
votes
4 answers

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 configured file 'main/binary-armhf/Packages' as…
FelipeFonsecabh
  • 157
  • 1
  • 3
  • 9
3
votes
1 answer

Which data base consume less resources?

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 consume less resources, our app, this app…
julian salas
  • 141
  • 1
  • 2
3
votes
1 answer

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). So, can any database repositories be used in this…
user11286
2
votes
0 answers

Database for Raspberry pi

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 appliances, Which online database should i use for this…
umer arif
  • 131
  • 2
2
votes
2 answers

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 run the step make release I get a segmentation…
Eric Clack
  • 163
  • 11
2
votes
0 answers

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 raspberrypi systemd[1]: Failed to start MariaDB…
cobra12
  • 143
  • 1
  • 9
2
votes
1 answer

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
Russell Hankins
  • 201
  • 2
  • 7
2
votes
1 answer

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 database on a remote PC. On the Microsoft SQL…
Zaid Al Aqqad
  • 21
  • 1
  • 6
1
2 3 4 5