8 votes

locale settings Issues

Run raspi-config. Select 4 Internationalisation Options. Within that submenu, complete: I1 Change Locale I2 Change Timezone However, the warning from perl about locale is not necessarily the ...
goldilocks's user avatar
  • 58.5k
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,033
5 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
  • 993
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
  • 683
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 do we interface barcode reader and raspberry pi

If you look at the specs for the device you linked, it says that it is a "USB-Keyboard Interface" device. This means it looks, to the computer, like a keyboard. Therefore, you can write your project ...
Kryten's user avatar
  • 131
3 votes

locale settings Issues

With the new raspbian release Jessie, this can be done easily by just setting the LC_ALL value to C. Here's a link of that solution that i updated on another question. Hope it helps.
giri-sh's user avatar
  • 777
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
Accepted

Stream replication of a postgres database on one raspberrypi2

In the blog post linked, the word node pretty much means machine. They are using 2 different computers for the slave and master nodes. A hint is in the slave node section; primary_conninfo = 'host=...
Skrrp's user avatar
  • 226
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

PL/SQL in Raspberry Pi

PL/SQL is a proprietary language owned by Oracle Corp. This is why you only see support for it in commercial RDBMS's such as Oracle itself and IBM DB2. The latter presumably pay giant licensing fees ...
goldilocks's user avatar
  • 58.5k
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

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

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,726
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
  • 41.9k
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

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,271
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

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
1 vote

Python: `python DT22logger.py` error using PUTTY

There is an error in your configuration file. Python, rather helpfully, tells you where. line 21 column 2 (char 347)
joan's user avatar
  • 70.6k

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