pjungwir

10 ms·

61.
by pjungwir 4y ago
\x is great but I'm even more fond of \gx, which transposes the last query you ran but leaves the setting as it was before. So it's very handy if you don't plan ahead. You can also use \gx in place of the semicolon, so you do
62.
by pjungwir 4y ago
A trick I've used for 20+ years that I think helps me put in ~8 hours of real work per day is to reserve some easy tasks for "after lunch work". It doesn't have to be literally after lunch, but whenever your brain is tir
63.
by pjungwir 4y ago
Bell launched a video phone too, back in the 60s. You can read about it in The Idea Factory , which is full of fascinating history. That book attributes the failure to people not wanting to be seen. I've worked with people who definit
64.
by pjungwir 4y ago
I see this pattern all the time in mssql code, but hardly ever elsewhere. I've always wondered if there is a reason for that. Are you coming from that background? I'm curious if anyone knows why it is so favored there? I'm no
65.
by pjungwir 4y ago
This sounds like a very nice system, and I'll give it a try. I'm already using git to keep things synced between my desktop and my laptop. I've never even attempted syncing to my phone, but if I do that giving access to only
66.
by pjungwir 4y ago
I use a mix of pass(1) and LastPass, but this incident has convinced me to put everything on pass. But I don't really use it the "recommended" way, where you put the password on the first line. It's not a great fit for a
67.
by pjungwir 4y ago
s/security/scrutiny ?
68.
by pjungwir 4y ago
This is what I have in my ~/.vimrc: " https://vi.stackexchange.com/questions/6/how-can-i-use-the-undofile if !isdirectory($HOME."/.vim") call mkdir($HOME."/.vim&q
69.
by pjungwir 4y ago
No, Ctrl-Z Ctrl-Z still undoes the last two edits. Basically Ctrl-Z is now "rewind" and Ctrl-Y is now "fast forward". Instead of a stack you have an append-only list. Even Ctrl-Z appends to the list. (I'm eliding th
70.
by pjungwir 4y ago
I'm still hoping to use multiranges to add temporal tables to Postgres, but life has been busy the last year. I apologize to you all for the delay. The coolest application of multiranges I've heard about is for astronomical observ
71.
by pjungwir 4y ago
That is a fun article, but they left out my favorite: the dial tone when someone hangs up. Speaking of phones, it's interesting to see movies' choices about the UI on mobile phones. Do they try to show something like a real phone,
72.
by pjungwir 4y ago
I was still curious about the translation quality, so I checked BMCR. Here is a review that praises the translation: https://bmcr.brynmawr.edu/2022/2022.09.40/ That's not really a surprise considering the hig
73.
by pjungwir 4y ago
Have you seen there is a "Landmark" Anabasis now? I don't know what the translation is like, but when I read Herodotus & Thucydides all the maps were a big help, and the appendices had lots of interesting bits of info. If
74.
by pjungwir 4y ago
My family bought a Tandy 1000 around 1985. I was eight years old and quickly started writing batch scripts and rudimentary BASIC games. My friend had a Tandy too and, being a musician, talked all the time about their "three-voice sound
75.
by pjungwir 4y ago
If you're interested in this, Hacker's Delight has several hundreds of pages of these tricks. The book picks up from a 1972 MIT memo called HAKMEM. For a database/web guy like me, reading it is just recreational, but that&#
76.
by pjungwir 4y ago
My kids are 13/11/9/7/3/1 and we homeschool. I took over math in September after the new baby came. I taught the four oldest from the Life of Fred series. The youngest was tearing through the books too fast, so at C
77.
by pjungwir 4y ago
One summer I had a job in the Penn library improving the catalog data for their medieval Latin manuscripts. The abbreviations were wild. Here is a handbook of them (which includes & = et and &-bar = etiam): https://core.a
78.
by pjungwir 4y ago
Oh I will surely buy this! This series of deep articles about Postgres index types looks like it's by the same authors, and is one of the few sources I've found that really goes into the data structures used: https://ha
79.
by pjungwir 4y ago
SEEKING WORK - Portland, OR or Remote I'm a full-stack developer with 20+ years experience. My specialties are deep Postgres consulting and web development in Rails/Django/React. Occasionally I write some C or Rust for perfor
80.
by pjungwir 4y ago
Post the salary range. From what I can tell DevOps is the hardest thing to hire for right now, and it commands the highest salaries. It's tough to find someone who can code and troubleshoot code problems, but also has all the skills of
81.
by pjungwir 4y ago
Oh this looks great! It reminds me of haml, where it is so much easier to see the structure of your file, and you avoid a whole class of dumb typo bugs. And I'm happy to see this doesn't serialize the arguments into json and back
82.
by pjungwir 4y ago
Doctor Dobb's Journal had a cool article once about using Prolog to prescribe medications, in particular avoiding conflicts with other prescriptions. It would have been in the early 2000s. According to the author, they used Prolog to
83.
by pjungwir 4y ago
It looks like you intended your first snippet to end with `return result` not `return i`, right? Mixing real-machine finitude with big-O theory often gives unexpected or unhelpful results. Once in an interview I argued that since hash table
84.
by pjungwir 4y ago
Thank you for writing this bit of history, Craig! I have a personal half-serious theory that it was Heroku that really gave Postgres its break-through popularity. I think life is often like that: after years & years of hard work, you ge
85.
by pjungwir 4y ago
This is what Tutorial D is, but it's never been widely adopted.
86.
by pjungwir 4y ago
This looks really cool! I think I found a few errors in the docs: 1. On https://hush-shell.github.io/intro/basic-constructs.html you say that `let x = array[5]` should panic, but the array has enough items. Perhaps you
87.
by pjungwir 4y ago
Postgres does. :-) At least if genetic algorithms count as AI. If there are a lot of tables in the query, Postgres will switch to its GEQO planner [0]. The hardest thing about planners is they need to make a decision fast. It would be silly
88.
by pjungwir 5y ago
These are necessarily bash functions, not executables, but here are two tools I'm proud of, which seem similar in spirit to vidir & vipe: # Launch $EDITOR to let you edit your env vars. function viset() { if [ -z &
89.
by pjungwir 5y ago
With vagrant, the guest's /vagrant directory is whatever host directory contains the Vagrantfile. Using that seems even easier than scp. You can also set up some other shared folder if you're less lazy than me.
90.
by pjungwir 5y ago
I wonder if all the recent work-from-home has changed anything? My reaction to the headline was, "Some of us never left." But then I've worked from home for seventeen years. If I drove to an office every day, I might prefer t

More ›