![]() ![]() ![]() I already had some limited experience using PostgreSQL with pgx for a pet project and was pleased to discover that the rest of the team also saw PostgreSQL as an excellent choice for meeting our needs: great developer experience, performance, reliability, and scalability.įor our search infrastructure, we started using Amazon OpenSearch Service. Next, we held a brainstorming session where we assembled our backend team to analyze our situation and discuss options. My first assignments involved improving some data structures we used internally and led to a team discussion about moving from a document-based database to a more traditional relational database in the face of some challenges. Much of the content in this tutorial is based on experience I acquired working for HATCH Studio, even though I’m just shy of ten months there. PostgreSQL, also known as Postgres, is an extendible feature-rich Object-Relational Database Management System that is almost 100% SQL standards-compliant and released as open source software under a permissive license. Read also: The ecosystem of the Go programming language and Homelab: Intel NUC with the ESXi hypervisor. See also my presentation Writing a Go application with PostgreSQL using pgx during a Go meetup HATCH in Amsterdam (Tuesday, 12 April 2022). Choosing a database driver for PostgreSQL.Environment variables for configuring PostgreSQL.Use the Table of Contents to skip to a specific part of this long post.ĭon’t forget to check out the accompanying repository /henvic/pgxtutorial.Ĭheck out the api.proto file to see the gRPC API created for this tutorial. To basics: Writing an application using Go and PostgreSQLīy reading this tutorial, you’ll learn how to use PostgreSQL with the Go programming language using the pgx driver and toolkit in a very productive manner.įurthermore, with the provided source code, you’ll be able to learn how to write efficient and sound unit and integration tests, ready to be run locally or on a Continuous Integration environment, such as GitHub Actions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |