Category: Databases and SQL

  • Infer Schema when Importing to PostgreSQL or MySQL

    —

    by

    Scott King
    in

    Postgres and MySQL are great Open Source databases in use by organizations of all sizes. Both of them are flexible and somewhat scalable. Both of them have nice GUI front-ends available to make them even easier to use. Sequel Pro for MySQL is a handy GUI frontend that runs on Macs, and one of the…

  • Using SQL Commands in Spark with SparkSQL

    Using SQL Commands in Spark with SparkSQL

    —

    by

    Scott King
    in

    Spark has become a standard for performing analysis on huge amounts of data due to its distributed nature. SparkSQL evolved as a necessary component of Spark due to the need for working with structured data.There are many times when there is a need to query data in Spark with SQL commands. Doing so isn’t complicated…

  • Installing MySQL from Scratch

    —

    by

    Scott King
    in

    You’ll probably see a lot of CSV files in the workplace, or generate them from the vast ocean of spreadsheets that are floating around the average office. But that won’t always be the case, and sometimes you’re going to need to tap directly into an existing database or build your own. So how do you…