Hacker News Reader

davyjoneson Why Use Postgres?

Careful with this if you want to use it for partitioning data (it was atleast true till 9.6 in my experiments). You will never hit the exclusion parameter and consequently end up scanning all the child tables in vain.

Hopefully the partitioning thing is soon fixed 'properly'.

davyjoneson RethinkDB Postmortem

Those fall under db authoring/modeling tools. https://github.com/pgmodeler/pgmodeler is a good pick.

davyjoneson RethinkDB Postmortem

I developed and use(d) pgxplorer (github.com/pgxplorer). So, I can tell you this: the best out there is psql (CLI). There exists no use case where a GUI is better than psql.

davyjoneson Let Postgres Do the Work (2013)

6 hours to 15 minutes here. This is with the right indices and stock install. I am sure an expert can do much better.

davyjoneson Say hello to Google Allo: a smarter messaging app

    Google something (often results in reading unrelated articles, "link dives", etc.)  <=====> Cache miss (?)

davyjoneson My experience rewriting Enjarify in Rust

Why is this getting downvoted? Please don't downvote if you disagree with this viewpoint. Rust has its reasons for is current form, which is OK! In general, the whole song and dance around GC is a hard problem.

I agree that the syntax is cryptic. I also think that programs are written by humans for human consumption (for accomplishing a certain task).

If you have a long term plan, you might want to factor in the talent pool, hardware cost, and tech debt. For your case, if that leads to Rust, so be it. Or if it means Python, that is fine too.

davyjoneson Show HN: BedquiltDB – A Mongo-like JSON doc store built on Postgres

Maybe they started with hstore and replaced that over time.

davyjoneson Try PostgreSQL 9.5

Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.

davyjoneson Ask HN: Who's looking for a cofounder?

Looking for a co-founder who has a strong ML background for SaaS business in retail/brick'n'mortar space.

davyjoneson Suddenly, a leopard print sofa appears

gi/go

davyjoneson [dead]

One way or the other, the company is looking after its interests. You will be reciprocating that when you find something better for yourself. They will understand.

I have quit, folks weren't too pleased, but I kept everything civil and professional. And I was successful in getting a recommendation.

davyjoneson The World Religions Tree (huge visualization)

Similar for Africa(n) which leads me to believe that the periphery covers only what is extant and only the roots of those are traced back to their origins.

davyjoneson Ask HN: What domain names do you have that you aren't utilizing?

pgaas.com

pgsafe.com

Was meant for postgres-as-a-service.

davyjoneson Math for eight-year-olds: graph theory for kids

Your write up on EC and tensors, I enjoyed it a lot. Thanks for the excellent effort!

davyjoneson Ask HN: Which developers/programmers do you closely follow?

Tom Lane on the postgresql lists. His breadth and depth of knowledge on the postgres code is mind boggling. And he takes equal effort in helping out on all lists...ranging from novice to hackers.

davyjoneson PostgreSQL Foreign Data Wrappers

file_fdw.

I have a file that keeps changing constantly. What was a file read/write at app level has been replaced. Less code, direct access to data and readily "ETL-able".

davyjoneson Valve's SteamVR solves big problems and poses bigger questions

> At least until we manage to fool the vestibular system as well as we can the eyes.

If we can trick the neurons on site, then might as well trick it right before it plugs in at the brain...in which case, we probably will have optics covered as well. Thence we can get rid of the headset altogether.

davyjoneson We use RethinkDB

I always do that. I have worked with Strategic Sourcing for a while...so... ;-)

davyjoneson We use RethinkDB

When I changed the country to Japan, the sticker price jumped from 2000 USD to 15,000 USD eq. for a very basic system. I am just at a loss as to what can explain this disparity. Guess I will have to call up my vendor to get a comparable quote.

davyjoneson Gravitational Lensing to Observe Ancient Earth

This was one of the first works I read that changed my perspective to focus on the human elements in science fiction as opposed to the bells and whistles.

davyjoneson Ceres' Deepening Mysteries

My crazy theory: naturally formed nuclear reactor.

davyjoneson Show HN: Interactive Essay on Signals, Sampling and the Fourier Transform

As a side note, the pressure that is waxing and waning in that diagram is very very small compared to atmospheric pressure.

The actual air molecules are moving at a much higher speed (the root mean squared velocity is dependent on the temperature). But if we imagine that these are weightless dust particles suspended in air, the diagram is accurate.

davyjoneson Ask HN: Freelancer? Seeking freelancer? (March 2015)

SEEKING WORK: MVP, Product Management, Engineering; Kansai area or Remote.

davyjoneson There exists a classical model of the photon after all

Usually a pretty common mistake. Fluid is always compressible (else sound won't travel in STP water). It is whether one chooses to model the flow as compressible or not.

davyjoneson How Likely Is It That Birth Control Could Let You Down?

> Don't want kids? Don't want to take chances? Don't have sex.

If you are done with predetermined quota, one can go under the knife and start shooting blanks at no bodily cost.

davyjoneson Authentication Cheat Sheet

The trick here is it not go to the reset page but to the signup page. Almost always, there is a message that indicates that the email id is already taken.

(which is why I think that indicating specifically, that the userid was incorrect or the password was, is better UX.)

davyjoneson Ask HN: How to get rid of speech anxiety?

There is self paced public speaking course on coursera.org.

davyjoneson I Almost Let My Failed Startup Destroy Me

I went cold turkey and it was very unpleasant. I cut it down gradually and it worked for me. Good luck!

davyjoneson Show HN: Comments by Top HN Posters Analysed by IBM's Watson User Modelling API

Master short story scifi writer Sheckley, R. has this covered:

Bad Medicine

http://www.gutenberg.org/files/9055/9055-h/9055-h.htm

davyjoneson Ask HN: Why are you stuck in a dead end job?

I mailed both of them. Got a reply from Buffer and it wasn't a template. The CTO had taken his time to look at what I had written and crafted an appropriate reply. I really really appreciated it.

On the other hand, I didn't even receive an acknowledgement from Heap, template or otherwise. It is fine, really. But I just want to get this out there as an addendum to your comment.