pjungwir

55 ms·

1. 451.▲
   by pjungwir 10y ago

   Wow, purchased, thank you! Code starts out tedious too but is worth it by the end. I guess for any technical subject you have to make sure you cover sufficient preliminaries to get all your readers up to speed.
2. 452.▲
   by pjungwir 10y ago

   I love this idea! I'm just a working programmer, but right now I'm trying to read through the highlights on research into temporal databases. People have been writing papers for 25-30 years, but it seems like not a lot has made it
3. 453.▲
   by pjungwir 10y ago

   Have you read Developing Time-Oriented Database Applications in SQL ? I am very fond of ranges (actually it's exclusion constraints that are the key addition IMO), but they are not even close to what I'd like to have. I want `PRI
4. 454.▲
   by pjungwir 10y ago

   Ha, I thought about RLS on system catalogs, but it's not supported. Here is a long thread about it: http://postgresql.nabble.com/Multi-tenancy-with-RLS-td586211... It is also possible to revoke privileges on pg_namespa
5. 455.▲
   by pjungwir 10y ago

   I've worked with Postgres, MySQL, Oracle, and SQL Server, and Postgres is my go-to choice. I can think of a few cons though: - Replication is harder to set up than MySQL. And there is no master-master replication like in MySQL. (Of cou
6. 456.▲
   by pjungwir 10y ago

   I hear people call moving the ssh port "security by obscurity" all the time. For instance: http://serverfault.com/questions/189282/why-change-default-s... http://serverfault.com/questions
7. 457.▲
   by pjungwir 10y ago

   SEEKING WORK - Portland, OR or Remote I'm a polygot, full-stack developer with 15 years experience. My specialties are Rails, Postgres, Chef, and Ember, although I'm comfortable on a variety of platforms. I am reliable, easy to wo
8. 458.▲
   by pjungwir 10y ago

   Do you feel that way about all ORMs or just ActiveRecord? How would you like it to be different?
9. 459.▲
   by pjungwir 10y ago

   Interesting connection! :-) As a web developer who has done mostly Rails for a long time, I default to ORMs. And it seems to me that the last 20 years of architecture theory boils down to "How do I put a layer in front of my database?&
10. 460.▲
    by pjungwir 10y ago

    After I wrote that comment I thought it might be worth submitting this Andl story to HN about Andl-on-Postgres: [0]. They write, "Relational expressions are converted into equivalent SQL and passed back to the Postgres SPI interface fo
11. 461.▲
    by pjungwir 10y ago

    Thought I'd submit this after leaving a comment about it here: https://news.ycombinator.com/item?id=11802900 I'm not involved in any way, but I heard about it from the author's activity on the Postgres mailin
12. 462.▲
    Andl, a relational language that is not SQL, is coming to Postgres(andl.org)

    272 points by pjungwir 10y ago|104 comments
13. 463.▲
    by pjungwir 10y ago

    I actually like SQL, but I'm glad people are willing to ask, "Can we do better?" I think for a working programmer, SQL is the only practical choice, but Tutorial D is an interesting attempt to improve (by C.J. Date, described
14. 464.▲
    by pjungwir 10y ago

    Since we're talking about Ubuntu, I would use the Ubuntu tools. They make it very easy to maintain several Postgres clusters side-by-side, e.g. /var/lib/postgresql/9.4/main vs /var/lib/postgresql
15. 465.▲
    by pjungwir 10y ago

    I've been trying out Phoenix, and it seems like the top contender for a Rails successor. It's not quite as fluent as Rails, but it's close. But I'm curious: since it is so much like Rails, won't it suffer from all t
16. 466.▲
    by pjungwir 10y ago

    Wow that sure is beautiful, and what luck! Does anyone know what the red flash was right in the middle, just above the water?
17. 467.▲
    by pjungwir 10y ago

    I think it's completely viable, although probably less so with VC funds. I plug this book a lot on HN, but in Managing the Professional Service Firm, David Maister talks about how a firm has 3 goals that must stay in balance: profit, j
18. 468.▲
    by pjungwir 10y ago

    There were sysadmins doing automation before people invented DevOps, and they had similar challenges: finding time for "projects" in between fixing the printer. A good book on this is Time Management for System Administrators by T
19. 469.▲
    by pjungwir 10y ago

    I gave a talk about handling errors in Node a few years ago: https://github.com/pjungwir/node-errors-talk At the time the solution was "use domains", but I think domains are deprecated now. It was painful eno
20. 470.▲
    by pjungwir 10y ago

    SEEKING WORK - Portland, OR or Remote I'm a polygot, full-stack developer with 15 years experience. My specialties are Rails, Postgres, Chef, and Ember, although I'm comfortable on a variety of platforms. I am reliable, easy to wo
21. 471.▲
    by pjungwir 10y ago

    I'm looking to transition from Rails to something more performant. Phoenix is at the top of my list, but these benchmarks worry me: https://www.techempower.com/benchmarks/#section=data-r12&hw=... https:/
22. 472.▲
    by pjungwir 11y ago

    I have similar thoughts. In the new SRE book[0], there is a history of Google's infrastructure automation, and in a way it started with tests: First they had Python scripts to do things on various machines. (It actually sounds a lot li
23. 473.▲
    by pjungwir 11y ago

    This is a fun way to think about it. A more "economics" way is that you value your time more when you have less of it, so you might sell the 9th hour at a higher price than you'd sell the first. And that's why workers in
24. 474.▲
    by pjungwir 11y ago

    I am happy using the command line and even prefer it to GUIs. I've always thought that Arch was a "project" distro, like having a car you work on every weekend. I spend enough hours fussing with systems already, so I want my
25. 475.▲
    by pjungwir 11y ago

    So even though this article is from early 2015, commenters here seem to confirm 14.04 is still bad. I've been feeling guilty lately for running 12.04 and am just waiting for a slow weekend to upgrade. I run Xubuntu and have no intentio
26. 476.▲
    by pjungwir 11y ago

    Here is the comment linking to the talk I mentioned: https://news.ycombinator.com/item?id=11448482
27. 477.▲
    by pjungwir 11y ago

    I'm a freelancer who always winds up as "the ops person", and I'm just waiting for my copy of this book to come from Amazon. I watched a video of a talk about this book---sadly I can't find it on Youtube anymore. A
28. 478.▲
    by pjungwir 11y ago

    If I had six months to research something, I'd work on temporal databases, starting with the book Developing Time-Oriented Database Applications in SQL. I'd look at the history of attempts to bring this into the SQL standard, incl
29. 479.▲
    by pjungwir 11y ago

    I'm curious what you thought of OpsWorks? I tried it a couple years ago, when it was really new, and it was pretty painful. I'd rather just run Chef myself on regular EC2 instances and Autoscaling Groups. I recall a lot of issues
30. 480.▲
    by pjungwir 11y ago

    That bugged me too, although it was such a fun article I didn't want to complain. :-) What he really means is that his first snippet is the identity function. Like x*1=x or x+0=x. Whatever it gets, it passes along unmodified. I think i