PostgreSQL Alternatives

PostgreSQL reviews and mentions

• Building RESTful API with Hexagonal Architecture in Go
  21 projects | dev.to | 27 Sep 2023

  For building the RESTful Point of Sale service API, I've considered and selected a combination of technologies that would work seamlessly together. For handling HTTP requests and responses, using the Gin HTTP web framework would make sense because I think it seems complete and popular among Go community too. To ensure data integrity and persistence, I'm using PostgreSQL database with pgx as the database driver, the reason I choose PostgreSQL because it is the most popular relational database to use in production and offers efficient Go integration. I'm also implementing caching using Redis with go-redis client library, which provides powerful in-memory data storage capabilities.

• Hacktoberfest 2023 with Ghostfolio
  9 projects | dev.to | 26 Sep 2023

  Ghostfolio is written in TypeScript and organized as an Nx workspace, utilizing the latest framework releases. The backend is based on NestJS in combination with PostgreSQL as a database together with Prisma and Redis for caching. The frontend is built with Angular.

• How to use PostgreSQL to store and query vector embeddings
  2 projects | dev.to | 26 Sep 2023

  Basic knowledge of Python and SQL (specifically PostgreSQL's SQL).

• PostgreSQL 16 Released
  2 projects | news.ycombinator.com | 14 Sep 2023

  Two relevant patches at least:

  1. https://github.com/postgres/postgres/commit/3838fa269c15706d...

  2. https://github.com/postgres/postgres/commit/121d2d3d70ecdb21...

• Swirl: An open-source search engine with LLMs and ChatGPT to provide all the answers you need 🌌
  5 projects | dev.to | 6 Sep 2023

  Using the Galaxy UI, knowledge workers can systematically review the best results from all configured services including Apache Solr, ChatGPT, Elastic, OpenSearch, PostgreSQL, Google BigQuery, plus generic HTTP/GET/POST with configurations for premium services like Google's Programmable Search Engine, Miro and Northern Light Research.

• The best platform to build serverless apps on in 2023
  3 projects | dev.to | 26 Aug 2023

  Every Supabase project comes with a full Postgres database, an authentication service already configured for you, a cloud storage API, access to Edge functions, and a vector Database for AI. We can see that the offering from Supabase is compact and similar to what Firebase offers you so in today's article I will show you how to set up and integrate the Supabase authentication into your serverless app. Then we'll look at some of the benefits that come with using this approach and finally, we'll see if this is an approach you should consider.

• Show HN: Postgres Language Server
  21 projects | news.ycombinator.com | 6 Aug 2023

  Generally I agree that this would be great to have, and Postgres does have a set of libraries it already maintains as part of the main source tree (i.e. libpq, etc), and there is a shared set of code between the backend and the "frontend" (https://github.com/postgres/postgres/tree/master/src/common). So theoretically you could imagine the parser moving into that shared code portion, sharing code but not necessarily requiring linking to a library from the backend.

  However, the challenge from what I've understood from past conversations with some folks working on Postgres core is that the parser is currently heavily tied into the backend - note the parser isn't just the scan.l/gram.y file, but also the raw parse node structs that it outputs. You can see how many files we pull in from the main tree that are prefixed with "src_backend": https://github.com/pganalyze/libpg_query/tree/15-latest/src/...

  Further, there isn't a canonical way to output node trees into a text format today in core, besides the rather hard to work with output of debug_print_parse - there have been discussions on -hackers to potentially utilize JSON here, which may make this a bit easier. Note that in libpg_query we currently use Protobuf (but used to use JSON), which does have the benefit of getting auto-generated structs in the language bindings - but Protobuf is not used in core Postgres at all today.

  All in all, I think there is some upstream interest, but its not clear that this is a good idea from a maintainability perspective.

• Building realtime experiences with Amazon Aurora
  3 projects | dev.to | 1 Aug 2023

  Aurora is a managed database service from Amazon compatible with MySQL and PostgreSQL. It allows for the use of existing MySQL code, tools, and applications and can offer increased performance for certain workloads compared to MySQL and PostgreSQL.

• FRONTEND AND BACKEND UNDERSTANDING THE DIFFERENCES
  7 projects | dev.to | 30 Jul 2023

  Databases Backend developers use databases like MySQL, PostgreSQL, MongoDB (NoSQL), or Redis (an in-memory database) to store and manage data. It is important for persistent data storage and retrieval in web applications.

• Query materialized views with Java, Spring, and streaming database
  3 projects | dev.to | 23 Jul 2023

  As RisingWave is wire-compatible with PostgreSQL, you can use the PostgreSQL JDBC driver to connect to RisingWave and interact with RisingWave from your Java applications. You can also use other clients’ libraries for different programming languages (NodeJS, Python, and Go).

• A note from our sponsor - Mergify
  blog.mergify.com | 28 Sep 2023

  Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free. Learn more →