Hacker News Reader

gregn610on Show HN: Fire UK Calculator and Visualiser

Nice. Does GIA mean General Investment Account? Maybe some tooltips?

gregn610on Mounting your iPhone on your motorcycle can damage its camera (2022)

it's not just mounted iphones. An iphone doesn't fit in the motorcycle mount but an old oneplus does, so that gets mounted and iphone stays in my jacket pocket. Iphone camera is fubar, oneplus is working just fine.

gregn610on Google Translate “Get well [Swedish firstname]” translates to “fuck you”

But if you play with the name, the translation is different:

- krya på dig Helga - take care of yourself Helga

- krya på dig Dave - screw you dave

- krya på dig Mary - come on Mary

- krya på dig Linnéa - brace yourself Linnéa

- krya på dig Mohammad - fuck you Mohammad

gregn610on SQL + M4 = Composable SQL

I've found text manipulation of SQL can quickly degenerate into a nightmare of concatenation, nested quoting & escaping.

I wrote up Using plain Jinja[1] or SQLAlchemy+Jinja[2] as complementary techniques. The post is a bit dated but the principles should still work.

- [1](https://github.com/gregn610/plpgsql/wiki/meta-sql-with-pytho...)

- [2](https://github.com/gregn610/plpgsql/wiki/meta-sql-with-pytho...)

gregn610on Barnes and Noble’s Nook GlowLight 4e is a cheaper option to the Kindle lineup

Is there good e-ink tablet for reading Wattpad?

gregn610on 13 years sailing around the world

Good list, one more you might like:

https://youtube.com/c/FreeRangeSailing

gregn610on Making Open Source economy more viable with dual license collectives

Couldn't we mash something like [flattr](https://flattr.com/) into the package managers ( npm, pip, cpan etc.)?

That would give the companies/users an option of regularly contributing a fixed budget to x FOSS projects without having to track down who/where/how for each dependency. The org collecting the micro payments distributes once a month to project maintainers with commit privileges.

For static libs, the project maintainers recursively use the same mechanism, the money trickles all the way down the dependency tree.

gregn610on DIY Onewheel – open-source self balancing skateboard

Have you seen the original Australian bushpig?

https://youtu.be/0OV33C2JgIE

gregn610on But what about the bus factor?

That might work if just one project from each maintainers portfolio was shifted.

gregn610on PostgREST 9.0

Ha - I find unsubstantiated, parroted mantras like this to be a team lead smell :) In the same way that Agile development has become a mindless cult of rituals that has little to nothing left of the original manifesto's vision, code reviews peppered with thoughtless "code smell" comments have become the bane of development.

gregn610on Selling Tiny Internet Projects for Fun and Profit

not just an email, your linkedin profile is required too.

gregn610on Colonial Pipeline Paid Hackers Nearly $5M in Ransom

Numberphile did a episode[0] on this, there's legal precedent from 1816 called Clayton's case[1].

Basically tainting with FIFO.

[0](https://www.youtube.com/watch?v=UlLN0QERWBs)

[1](https://en.wikipedia.org/wiki/Devaynes_v_Noble)

gregn610on Bash code generator for command-line arguments

Awesome! I think it would be even better if it could generate from doctopt style definitions :p

gregn610on Impressive backyard engineering on an obscure YouTube channel

You'll love this one, Allen Millyard uses a hand hacksaw & his BBQ to make a Kawasaki Super Six and a Viper powered motorcycle. https://www.youtube.com/user/millyardviper

gregn610on PostgreSQL's Imperfections

yup, that's what I meant by authorisation, keeping the roles and groups in pgsql up to date.

gregn610on PostgreSQL's Imperfections

I'm surprised that no-one is complaining about the lack of Active Directory integration for authorization.

#disclaimer - Author of an AD integration solution that never got off the ground.

https://github.com/gregn610/padnag

gregn610on Coin found off northern Australia may be from pre-1400 Africa

there's a fascinating audio book called 1434 putting together a pretty convincing argument that many of the European "discoveries" where predated by Chinese.

http://www.gavinmenzies.net/

gregn610on Ask HN: What discontinued company/product do you wish was still around?

[powerbuilder](https://en.wikipedia.org/wiki/PowerBuilder), for business crud apps. i think was version 11 when it peaked before going all web/.net

gregn610on The Workman Keyboard Layout Philosophy (2010)

Very much this. This is the results for my personal bread and butter, python and SQL. Workman tested very much mid-pack.

http://patorjk.com/keyboard-layout-analyzer/#/load/FKcXzlQ2

gregn610on Nim partners with Status.im

Is there a transpiling / migration story for a python code base into Nim? I briefly looked at Nuitka to get to a dependency free binary from python but this could be another approach.

gregn610on PgModeler – PostgreSQL Database Modeler

Toad Modeler for modelling. Handles defered constraints, inheritance, keys etc. Very scriptable tho the scripting IDE isn't great.

gregn610on Toml: Tom's Obvious, Minimal Language

A killer feature of TOML compared to JSON is that it allows comments. A config file without comments and examples ain't great. I found the double square bracket syntax useful and understandable. Agreed it's not obviously .INI or perfectly elegant but it certainly works and has its use-cases. Anyways, thank you @mojombo!

gregn610on Alternatives to Google Products

That https://panopticlick.eff.org link was interesting, but I don't see what about my user agent string makes it so unique (1: 76540.09) ?

  Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.62 Safari/537.36

Looks fairly generic, I think I'm running a mainstream chrome browser on a mainstream OS.

gregn610on Duolingo Suddenly Has Over Twice as Much Language Learning Material

https://en.m.wikipedia.org/wiki/La_plume_de_ma_tante_(lingui...

Saved you a click

gregn610on PostgreSQL 10: Partitions of partitions

How is this better than inherited tables with indexes and constraints ala https://stackoverflow.com/a/3075248

gregn610on Message encryption a 'problem' – UK home secretary

"Wanton or Furious riding" is also an offence.

gregn610on How do you make programmers work 60-80 hours per week?

Agreed to a point, but there's also several hours a day of non-programming that just has to get done which never features in these SV conversations. Dealing with network guys to get the firewall exceptions you need, getting the DBA to actually do the indexes you asked for, endless ticket updates, meetings, more meetings, timesheets, checking the contractor's deliverables, production issues, interuptions etc. etc. Then add understaffing, UAC policies, sanfus and shifting requirements. So sure, 3 or 4 hours in the programming zone easily becomes a 55hr week.

gregn610on Ask HN: What are you working on?

A utility to sync PostgreSQL roles with Active Directory.

  http://padnag.io/

The closest thing I could find was a nightmare to deploy on linux, so I decided to fix that. It's getting really close to finished, I just need a few more hours in the day :p

gregn610on Voice Calls: Secure, Crystal-Clear, AI-Powered

Pied Piper, is that U ?

gregn610on Airflow and the Future of Data Engineering: A Q&A

If you enjoy making sure your peas don't touch the carrots, then sure, strong typing is great in the data space. But when you get woken up because a spreadsheet comes through as 11.0 rather than 11 or you have to type

    Double.parseDouble(x) == Double.parseDouble(y) 
    /* instead of pythons */ 
    x == y

27 times to get a feed file parsed, then I'd say that the tools are lacking basic useability. And especially primitive in light of the handwriting reading, photo tagging, go playing,supermario winning possibilities of ML.