Welcome to my site! I'm a web developer in Lawrence, KS, and I like blogging about Python and programming in general. I'm also an avid motorcycle rider. Below you can find a list of my most recent blog posts.
I've developed an interest in some of the more advanced features of SQLite after reading the O'Reilly title Using SQLite (Small. Fast. Reliable. Choose Any Three). For personal projects I like using SQLite, but when I need something more powerful I turn to Postgresql. Because peewee supports both of these databases (as well as MySQL), it is limited to a lowest-common-denominator feature set. While this encompasses a broad range of features, each database engine has its own extensions and I've been interested in adding some pythonic support for the cooler extensions.
Here are some of the fun things you can find in peewee's playhouse (collection of extensions):
This post will showcase the peewee support for HStore, JSON document store, and arrays. I've written elsewhere about SQLite's full-text search, so if you're a SQLite user you may want to check out that post.
To follow along at home, feel free to install peewee:
pip install peewee
It's been a great summer so far! Here are some of the things I've been up to.
I was trying to get some work done the other day and there was an octopus attack. I survived by eating them.
Read on for more!
A co-worker of mine mentioned that he missed Ruby's syntactic sugar for regular expressions. I haven't used Ruby's regular expressions, but I'm familiar enough with Python's to know that the API is a bit wanting in syntactic sweetness.
In this post I'll show how you might use python's magic methods to make a nicer API for working with regular expressions.
SQLite is a fantastic database and in this post I'd like to explain why I think that, for many scenarios, SQLite is actually a great choice. I hope to also clear up some common misconceptions about SQLite.