Skip to content

Instantly share code, notes, and snippets.

@mlvzk
mlvzk / default.nix
Last active May 25, 2021 14:23
Awestore on NixOS. Ignore the default.nix
{ luaPackages
, runCommand
, fetchFromGitHub
, lib
}: luaPackages.toLuaModule (runCommand "awestore" {
src = fetchFromGitHub {
owner = "K4rakara";
repo = "awestore";
rev = "5509786a1d5bc538dcdde027bd07b35bc29b0df1";
sha256 = "sha256-VuMmEf5bCifXKHerTyFOYW4w4fXA83HM02Oj4VmQOeo=";
@mlvzk
mlvzk / hasura.md
Last active January 15, 2021 15:34

Tables + function SQL

Function:

CREATE
OR REPLACE FUNCTION public.random_media(n integer) RETURNS SETOF media LANGUAGE sql STABLE AS $ function $
select
  *
from
  media TABLESAMPLE SYSTEM_ROWS(n) $ function $