-
Recent Posts
Recent Comments
- ubershmekel on Two bugs don’t make a right
- Ram Rachum on Optimizing Django ORM / Postgres queries using left join
- Dimensions in Mathematics on Beautiful Code
- Tomer Filiba on Collision: the story of the random bug
- Brendan Dolan-Gavitt on Collision: the story of the random bug
Archives
- August 2012
- July 2012
- June 2012
- June 2011
- February 2011
- January 2011
- December 2010
- April 2010
- March 2010
- February 2010
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- February 2007
Categories
- Algorithms
- Assembly
- C
- Challenges
- Compilation
- computer science
- Cryptography
- CSS
- Databases
- decompilation
- Design
- Fractals
- Game Development
- Geometry
- gotchas
- Graphics
- Group Theory
- Humour
- Javascript
- Linux
- Math
- Miscellaneous
- Optimization
- Optimization
- Optimization
- Optimization
- Origami
- Personal
- Programming
- Programming Philosophy
- Projects
- Protocols
- Python
- rants
- Research
- Security
- Sound
- startup
- Statistics
- Teaching Programming
- Testing
- Uncategorized
- Utility Functions
- web-design
Category Archives: Databases
Optimizing Django ORM / Postgres queries using left join
For the latest project I’m working on, we’re using Django with Postgres. I was writing some code that had to find a list of objects that weren’t processed yet. The way they were stored in the DB is like so: … Continue reading
Posted in Databases, Optimization
Tagged django, left join, optimization, orm, postgres, sql
1 Comment
Bulk INSERTs FTW
A short while ago, I had to research some API for a company I’m consulting for. This API yields very good quality data, but isn’t comfortable enough to process it for further research. The obvious solution was to dump this … Continue reading
Posted in Databases, Programming
Tagged bulk-insert, Databases, Python, sql-server, sqlalchemy, sqlite
1 Comment
A Simple Race-Condition
Lately, I’ve mostly been working on my startup. It’s a web-application, and one of the first things I’ve written was a cache mechanism for some lengthy operations. Yesterday, I found a classic race-condition in that module. I won’t present the … Continue reading
Posted in Databases, Design, Programming
Tagged Bug, Caching, Databases, Multi-Threading, Race-Condition, web applications
14 Comments
Actual Data Always Needs To Be Explicit
This might seem obvious, but it wasn’t to me it first. Now I consider it a database design rule of thumb, or even a patten. I’ll explain using an example. Consider an application where you also need automatic tagging of … Continue reading
Posted in Databases, Design, Programming, startup
Tagged Databases, Design, design patterns
Leave a comment
Database Design Problem
A few weeks ago, I had to work out a database design for my startup. I had a bit of a hard time deciding on a design direction, but after thinking about it, I settled on a design I was … Continue reading
Posted in Databases, Design, startup
Tagged Anti patterns, Databases, Design, design patterns, Entity-Attribute-Value model, Harvesting, Inner platform effect
5 Comments