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.

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

Learn “How Computers Work” with Bill Gates, Ladyada and more – From Code.org !

CircuitPython in 2018 – Python on Microcontrollers is here!

Have an amazing project to share? Join the SHOW-AND-TELL every Wednesday night at 7:30pm ET on Google+ Hangouts.

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

Follow Adafruit on Instagram for top secret new products, behinds the scenes and more https://www.instagram.com/adafruit/

Maker Business — Prototyping PCBs with Particle, a guide from a pro in the field #makerbusiness

Wearables — Learn about stretch

Electronics — Test for interference on the cheap!

Biohacking — Visualizing FLU Data with Wearables

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.