PostgreSQL

PgSQL: View Rows Per Table

Posted on

Two Methods: First: SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC;   Second: SELECT nspname AS schemaname,relname,reltuples FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN (‘pg_catalog’, ‘information_schema’) AND relkind=’r’ ORDER BY reltuples DESC;

MySQL

MySQL: Script to Create a Calendar

Posted on

Copied and tweaked from Github https://gist.github.com/bryhal/4129042 DROP TABLE IF EXISTS time_dimension; CREATE TABLE time_dimension ( id INTEGER PRIMARY KEY, — year*10000+month*100+day db_date DATE NOT NULL, year INTEGER NOT NULL, month INTEGER NOT NULL, — 1 to 12 day INTEGER NOT NULL, — 1 to 31 quarter INTEGER NOT NULL, — 1 to 4 week INTEGER […]

Life

Ranking Comediantes Venezuela

Posted on

FROM 90’s till Today: Emilio Lovera Conde del Guacharo Laureano Marquez RECENT Luis Chataing YOUNG Gabo Ruiz Ricardo del Bulfalo Vero Gomez Jose Rafael Guzman Led Varela Nanutria Jean-Mary Alex Goncalves WEBSHOWS/Podcasts De a Toque El Mundo y el País Nos Reiremos de Esto Best Short Stand-Up Led Varela: Perdido en el Ávila