hglaser

15 ms·

91.
4 Ways to Join Only The First Row in SQL(periscope.io)
1 points by hglaser 12y ago|0 comments
92.
by hglaser 12y ago
Not directly related to a consumer app, but I've found that requests for more features strongly predict customers who aren't going to pay. Customers who are a good fit for the product ask for the core features to work better, fast
93.
Google Easter Egg: May the fourth be with you(google.com)
1 points by hglaser 12y ago|0 comments
94.
by hglaser 12y ago
CanvasJS, which we're really pleased with. Very fast to develop with, very fast to render (some customers have hundreds of charts per dashboard).
95.
by hglaser 12y ago
This looks very cool. My company ( http://periscope.io ) is just now getting to the point of putting documentation online, and -- surprise! -- it's a huge pain and products in this space all seem mediocre. One deal-breaker fo
96.
Selling Your Company? Prioritize Dollars Over Prestige(techcrunch.com)
1 points by hglaser 12y ago|0 comments
97.
by hglaser 12y ago
Best advice in the post: "Easy. I stopped reading Techcrunch." 42Floors is a magnitude bigger than my company ( http://periscope.io ) and has always seemed like one of those runaway startup successes that we aspire to a
98.
by hglaser 12y ago
I was at Google during the Eric Schmidt years and thought the author captured it pretty well, including: * A basically coherent, well-run, thriving place to work; except: * Lots of executive infighting, especially certain execs; and: * Larr
99.
NASA Signs Agreement with SpaceX for Use of Historic Launch Pad(nasa.gov)
12 points by hglaser 12y ago|0 comments
100.
by hglaser 13y ago
The more early-stage a startup is, the more they probably value startup-y breadth and self-motivation higher than raw in experience in any one category. So looking for early-stage startups where your last couple years will be a strength, no
101.
Use generate_series in SQL to get continuous results(periscope.io)
2 points by hglaser 13y ago|0 comments
102.
by hglaser 13y ago
Selecting companies that are valued at over $1B yet haven't IPO'd yet is a really narrow set and a moving target. Why not include companies that were venture-backed and have IPO'd? And/or companies that were acquired for
103.
by hglaser 13y ago
Periscope -- San Francisco -- User Experience Designer Periscope is a data analysis tool that uses pre-emptive in-memory caching and statistical sampling to run data analyses really, really fast. The slick UI and impressive backend speed se
104.
by hglaser 13y ago
> FWIW, the few folks I know who tried to stay on purely technical paths ended up regretting it many years later. Why?
105.
by hglaser 13y ago
Why aren't there other vim committers? Bram's conservatism makes perfect sense for someone who has to maintain this huge, consequential, intimidating codebase. Why hasn't he gotten some help?
106.
Neovim: vim's rebirth for the 21st century(bountysource.com)
3 points by hglaser 13y ago|0 comments
107.
How to speed up where clauses by 3,000X(periscope.io)
3 points by hglaser 13y ago|0 comments
108.
by hglaser 13y ago
Yes. Yes yes yes yes yes. "Front-end engineering" is a craft that happens to be relevant right now. It's an artifact of the particular client-server computing model we currently have. It is not likely to be relevant 5-10-20 y
109.
by hglaser 13y ago
This is super hard and there is no great answer. I've never met anyone who's had good luck with places like Betalist. (Though "Show HN" can work.) Realistically you are going to be tracking down your first 100 users your
110.
Double Your Redshift Speed With Sortkeys and Distkeys(periscope.io)
4 points by hglaser 13y ago|0 comments
111.
by hglaser 13y ago
We didn't try SSD drives. It's a good idea, worth a shot for a future post.
112.
Count distinct performance compared on top 4 SQL databases(periscope.io)
31 points by hglaser 13y ago|7 comments
113.
by hglaser 13y ago
OP here again. This was such a good idea, we decided to do it. :) Here are the same queries tested on MySQL, MSSQL and Oracle as well: https://periscope.io/blog/count-distinct-in-mysql-postgres-s... tl;dr: Oracle and M
114.
by hglaser 13y ago
Good idea. Times are from my laptop, which is less beefy than the test rig we used: First query: 996s First query with your variation: 593s Second query: 67s Third query: 21s
115.
by hglaser 13y ago
https://periscope.io/blog/atom.xml
116.
by hglaser 13y ago
OP here. It's no EXPLAIN ANALYZE, but here are the EXPLAINs at least. The originals were averages of 10 runs. These EXPLAINs are just quick runs on my laptop, so no promises. :) First query:
117.
by hglaser 13y ago
OP here. Great points -- especially around MySQL and subqueries, which has been a frustration for us. Comparing across different RDBMS's is a great idea. Maybe we can squeeze it into a future blog post. :)
118.
Use Subqueries to Count Distinct 50X Faster(periscope.io)
21 points by hglaser 13y ago|2 comments
119.
by hglaser 13y ago
Thank you for spending so much time on this. We appreciate it.
120.
Telling It Like It Is(avc.com)
5 points by hglaser 13y ago|0 comments

More ›