apollographql.com
Designing Your First GraphQL Schema
5 min · · Building schemas are a key part of building a graph. Schemas are one of the major benefits of using GraphQL. The schema defines how clients can retrieve and data from your GraphQL API. With schemas,… · Shared by 5, including Evan (he/him)
blog.crunchydata.com
Generating JSON Directly from Postgres
3 min · · PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers. · Shared by 13, including Evan (he/him)
AppSignal
Building Aggregates in Elixir and PostgreSQL
12+ min · · In this article, we will describe the roles and implementation of aggregates in Elixir and PostgreSQL. · Shared by 9, including Evan (he/him)
prisma.io
Introduction to database schemas
12+ min · · Schemas are the way that you configure your database to represent your data within the system. This guide will cover what schemas are, why they're important, and what to think about when designing… · Shared by 6, including Evan (he/him)
github.com
0xnr/awesome-bigdata
· A curated list of awesome big data frameworks, ressources and other awesomeness. - 0xnr/awesome-bigdata · Shared by 6, including Evan (he/him)
pgexercises.com
PostgreSQL Exercises
1 min · · Welcome to PostgreSQL Exercises! This site was born when I noticed that there's a load of material out there to help people learn about SQL, but not a great deal to make it easy to learn by doing.… · Shared by 48, including Brian, shishir das, Evan (he/him)
tatiyants.com
Postgres Query Plan Visualization
7 min · · Postgres Explain Visualizer (Pev) is a tool I wrote to make EXPLAIN output easier to grok. It creates a graphical representation of the query plan. · Shared by 127, including Florian Hanke 🍎, johan pretorius, Claudio Perez Gamayo, Pascal Birchler, Brian, Vikram Dutt, Vojtěch Hýža, Kenneth Kalmer, Evan (he/him), Mark Needham, yawniek 📯
learnsql.com
SQL Window Functions vs. GROUP BY: What’s the Difference?
5 min · · Window functions and GROUP BY may seem similar at first, but they’re quite different. Learn how window functions differ from GROUP BY and aggregate functions. · Shared by 4, including Evan (he/him)
learnsql.com
What Is the Difference Between a GROUP BY and a PARTITION BY?
7 min · · What is the difference between a GROUP BY and a PARTITION BY in SQL queries? When should you use which? You can find the answers in today's article. · Shared by 4, including Evan (he/him)
learnsql.com
SQL Window Functions Cheat Sheet
4 min · · This 2-page SQL Window Functions Cheat Sheet covers the syntax of window functions and a list of window functions. Download it in PDF or PNG format. · Shared by 24, including Dr. Ganapathi Pulipaka 🇺🇸, Evan (he/him)
Towards Data Science
SQL Window Functions: The Intuitive Guide
12+ min · · Intuitively learn different components of window functions using Postgres and implement into your data workflow · Shared by 7, including Evan (he/him)
educba.com
PostgreSQL Window Functions | Guide to Window Function in PostgreSQL
4 min · · Guide to PostgreSQL Window Functions. Here we discuss an introduction to PostgreSQL Window Functions with respective examples for better understanding. · Shared by 4, including Evan (he/him)
2ndquadrant.com
Business Intelligence with Window Functions in PostgreSQL [Webinar]
1 min · · As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Business Intelligence with Window Functions in PostgreSQL, which gave an overview of Window Functions, how to use them… · Shared by 5, including Evan (he/him)
arunkrsoam.medium.com
Window functions with PostgreSQL
6 min · · Understand the significance of window functions with PostgresSQL. · Shared by 4, including Evan (he/him)
thoughtbot
Postgres Window Functions
6 min · · Take your queries to the next level with window functions. · Shared by 4, including Evan (he/him)