How to set up a Postgres database on a Raspberry Pi @Raspberry_Pi #PiDay #RaspberryPi

Great piece from Ben Nuttall up on Opensource.com.

Databases are a great way to add data persistence to your project or application. You can write data in one session and it’ll be there the next time you want to look. A well-designed database can be efficient at looking up data in large datasets, and you won’t have to worry about how it looks, just what you want it to find. It’s fairly simple to set up a database for basic CRUD (create, record, update, delete) applications, which is a common pattern, and it is useful in many projects.

Why PostgreSQL, commonly known as Postgres? It’s considered to be the best open source database in terms of features and performance. It’ll feel familiar if you’ve used MySQL, but when you need more advanced usage, you’ll find the optimization in Postgres is far superior. It’s easy to install, easy to use, easy to secure, and runs well on the Raspberry Pi 3.

Read more.


Adafruit publishes a wide range of writing and video content, including interviews and reporting on the maker market and the wider technology world. Our standards page is intended as a guide to best practices that Adafruit uses, as well as an outline of the ethical standards Adafruit aspires to. While Adafruit is not an independent journalistic institution, Adafruit strives to be a fair, informative, and positive voice within the community – check it out here: adafruit.com/editorialstandards

Join Adafruit on Mastodon

Adafruit is on Mastodon, join in! adafruit.com/mastodon

Stop breadboarding and soldering – start making immediately! Adafruit’s Circuit Playground is jam-packed with LEDs, sensors, buttons, alligator clip pads and more. Build projects with Circuit Playground in a few minutes with the drag-and-drop MakeCode programming site, learn computer science using the CS Discoveries class on code.org, jump into CircuitPython to learn Python and hardware together, TinyGO, or even use the Arduino IDE. Circuit Playground Express is the newest and best Circuit Playground board, with support for CircuitPython, MakeCode, and Arduino. It has a powerful processor, 10 NeoPixels, mini speaker, InfraRed receive and transmit, two buttons, a switch, 14 alligator clip pads, and lots of sensors: capacitive touch, IR proximity, temperature, light, motion and sound. A whole wide world of electronics and coding is waiting for you, and it fits in the palm of your hand.

Have an amazing project to share? The Electronics Show and Tell is every Wednesday at 7pm ET! To join, head over to YouTube and check out the show’s live chat – we’ll post the link there.

Join us every Wednesday night at 8pm ET for Ask an Engineer!

Join over 36,000+ makers on Adafruit’s Discord channels and be part of the community! http://adafru.it/discord

CircuitPython – The easiest way to program microcontrollers – CircuitPython.org


Maker Business — Philips, an electronics giant, has faded from its former glory

Wearables — Capture sounds

Electronics — Audio amplifier advice

Python for Microcontrollers — Python on Microcontrollers Newsletter: MicroPython Pico W Bluetooth, CircuitPython 8.0.4 and much more! #CircuitPython #Python #micropython @ThePSF @Raspberry_Pi

Adafruit IoT Monthly — Boxing Glove Tracker, Disconnecting Smart Appliances, and more!

Microsoft MakeCode — MakeCode Thank You!

EYE on NPI — Maxim’s Himalaya uSLIC Step-Down Power Module #EyeOnNPI @maximintegrated @digikey

New Products – Adafruit Industries – Makers, hackers, artists, designers and engineers! — #NewProducts 3/15/23 Feat. Adafruit CAN Bus FeatherWing – MCP2515!

Get the only spam-free daily newsletter about wearables, running a "maker business", electronic tips and more! Subscribe at AdafruitDaily.com !



No Comments

No comments yet.

Sorry, the comment form is closed at this time.