Skip to content

Instantly share code, notes, and snippets.

View vbilopav's full-sized avatar
🏠
Working from home

Vedran Bilopavlović vbilopav

🏠
Working from home
View GitHub Profile
/*
Task: get a set of movies where Zendaya played a role,
and for every such movie calculate the average review score,
and also retrieve the list of top 5 actors in the order of credits.
Here’s how such query can be written in EdgeQL:
select
Movie {
title,
@vbilopav
vbilopav / md_table_to_table_table.sql
Last active July 17, 2023 12:37
Script to create a postgresql table from markdown table (pasted as variable)
do
$$
declare
_table_name text = 'md_temp';
_md text = '
| Command | Description |
| --- | --- |
| `git status` | List all *new or modified* files |
| `git diff` | Show file differences that **havent been** staged |
';

Dictionary for database example

  • Server: PostgreSQL 216.158.72.53:5432, version 13.7 (Debian 13.7-0+deb11u1)
  • Local time stamp: 2022-07-20T12:41:43.0051958+02:00
  • Schema: public

Table of Contents