Hacker News: davyjones

New comment by davyjones in "Why Use Postgres?"

davyjones — Mon, 01 May 2017 01:42:28 +0000

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'.

New comment by davyjones in "RethinkDB Postmortem"

davyjones — Wed, 18 Jan 2017 23:21:32 +0000

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

New comment by davyjones in "RethinkDB Postmortem"

davyjones — Wed, 18 Jan 2017 06:59:47 +0000

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.

New comment by davyjones in "Let Postgres Do the Work (2013)"

davyjones — Sun, 27 Nov 2016 01:01:50 +0000

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

New comment by davyjones in "Say hello to Google Allo: a smarter messaging app"

davyjones — Wed, 21 Sep 2016 19:41:46 +0000

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

New comment by davyjones in "My experience rewriting Enjarify in Rust"

davyjones — Mon, 19 Sep 2016 22:48:11 +0000

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.

New comment by davyjones in "Show HN: BedquiltDB – A Mongo-like JSON doc store built on Postgres"

davyjones — Wed, 20 Apr 2016 00:12:15 +0000

Maybe they started with hstore and replaced that over time.

New comment by davyjones in "Try PostgreSQL 9.5"

davyjones — Sun, 05 Jul 2015 06:29:01 +0000

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

New comment by davyjones in "Ask HN: Who's looking for a cofounder?"

davyjones — Mon, 29 Jun 2015 01:30:53 +0000

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

New comment by davyjones in "Suddenly, a leopard print sofa appears"

davyjones — Sat, 20 Jun 2015 22:10:39 +0000

gi/go

New comment by davyjones in "[dead]"

davyjones — Sun, 24 May 2015 00:12:58 +0000

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.

New comment by davyjones in "The World Religions Tree (huge visualization)"

davyjones — Sun, 10 May 2015 21:43:16 +0000

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.

New comment by davyjones in "Ask HN: What domain names do you have that you aren't utilizing?"

davyjones — Wed, 22 Apr 2015 00:42:13 +0000

pgaas.com

pgsafe.com

Was meant for postgres-as-a-service.

Minimalist Object Storage

davyjones — Sun, 19 Apr 2015 05:41:59 +0000

Article URL: http://minio.io/

Comments URL: https://news.ycombinator.com/item?id=9402153

Points: 1

# Comments: 0

Zubulake v. UBS Warburg

davyjones — Sun, 12 Apr 2015 02:03:46 +0000

Article URL: http://en.wikipedia.org/wiki/Zubulake_v._UBS_Warburg

Comments URL: https://news.ycombinator.com/item?id=9361759

Points: 1

# Comments: 0

New comment by davyjones in "Math for eight-year-olds: graph theory for kids"

davyjones — Sat, 11 Apr 2015 05:35:51 +0000

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

New comment by davyjones in "Ask HN: Which developers/programmers do you closely follow?"

davyjones — Wed, 08 Apr 2015 02:58:45 +0000

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.

Ask HN: Essay on naturals, rationals, irrationals, algebraics

davyjones — Fri, 27 Mar 2015 07:02:17 +0000

A while ago, I chanced upon a light mathematical essay that made the case that algebraics were the next 'logical' step after irrational numbers.

As I remember it, it built up steadily from natural numbers to rational to irrational to algebraics using equations.

Sadly I lost the link. If anyone remembers reading something like this and has a link, I would appreciate it very much.

Thanks!

ps. This was a mathematician(?)'s personal site. There were others essays on Maths too.

Comments URL: https://news.ycombinator.com/item?id=9275037

Points: 1

# Comments: 0

New comment by davyjones in "PostgreSQL Foreign Data Wrappers"

davyjones — Wed, 18 Mar 2015 23:37:40 +0000

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".

New comment by davyjones in "Valve's SteamVR solves big problems and poses bigger questions"

davyjones — Mon, 16 Mar 2015 05:08:02 +0000

> 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.