When troubleshooting serial bus communications like I2C, UART, or SPI, it can be handy to disconnect a chip select or data line to isolate external devices. Once isolated, the data can be viewed on a logic analyzer or oscilloscope to determine if the SPI or UART signal outputs are really connected to inputs or when examining the effects of multiple pull-up resistors on I2C. The Feather Isolator was designed to individually disconnect a Feather's pin with a switch to help with the troubleshooting effort.

I wanted a clock that would display the time in large yellow characters and display the week and day.  For fun added a 60 RGB neo-pixel ring to tick off the seconds.

The last part was to display the phase of the moon in a fun way and found these to be entertaining. 

I cut a sheet of plex-glass to 8x11 sheet.  I used miniature self-tapping screws to mount the RGB neo-pixel ring.  I used this same kind of screws to mount the 4-digit display and two of the Quad Alphanumerica Displays.

I drill large enough holes to plug the displays up to the Adafruit Qualia ESP32-S3 and daisy chained the rest.

I did solder 3 wires to the RGB neo-pixel ring a crimped a 3-pin connector on the other and plugged it in socket A0.

I used Photopea to create a 3x3 of the moon phases I found on the internet.  For the new moon phase I copied the full moon phase and changed its color from yellow to blue.  and its a seperate .bmp file.

I am not a very good coder anymore and new to python.  I am sure there are better coders out there than me for sure.  I hacked most of the code from other projects.

 

 

Parts Required for this project:

1. Adafruit Qualia ESP32-S3 for TTL RGB-666 Displays (PI - 5800
2. Round RGB TTL TFT Display -2.1" (PI - 5806)
3. NeoPixel 1/4 60 Ring 5050 RGB LED w/Integrated Drivers (PI -1768)
4. Quad Alphanumerica Display - Blue 0.54" Digits w/ I2C Backpack - Stemma QT / Qwiic (PI 1912)
5. Assembled Adafruit 0.56: 4-Digit 7 Segment Display -w/ I2c Backpack QT - Yellow (PI 5602)
6. Stemma QT JST SH 4-Pin Cable (50mm & 100mm)

Overview

This page aims to illustrate and document how you can use PostgreSQL and PostgREST to store and access data generated by sensors connected to micro-controllers or other IoT devices. Before we dive in, I'll introduce the projects and utilities that we'll be using:

• PostgreSQL - A widely used, open source database system. It's very extensible and has many plugs and other utilities built "on top" of it. Client applications connect to it via a network port and send SQL commands to create, read, update, and delete data.
• PostgREST - A standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations. This web server allows us to create, update and access our data with HTTP requests from micro-controllers and other endpoints.
• NGINX - A widely used web server with reverse proxy, load balancing, and many other capabilities. This project will use it to host static HTML and JS files that can be viewed in a browser. It is good practice to use Apache or NGINX as a reverse proxy "in front" of other web server utilities like PostgREST.
• ApexCharts - A Javascript library for making charts and graphs. We'll use this to graph data that we read out of our database.

Setup PostgreSQL

Method 1: Docker

The official PostgREST tutorial skips the full PostgreSQL setup opting instead for a quick / easy setup running inside of a Docker container. If you already have or are familiar with Docker then this route is quite straight forward. The following command will create and launch a PSQL container:

 

I'm almost ashamed to admit I had a Raspberry Pi 400 that went unappreciated for the longest time. My Dad got it for me as a gift, and it was sitting in a box of spare parts for months. Once I finally got to open it up and take a good look at it, I really wanted to do something cool with it. The Pi 400 was great enough by itself, having a built-in keyboard which you would only need to add a monitor to have a complete computer setup. However, I wanted to have an "all-in-one" setup, with even less wires to plug in. And since I was in a "Fallout" kinda mood, having recently watched the TV series and played one of their games, I decided to model this all-in-one casing based off of the terminal featured in the Fallout game series.

The general idea was to build a plastic casing to house all the pieces, and extend the Pi 400's ports with panel mount cables. First things first, I needed a monitor. It took me a while to find a monitor that I liked, but in the end, the one pictured above was what I settled on. However, I realized much too late that the monitor in question turned out to be a 12V monitor, and I was trying to have all the pieces be consistently 5V. I needed to adapt my strategy if I wanted to have a system powered by only one adapter. So, I bought a power adapter that output 12V and 5A, which I would use to power the monitor first, then bring the remaining power down to 5V via a buck converter.