Best of PostgreSQLJune 2023

  1. 1
    Article
    Avatar of awsplainenglishAWS in Plain English·3y

    All your servers accessible directly and securely from your Browser

    All your servers are accessible directly and securely from your Browser. Border0 client portal is a beautiful and efficient web interface that allows your users to quickly and easily discover all servers they have access to. The dashboard features app cards for each service, with easily distinguishable icons and details.

  2. 2
    Article
    Avatar of unzipUnzip·3y

    Vector Databases 🧫 Explained

    vector databases use algorithms like ANN(Approximate Nearest Neighbors) so they can facilitate efficient storage, retrieval, and similarity search operations. These databases excel at handling structured data with a fixed schema. But they often struggle with unstructured or high-dimensional data, such as images, audio, and text.

  3. 3
    Article
    Avatar of asayerasayer·3y

    Creating a Node API with Knex and PostgreSQL

    Knex.js is a JavaScript query builder for relational databases that can be used with Node.js. Using Knex, you can easily create complex queries to select, insert, update, and delete data from a database. In this article, you will explore how to build applications that leverage PostgreSQL without writing raw SQL queries.

  4. 4
    Article
    Avatar of medium_jsMedium·3y

    Data Engineer Project: Postgres (Database) to S3 (DataLake) to Postgres (Data Warehouse) | Prep Coffee Inventory Management

    This post discusses a data engineer project that involves transforming data from a PostgreSQL database to an S3 datalake and then to a PostgreSQL data warehouse. The author shares their experience and methodology, as well as the tools used. They also highlight the problems they faced during the project.