HNHacker News
TopNewBestAskShowJobs

kendowns

7 karma · joined May 5, 2008

Author of The Database Programmer blog ( http://database-programmer.blogspot.com) and the Andromeda Database Development System (http://www.andromeda-project.org).
submissionscomments
kendowns··on [dead]
Does intelligence involve dealing with facts? Cuz the title is factually incorrect.
kendowns··on Javascript TRS-80 Performance: Firefox, IE9 still slow
SEA DRAGON!!! WOOOO!!!!
kendowns··on Poll: How old were you when you started programming?
About 12 on a TI calculator. 13 on TRS-80 Basic, 13 or 14 for Assembly
kendowns··on Minimize Code, Maximize Data
Nope. kqr2 had it right, the approach was to move parameters into tables that the user could edit. Asking the user to spell anything out is not in the cards for that example.
kendowns··on The Wonderful Awful Browser
Actually I have, it is extremely cool. For my own case I don't know where it will fit in yet, as I currently do fine without it, but its one of those things I follow.
kendowns··on The Wonderful Awful Browser
You can have your cake and eat it too, and you don't have to compromise. All you have to do is recognize where the browser's original intent may be different from your own (doc mgmnt versus transactional database mgmt). Making the browser do the job is very doable, but it is much easier if you recognize why it seems hard.
kendowns··on The Wonderful Awful Browser
The actual reason I gave in the OP was easy distribution. This is huge.

I think also that my OP could have been stronger pointing out that the job is completely doable (in fact I've done it), with a sort of "here are the problems you will face" feel.

kendowns··on Minimize Code, Maximize Data
A cursory google search gave no obvious explanation of this, do you have a specific link to serve as a starting point?
kendowns··on Minimize Code, Maximize Data
Yes, the code-is-data is one of those frustratingly true-but-out-of-context things. I created a complete framework that builds databases out of a text file (YAML it so happens) including security and automations (http://www.andromeda-project.org), but was unaware of TBL's essay. I will have to read it carefully and determine what citations may be in order.
kendowns··on Minimize Code, Maximize Data
I think that in this case you get a non-trivial performance gain with some basic implementation improvements. You can replace the row-by-row round trip with a single SQL UPDATE with a LIMIT (or a LIMITed subquery if the server does it that way).

Also, the performance of the algorithm in the essay would be linear to the number of rows requiring update, can you elaborate on whether the RETE alogorithm can do any better in this case.

And finally, thanks for the note on RETE, I will have to investigate that.