Skip to content

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

2.3 KB
Raw Blame
export default [
  {
    lang: 'sql',
    title: 'Geographical',
    code: `SELECT superhero.name
FROM city, superhero
WHERE ST_Contains(city.geom, superhero.geom)
AND city.name = 'Gotham';
  `,
    detail_title: 'Spatial and Geographic objects for PostgreSQL',
    detail_text:
      'PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.',
    badges_label: 'Extensions used:',
    badges: ['PostGIS'],
    url: '',
  },
  {
    lang: 'sql',
    title: 'Cryptographic',
    code: `-- This can be run in the SQL editor
psql
CREATE EXTENSION pgcrypto;
SELECT crypt('mypass', gen_salt('bf', 4));
crypt
--------------------------------------------------------------
$2a$04$1bfMQDOR6aLyD4q3KVb8/ujG7ZAkyie4d/s3ABwuZNbzkFFgXtC76

-- We can now execute the statement below to store the string safely in the database:
INSERT INTO users (user_id,enc_pass) VALUES (1,'$2a$04$1bfMQDOR6aLyD4q3KVb8/ujG7ZAkyie4d/s3ABwuZNbzkFFgXtC76');`,
    detail_title: 'Cryptographic functions for PostgreSQL.',
    detail_text:
      'The pgcrypto module is a cryptographic extension that provides a number of hashing and cryptographic functions.',
    badges_label: 'Extensions used:',
    badges: ['pgcrypto'],
    url: '',
  },
  {
    lang: 'sql',
    title: 'Monitoring',
    code: `SELECT order_details.qty,
    order_details.item_id,
    order_details.item_price
FROM order_details,
  customers
WHERE customers.id = order_details.customer_id
AND customers.email = '[email protected]'

-- You can now view pg_stat_statements

SELECT * 
FROM pg_stat_statements;

userid              | 16384
dbid                | 16388
query               | select * from users where email = ?;
calls               | 2
total_time          | 0.000268
rows                | 2
shared_blks_hit     | 16
shared_blks_read    | 0
shared_blks_dirtied | 0
shared_blks_written | 0
local_blks_hit      | 0
local_blks_read     | 0
local_blks_dirtied  | 0
local_blks_written  | 0
...
`,
    detail_title: 'Tracking execution statistics of all SQL statements',
    detail_text:
      'The pg_stat_statements module provides a means for tracking execution statistics of all SQL statements executed by a server.',
    badges_label: 'Extensions used:',
    badges: ['pg_stat_statements'],
    url: '',
  },
]