wulczer

16 ms·

151.
by wulczer 15y ago
A piece of fun trivia. What is currently the PostgreSQL codebase used to be written in Lisp, and was subsequently ported to C. You can still recognize Lispy idioms in many places, there's abundany usage of the List structure, functions call
152.
by wulczer 15y ago
We used IPython's parallel processing features at (first (take-right jobs 2)) for load testing. One machine would run ipcluster and people who were not doing CPU or network intensive tasks would fire up ipengine that connected to the ipclus
153.
by wulczer 15y ago
The last time I had to rewrite an SQL query because it was too slow (5 days ago) I definitely used the knowledge taught to me in my CS course.
154.
by wulczer 15y ago
GStreamer is another option. While support for some formats is provided in GStreamer by using ffmpeg, it has independent implementations for many formats and a very different architecture.
155.
by wulczer 15y ago
Sounds a little like apps in Djangoland. Maybe someone who knows both frameworks could confirm.
156.
by wulczer 15y ago
If you're looking for blogging software for hackers, look at http://wingolog.org/software/tekuti/ . From the page: Tekuti means "I'm telling you" in Oshiwambo. It is weblog software written in Scheme, using Git as its persistent stor
157.
by wulczer 15y ago
It's MIT licensed, so not proprietary. Did you mean to say "third-party"?
158.
by wulczer 15y ago
I think it's Wikipedia because "walkman" has a much longer history as a brand name, from cassette players to cell phones. I remember times where back where I lived "walkman" was a plain noun meaning "any kind of portable cassette player".
159.
by wulczer 15y ago
I'd say that the URL for Apple iPod is: http://google.com/search?q=apple%20ipod and for Sony Walkman: http://google.com/search?q=sony20walkman Really, I see people going to their GMail by typing "gmail" in Google. And ask 100
160.
by wulczer 15y ago
That's what ON UPDATE CASCADE is for. If you have a distributed system, generating unique identifiers and keeping referential consistency across the distributed parts is already a difficult problem. But that's a digression. If I ever get so
161.
by wulczer 15y ago
I think I see the fundamental point where we disagree. I try to keep as much business logic in the database as possible. That's more of a DBA perspective, I guess: don't trust these pesky app developers, always assume they'll try to put bro
162.
by wulczer 15y ago
Yeah, these might all be valid reasons to use surrogate keys. I'm not saying there are none, just that always using one often leads to design mistakes. Incidentally, part III of the keyvil blog posts talks about reasons to use surrogates :)
163.
by wulczer 15y ago
There are strong opinions on it, but I firmly believe that "always have an autoincremental id" is a very wrong approach. Read http://it.toolbox.com/blogs/database-soup/primary-keyvil-par... (an often-quoted series of blog posts on why sur
164.
by wulczer 15y ago
SQLAlchemy supports multiple-column primary keys, Django ORM does not. What's more to think about?
165.
by wulczer 15y ago
Oh, I see what you're referring to. Yes, storing the local time and the timezone is not exactly what's enough, all that time I was thinking about the PostgreSQL timestamp with time zone type, which is preferable to use vs storing the Unix t
166.
by wulczer 15y ago
Use pytz. import pytz from datetime import datetime tz = pytz.timezone('Asia/Shanghai') tz.normalize(pytz.utc.localize(datetime.utcnow()).astimezone(tz))
167.
by wulczer 15y ago
You store the local time and timezone. You show the value in whatever timezone the user configured the application. If you store only Unix time, you don't have enough information. If you store both the Unix timestamp, the local time and the
168.
by wulczer 15y ago
But you frequently need to store the original timezone, to be able to do date calculations after storing it. For instance, a user added an appointment and her timezone is America/Los_Angeles. Then she moved to China and changed her timezone
169.
by wulczer 15y ago
Storing time as Unix timestamps is often not possible. Often you need to be able to answer questions like "did this moment fall on a weekday?", "what day was it 3 hours after that moment" and so on. My rule is to either work with integer Un
170.
by wulczer 15y ago
Oh, good point. I clearly need more caffeine in my system.
171.
by wulczer 15y ago
Looks useful, but why make smoke.confirm work differently from plain confirm? It uglifies the API for no gain, IMHO.
172.
by wulczer 15y ago
http://en.wikipedia.org/wiki/CAP_theorem
173.
The Vietnam of Computer Science(blogs.tedneward.com)
3 points by wulczer 15y ago|1 comments
174.
by wulczer 15y ago
My first reflex was to write a comment mentioning that essay and then I found this. Wish I could upvote you more...
175.
by wulczer 15y ago
See http://www.madore.org/~david/computers/quine.html and http://www.nyx.net/~gthompso/quine.htm
176.
by wulczer 15y ago
A quick search reveals this post: http://jan.kneschke.de/2008/9/9/async-mysql-queries-with-c-a... with a little more in-depth exploration of the MySQL async API. The problem seems to be that that (undocumented) API does not handle EAGAIN
177.
by wulczer 15y ago
Oh, missed that one. It's a great day for dashboards and the more the merrier!
178.
by wulczer 15y ago
Ah, our quest for a logo was truly epic. One day we'll write a blog post about 99designs... Anyway, I hope that this exact conversation will make you remember it's duckSboard.com ;)
179.
by wulczer 15y ago
It's definitely going to be included in all plans. To expand on that, we do real real-time. For services that provide real-time updates, like Twitter, you get notification in the exact same moment someone retweeted you or followed you. For
180.
by wulczer 15y ago
Yeah, we found that after we already made the page public and didn't want to touch it right after launch. We have a fix that we'll apply in a few minutes. Thanks!

More ›