Best of PostgreSQLJanuary 2023

  1. 1
    Article
    Avatar of communityCommunity Picks·3y

    Modern API design with Golang, PostgreSQL and Docker

    Go is a powerful language that's highly performant and has concurrency built in the language itself making it perfect for micro services. This article is aimed at anyone who wants to build a CRUD micro service or a simple RESTful API using Go (or Golang for SEO purposes) You can find all the code in my repository.

  2. 2
    Article
    Avatar of eversqlEverSQL·3y

    The most popular database of 2022 will surprise you! And insight #7 impacts your salary

    StackOverflow's developers survey results are already in, and the most popular databases for 2022 have been revealed. The most popular database is now PostgreSQL for the first time ever. The survey had 48,788 votes and it is important to highlight that the popularity of different databases can vary depending on a number of factors.

  3. 3
    Article
    Avatar of communityCommunity Picks·3y

    How To Design And Build A Database In Postgres

    The data the client wants to be stored in the database is data related to items on sale, orders made, and customers who make the orders. In this article, I will show you how to design and build a relational database from scratch in Postgres for John’s ecommerce business.

  4. 4
    Article
    Avatar of thisdotThis Dot·3y

    Introducing the express-typeorm-postgres Starter Kit

    The starter kit provides you with infrastructure for development, and integrations with these infrastructures. It comes with a working Redis instance for caching and a second Redis for queues. It also starts up a Postgres instance for you, which you can seed with TypeORM. The infrastructure runs on docker using docker-compose.

  5. 5
    Article
    Avatar of tigerdataTigerData (Creators of TimescaleDB)·3y

    Best Practices for Time-Series Modeling

    Time-series applications are designed to store massive amounts of time-related information. Data modeling the underlying data storage when you have one or more Timescale hypertables is essential. Since Timescale is built upon a relational database model, there are a few ways you can design our hypertables.

  6. 6
    Article
    Avatar of communityCommunity Picks·3y

    How this low-hanging fruit improved our DB throughput by over x200 and prevented outages in production

    This low-hanging fruit improved our DB throughput by over 200x and prevented outages in production Jan 7. Lior: Improving database performance is a valuable goal in and of itself, but it’s ultimately just a means to an even greater end. When done correctly, this can provide a significant performance boost.