Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
pjungwir
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
29 ms
·
331.
▲
by
pjungwir
9y ago
Can anyone doing Phoenix in production share their typical HTTP response times? I built a small Phoenix project about a year ago, and compared to Rails it wasn't quite as fluent but still pretty nice. But ever since then, I've bee
332.
▲
by
pjungwir
9y ago
Okay, I appreciate the reply! I admit they had some good points about problems they found in some TSQL2 edge cases (mentioned in that paper of theirs). I will reconsider how quickly I get to their temporal book. I agree knowing a more pure
333.
▲
by
pjungwir
9y ago
Thank you for range types! They are awesome and I have lost count of how often I've used them. I even have a blog post you might enjoy about defining an inetrange: http://illuminatedcomputing.com/posts/2016/06
334.
▲
by
pjungwir
9y ago
I saw your note in the post apologizing for making up your own terminology. I wouldn't feel too bad. In the SQL world no two authors I've read use the same terminology for these things! :-) Perhaps some terms are more "standa
335.
▲
by
pjungwir
9y ago
Temporal tables are a pet interest of mine, so here are some links that people might find useful: Richard Snodgrass, Developing Time-Oriented Database Applications in SQL . Hugh Darwen & C.J. Date, "An Overview and Analysis of Pro
336.
▲
by
pjungwir
9y ago
SEEKING WORK - Portland, OR or Remote I'm a polyglot, full-stack developer with 17 years experience. My specialties are Rails, Postgres, Chef, and Angular/Ember, although I've done a lot of Java and Python too. I am reliable,
337.
▲
by
pjungwir
9y ago
I watched your video and I am tempted to sign up (as a freelancer). I guess Toptal is a competitor, as someone who claims to offer elite talent. I like how unlike them you don't seem to require lots of CS algorithm quizzing and a big u
338.
▲
by
pjungwir
9y ago
Indeed after ruling out HLL I decided that was the way to go. :-) I guess an HLL is more appropriate when you can't so easily keep track of which items have already been added to each set. For example if you were counting unique visito
339.
▲
by
pjungwir
9y ago
I was interested in using HLL for a project where I had ~20 million objects and each had a "status" with about 6 possibilities. I wanted to get fast counts of how many objects were in each status. But their status can change over
340.
▲
by
pjungwir
9y ago
From the article: > The example is that if you have 10 rakes in the stores, > you can only sell 10 rakes. The approach that is taken > is quite nice, by simulating the notion of having a > document per each of
341.
▲
by
pjungwir
9y ago
I'm reading this book right now too. It is sort of my bedtime reading. I've used Linux since 2000 and Solaris before that, and I do occasional C but mostly Ruby/Python/Java. At first a lot of it was stuff I knew, but rea
342.
▲
by
pjungwir
9y ago
SEEKING WORK - Portland, OR or Remote I'm a polyglot, full-stack developer with 17 years experience. My specialties are Rails, Postgres, Chef, and Angular/Ember, although I'm comfortable on a variety of platforms. I am reliab
343.
▲
by
pjungwir
9y ago
I've only glanced at this, but I love the idea of making your API be SQL. I did this recently for a company whose customers have a lot of "power users" who are not professional programmers but use tools like R, Excel, Tableau
344.
▲
by
pjungwir
9y ago
Something that has tripped me up a bit with service workers is this: I can use the service worker to cache all the things, and I can embed their hashes in the service worker so it knows when to refetch code that has changed, but how do I te
345.
▲
by
pjungwir
9y ago
I've used Vue for a couple projects now and it's my favorite SPA framework by far. But I liked Knockout too, and now that feels abandoned, and I'm afraid Vue will suffer the same fate. Will it really stick around in the face
346.
▲
by
pjungwir
9y ago
I wrote the initial patch for the UUID support! It's my only Postgres contribution so far (except for docs), and I really only write C a few times a year. I made a few revisions but as I fell behind others picked it up and got it over
347.
▲
by
pjungwir
9y ago
Good example! So many vulnerabilities come from a lack of imagination. :-)
348.
▲
by
pjungwir
9y ago
No, and I've set it up many times. It's just . . . whenever I talk to people about this I get the impression they think it secures them against more. Non-technical people especially (but not just them) worry about someone "ha
349.
▲
by
pjungwir
9y ago
Totally agree about the encryption. I've set up databases to run on encrypted disks (LUKS or nowadays on AWS you can get encrypted EBS), but I feel like that is really just to tick the "encrypted at rest" compliance checkbox,
350.
▲
by
pjungwir
9y ago
I use Python to control the GPIO pins on a Raspberry Pi to run my sprinklers. It just runs out of cron. I haven't polished it yet for publication, but here it is: https://github.com/pjungwir/raspi-sprinklers
351.
▲
by
pjungwir
9y ago
Another breakthrough I recall was understanding that there are three alternatives: move, copy, borrow. I don't know about the docs nowadays, but when I was starting it seemed like explanations would always pick two of these and describ
352.
▲
by
pjungwir
9y ago
That is true, but personally I think about that as coming "after" all the ownership stuff checks out, and as an implementation detail that I can usually ignore. I do keep it in the back of my mind though. Btw I have a saying: when
353.
▲
by
pjungwir
9y ago
As someone whose career has been mostly in Java/Python/Ruby but is also comfortable with C, learning Rust has been like a step function, where each time I get stuck I correct some discrete misperception and then have an easier tim
354.
▲
by
pjungwir
9y ago
SEEKING WORK - Portland, OR or Remote I'm a polyglot, full-stack developer with 17 years experience. My specialties are Rails, Postgres, Chef, and Angular/Ember, although I'm comfortable on a variety of platforms. I am reliab
355.
▲
by
pjungwir
9y ago
Once upon a time I wrote a function for remind(1) to compute the date of Pascha (Easter in the eastern churches), which uses different rules. It uses the Julian calendar (mostly). Here it is on github: https://github.com/pju
356.
▲
by
pjungwir
9y ago
> There are really no unsolved problems (of note), so it's not interesting to academics. For anyone who likes SQL and is looking for a research topic, read about temporal databases and suggest some ways to handle DDL changes over ti
357.
▲
by
pjungwir
9y ago
Personally I feel a mix of eagerness and skepticism. Just to rule out the bait-and-switch, this is $500k to write code? Not to travel half the time and bring in more sales? They say they want "React/Redux specialists, Unity develo
358.
▲
by
pjungwir
9y ago
I have a story of temptation and pressure---not as good as Jacques's but maybe interesting anyway. I was leaving grad school (not for tech) and getting back into programming. I had two new kids, and I was really ready to stop living on
359.
▲
by
pjungwir
10y ago
People don't seem to like your names, and perhaps the names do need more work, but I wanted to commend you for trying . Whenever I see something named "Group" I cringe a little, because it is so abstract and meaning-free. It
360.
▲
by
pjungwir
10y ago
Yep, trusting every submission initially is fine, and we do use tricks like you suggest to flag suspicious accounts. For instance if you submit "11111" then "11112" then "11113" on up through "99999"
More ›