Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Shopify POS

shopify.com

Post reply on HN
Print view View original

121–124 of 124 posts

Re: Shopify POS

#121

Post by orenmazor »

beagle3 wrote: post #119
orenmazor wrote: post #117

Earlier quoted context omitted.

We started out with mondrian+mysql, but quickly had to drop mysql ("mysql is great until you want to put data into it and then get it back out again" - unattributed, to protect the guilty). Our primary work was with postgresql in the beginning. which, in my opinion, is a pretty solid database to work with overall. We did partition all of our dimension and facts tables, which helped a great deal. Aggregates were a pro…

With all due respect to pgsql, mondiran and mysql - you're using the wrong toolkit. You need a column store, like Vertica, kdb+, TimesTen (now Oracle?), Sybase anytime (I think that was what it was called). You can do very well at much, much lower cost in the Python world: pandas, PyTables, or even just straight numpy. Seriously, using any of these would make the report generation time basically zero, and you'd just…

I didn't make it clear in my response, and thats my fault. We actually dont use pg, mondrian, or mysql anymore.

We ended up with a golang solution that we use essentially like you would with a column store. It's very fast and extremely thin.

Re: Shopify POS

#122

Post by beagle3 »

scott_karana wrote: post #120
beagle3 wrote: post #119

Earlier quoted context omitted.

With all due respect to pgsql, mondiran and mysql - you're using the wrong toolkit. You need a column store, like Vertica, kdb+, TimesTen (now Oracle?), Sybase anytime (I think that was what it was called). You can do very well at much, much lower cost in the Python world: pandas, PyTables, or even just straight numpy. Seriously, using any of these would make the report generation time basically zero, and you'd just…

> ...you're using the wrong toolkit. You need... Ouch. Do you really feel so well acquainted with their internal design that you can use such strong language? It comes across as dogmatic.

I am only as familiar as orenmazor describes above.

Would you have said that if I urged him to get a hammer to hit on nails, rather than a screwdriver? It is about as dogmatic. (you can put nails into a wall with a large enough screwdriver - I've done it myself before when the nail was small enough and i had no hammer - but it's still the wrong toolkit)

Re: Shopify POS

#124

Post by munimkazia »

nickles wrote: post #72
munimkazia wrote: post #71

This looks like the sort of product that makes me wonder why no one thought of this before. Or has any other online e-commerce platform did something like this before?

Others have done this before. See Shopkeep POS, Breadcrumb by Groupon, Erply, Vend, Square, etc.

Ah. I guess I am pretty out of touch with the online payment systems world, as none of the international payment gateways work in India from a vendor's point of view.
Post reply on HN