Skip to main content
8 votes

locale settings Issues

I was having a very similar issue. Here's how I fixed it: Run sudo nano /etc/default/locale Change it to include these three lines: LANG=en_US.UTF-8 LC_ALL=en_US.UTF-8 LANGUAGE=en_US.UTF-8 Then ...
Pikamander2's user avatar
5 votes
Accepted

Which database on Raspberry for 100,000+ Entries?

"Millions of entries" is peanuts for databases (or even data files as @joan suggests) nowadays. Let's say you need to store a 64-byte datavalue (maybe readings from a few sensors). If you store that a ...
Phil B.'s user avatar
  • 5,043
4 votes

Install Postgre SQL in Raspbian Stretch

As of right now (11/24/2017) you can install Postgresql v9.6 (stable/armhf) directly from the default Raspbian repositories via this command in the terminal/shell: sudo apt install postgresql-9.6 If ...
MrChips's user avatar
  • 983
4 votes
Accepted

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

In addition to the options presented by Ingo, there is also a PostgreSQL Docker image with ARM support: https://github.com/docker-library/postgres https://hub.docker.com/_/postgres/ This will ...
tttapa's user avatar
  • 986
3 votes

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

Seems like an IoT question, but anyway. You should define your project better. Usually then we start planing a project, we first list what we expect from the system. I guess that you want your ...
GramThanos's user avatar
3 votes

Host MP3 streaming website on raspberry pi

There exist some projects out there to achieve something like what you want. Volumio is an example of that. Another one is RuneAudio. Depending on where you want to store your music, I would suggest ...
David's user avatar
  • 703
3 votes

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

I tried all of the above, and all are valid, but my solution seems to be to make pi a member of group mysql e.g. usermod -a -G mysql pi
Simon Markham's user avatar
3 votes

How to install InfluxDB and Grafana?

I tried the same a few days ago on my RPi3 with the newest Raspbian Jessie (2016-03-18). But most of the tutorials online are kinda old and didn't seem to to work for me. (Like the answer from Daniel ...
IIIIIIIIIIIIIIIIIIIIII's user avatar
3 votes

locale settings Issues

Scriptable solution: sudo -i echo "en_US.UTF-8 UTF-8" > /etc/locale.gen locale-gen en_US.UTF-8 echo "LANG=en_US.UTF-8" > /etc/default/locale update-locale en_US.UTF-8
Filippo Vitale's user avatar
2 votes

locale settings Issues

I met the same problem when using SSH to connect my PI. I noticed that configuration in PI is different from locale settings in my computer. I change the /etc/default/locale in BOTH pi and computer ...
larrydong's user avatar
2 votes
Accepted

GUI for Mariadb on the Raspberry Pi

I found I could use mysql workbench, but there are incompatibility issues. I was hoping I could find something better. sudo apt-get install mysql-workbench
Russell Hankins's user avatar
2 votes

Which data base consume less resources?

Part of this can't be answered without knowing what kind of performance you need out of your database. On the Raspberry Pi, you have a couple mainstream options. MySQL PostgreSQL SQLite Flat files ...
Jacobm001's user avatar
  • 11.9k
2 votes

Install Postgre SQL in Raspbian Stretch

I've built armhf binaries for Raspbian stretch for PostgreSQL 11.2 that you can use by adding the apt repo: deb https://dl.cloudsmith.io/public/james-coleman/postgresql-arm-debian/deb/raspbian ...
jcoleman's user avatar
  • 121
2 votes

How do I use Raspberry Pi to create a web application for my sensors?

NOTE: This question is dangerously close to being an opinion question, which is more appropriate for Reddit. But I've tried to cast this answer as a "here's a working example". And you yourself have ...
OyaMist's user avatar
  • 1,119
2 votes

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

When you have solved the firedatabae you will meet another. The URL you refere to have a serious error. The "801s vibration sensor" have one digital output that is triggered depending on the level ...
MatsK's user avatar
  • 2,811
2 votes

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

The postgresql project has binaries available for Debian using a repository with adding an entry in /etc/apt/sources.list as you can see at Postgresql - Linux downloads (Debian). But you will also ...
Ingo's user avatar
  • 42.2k
2 votes

Raspberry Pi 4 as server with connection to two networks

The following answer is assuming you could connect your Raspberry Pi to your router via Ethernet. You can start a hotspot in your Raspberry Pi and connect your ESP32 via the hotspot. As per my ...
Irfanuddin's user avatar
1 vote

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?

Google it: online website analysis tool. There is a lot of website in this case and you can get a statistic of your site. In this link, I have tested your site. Check the result. The size is too large ...
Mohi Rostami's user avatar
  • 4,333
1 vote

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. In this instance, you need ...
Mohi Rostami's user avatar
  • 4,333
1 vote

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

If you are working with a sensor there are two major options: 1. You have to handle it through I2C 2. You have to read the analog or digital signal from that sensor(basically Vcc,Out,GND) What ever ...
Sohan Arafat's user avatar
  • 1,838
1 vote

Share data between different

I did something similar and used this basic set-up: Remotes controlling sensors send data to central. In my case I send JSON with the data over http. Central stores data in a MySQL database when the ...
Brick's user avatar
  • 1,377
1 vote

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

Use sqlite3, that's well supported in Raspbian. There's also some support in Android. https://developer.android.com/training/data-storage/sqlite
Dougie's user avatar
  • 5,321
1 vote

Data logging in Raspberry Pi

If it doesn't have to be NoSQL then the simplest option is SQLite3. The only restriction with SQLite3 is one writer. You can have multiple readers. I've been logging data from a BMP180 temp/pressure ...
Dougie's user avatar
  • 5,321
1 vote

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?

When you flash an sdcard any existing data is overwritten and gone for ever. Most flashing programs warn you of this before writing
Bra1n's user avatar
  • 1,251
1 vote

How to install CouchDB 2 on Raspberry Pi

Use the Erlang package that comes with Debian Stretch, not the one from the Erlang Solutions repository: sudo apt-get --no-install-recommends -y install \ build-essential pkg-config erlang \ ...
Eric Clack's user avatar
1 vote

Install Postgre SQL in Raspbian Stretch

As others have suggested, you can install PostgreSQL by using: $ sudo apt install postgresql-9.6 However I would not recommend using PgSQL on RPi unless: your RPi is on battery / UPS or you will ...
johndodo's user avatar
  • 113
1 vote

Install Postgre SQL in Raspbian Stretch

To find out the latest version of PostgreSQL (that you can install with apt): sudo apt-cache search postgresql | less As of now (12/14/2017) latest version (from the default Raspbian Stretch apt ...
Jim Callahan's user avatar
1 vote

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

I had a same problem. Then I mounted external hdd to /database and configured /etc/fstab to mount the drive at boot. Then it started working.
isakua's user avatar
  • 11
1 vote

looking for a compiled version of postgreSQL 9.5 for rpi 2

You could upgrade to the stretch version of Raspbian, it includes postgres 9.5 atm.
yglodt's user avatar
  • 347
1 vote

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

Use the pymssql module. Install with following command: pip install pymssql In your script you can use the following code: from os import getenv import pymssql server = getenv("...
Joe Platano's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible