HackerTrans
TopNewTrendsCommentsPastAskShowJobs

apavlo

no profile record

comments

apavlo
·4 months ago·discuss
For those that are unaware, the instructor of this is on the board of OpenAI:

https://openai.com/index/zico-kolter-joins-openais-board-of-...
apavlo
·6 months ago·discuss
> I'd love to hear about semantic layer developments in this space (e.g. Malloy etc.)

We also hosted Llyod to give a talk about Malloy in March 2025:

https://db.cs.cmu.edu/events/sql-death-malloy-a-modern-open-...
apavlo
·6 months ago·discuss
> How is SpacetimeDB not mentioned here?

https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-re...
apavlo
·6 months ago·discuss
> none of the reviews of the last few years mention immutable and/or bi-temporal databases.

We hosted XTDB to give a tech talk five weeks ago:

https://db.cs.cmu.edu/events/futuredata-reconstructing-histo...

> Which looks more like a blind spot to me honestly.

What do you want me to say about them? Just that they exist?
apavlo
·6 months ago·discuss
> Am I living in a bubble?

There are rumblings that the MySQL project is rudderless after Oracle fired the team working on the open-source project in September 2025. Oracle is putting all its energy in its closed-source MySQL Heatwave product. There is a new company that is looking to take over leadership of open-source MySQL but I can't talk about them yet.

The MariaDB Corporation financial problems have also spooked companies and so more of them are looking to switch to Postgres.
apavlo
·6 months ago·discuss
> Nothing about time series-oriented databases?

https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-re...
apavlo
·6 months ago·discuss
> I can't believe that article has no mention of SQLite ??

https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-re...
apavlo
·6 months ago·discuss
Thanks for catching this. Updated: https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-re...

I need to figure out an automatic way to track these.
apavlo
·9 months ago·discuss
> If the org behind it ever decides to rugpull/elastic you

I love it that you use "elastic" as a verb here.
apavlo
·9 months ago·discuss
> so... you take 10%-30% performance hit _right away_, and you perpetually give up any opportunities to improve the decoder in the future.

The WASM is meant as a backup. If you have the native decoder installed (e.g., as a crate), then a system will prefer to use that. Otherwise, fallback to WASM. A 10-30% performance hit is worth it over not being able to read a file at all.
apavlo
·9 months ago·discuss
The backstory is complicated. The plan was to establish a consortium between CMU, Tsinghua, Meta, CWI, VoltronData, Nvidia, and SpiralDB to unify behind a single file format. But that fell through after CMU's lawyers freaked out over Meta's NDA stuff to get access to a preview of Velox Nimble. IANAL, but Meta's NDA seemed reasonable to me. So the plan fell through after about a year, and then everyone released their own format:

→ Meta's Nimble: https://github.com/facebookincubator/nimble

→ CWI's FastLanes: https://github.com/cwida/FastLanes

→ SpiralDB's Vortex: https://vortex.dev

→ CMU + Tsinghua F3: https://github.com/future-file-format/f3

On the research side, we (CMU + Tsinghua) weren't interested in developing new encoders and instead wanted to focus on the WASM embedding part. The original idea came as a suggestion from Hannes@DuckDB to Wes McKinney (a co-author with us). We just used Vortex's implementations since they were in Rust and with some tweaks we could get most of them to compile to WASM. Vortex is orthogonal to the F3 project and has the engineering energy necessary to support it. F3 is an academic prototype right now.

I note that the Germans also released their own fileformat this year that also uses WASM. But they WASM-ify the entire file and not individual column groups:

→ Germans: https://github.com/AnyBlox
apavlo
·10 months ago·discuss
> • Memory-Mapping (mmap): We treat the database file as if it’s already in memory, eliminating the distinction between disk and RAM.

Ugh, not another one...
apavlo
·10 months ago·discuss
You are conflating MySQL and InnoDB. The latter does a lot of good things, much more than the former.
apavlo
·4 years ago·discuss
Yes, of course it's me.

Apply anyway and let's chat.
apavlo
·4 years ago·discuss
If you are a disillusioned PostgreSQL or MySQL DBA and are looking for a way out, then we have a job for you! We are looking for a plucky individual that wants to help us spread the message on how to use ML to automatically manage and configure databases.

* Developer Relations Engineer: https://jobs.lever.co/ottertune/486e1fdb-ceb6-44d4-872f-c66e...

This is a super important position to us, so you can email me directly if you want to discuss: [email protected]
apavlo
·4 years ago·discuss
OtterTune | Full-time | Remote (US/Canada) | https://ottertune.com

OtterTune is a database optimization-as-a-service company. We use ML to automatically improve the performance of MySQL/PostgreSQL databases running on Amazon. We are a remote-first company. We are backed by Accel and the co-founders of Snowflake, DataBricks, SingleStore, CockroachDB, and Duolingo.

* Senior Front-End Engineer: https://jobs.lever.co/ottertune/ad9948ce-a542-4189-bd49-0bf3...

* Developer Relations Engineer: https://jobs.lever.co/ottertune/486e1fdb-ceb6-44d4-872f-c66e...

* Solutions Architect: https://jobs.lever.co/ottertune/0b14fbe7-d8b2-4d46-91fd-a6e7...

* UI/UX Designer: https://jobs.lever.co/ottertune/0b14fbe7-d8b2-4d46-91fd-a6e7...

* Director of Operations: https://jobs.lever.co/ottertune/2d077acf-7390-498c-9137-fa9e...

Legit compensation + equity. 401k w/ matching. PTO + sickdays + paid FMLA.

We are also hiring for many other roles: https://ottertune.com/careers/

Email us if you have questions: [email protected]