Category: SQL
-
How we built Data Science Web App “Route Planner X” on AWS infrastructure
In this blog post, I will tell you about what our team of 5 graduates used to built an end-to-end data science web application to handle 150 million rows of data.
-
[Guide] Building Data Science Web Application with React, NodeJS, and MySQL
-
How to import data from MySQL database into Pandas Data Frame
It is easy to load CSV data into Python’s Pandas Data Frame. I always think this is also the case for loading MySQL into Data Frame. However, it turns out to be quite troublesome.
-
[MySQL] Reset & Import Database in MySQL using Command Line
Sometimes client’s server doesn’t has PHPMyAdmin installed (and it is 11MB, too big in my opinion), and I have to import database to deploy website from localhost to production server. Thus, I need to find a way to import SQL file directly in command line.