lfittl

The issue is that you would be missing the tenant_id (or user_id) if you were to do `other_object.pages.find(params[:id])` (i.e. on something thats not directly below the user)

That is a problem in systems that expect the tenant_id to always be in the query, so you can locate which node the query needs to go to.

Thats a good question - there is nothing explicit for it, yet.

You could probably do it nonetheless with Rails' own has_many/belongs_to relationships for that sub-tenant, but the automatic adding of department_id into queries wouldn't happen.

Depending on what storage you end up using, that might matter or not. For example with Citus, you'd typically take the top-level tenant (customer_id) as a shard key, and just have all the departments of that tenant on the same node - so it would work fine.

Its a bit more complex than that unfortunately.

Since Rails isn't used to include something like a tenant_id, and doesn't support composite primary keys either, you'd have to always hand-write your SQL.

Feel free to take a look at the source - it effectively ends up being a default scope with some additional glue code.

Thanks for sharing - author here.

I've been working on this library for 2-3 months now, if somebody gives it a try let me know how it goes :)

I'd be happy to answer any questions as well.

Pretty sure the labor certification and prevailing wage requirement is on a county / city basis (i.e. somewhat related to the actual local wages), see also https://www.dol.gov/whd/immigration/h1b.htm

I've built my own system to handle it in Austria - its actually not that bad, once you automate it well enough.

Feel free to shoot me an email at lukas@fittl.com - happy to share notes and code.

We've evaluated it for our cloud database service, but ended up going back to ext4 due to memory management bugs.

In particular this one: https://github.com/zfsonlinux/zfs/issues/3645

Looks like you missed the window where Peter was answering questions, and I'm not a lawyer (so please talk to one!), but:

I think you could look into doing an EB1 green-card in the extraordinary ability category - the requirements are similar to the O-1 (just reviewed a bit more thoroughly), and it'd give your wife a work permit if you file the paperwork together. In theory that process can be done in ~3 months (for the EAD card, which would allow her to work) when you file the I-140 with premium processing.

See also https://www.uscis.gov/working-united-states/permanent-worker...

Do you mean timeseries data as in IoT/sensor data/etc, DevOps monitoring metrics (i.e. server load, app performance, etc), or something else?

Curious since I'm currently researching how PostgreSQL could do better in this space :)

I'll leave the initial questions to the Citus team, but re: CloudFlare this link might be helpful:

https://blog.cloudflare.com/scaling-out-postgresql-for-cloud...

Copying from https://github.com/citusdata/cstore_fdw#usage

  To load or append data into a cstore table, you have two options:
  
  You can use the COPY command to load or append data from a file, a program, or STDIN.
  
  You can use the INSERT INTO cstore_table SELECT ... syntax to load or append data from another table.
  
  Note: We currently don't support updating table using DELETE, and UPDATE commands. We also don't support single row inserts.

So I think you can certainly mutate tables, but the focus is on bulk-inserts, rather than individual append actions.

Fair point - I assume this will be merged together in some way (i.e. the Citus stuff building on top of the parallel scan infrastructure), but probably a better question to ask on #citus IRC / open a Github issue.

Some Postgres committers work on Citus as well (e.g. Andres Freud), so I'm sure this has been thought through before.

AFAIK all the parallel work done in 9.6 refers to parallel operations on a single node (but multiple cores).

This would be complimentary to what Citus does, which is distributing the load across multiple shard instances (each with their own cores, benefiting from the parallel work in 9.6).

To answer this more explicitly than the other comment: Yes, CoreOS is intended as the host system for containers.

Inside the Docker (or rkt) containers you can run whichever distribution or static binary you like.

The combination of CoreOS+Kubernetes+Docker+Alpine Linux (inside the containers) works pretty well in my experience.

I'd love for d3 to have great integration with React - whats your suggested approach?

https://github.com/FormidableLabs/victory seems most promising, but isn't really d3, more "d3-like".

