はてなブックマーク

SQLite: Small. Fast. Reliable. Choose any three. July 14, 2014 12:37 / berkeleydb peewee python sqlite / 10 comments 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. Concurrency As the maintainer of an ORM, I get asked a lot of questions about

Using SQLite Full-Text Search with Python May 12, 2014 19:12 / peewee python search sqlite / 0 comments In this post I will show how to use SQLite full-text search with Python (and a lot of help from peewee ORM). We will see how to index content for searching, how to perform searches, and how to order search results using two ranking algorithms. Last week I migrated my site from Postgresql to SQLi

Using python and k-means to find the dominant colors in images October 23, 2012 17:23 / algorithms python / 17 comments I'm working on a little photography website for my Dad and thought it would be neat to extract color information from photographs. I tried a couple of different approaches before finding one that works pretty well. This approach uses k-means clustering to cluster the pixels in gr

Powerful autocomplete with Redis in under 200 lines of Python July 06, 2012 16:29 / autocomplete python redis / 0 comments Update Redis-completion is now deprecated. The autocomplete functionality, along with a number of other features, have been integrated into a new project walrus. Check out the walrus blog announcement for more details. Original post In this post I'll present how I built a (rea

I recently rewrote my personal site using flask and peewee, breaking a good amount of stuff in the process. I was trying to track down the errors by tailing log files, but that didn't help alert me to new errors that someone visiting the site might stir up. I thought about setting up error emails a-la django, which is a tried and true method...but then I happened on a different approach. I won't s

Building a bookmarking service with python and phantomjs March 29, 2012 19:16 / flask phantomjs python saturday-morning-hacks / 1 comments Using python and phantomjs, a headless webkit browser, it is a snap to build a self-hosted bookmarking service that can capture images of entire pages. Combine this with a simple javascript bookmarklet and you end up with a really convenient way of storing book

Huey, a lightweight task queue for python February 02, 2012 15:22 / huey python / 0 comments Note Just a heads-up, this post contains code examples for an out-of-date version of huey. If you're interested in seeing current example code, check out the documentation. Preface At my job we've been doing a quarterly hackday for almost a year now. My coworkers have made some amazing stuff, and its nice

Integrating the flask microframework with the peewee ORM September 27, 2011 10:52 / django flask peewee python / 5 comments I'd like to write a post about a project I've been working on for the past month or so. I've had a great time working on it and am excited to start putting it to use. The project is called flask-peewee -- it is a set of utilities that bridges the python microframework flask a

Peewee, a lightweight Python ORM - Original Post November 28, 2010 15:01 / database django orm peewee python / 15 comments Edit I rewrote peewee from the ground up. The query examples in this post are no longer supported. Edit, Jul 24, 2011: added support for Postgresql and MySQL (in addition to SQLite). Edit, June 8, 2011: added support for MySQL For the past month or so I've been working on writ