dhd415

24 ms·

181.
Hash indexes are fully implemented in PostgreSQL 11(rhaas.blogspot.com)
7 points by dhd415 9y ago|0 comments
182.
by dhd415 9y ago
It's proprietary and therefore not an option for everyone, but SQL Server's "Filestream" feature [1] was designed for the "large blob of unstructured data" use case (small blobs of unstructured data generally w
183.
by dhd415 9y ago
I'd consider HNES's highlighting of new comments to be nearly essential to reading HN. I don't understand how others can follow long discussions without any indication of what comments have been posted since a previous viewin
184.
by dhd415 9y ago
I use the "Chrome Store Foxified" extension which lets you install some Chrome plugins including HNES.
185.
by dhd415 9y ago
I don't see how pgsql could perform such optimizations as eliminating a sorting step when ordering results by column(s) in a clustered index if there is no guarantee that new or updated data will also be ordered by the clustered index.
186.
by dhd415 9y ago
That kind of clustering is a point-in-time operation. Subsequent inserts and updates aren't stored in clustered order. When the ordering is guaranteed, the query planner can be more aggressive in optimizing certain kinds of queries. A
187.
by dhd415 9y ago
It's disappointing that pgsql has no index-organized tables aka clustered indexes. They are quite advantageous for a variety of workloads.
188.
by dhd415 9y ago
I have but I'd say that SQLite is not intended for use in that scenario. It's an in-process library for persisting data to disk in a generally relational format with a SQL interface. It starts to degrade under highly concurrent re
189.
by dhd415 9y ago
I'd happily pay for an alternative to GV, too, especially since Google has shown little interest in GV and has a tendency to shut down services in which they've lost interest (RIP, Google Reader). Better support for MMS would be n
190.
by dhd415 9y ago
I largely agree with the above and I would say that 1000 reqs/sec is probably a decent threshold for considering when async IO is going to matter for performance. That said, the details of your particular workload may benefit from asyn
191.
by dhd415 9y ago
Yes, although everything that I've read suggests that Motorola's patent portfolio was light on anything related to smartphones so it provides little in the way of a litigation deterrent for competitors of Google or Android OEMs.
192.
by dhd415 9y ago
Some speculate that the Motorola acquisition was for their patent portfolio rather than their product line. I don't know how much credence to give that theory. An argument in favor of it is how quickly the Motorola phone business (minu
193.
HTC in final negotiations to sell smartphone business to Google(droid-life.com)
50 points by dhd415 9y ago|32 comments
194.
by dhd415 9y ago
Describing the production operation of MySQL as a minefield is an excellent analogy. I maintained a list of the mines I stepped on in the last job I had where MySQL was used and here are the two I encountered with the biggest blast radius:
195.
by dhd415 9y ago
From the reports I've seen, the big vendors (HP, Dell, Lenovo, etc.) ship about 3x more servers than workstations. And that probably understates the degree to which Xeons end up in servers rather than workstations since HP, Dell, and L
196.
Cross-cloud migration with CockroachDB(cockroachlabs.com)
12 points by dhd415 9y ago|0 comments
197.
by dhd415 9y ago
One of the commenters on the original article ( https://medium.com/@tarthedark/did-a-custom-bench-between-ht... ) changed a few lines of the C# to use some different ASP.NET facilities which more than doubled the reqs&#x
198.
Essential Phone review: An arcane artifact from an unrealized future(theverge.com)
90 points by dhd415 9y ago|66 comments
199.
by dhd415 9y ago
Same here. I've found that all the other registry and policy methods eventually stopped working for me whereas disabling the update service has worked reliably for 9+ months.
200.
by dhd415 9y ago
North Texas (Dallas, Ft. Worth, etc.) get pretty cold during the winter. I've spent a fair amount of time in North and Central Texas and while high AC bills during the summer (i.e., mid-April to early October) are common, the single hi
201.
by dhd415 9y ago
Yep, furthermore, Texas is in the bottom 20% of states in terms of residential energy use per capita (which is pretty remarkable given how ubiquitous and essential AC is there). It's all about industrial use.
202.
by dhd415 9y ago
This is really about Peachpie, an open source PHP to .NET compiler. (Edit: the title has now been updated) From the comments on the article, here's a set of benchmarks showing Peachpie with a significant performance advantage over PHP
203.
by dhd415 9y ago
I think the fact that the 27" monitors next to it are closer to the camera in that photo makes the TV look artificially smaller. It absolutely dwarfs the 27" monitors. If you're close to any store that carries 40" 4k TVs
204.
by dhd415 9y ago
Mine is a 40" Samsung UN40KU6300 though Samsung appears to rev its model lineup frequently so they may have already released a successor to this model. It was a little difficult to confirm that it supported 4k@60hz with 4:4:4 chroma, b
205.
by dhd415 9y ago
I detect no lag when moving windows around. It might not (or might -- I simply don't know) be good enough for gamers, but it's definitely smooth enough for development, document, or web browsing (aka productivity) tasks.
206.
by dhd415 9y ago
Here's an image of it while I was working on 3 or 4 documents for a non-development task: https://ibb.co/bWUYh5
207.
by dhd415 9y ago
I've been using a Samsung 40" 4k TV as my main monitor for development work for about 8 months and it's been great for me. A couple caveats -- Because I don't game or do graphics work, I don't know or care about col
208.
by dhd415 9y ago
We used a code conversion tool from Artinsoft (now Mobilize.Net) and brought one of their consultants onsite for a week. The cost for that was in the low 5 figures, but our CTO (rightfully) recognized that as a bargain given the amount of d
209.
by dhd415 9y ago
I was involved in the conversion of over 500k lines of Visual Basic 6 to C# motivated by Microsoft's EOL'ing of VB6. Most of it was a desktop application although part of it was a server component. We used an automated code conver
210.
by dhd415 9y ago
I'm guessing that the sci-fi practice was due to the sociological similarities between spacecraft crews and ship crews on isolated, long-term voyages. At present, the US Air Force has been responsible for most high-tech concerns includ

More ›