Tag Archives: mysql

basic database table creation and load from csv using mysql and postgres

Basic database table creation with MySql and PostGreSQL. The starting point to most data applications is getting the data feeds and populating the tables. here’s an example of the process I’m loading a stock_history table from yahoo finance api source. … Continue reading

Posted in data wrangling, relational databases | Tagged , , , , | Leave a comment

Why PostgreSQL is the better MySQL

Ever since MySql has been purchased by Oracle, it has been lagging in development in the open source space. MariaDB , Percona, Aurora are spin offs that try to address it.  MySql is the original M of the LAMP stack. … Continue reading

Posted in data wrangling, relational databases | Tagged , , , , , | Leave a comment