Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
empthought
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
76 ms
·
871.
▲
by
empthought
14y ago
The coolest thing about the hobby is that it scales to all sorts of different interests and spending levels. Compare this to < http://smallwonderlabs.com/Rockmite.htm> . Sure, it has no buttons at all, but you build it yourself and
872.
▲
by
empthought
14y ago
"VP" is so prevalent at banks because bank depositors and customers feel important when they get to talk to a "vice president."
873.
▲
by
empthought
14y ago
Walt's background and motivations are that he was an evil criminal looking for an excuse to become what he actually is...
874.
▲
by
empthought
14y ago
Please read Tufte's advice on graphs. 3D graphs are especially irritating.
875.
▲
by
empthought
14y ago
Key-value stores like dbm since the 1980s? You're not exactly going out on a limb with those high hopes. :)
876.
▲
by
empthought
14y ago
Try it without shouting -- select * from users Looks more like Haskell now.
877.
▲
by
empthought
14y ago
All of those modification times/users should be in a separate audit trail table, which likely will look like an EAV table. That's OK because it's tracking the history of updates, e.g. (time, table_name, column_name, old_value, new_value, ch
878.
▲
by
empthought
14y ago
Sounds like an array of custom data types with phone_number, phone_number_label columns, then. PostgreSQL can do that. I think applications overspecify things like cell_phone_number because they would like to query for all cell phone number
879.
▲
by
empthought
15y ago
It's not true that using arrays is using SQL against its grain. If this is an arbitrary list of phone numbers then an array is fine -- the domain being modeled is "list of phone numbers" not "phone number." If you need to query specific pho
880.
▲
by
empthought
15y ago
In general I disagree, but in this specific case you are right that a procedural interface to manipulating books/chapters is preferable. Essentially if your API is single-table DML, then triggers are preferable. If multiple tables need to b
881.
▲
by
empthought
15y ago
I think you should be able to write a delete rule on Chapter that will ensure that no array in Book contains that chapter, whether through cascading the delete or through raising an error.
882.
▲
by
empthought
15y ago
OK, that's definitely a matter for a custom trigger on the table. Another option would be to keep the chapter order in an array column on the Book table, since arguably the arrangement of chapters belongs to the book rather than the chapter
883.
▲
by
empthought
15y ago
What's the trouble with PostgreSQL's sequence support? ( http://www.postgresql.org/docs/9.1/interactive/sql-createseq... )
884.
▲
by
empthought
15y ago
http://scienceblogs.com/pharyngula/2008/01/the_return_of_lou... "I'd be surprised if any of you knew who Louis Savain is — he's a weird little crackpot that I stomped on hard all of 3½ years ago..."
885.
▲
by
empthought
15y ago
Yeah, that's all. The reason it's relevant is that XPath processors often value conformance over expanding the utility of their system. I didn't want someone going off and using libxslt or xalan expecting it to process things in a memory-ef
886.
▲
by
empthought
15y ago
Just /node/node2/following::* in a predicate or whatever. Perhaps you're conflating XPath-as-used with XPath-as-specified? http://msdn.microsoft.com/en-us/library/ms950778.aspx explains that you can't support all of XPath (even 1.0) and p
887.
▲
by
empthought
15y ago
There's a following:: axis in XPath which lets you look ahead to arbitrary elements. So the processor needs to load the document into memory, which of course is not streaming.
888.
▲
by
empthought
15y ago
I think you're overstating the capabilities and implementation of common XPath processors here, and silently implying the use of a subset or modified version of XPath as specified. Arbitrary XPath will likely require loading the entire
889.
▲
by
empthought
15y ago
Lakatos's [Proofs and Refutations]( http://www.worldcat.org/oclc/258084194 ) is good background on the mathematical ideas that Stepanov is alluding to. The short version is that you don't start with axioms, because they are generally uninte
890.
▲
by
empthought
15y ago
Check it out... def fibonacci_sequence(): a, b, c = 0, 0, 1 while True: a = b; b = c; c = a + b yield b >>> fibonacci_sequence() <generator object fibonacci_seque