paint-brush
65 Stories To Learn About Postgresqlby@learn
345 reads
345 reads

65 Stories To Learn About Postgresql

by Learn RepoMay 26th, 2023
Read on Terminal Reader
tldt arrow

Too Long; Didn't Read

Learn everything you need to know about Postgresql via these 65 free HackerNoon stories.

People Mentioned

Mention Thumbnail
featured image - 65 Stories To Learn About Postgresql
Learn Repo HackerNoon profile picture

Let's learn about Postgresql via these 65 free stories. They are ordered by most time reading created on HackerNoon. Visit the /Learn Repo to find the most read stories about any technology.

1. Create a Ruby on Rails (Rails-Postgresql-React) App using Docker Compose

How to create a Ruby on Rails application with Postgresql and React with Docker Compose

2. With JSONB Data in PostgreSQL, You Can Get the Best of Both Worlds

JSONB in PostgreSQL offers the best of relational and NoSQL. Here are two techniques that we use at AppLand to make JSONB data even more effective.

3. How Useful is PostgreSQL Full Text Search

PostgreSQL is the jack of all trades when it comes to databases. It brings you all the features you've come to love about SQL plus a bunch of features from Non-SQL databases. Some of these Non-SQL features like the JSONB data type are wonderful and you don't even have to dare flirt with another database. Others are good but not as robust and featureful as other databases.

4. Multi-tenant Postgres In The Real World

Back in the days when MySQL was the undisputed open source database champion, there was a sense that people who took their databases seriously would choose PostgreSQL instead. Everyone else chose MySQL; it was fast and it was easy.

5. Telegram Bot In Scala 3 With Bot4s + http4s + Doobie for CI notifications

Scala 3 is finally here, but have you seen many real-world applications written in it? In this article, I will show you an example of such an application!

6. Creating Clean Architecture Using Golang

Hi guys, I’m a Front-End developer. Before there was a time 2 years working CMS Magento, I like CMS Magento because system clean, and architecture database EAV (Entity — Attribute — Value) but I don’t understand why present I’m dev front-end (I don’t know) in the 2-year current. And present I chance comeback working position Back-End that I like.

7. Migrating from Heroku to Render

Migrate from Heroku to Render

8. Comparing Optimistic and Pessimistic Locking With GO and PostgreSQL

Comparison between Optimistic and Pessimistic locking with Golang and PostgreSQL

9. Migrating A Rails App To Digital Ocean The Easy Way

Heroku is one of the top PaaS in the market thanks to many of its features that make focus on development instead of configuration and maintenance. This has bee

10. Principles of a Clean Relational Database

The article describes how a relational database should be designed to properly work in OLTP mode.

11. Logical Replication: Real-time Web Updates From Your PostgreSQL Database

I wrote a small open-source library that combines dotNetify with PostgreSQL logical replication.

12. How To Install PostgreSQL With Docker Quickly

Many developers still install a database on their computer and work on it. It may be a preferable method, but using Docker takes only seconds to set up a database. I used PostgreSQL and Docker in my latest project. As a result, I have achieved efficiency and convenience. I will give you my experience with PostgreSQL and Docker.

13. PostgreSQL diff Explained

Normal development flow requires continuous patching the production database with local changes normally made automatically by the orm software, this method is not perect but deceptively simple, all we'll use is standard Unix commands, and is good enough for us.

14. How To Build Location-Based App with Geo🌎Django

Working with Geo🌎Django

GeoDjango is a built-in application that is included as a contrib module in Django. It’s actually a complete framework itself that can

15. DBngin: Instant Local Server for MySQL, PostgreSQL, and Redis

Docker might be an easy solution as an all-in-one tool for setting up a Local Development Environment. But on the other hand, it eats up a huge portion of your system resources to get up and running, and we hate it when our computer becomes lagging and clumsy.

16. How to Build a Directed Acyclic Graph (DAG) - Towards Open Options Chains Part IV

In "Towards Open Options Chains", Chris Chow presents his solution for collecting options data: a data pipeline with Airflow, PostgreSQL, and Docker.

17. How To Connect Ruby on Rails API, PostgreSQL And Heroku

Creating a new Rails app is super easy by itself. And, creating a Rails app set up as an API is not much different.

18. PostgreSQL vs. MongoDB: Evaluating Database Structure, Speed, and More

Choosing a database can be scary as it’s nearly impossible to change once you’ve built on one. So which will you choose? PostgreSQL or MongoDB?

19. Your Guide To Schema-based, Multi-Tenant Systems and PostgreSQL Implementation

There are several architectures that could be followed to achieve multi-tenancy at the database layer.

20. Check Out These 8 Free SQL Courses to Learn About Oracle, MySQL, and SQL Server

