10,000 scraps of paper

• 

• 

• 

I got stuck for a bit today on how to configure a PHP PDO connection in a Docker based WordPress dev env. Here’s the function…

/**
 * Get the database connection
 * @return \PDO database connection instance
 */
public function get_connection() {
    $dbname = \TMSC\tmsc_sync()::$tms_db_name;
    $username = \TMSC\tmsc_sync()::$tms_db_user;
    $password = \TMSC\tmsc_sync()::$tms_db_password;
    // Build the DSN string
    $host = \TMSC\tmsc_sync()::$tms_db_host;
    $port = '3306';
    if ( strpos( $host, ':' ) ) {
        list( $host, $port ) = explode( ':', $host );
    }

    $dsn = "mysql:host={$host};port={$port};dbname={$dbname}";

    $connection = new \PDO( $dsn, $username, $password, array(
        \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
    ) );

    // Since MySQL supports it, don't automatically quote parameters to allow control over data types.
    // This comes in useful for automatically manipulating the LIMIT clause.
    $connection->setAttribute( \PDO::ATTR_EMULATE_PREPARES, false );

    // Uncomment to enable connection debugging.
    $connection->setAttribute( \PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION );

    $this->set_mysql_global_defaults( $connection );
    return $connection;
}

When this function connects to a Remote AWS/RDS database, we configure it with a FQD for the $host variable. But, when running the same function locally, within our Docker setup, we must use the docker container name “jetpack_mysql” (as defined in the docker-compose.yml file) and not “127.0.0.1” or “localhost”.

One foot in front of the next is the only way to get there.

This is my first post on the site using [Gutenberg](https://github.com/WordPress/gutenberg).

I sit there, typing here

I just stumbled across a thing I wrote months ago at work, x-posting here for posterity:

I heard a segment recently on NPR’s Here And Now re: Facebook and Google together capturing 80-90% of online advertising. As so many web-based business models hinge on advertising (either directly or indirectly), this allows these two companies to “steer” the future of the web in so many ways.

The web I grew up on was about connecting to information (aka, content). Increasingly, today’s web is about connecting to people. Google and Facebook are coming at this intersection of content and people from opposite directions and at that intersection is the proverbial end of the rainbow, pot of gold.

I don’t have a full theory developed for this (yet), but I believe this centralization and consolidation, combined with increasingly algorithmic driven user experiences, reduces our online experience to normalized advertising units and pays no respect to the diversity of our offline/analog world. For me, the concept of an “open web” represents an alternative.

[lfh-gpx src=https://mark.drovdahl.com/wp-content/uploads/2018/01/Lake_Poway_Trail_Run_w_Katie.gpx title=”Lake_Poway_Trail_Run_w_Katie” color=blue width=5 ]Always good to sneak in a run while on vacation =)[/lfh-gpx]