Best of PostgreSQL — August 2022

  1. 1
    Article
    Avatar of devtoDEV·4y

    Free Alternatives to Heroku

    Heroku has brought an end to free dynos and Postgres databases. Other free platforms can be used to host Django (Python) powered web applications for free. Fly and Render seems to offer Postgres on a free plan. Railway doesn't have a free tier, but basic usage is quite cheap.

  2. 2
    Article
    Avatar of communityCommunity Picks·4y

    DDD, Hexagonal, Onion, Clean, CQRS, … How I put it all together

    Ports & Adapters architecture identifies three fundamental blocks of code in a system. In most languages and in its most simple form, the Port will be an Interface, but it might actually be composed of several Interfaces and DTOs.

  3. 3
    Article
    Avatar of supabaseSupabase·4y

    Supabase Vault

    Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.

  4. 4
    Article
    Avatar of logrocketLogRocket·4y

    Build a full stack app with Next.js and Supabase

    Next.js is an open source Firebase alternative with a lot of powerful tools, including seamless authentication. Next.js and Supabase are one of the easiest and most popular ways to build production-ready React applications. Use React's useEffect to optimize your application's performance Switch between multiple versions of Node.

  5. 5
    Article
    Avatar of communityCommunity Picks·4y

    Build a full stack app with create-t3-app

    Getting Started Let's set up a starter project with create-t3-app. We're going to build a Guestbook inspired by Lee Robinson's Guestbook.

  6. 6
    Article
    Avatar of geekflareGeekflare·4y

    PostgreSQL vs MySQL: Differences and Similarities

    The database system uses multi-version concurrency control (MVCC), MVCC makes a database suitable for concurrent data entry and data queries done by writers. Both the database systems offer account management features like roles, groups, and individual users. Users can simply download the distribution package under the MIT license. Oracle controls the development and maintenance of the DBMS. It is free and available as a server version on GitHub.

  7. 7
    Article
    Avatar of infosecwriteupsInfoSec Write-ups·4y

    Cybersecurity Learning Path

    Learn Programming Programming is a core part if you want to make a career in cybersecurity. Coding knowledge can give you the insight you need to recognize what a piece of software is doing, and even if it's malicious code or not.

  8. 8
    Article
    Avatar of hnHacker News·4y

    Learn Postgres at the Playground

    Postgres playground is a new place for devs to polish their Postgres skills. With canned datasets you can load Guided tutorials to follow along to learn about the power of Postgres Postgres in a browser.

  9. 9
    Article
    Avatar of devtoDEV·4y

    Thinking like containers

    Virtualization is a solution to the problem of isolating and having a completely different environment sharing the same "machine" Virtualization has a cost: it does not share the same OS kernel. For doing so, we should use a flag option in the run command: $ docker run -it ruby:2.7.

See all PostgreSQL archives