SQL is very important and many programmers realize this, however, I have found that many more programmers just don't spend much time improving their SQL skills.

21. PostgreSQL Change Data Capture and Golang Sample Code

PostgreSQL offers Logical Decoding Method to make log-based change data capture possible. Setup and run CDC in several steps.

[22. Towards Open Options Chains:

A Data Pipeline Solution - Part I](https://hackernoon.com/towards-open-options-chains-a-data-pipeline-solution-for-options-data-part-i) In "Towards Open Options Chains", Chris Chow presents his solution for collecting options data: a data pipeline with Airflow, PostgreSQL, and Docker.

23. When You Shouldn't Use Async in Python

What comes to a Python developer’s mind when he needs to write an I/O bound application? Of course async. Why? Usually, because it’s a trend. And I’ve seen this

24. Database Connection Pooling With pgbouncer

Introduction: The Postgres Connection Pool Problem

25. Towards Open Options Chains - Part III: Get Started with Airflow

In "Towards Open Options Chains", Chris Chow presents his solution for collecting options data: a data pipeline with Airflow, PostgreSQL, and Docker.

26. How Java Apps Litter Beyond the Heap

A look at the garbage Java apps generate, demonstrated with some help from Postgres and SSDs.

27. 6 Reasons You Should Transition to PostgreSQL from Oracle

As opposed to proprietary solutions (like Oracle), you won’t get locked in with ever-escalating license fees. Here are 6 reasons you should move to PostgreSQL.

28. Hacking PostgreSQL Internals to Deliver Push Notifications

This post dives into the internals of Postgres replication, WAL, and logical decoding. We will also write our own plugin to send push notifications.

29. UUIDs Outshine Auto-Increment IDs and It’s Not Close

People are still using autoincrementing integer ids in postgres in 2023 and they shouldn't be! UUIDs are leaps and bounds better.

30. Part One: An open-source python REST API (Tribal) using Django framework

The story is the compilation of the several articles I shall use to illustrate how to build a complete Django open-source API about tribes of the world.

31. How To Run PostgreSQL as a Build Requirement in TeamCity Build

We use different Continuous Integration tools in our projects. One of them is TeamCity software. A pipeline for TeamCity can be configured easily and has two steps, such as run tests and build a docker image for further deployment. However, I needed to run Postgres before running tests. I made a research, I read the documentation and this article may be useful to close a gap for team city’s documentation.

32. How to Query Deeply Nested JSON Data in PSQL

Recently I had to write a script, which should’ve changed some JSON data structure in a PSQL database. Here are some tricks I learned along the way.

33. How to Use Materialize and Redpanda to Analyze Raspberry Pi Temperature Data

This is a self-contained demo using Materialize to process data IoT devices data directly from a PostgreSQL server.

34. A How-to Guide for Writing REST Applications

REST (Representational State Transfer) methodology is basically a way to build web services. 'll talk about how to build a REST application and an API for it.

35. An In-depth Look Into MySQL Vs. PostgreSQL

PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for years.

36. Creating a Poor Man's API Using PostgREST

Creating a full-fledged API requires resources, both time and money.

37. Here's How I Got Started With Kubernetes: Part I

While scheduling classes for my final semester of college, I was very eager to do something different. Like many of my computer science peers, I had grown tired of the typical class where we have to reinvent the wheel when learning new concepts.

38. PostgreSQL Index Types: Beyond the B-tree

bad indexing is the main source of bad performance of your database

39. How to Connect Your Bastion Server to a PostgreSQL Server with an SSH Tunnel

In this article, you'll learn how to connect to an RDS server through a bastion server in Bash using an SSH tunnel.

40. How to Migrate Data from an MSSQL Server to PostGreSQL?

Thinking of shifting to a new database management engine? Here's how to migrate data from SQL server to PostgreSQL.

41. Fastest Way to Create and Share Code in Any Language

Share code using these lightning fast sandboxes available in almost all popular languages

42. Migrating Away From Query Builders and ORMs in JavaScript or TypeScript

I spent the better part of a day moving a project completely off of the ORM we were using (TypeORM). Ever since I started doing web development, I’ve been using some kind of heavy abstraction on top of my database. Whether it’s Mongoose when I used MongoDB, or TypeORM when I decided to move to TypeScript and PostgreSQL. However, it turns out that ORMs and query builders aren’t so great. I used to be that person that thought ORMs and query builders did the job for me, and I used it as an excuse to not learn SQL (which is what everyone tells you NOT to do). Given the tools that exist today, I would wholeheartedly recommend doing it the opposite of how I did if you’re starting off new to these things — write your SQL stuff by hand, or with help from the tools I mention later in the post. It’ll feel really slow at first, but you’ll thank yourself later 😄

43. Finessing Postgres into an Insane 200x Faster Query Plan

This article will show you a real-life optimization story and how PostgreSQL row count estimation can go very wrong when trying to get a faster query plan

44. Hunting for Customers With PostgreSQL

Now more than ever, you have to hold onto every customer you can. Customers don’t love your product one minute, then fall out of love with it the next. Normally there’s a declining trend in usage of your product over time.

45. Time For Me To Fly… To Render

Heroku has eliminated their free plans, so I’m migrating to Render for my prototype products and services. Let’s see how easy it is to convert to Render PaaS.

46. 2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many others to see which database management systems are most favored this year.

47. Gamify Personal Fitness Using A PostgreSQL Database

Create your own PostgreSQL database to gamify your exercise. Keep track of the progress of your running, and perform data analysis with yourself as the dataset.

48. Towards Open Options Chains Part II: Foundational ETL Code

In "Towards Open Options Chains", Chris Chow presents his solution for collecting options data: a data pipeline with Airflow, PostgreSQL, and Docker.

49. IKODIX Helps to Create Admin Panel Fullstack Apps for Your Databases

IKODIX is an online code generator for admin panel full-stack applications for any relational database.

50. Towards Open Options Chains Part V: Containerizing the Pipeline

In "Towards Open Options Chains", Chris Chow presents his solution for collecting options data: a data pipeline with Airflow, PostgreSQL, and Docker.

51. Taking a Closer Look into Google's AlloyDB Architecture for PostgreSQL

An exploration of AlloyDB's architecture and design, focussing on its storage engine, with descriptions of how it handles reads and writes

52. How PostgreSQL Aggregation Inspired Timescale Hyperfunctions’ Design

Get a primer on PostgreSQL aggregation, how PostgreSQL´s implementation inspired us as we built TimescaleDB hyperfunctions and what it means for developers.

53. PostgreSQL Transaction Isolation Levels with Go Examples

Illustration composed from MariaLetta/free-gophers-pack, original gopher by Renee French.

54. How To Create Golang REST API: Project Layout Configuration [Part 2]

In a previous post I was explaining the basics of setting up GO application for REST API. Now I'll go into details by first creating configurable server, adding http router (mux) and some DB interaction. Let's get (the indoors party) started!

55. Digging into Postgres's Lesser Known Features

Postgres Handles More than You Think

56. Log Slow Postgres Query Plans Automatically: An Introduction to auto-explain

Automatically log slow query plans with auto_explain and learn how to fix the problematic PostgreSQL queries that are slowing you down.

57. How To Create Golang REST API: Project Layout Configuration [Part 1]

During past couple of years I have worked on few projects written in GO. I noticed that the biggest challenge developers are facing is lack of constraints or standards when it comes to project layout. I'd like to share some findings and patterns that have worked best for me and my team. For better understanding I'll go through steps of creating a simple REST API.

58. Deploying a Java Spring Boot app on AKS with Azure Database for PostgreSQL

In this post, learn how to run a Java Spring Boot application on Azure Kubernetes Service (AKS) and connects to Azure PostgreSQL using Azure AD Pod identity.

59. How To Create and Load Test Data in PostgreSQL

Learn what tools and approaches are available to create and load test data for webapps without an ORM.

60. Types Of Medical Databases And Their Benefits For Humanity

What are medical databases?Medical Databases serve as an essential part in medical care, which includes the disciplines of research, documentation, patient care and treatment. The medical industry is constantly on the lookout for new medical applications, which would help improve their services. These endeavors are usually done through databases, which store data regarding diseases, diagnosis, treatments, medication, medical devices, medical practices and other pertinent details about medical professionals. With the constant advancements made in technology, these databases have also grown to be more technologically advanced and complex.

61. How To Scale Django/Postgres With PgBouncer on Heroku

Do you have an app on Heroku using Postgres? Are you running out of database connections?

62. Setting up Continuous PostgreSQL Backups

This manual describes the process of setting up continuous backups for PostgreSQL databases to safeguard your data from accidental loss in an efficient way.

63. Lessons Learned Building A Golden Kitty Award-Winning Product

Here's the whole story of how I built One Word Domains from scratch, grew it to 50,000 users, and end up winning the coveted Golden Kitty Award.

64. Building Your First GraphQL Server

65. Top 12 FAQs About PostgreSQL

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for all major platforms including Linux, UNIX, Windows, and OS X. It allows you to add custom functions developed using different programming languages such as C/C++, Java, etc. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server.

Thank you for checking out the 65 most read stories about Postgresql on HackerNoon.

Visit the /Learn Repo to find the most read stories about any technology.