damilola dolor 0xdod

## postgresql_is_enough.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                0xdod
                / postgresql_is_enough.md
            
            
              Created
              December 17, 2024 21:44
                — forked from cpursley/postgresql_is_enough.md
            
              
                Postgres is Enough 
              
          
    PostgreSQL is Enough


Simplify: move code into database functions
Just Use Postgres for Everything
Just use Postgres
PostgreSQL is the worlds’ best database
Postgres is eating the database world
Hacker News discussion

Background and Cron Jobs


## creating_a_date_dimension_table_in_postgresql.sql
DROP TABLE if exists d_date;

CREATE TABLE d_date
(
  date_dim_id              INT NOT NULL,
  date_actual              DATE NOT NULL,
  epoch                    BIGINT NOT NULL,
  day_suffix               VARCHAR(4) NOT NULL,
  day_name                 VARCHAR(9) NOT NULL,
  day_of_week              INT NOT NULL,
	DROP TABLE if exists d_date;

	CREATE TABLE d_date
	(
	date_dim_id INT NOT NULL,
	date_actual DATE NOT NULL,
	epoch BIGINT NOT NULL,
	day_suffix VARCHAR(4) NOT NULL,
	day_name VARCHAR(9) NOT NULL,
	day_of_week INT NOT NULL,