Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
phereford
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
9 ms
·
31.
▲
by
phereford
10y ago
I made a very broad assumption based on my past experiences with engineers and I apologize if I offended you. Most engineers I have met in my career have really depended on an ORM to do all of their heavy lifting. They can write some of the
32.
▲
by
phereford
10y ago
4000 records with a one-to-many join (the many part capped at 240 records). The aggregations are done mostly on that join table. In our original ruby process, it would return just that, 240 records per join and aggregate on that. Our SQL pr
33.
▲
by
phereford
10y ago
Yea. It returns a table of rows, where the return columns are defined in the stored procedure. I may have used the wrong nomenclature. I was trying to differentiate between a table in a database schema versus one defined in a function.
34.
▲
by
phereford
10y ago
Honestly, it's yak shaving at that point. Like the article pointed out, you can create an index on a stored procedure that is IMMUTABLE. That will have some effect on the performance of the query. There are other patterns you can use t
35.
▲
by
phereford
10y ago
Absolutely agreed. In our particular situation, the ruby calculations were the bottlenecks based on our benchmarks.
36.
▲
by
phereford
10y ago
Most ORMs will not do the level of aggregations you want or need without writing raw SQL within your ORM. If you are already writing raw SQL in your ORM for aggregation level computations, you might as well create a stored procedure, make i
37.
▲
by
phereford
10y ago
Absolutely! We use rails. I just mentioned doing it in that method as opposed to throwing it in a migration. That migration shouldn't change in version control. We wanted a history of the changes and an easy way to access it in migrati
38.
▲
by
phereford
10y ago
With the correct abstractions, you can definitely run tests on save. SQL is rather readable these days. It's obviously not as easy to read as ruby or python and is slightly more verbose, but it is certainly readable. Mileage will vary
39.
▲
by
phereford
10y ago
That's exactly what we did. We return an anonymous table of records in Postgres that are then passed to ruby to render an excel file. The SQL query takes 27s on average. The ruby view generation is fast as well but I haven't prof
40.
▲
by
phereford
10y ago
At work, we have an internally generated report that was done purely in ruby. It worked, barely, munging numbers for about 1000 records. When we hit 4000 records, the report took about 6 hours to run in ruby. We looked for some obvious opti
41.
▲
by
phereford
10y ago
While Wikileaks may not alter any of the information they are given, it is plausible that their sources have the ability to alter documents before sending to Wikileaks. The only newsworthy item I have seen was this: http://mobile
42.
▲
by
phereford
10y ago
I have had a number of managers in my career. Some where they couldn't careless about my career prospects (no 1-1s, no conversations, nothing). And the best ones put me in positions to thrive and grow. For those of you in either of the
43.
▲
by
phereford
10y ago
Who do you feel less loyal to? I only ask as I essentially try to keep the same boundaries but don't feel less loyal. I actually feel more loyal as I have more _focused_ time for the company, but this is probably just a rationalization
44.
▲
by
phereford
10y ago
I completely echo this sentiment. I like Ember, but have found that the learning curve of a React/Redux app is significantly smaller than that of a similar Ember app. Small sample size for me (2 Ember projects, 6+ React projects), but
45.
▲
by
phereford
10y ago
It's a numbers game once they subscribe, even if the link is there. Some people, myself included, won't hit that unsubscribe button. I'll just forever mark it as spam until it no longer shows up in my inbox.
46.
▲
by
phereford
10y ago
Amazon (in the US) sold out of all of it's Preorders within hours of the preorder launch a few months back.
47.
▲
by
phereford
10y ago
I _think_ WL == WikiLeaks.
48.
▲
by
phereford
10y ago
Yep. I completely agree. I hadn't had my early am coffee yet ;)
49.
▲
by
phereford
10y ago
You are absolutely right.
50.
▲
by
phereford
10y ago
I've worked with similar organizations that want the transaction on their site due to all the reasons mentioned in the comments. There are providers that use JavaScript to allow you to take payment information on your platform but neve
51.
▲
by
phereford
10y ago
This industry is ripe for innovation. I agree that the state of malware being served through Ad Exchanges is grotesque and I fully employ my ad blocker everywhere. Here is the thing I just dont get. Why doesnt some tech savvy organization c
52.
▲
Hack the Pentagon Cybersecurity Initiative
(defense.gov)
1 points
by
phereford
11y ago
|
0 comments
53.
▲
by
phereford
11y ago
ESPN published an article the day after with about 10-12 tweets surrounding the victory. You didn't need to be on Twitter to see it, just on ESPN the day after to realize what you missed.
54.
▲
by
phereford
11y ago
Awesome! I had chosen flux for one project I was on and really enjoyed it! Thanks for the post!
55.
▲
by
phereford
11y ago
https://github.com/coryhouse/react-slingshot is my go to boilerplate.
56.
▲
by
phereford
11y ago
There are lots of popular Flux libraries. https://github.com/acdlite/flummox https://facebook.github.io/flux/ https://github.com/reflux/refluxjs http://fluxxor.com
57.
▲
by
phereford
11y ago
From my initial readings and implementations of flux, it seems that actions should only really interact with stores through the dispatcher. To achieve uni directional data flow here, you could pass the DataSTore.loadingState from the compon
58.
▲
The Value of Feedback: A Tale of Building an Internal Tool
(americastestkitchen.github.io)
1 points
by
phereford
11y ago
|
0 comments
59.
▲
by
phereford
11y ago
I do not disagree about the shell history being very important. Some histories do end up getting truncated at a set interval. That was the main reason I brought up tracking this command trail at some point close to the task being completed.
60.
▲
The Value of Postmortems
(americastestkitchen.github.io)
7 points
by
phereford
11y ago
|
3 comments
More ›