Johbo's Notes - Working on the Web
  • About Me
  • Archives

Working on the Web

Johannes Bornhold blogging on software development, technical topics, and the challenges of growing organizations which make software.

Johannes Bornhold Portrait

Creating a partial unique index with SQLAlchemy in PostgreSQL

Fri 04 November 2016 by Johannes Bornhold in develop Tags sqlalchemy / postgresql / snippet

A partial unique index allows to constrain only a subset of the records in a table. This post shows an example how to implement a partial unique constraint with SQLAlchemy.

more ...

Upgrading old NixOS machines

Tue 01 November 2016 by Johannes Bornhold in nixos Tags nixos / nix

Upgrading old NixOS machines can lead to a situation where the rebuild fails due to an unknown hash algorithm. This post shows a workaround to get started again.

more ...

Custom meta tags with Pelican, canonical URL as example

Tue 25 October 2016 by Johannes Bornhold in tools Tags pelican / seo / snippet

Setting custom meta data with Pelican can be implemented easily. This post shows a small example how I solved it.

more ...

Printing the generated query including parameters

Sun 23 October 2016 by Johannes Bornhold in develop Tags sqlalchemy / sql

Small example how to print out a SQLAlchemy query with parameters being expanded.

more ...

Sort certain result items on top in PostgreSQL

Wed 19 October 2016 by Johannes Bornhold in develop Tags sql / postgres / search

When displaying items based on a database search, one sometimes wants to display a specific set of items at the top or bottom of the result set. Applying the custom order inside of the database query allows to still use LIMIT and OFFSET in a natural way.

more ...

Storing the Heroku Connect configuration in a repository

Sat 01 October 2016 by Johannes Bornhold in develop Tags json / heroku / jq

A hint on how to store the Heroku Connect mapping configuration in a repository, so that diffs are readable and a useful information of the system changes over time.

more ...

Comparing tables in PostgreSQL

Thu 29 September 2016 by Johannes Bornhold in develop Tags postgresql / sql / snippet

Two approaches to quickly compare two similar tables and get an idea of how many records differ based on an example with geo data.

more ...

Thoughts on a command line toolkit for Pyramid

Sat 24 September 2016 by Johannes Bornhold in develop Tags python / pyramid / cli / click

Thoughts on how an integration of a CLI (command line interface) toolkit for the Pyramid web framework might look like and could be integrated into the configuration mechanisms of Pyramid itself.

more ...

Heroku Connect - Trigger sync of failed records

Wed 21 September 2016 by Johannes Bornhold in develop Tags salesforce / heroku-connect / postgresql / sync

Working with Heroku Connect means that at some point some records will end up in a failed state. This post shows a few options how to trigger the sync manually again.

more ...

Build a Nix derivation against a specific channel

Sun 18 September 2016 by Johannes Bornhold in nixos Tags nix / nix-build / nix-shell

Channels can play a tricky role when using the Nix package manager to manage development environments. Especially when one want to make sure that a derivation builds against multiple channels. This post shows how to quickly build a derivation against a different channel based on setting a URL into the include path for Nix.

more ...

  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • »
  • Social

    • twitter
    • github
    • linkedin
  • Categories

    • cloud
    • develop
    • event
    • hello
    • macos
    • nixos
    • tools

© 2023 Johannes Bornhold

Back to top