mble_

6 ms·

1.
by mble_ 4mo ago
PlanetScale | https://planetscale.com/ | Software Engineer - PlanetScale Postgres | Remote (AMER, LATAM & EMEA) | Base range: $120,000 - $290,000 USD I'm the hiring manager for this position. Come build the best Po
2.
by mble_ 2y ago
Why not both? There are times when pushing the work down to the database layer is appropriate - databases are quite good at a lot of these operations - but if you need more nuanced approaches (e.g. ANOVA, ARIMA, other kinds of forecasting o
3.
by mble_ 2y ago
> I just think we must have completely different working experiences. Likely! I've generally worked in smaller orgs (including as part of a much larger org, as with my current employer) and there is less access to dedicated resource
4.
by mble_ 2y ago
Agreed, if you have the budget for it. There are often times where living off the land is necessary.
5.
by mble_ 2y ago
Author here. One of the main things here is that you should know your data well enough to articulate the right request from BI. In my experience, BI often end up as pure order takers - if you ask the wrong question, you get a lovingly forma
6.
by mble_ 2y ago
Oh, very cool. I'll have to add this to my list to check out next year.
7.
by mble_ 2y ago
Pinot is something I haven't had any personal experience with, so that's why it wasn't on the list - same with StarRocks, or Druid. Something for me to look into next year, clearly.
8.
by mble_ 2y ago
I love Datalog, but its such a niche technology. If I had included it, I would have probably swapped out TigerBeetle for it.
9.
by mble_ 2y ago
> What people usually do for HA with PostgreSQL or do they just not care about it? Patroni for most cases. At Heroku we have our own control plane to manage HA and fencing which works very reliably. I also like the approach the Cloud Nat
10.
by mble_ 2y ago
Apache Cassandra would probably be the most notable one (outside of Kafka etc).
11.
by mble_ 2y ago
It was not intentional. I've corrected this oversight, and attribution is now provided - my apologies.
12.
by mble_ 2y ago
I lived through the MongoDB hype cycle. For document databases, I'm more interested in things like PoloDB and SurrealDB.
13.
by mble_ 2y ago
Still very much "open-source": https://github.com/cockroachdb/cockroach But relicensed to the "CockroachDB Software License" as a form of BSL to prevent reselling.
14.
by mble_ 2y ago
Yeah, this is the bit for me. We have almost no good OSS layers for folks to "plug and play". Its a bit of a vicious circle - because there is low exposure, no one is building those layers. Because no one is building the layers, t
15.
by mble_ 2y ago
Definitely doesn't replace databases, at least LLMs as they currently are. We're going to be stuck with relational algebra for a long time to come, but the interfaces to interact with store might change over time from SQL to more
16.
by mble_ 2y ago
I didn't want ClickHouse to take all the glory. /s The actual reason is that DuckDB's API and integration into other places (e.g. Evidence) and its use of extensions (like the aforementioned gsheets one) gives it priority for
17.
by mble_ 2y ago
Author here. Thanks for sharing! My choices are pretty coloured by personal experience, and I didn't want to re-tread anything from the book (Redis/Valkey, Neo4j etc) other than Postgres - mostly due to Postgres changing _a lot_ o
18.
by mble_ 2y ago
Author here. I deliberately didn't include one because I'm waiting for the dust to settle a bit. There is a lot of activity in the space, from things like TurboPuffer (proprietary), Postgres extensions like VectorChord and pgvecto
19.
by mble_ 3y ago
Hey, I wrote this! Thanks for all the additional warm feelings about Lua on its 30th birthday year. I have a "second part" in the works on this about implementing something a little more advanced in Lua, and some more exploration
20.
by mble_ 3y ago
Hey, I wrote this! Happy to answer Qs about stuff I've learned for operating and being responsible for ETOOMANY Postgres, MySQL, Redis, Kafka, Cassandra and OpenSearch installs over the years.