PostgreSQL Reviews and details

Social recommendations and mentions

• Convert insert mutation to upsert

  In this quick post, we’ll walk through implementing an Upsert operation in Hasura using PostgreSQL and GraphQL. - Source: dev.to / 8 months ago

• Perfect Elixir: Environment Setup

  I’m on MacOS and erlang.org, elixir-lang.org, and postgresql.org all suggest installation via Homebrew, which is a very popular package manager for MacOS. - Source: dev.to / about 1 year ago

• Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

  According to the documentation, crate sqlx is implemented in Rust, and it's database agnostic: it supports PostgreSQL, MySQL, SQLite, and MSSQL. - Source: dev.to / over 1 year ago

• Really tired. Is PostgreSQL even runnable in Windows 10? pgAdmin4 stucks at Loading whatever I try.

  Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the postgresql.org package. Source: almost 2 years ago

• Why SQL is right for Infrastructure Management

  SQL immediately stands out here because it was designed for making relational algebra, the other side of the Entity-Relationship model, accessible. There are likely more people who know SQL than any programming language (for IaC) or data format you could choose to represent your cloud infrastructure. Many non-programmers know it, as well, such as data scientists, business analysts, accountants, etc, and there is... - Source: dev.to / about 2 years ago

• Ask HN: Hunting for a Framework

  Vapor[0] based on Swift. Advantage of this is that you don't have to evaluate multiple frameworks for Swift and suffer paralysis by analysis. All the Swift community is behind one framework. The next is Actix[1] based on Rust. There are many frameworks in Rust and most of them have not reached 1.0 And which framework will survive becomes a question. Other not so well-known is Wt[2] based on C++. This actually is... - Source: Hacker News / over 2 years ago

• Migrating Your PostgreSQL Database From Heroku to CockroachDB

  This is big news: Heroku used to be one of the easiest ways for you to get a free server, PostgreSQL database, and a Redis cache, all in a single location and all for free. - Source: dev.to / over 2 years ago

• Why ORMs Aren't Always a Great Idea

  ORMs tend to just obscure what is going on. If I know SQL and PostgreSQL, I can essentially understand just about ANY project that uses them, without having to learn the specifics of one of two dozen ORMs with its own idiosyncrasies. If you are a startup that uses an ORM, then essentially the developers working on your product will always interact with the database through an ORM preventing them from developing... - Source: dev.to / almost 3 years ago

• Lateral joins in PostgreSQL and how the heck do you progress your learning?

  Pg has homepage: https://postgresql.org/ . In there, at the top, there is link named "Documentation" - https://www.postgresql.org/docs/ - From there pick the version you're using, or just go for "current" : https://www.postgresql.org/docs/current/index.html. Source: almost 3 years ago

• PostgreSQL 14: TLS Connection

  To use PostgreSQL as external database servers, it's better to use TLS/SSL connection. This post shows how to generate certificates, configure servers and verify them. - Source: dev.to / about 3 years ago

• UUID/GUID, CUID & NanoID: What's The Difference?

  So recently, I was on a live steam with @aydrian on Twitch where I demonstrated how to migrate a live serverless application (Next.js and Vercel) from PostgreSQL database onto CockroachDB serverless with zero application downtime. If you're interested in that, please do check out the video. - Source: dev.to / about 3 years ago

• Create a Reddit clone with RedwoodJS

  A Postgres database running. You can either have the Postgres server installed, or use Docker. I'll be doing the latter in this tutorial. - Source: dev.to / about 3 years ago

• Converting XML to JSON in Rust

  I generally default to using JSON for data interchange but there are still a myriad of formats of XML out there, for which I have created the xmltojson crate. I originally wrote this one night to help me get an XML dataset into JSON so that I could use PostgreSQL's JSONB column type, but I only recently published it to crates.io since it may be useful for others. - Source: dev.to / almost 4 years ago

• 🎉 The Create Go App project has grown to v2, but is still easier, better, faster & stronger

  Postgres — configured PostgreSQL container with apply migrations (by golang-migrate/migrate tool) for backend. - Source: dev.to / about 4 years ago

• Meta - can we ban trivial requests for help?

  We are not locking down our subreddit to only postgresql.org content. The PostgreSQL universe is larger than just postgresql.org. Source: about 4 years ago

• Shelly: under the hood

  Finally, on the backend, we've got a simple Scala-based application, deployed on Heroku. The database is PostgreSQL, but the application is not a straightforward CRUD as you might expect, but instead uses SQL-based, transactional event sourcing. Probably overkill, but — if we ever want to create a new view basing on the events (which include e.g. Program creation in creative mode, or solving a challenge) — for... - Source: dev.to / about 4 years ago