What are your experiences with going from a successfully issued O-1 visa to an EB-1A?

Any lessons learned / things one should watch out for? (specifically around required evidence or RFEs that you got issued)

Thanks for your time! :)

Thanks for the thoughtful reply! Appreciate the work on performance, its essential and the main motivator to use Influx instead of Postgres.

I'll certainly revisit Influx once tsm1 is the default and backups are in :)

Re 0.8: As the other poster noted, I think it was related to histograms and/or derivatives - would have to go back to look.

The Influx team is doing great things - however from the perspective of someone who's tried using InfluxDB in the last few months for a production app:

I really, really wish they'd hire 2-3 more database engineers to focus on the actual timeseries database, not nice looking tooling around it.

Simple things like incremental backups are still not working as expected in recent releases. Useful features from the 0.8 series still haven't been ported. And tsm1 is a neverending effort it seems.

We've went back to Postgres for storing timeseries data since we didn't feel confident to use InfluxDB in production.

Unfortunate to hear - although there is (less violent) xenophobic behaviour in Austria that I'm worried about as well.

Yeah, agreed. Its all relative, thats why I used "affordable" instead of "cheap".

In my head I compare Vienna with London and the US (SF/NYC/etc) which are 2-3x as expensive, plus healthcare is worse.

Personal Preference: Vienna, Austria

I'm from there, but part of the reason why I keep coming back is cause its affordable to rent, even in the hip districts (600-700 EUR for 1br) + a great city to live + good bunch of startups + cheap for flying in/out. Prague is similar.

Also heard great things about Sofia, but haven't lived there (yet). And Berlin is of course a good option as well.

pganalyze (https://pganalyze.com/) - Performance Monitoring for PostgreSQL databases.

Its cool because:

We visualise the metrics & counters that are usually hidden away in PostgreSQL internal tables.

Plus we check that your database is fast and configured correctly.

Also: I'm a techie with a UX hat, and data visualisation and pattern matching is fun :)

And if you like languages, don't forget:

Why Arabic Is Terrific http://idlewords.com/2011/08/why_arabic_is_terrific.htm

(author here)

Yeah - I'm not 100% happy with it either. Initially I had Exploration, which is really what I mean (you open up the floodgates and look quickly at a lot of different ideas, before zooming in on one).

But that sounded kind of quirky/confusing when used for comparing it with Execution, as in Execution vs Exploration.

And after all, Ideation is also a valid word to use in this context.

Author here - thanks for the comment (and please don't worry about sharing stories, its true after all!)

This was a big problem/mistake we made back then (and which isn't obvious from the slides) - we just didn't let people try the product, since we didn't want to be a hosting company ourselves.

We did show demos to people and did pilots in a few cases, but it would have benefited us a lot to have a public installation where people could have tried out the product.

I'm sorry we didn't get to work together then - there was certainly a lot of interest that we managed (and filtered through) poorly.

Luckily I've learned from that (I hope!) :)

A similar template (although free) by Seedcamp & Brown Rudnick, mostly for covering IP rights and equity distribution + vesting: http://www.seedcamp.com/2011/09/seedhack-founders-collaborat...

Direct PDF link: http://www.seedcamp.com/main/wp-content/uploads/2011/09/Seed...

Similar project in 2010, with a better video camera and detailed description:

https://vimeo.com/15091562#at=0 (also by a dad with his son)

Another similar open startup bootstrapping blog: http://bootstrapchallenge.com/

Started with 10k GBP some months ago (to bootstrap fulltime) and keeps a spreadsheet of all expenses and income.

The big benefit of 30x500 that I've seen is the peer-group through the very active mailinglist.

Also a lot of good marketing/copywriting advice and feedback that you'd otherwise not get.

Whether you'd like to spend the money is another question of course.

Agreed, we've been using https://railsonfire.com/ for our private repos - good to see the competition heating up in the space.