Database Posts

Configure Laravel to Use PostgreSQL with Homestead

  • Date: 29 Apr 2018
  • 4 min read

I was building a Laravel app in Homestead, with MySQL. I later decided to use PostgreSQL. This took a bit longer than expected. Here is how I did it. Review Homestead Setup Update Laravel’s DB Config Recreate the database in PostgreSQL Recreate the Database Tables and Data Optional: Install a [...]

Documenting Database Design

  • Date: 03 Feb 2016
  • 3 min read

Documenting database design is just one of those skills we web developers tend to lack. I have some theories as to why. draws on writing & design talents, rather than just technical talents is usually about the business domain, not the application itself can be boring and tedious If done [...]

The Simplicity of SQLite

  • Date: 25 Jan 2016
  • 1 min read

SQLite consists of a single file as the database and a set of CLI commands. “Like all magnificent things, it’s very simple.” I first brushed up against SQLite while building stuff in Ruby on Rails. The weird thing about SQLite, as a database, is that it’s not a client-server setup. [...]