Icathian

11 ms·

91.
by Icathian 3y ago
Fascinating exploit, and a good write-up. Not that you'd expect anything less from the Openwall pedigree. Really cool stuff, thanks for sharing!
92.
by Icathian 3y ago
Donno about a bug Id, but there were a couple mailing list discussions. Here: https://www.postgresql.org/message-id/flat/1376149.167526827... Disclosure: I reported this particular bug. It was a fun one to run do
93.
by Icathian 3y ago
Little known bug, but enums also choke dump/restore if you use them as a hash partition key. That said, they can be really nice for all the same reasons static types are nice. Good article!
94.
by Icathian 3y ago
I must have missed all the nuanced judgment in your original post. Maybe you can quote some for me.
95.
by Icathian 3y ago
Uh. Heikki is definitely not just "some guy". Dude is one of the top contributors to Postgres.
96.
by Icathian 3y ago
Some interesting discussion on this here also: https://news.ycombinator.com/item?id=36284487
97.
by Icathian 3y ago
I use nvim-dap for python and go multiple times a week. It's basically the same as VSCode's debugger and I'm a huge fan.
98.
by Icathian 3y ago
That's really not right. Andres Freund and Robert Haas at least are pretty clearly theoretically in support (which is all anyone can offer at this point). Those are some big names to have in the "aye" column.
99.
by Icathian 3y ago
Postgres in particular has many other processes that do a ton of bookkeeping and maintenance. Autovacuum, checkpointer, walwriter, etc. Each of these having process overhead and also having to deal with shared memory is probably the targe
100.
by Icathian 3y ago
There have been a good handful of those. Greenplum is much older, PostgresPro was 2015. I'm sure there have been others too. Edit: I hadn't heard of Oriole. Neat!
101.
by Icathian 3y ago
Pretty neat pitch by a very prolific PostgreSQL hacker about refactoring from the current multiprocessing architecture to a multi-threaded one. I don't know how it'll play out but personally I think it looks promising.
102.
Let's make PostgreSQL multi-threaded(postgresql.org)
56 points by Icathian 3y ago|26 comments
103.
by Icathian 3y ago
I am very curious but my search-fu has failed me. What was the requirement? Is there a link or jargon file or something I could read? I love this kind of stuff. Thanks!
104.
by Icathian 3y ago
Can we please get the title put back, the weird anti-Rust clickbait does a disservice to an excellent podcast. The original title was The Future of Programming With Richard Eisenberg. @dang
105.
by Icathian 3y ago
I think you are drastically overestimating the ability of most devs to write performant code. Do you really think you're going to get better results asking devs who, by your measure cannot write good declarative SQL schemas and querie
106.
by Icathian 3y ago
You can set autovacuum reloptions on a per-table basis, if they differ that much for your your use case.
107.
by Icathian 4y ago
People talk about its slowness, but I've got mine pretty damn kitted out and it's still faster than VSCode, VStudio, and JetBrains products. It's not as fast as vim, I'll admit, though.
108.
by Icathian 4y ago
My understanding was that the sqlite test suite is closed source, and kept under pretty tight grip as it represents their competitive advantage to anyone trying to fork sqlite. Pretty sure the lead dev said something along those lines when
109.
by Icathian 4y ago
Georgia Tech's OMSCS comes in at about $7k total. I think that's a good place to start.
110.
by Icathian 4y ago
Self-paced is the tough ask. Part of the value of formal schooling is the forcing function of deadlines to make you actually spend the time and absorb the material.
111.
by Icathian 4y ago
There was a really great podcast called The Downtime Project that dissected and discussed a postmortem in each episode. There were like a dozen episodes in the first season and they never did make a second one. Pity, I really, really liked
112.
by Icathian 4y ago
Honestly just practice. They cost me an interview I really wanted once, so now anytime I stumble across one in a project I take extra time to read and understand it. I also make a point of using bitmasks as function arguments in places wher
113.
by Icathian 4y ago
Appreciate the nudge! I use magit daily and it's awesome. I tossed the project some cash, I'd have paid at least that much for it. Thanks for making it for everyone!
114.
by Icathian 4y ago
I'm working on a pretty huge go project with lsp and a ton of bells and whistles and haven't had it noticeably lag on anything. Out of curiosity how big were the files/projects in your case? Did you have some other super hea
115.
by Icathian 4y ago
This is hyperbole at best. There are entire swathes of the country, both rural and suburban, with plenty of safe places for kids to exist.
116.
by Icathian 4y ago
Dreadnought and Fractured Space both deserved better than they got. Makes me sad I can't just go hop on games anymore, they were a lot of fun.
117.
by Icathian 4y ago
Would you mind ballparking how many applications you've put out, and to what kinds of companies? That's super concerning to hear.
118.
by Icathian 4y ago
I think you nailed it's and it's the same reason I fled data work to backend and now systems work. Endless bickering about which metric goes on which page and whether we're correctly capturing the concern of the month was dri
119.
by Icathian 4y ago
Awesome, I'll play with this a bunch on Monday. Thank you!
120.
by Icathian 4y ago
Mind sharing that? Merge resolver view is the only thing I'm still opening vscode for and I'd be very happy to finally kill that off.

More ›