lfittl

12 ms·

91.
by lfittl 7y ago
You typically do it on a schedule, e.g. once per hour, or once every day. In the post the whenever gem ( https://github.com/javan/whenever ) is used, but you could use anything that is able to run things periodically. If
92.
Read/Write Splitting with Azure Postgres(techcommunity.microsoft.com)
5 points by lfittl 7y ago|0 comments
93.
by lfittl 7y ago
(not the author, but I've discussed this with him previously) This is a problem with `order` in Active Record in particular, where you can't pass in a bind variable the same way you'd expect it to work with `where`. Therefore
94.
by lfittl 7y ago
The "Clusters Created" metric seems to imply that every deployed database sends back tracking information to Yugabyte's servers. I've had to look a bit in the docs to find this page, which seems to confirm it: https:&#x
95.
The Engineering Manager/Product Manager Marriage(craigkerstiens.com)
3 points by lfittl 7y ago|0 comments
96.
Postgres tips for the average and power user(citusdata.com)
138 points by lfittl 7y ago|9 comments
97.
by lfittl 7y ago
This seems to be confirmed by the IOPS numbers in the documentation: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/storage-...
98.
The most useful Postgres extension: pg_stat_statements(citusdata.com)
4 points by lfittl 8y ago|0 comments
99.
by lfittl 8y ago
For what its worth, the HSR plan includes Caltrain electrification, which will eventually cut down SF to San Jose to ~45 minutes. And the state is bigger than just the Bay Area :-)
100.
by lfittl 8y ago
This overall seems like a very useful resource for EU-based founders. That said, their suggestion of "Seriously consider back-loaded vesting schedules" is employee unfriendly ( https://www.indexventures.com/blog&#x2
101.
Materialized views vs. Rollup tables in Postgres(citusdata.com)
40 points by lfittl 8y ago|8 comments
102.
by lfittl 8y ago
(author here) I had a very positive Postgres experience writing this, as I was able to find three separate bugs before the 11 release. Two of them have bugfixes merged already (JIT EXPLAIN bugs, auto_explain support for JIT) and a third has
103.
by lfittl 8y ago
Quality of the backbone matters - Hetzner is going for the cheapest it can find, and (presumably) peering where it can, with whomever it can find. AWS and GCP both have much more investment into their own backbone, plus higher quality trans
104.
by lfittl 8y ago
In case you're looking for something Postgres syntax compatible, and find cgo acceptable: https://github.com/lfittl/pg_query_go (this uses the actual Postgres parser wrapped into a library)
105.
by lfittl 8y ago
DocuSign's API is very frustrating to work with, as you can't go into production without getting their "approval" first. Amongst other things, the approval process requires you (or did require you when I last tried) to r
106.
by lfittl 8y ago
If you're primarily looking for pass-through taxation it might also be worth looking at electing your C-Corp to be treated as an S-Corp: https://www.irs.gov/businesses/small-businesses-self-employe... (not a tax a
107.
by lfittl 9y ago
Just in the off-chance this is useful to someone: If you find yourself needing the Postgres parser elsewhere, e.g. in some custom tooling to analyze SQL queries, I extracted it into a library some time ago: https://github.com&#x2
108.
Designing Your SaaS Database for Scale with Postgres(citusdata.com)
7 points by lfittl 9y ago|1 comments
109.
Guidance on Performing Retrospectives(craigkerstiens.com)
37 points by lfittl 9y ago|4 comments
110.
by lfittl 9y ago
Is it correct that the entrepreneur rule was reinstated by court order ( https://www.uscis.gov/news/news-releases/uscis-begin-accepti... ) so that entrepreneurs could actually file for this right now? (until they un
111.
by lfittl 9y ago
AFAIK its Monodraw: https://monodraw.helftone.com/ (I've asked Brandur this in the past, so assuming he hasn't changed it this should still be what he uses)
112.
by lfittl 9y ago
FWIW, this is fixed in the upcoming Postgres 10: "Reduce locking required for adding values to enum types (Andrew Dunstan, Tom Lane) Previously it was impossible to run ALTER TYPE ... ADD VALUE in a transaction block unless the enum ty
113.
by lfittl 9y ago
Thanks for the shout-out - I'm the author of the base library you listed that can be used to work with the Postgres parser (libpg_query). That said, the tool being discussed here (pev) is used to interpret EXPLAIN plans, which libpg_qu
114.
by lfittl 10y ago
Its supported in all regions as of January 25: https://aws.amazon.com/blogs/aws/aws-ipv6-update-global-supp...
115.
by lfittl 10y ago
No, you can't, unless I'm missing something: https://www.americanexpress.com/us/content/rewards-info/busi...
116.
by lfittl 10y ago
There are a few things, the most important ones: - Including the tenant_id in modification queries as well (e.g. UPDATE/DELETE) - Support for specifying the current tenant as an ID (through `MultiTenant.with_id(123) { ... }`) -
117.
by lfittl 10y ago
Let me start by saying that apartment is great - but it takes a different approach. The most important difference is that apartment shards by database or schema, vs activerecord-multi-tenant puts all your data into the same table, and then
118.
by lfittl 10y ago
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 alway
119.
by lfittl 10y ago
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 woul
120.
by lfittl 10y ago
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 lo

More ›