Shahidh K Muhammed shahidhk

Engineer at @hasura

Recently created

Least recently created

Recently updated

Least recently updated

shahidhk / realtime-poll-online-users-view.sql

Created August 28, 2018 11:41

	CREATE VIEW online_users AS
	SELECT count(*) AS count
	FROM "user"
	WHERE ("user".last_seen_at > (now() - '00:00:15'::interval));

shahidhk / realtime-poll-user-online-trigger.sql

Created August 28, 2018 11:39

	CREATE FUNCTION update_last_seen_timestamp_func() RETURNS trigger
	LANGUAGE plpgsql
	AS $$
	BEGIN
	NEW.last_seen_at := now();
	RETURN NEW;
	END;
	$$;

	CREATE TRIGGER update_last_seen_timestamp_trigger

shahidhk / realtime-poll-results-view.sql

Created August 28, 2018 11:16

	CREATE VIEW poll_results AS
	SELECT poll.id AS poll_id,
	o.option_id,
	count(*) AS votes
	FROM (( SELECT vote.option_id,
	option.poll_id,
	option.text
	FROM (vote
	LEFT JOIN public.option ON ((option.id = vote.option_id)))) o
	LEFT JOIN poll ON ((poll.id = o.poll_id)))

shahidhk / realtime-poll-tables.sql

Created August 28, 2018 10:52

Schema for a realtime poll application

	CREATE TABLE "user" (
	id uuid DEFAULT gen_random_uuid() NOT NULL,
	created_at timestamp with time zone DEFAULT now() NOT NULL,
	online_ping boolean,
	last_seen_at timestamp with time zone
	);

	CREATE TABLE poll (
	id uuid DEFAULT gen_random_uuid() NOT NULL,
	created_at timestamp with time zone DEFAULT now() NOT NULL,

shahidhk / fk_rel_book_author_schema.sql

Created August 14, 2018 09:28

	CREATE TABLE book (
	id SERIAL NOT NULL,
	title TEXT NOT NULL,
	author TEXT NOT NULL,
	genre TEXT,
	PRIMARY KEY (id)
	);

	CREATE TABLE author (
	name TEXT NOT NULL,

shahidhk / fk_rel_address_table_schema.sql

Created August 13, 2018 12:48

	CREATE TABLE address (
	id SERIAL NOT NULL,
	user_id INTEGER NOT NULL REFERENCES "user" (id),
	street TEXT,
	city TEXT,
	country TEXT,
	PRIMARY KEY (id)
	);

shahidhk / fk_rel_user_address_schema.sql

Last active August 14, 2018 11:29

	CREATE TABLE "user" (
	"id" SERIAL NOT NULL,
	"name" TEXT NOT NULL,
	PRIMARY KEY ("id")
	);

	CREATE TABLE address (
	id SERIAL NOT NULL,
	user_id INTEGER NOT NULL REFERENCES "user" (id),
	street TEXT,

shahidhk / jsonb_laptop_listing_view.sql

Last active August 10, 2018 09:29

	CREATE VIEW laptop_listing AS
	SELECT
	name, price,
	spec->>'processor' AS processor,
	spec->>'ram' AS ram,
	spec->>'disk' AS disk,
	spec->>'display' AS display
	FROM
	product
	WHERE

shahidhk / jsonb_insert_mutation_delete_at_path.md

Created August 10, 2018 09:02

# Query
mutation {
  update_product(
    where: {
      uuid: {_eq: "09cf633b-a34c-45cc-ad59-3273e3ad65f3"}
    },
    _delete_at_path: {
      spec: ["frequency_response", "min"]
 }

shahidhk / jsonb_update_mutation_append_array.md

Created August 10, 2018 07:08

# Query
mutation updateProductSpec ($data: jsonb) {
  update_product(
    where: {
      uuid: {_eq: "09cf633b-a34c-45cc-ad59-3273e3ad65f3"}
    },
    _append: { spec: $data }
  ) {
    affected_rows

Newer Older