Category Archives: relational databases
mysql tricks: do instant table swap to mitigate mysql deadlock error.
mysql tricks: do instant table swap to mitigate mysql deadlock error. Continue reading
Posted in etl, relational databases, Uncategorized
Tagged database, dba, etl, sql, tips
Leave a comment
Amazon Redshift is an amazing database product
Redshift is : Fast like Ferrari Cheap like a Ford Fiesta Useful like a Minivan Self Driving Auto-magics like Tesla with Autopilot Key features: Really fancy features under-the-hood: -interleaved sort keys -columnar distributed storage -smart parallel execution -IO optimization (return … Continue reading
Posted in big data, Business Intelligence, Cloud, data analysis, relational databases
Tagged BI, BI tools, big data, database, postgresql, relations databases
Leave a comment
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 database, mysql, postgresql, sql, tips
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 database, mysql, postgresql, relations databases, research, trends
Leave a comment
Data Ninjaeering 