Top 5 FinTech Pitch Decks That Pulled Millions

Investing should be more like watching paint dry or watching grass grow. If you want excitement, take $800 and go to Las Vegas. — Paul Samuelson. Hey guys, recently I’ve been dabbling on a pitch deck creation. To create a better pitch deck that will captivate investors and clients alike. Upon reading multiple pitch decks that have been submitted to YCombinator 1 , I’ve concluded that there is a certain pitch deck structure and characteristics needed. For me, I think a pitch deck must contain only the core of what you’re trying to do or achieve. I mean, just keep it short and simple which even a 5 year old could understand. Don’t put any jargon and highlight the important parts like graphs and figures. Anyways, let’s dive on some pitch decks used and created by well known companies in this day and age. Coinbase If you’ve been in the crypto space for a while, I know for sure you’ve heard the name Coinbase. Its one of the top cryptocurrency exchange that is base

Output File from PSQL Command

She had an immense curiosity about life, and was constantly staring and wondering.
— Henry James in The Portrait of a Lady.

Hi guys, if one day your on a vacation on a remote island and can’t access your workstation. And the only access you can get due to slow internet speed is SSH (Secure Shell). You tried to access the remote production database using a rented computer and an SSH client, the tools inside the server is only compose of a psql command.

Don’t panic and don’t worry we got you covered, thepsql saves your day if you’ll just gonna be exporting SQL schema layouts.

First and foremost, we fire up and execute the psql command. Inside the psql environment execute the commands below:

\o dump.txt
SELECT 'postgresql' AS dbms,t.table_catalog,t.table_schema,t.table_name,c.column_name,c.ordinal_position,c.data_type,c.character_maximum_length,n.constraint_type,k2.table_schema,k2.table_name,k2.column_name
  FROM information_schema.tables t
  NATURAL LEFT JOIN information_schema.columns c 
  LEFT JOIN(information_schema.key_column_usage k 
    NATURAL JOIN information_schema.table_constraints n
    NATURAL LEFT JOIN information_schema.referential_constraints r) 
  ON c.table_catalog=k.table_catalog AND c.table_schema=k.table_schema AND c.table_name=k.table_name AND c.column_name=k.column_name
  LEFT JOIN information_schema.key_column_usage k2 
  ON k.position_in_unique_constraint=k2.ordinal_position AND r.unique_constraint_catalog=k2.constraint_catalog AND r.unique_constraint_schema=k2.constraint_schema AND r.unique_constraint_name=k2.constraint_name 
  WHERE t.TABLE_TYPE='BASE TABLE' AND t.table_schema NOT IN('information_schema','pg_catalog');

This command will create a dump file containing all the table structure containing each constraint available, this is usually needed when you need to analyze ER (Entity Relation) diagram. You could example paste the output of this command on Lucid Chart to analyze entity relationship.

A break down of this is, the SELECT command will query all table structure and schema.

Switches Legend:
\o => outputs to file
\O => turns off the output to file feature

The output file will be generated on the same directory where you run the psql command.

So guys, when on vacation what are the things you can do on a slow internet and a rented computer? Hope you enjoyed this article!


Popular posts from this blog

Top Three DNS Providers That Provides Good Service in SEA (Southeast Asia)

Sending Email Using MailKit in ASP.NET Core Web API

Disable mDNS and SSDP Discovery in Google Chrome