SQL Archives

Building a Universe with Open Source Code

Tau Station relies heavily on open source code. Our database is PostgreSQL, with database deployment management handled by sqitch. Our main programming language is Perl 5, we use Redis heavily as a fast cache for non-critical data, and so on. Lots and lots of open source code.

For our developers who want to share some of our code with the open source community, we simply ask that the code not have “Tau Station-specific” code in it. In other words, part of the fun of Tau Station is discovering its secrets by exploring the universe, not reading them in source code.

So we’ve released two more modules which, we hope, others might find useful.

Continue reading "Building a Universe with Open Source Code"

On writing clean database code

In earlier articles we looked at the way we use “economic exchanges” to simplify complex code into a series of small understandable steps. We use similar ideas to build up business logic in our DBIx::Class model layer: combining multiple small predefined queries together to create more complex conditions for generating SQL queries against the database.

Read on below if you take the challenge to read “0011001010” language of our database experts who love to share knowledge with you again about clean code.

Continue reading "On writing clean database code"

Tau Station’s Tech Stack

People have been asking about our technology stack, so this post will be a bit “tech heavy.” Further, it will be opinionated tech-heavy. You’ve been warned!
When I started Tau Station, I knew that I was primarily looking for a robust Web framework, a flexible ORM (object-relational mapper), and a strong database. Due to my having been heavily involved in open source for years, only open source products were considered.

Continue reading "Tau Station’s Tech Stack"