a curated list of database news from authoritative sources

January 23, 2023

For systems, research is development and development is research

The Conference on Innovative Data Systems Research (CIDR) 2023 is over, and as usual both the official program and the informal discussions have been great. CIDR encourages innovative, risky, and controversial ideas as well as honest exchanges. One intensely-discussed talk was the keynote by Hannes Mühleisen, who together with Mark Raasveldt is the brain behind DuckDB.

In the keynote, Hannes lamented the incentives of systems researchers in academia (e.g., papers over running code). He also criticized the often obscure topics database systems researchers work on while neglecting many practical and pressing problems (e.g., top-k algorithms rather than practically-important issues like strings). Michael Stonebraker has similar thoughts on the database systems community. I share many of these criticisms, but I'm more optimistic regarding what systems research in academia can do, and would therefore like to share my perspective.

Software is different: copying it is free, which has two implications: (1) Most systems are somewhat unique -- otherwise one could have used an existing one. (2) The cost of software is dominated by development effort. I argue that, together, these two observations mean that systems research and system development are two sides of the same coin.

Because developing complex systems is difficult, reinventing the wheel is not a good idea -- it's much better to stand on the proverbial shoulders of giants. Thus, developers should look at the existing literature to find out what others have done, and should experimentally compare existing approaches. Often there are no good solutions for some problems, requiring new inventions, which need to be written up to communicate them to others. Writing will not just allow communication, it will also improve conceptual clarity and understanding, leading to better software. Of course, all these activities (literature review, experiments, invention, writing) are indistinguishable from systems research.

On the other hand, doing systems research without integrating the new techniques into real systems can also lead to problems. Without being grounded by real systems, researchers risk wasting their time on intellectually-difficult, but practically-pointless problems. (And indeed much of what is published at the major database conferences falls into this trap.) Building real systems leads to a treasure trove of open problems. Publishing solutions to these often directly results in technological progress, better systems, and adoption by other systems.

To summarize: systems research is (or should be) indistinguishable from systems development. In principle, this methodology could work in both industry and academia. Both places have problematic incentives, but different ones. Industry often has a very short time horizon, which can lead to very incremental developments. Academic paper-counting incentives can lead to lots of papers without any impact on real systems.

Building systems in academia may not be the best strategy to publish the maximum number of papers or citations, but can lead to real-world impact, technological progress, and (in the long run even) academic accolades. The key is therefore to work with people who have shown how to overcome these systemic pathologies, and build systems over a long time horizon. There are many examples such academic projects (e.g., PostgreSQL, C-Store/Vertica, H-Store/VoltDB, ShoreMT, Proteus, Quickstep, Peloton, KÙZU, AsterixDB, MonetDB, Vectorwise, DuckDB, Hyper, LeanStore, and Umbra).


An effective product manager

There are three specific activities I have loved in some product managers I've worked with (and missed in others).

tldr;

  • Talk with customers and prospects
  • Develop and share a vision
  • Evangelize

Talk with customers and prospects

As a product manager, your superpower over engineering is to have spent time with customers and prospects. You should have (or develop) a good understanding of the market and your product's potential.

The only way you can do this is by spending time, over time, with customers and prospects. Understanding their workflows and their issues.

Develop and share a vision

Cynical folks will cringe at the word "vision" but it is a serious and necessary part of a successful organization.

As a product manager, you should establish and share a path for engineering to follow based on your understanding of customers, prospects, the market, and the company.

This is the "roadmap" and "prioritization". But prioritization is useless without a long-term vision.

The roadmap should represent (and broadly demonstrate) a concrete and meaningful goal. A goal that you can and should adjust over time as the company and market changes.

Evangelize

In bigger organizations there might be dedicated evangelism teams. But product managers must drive this work.

Evangelism should fit the vision you've developed.

And in the absense of dedicated evangelism teams, product managers should be creating demos, writing blog posts, and testing the solution with customers and prospects.

Again, it's fine for dedicated teams outside of product management to do bits of that work. But it must be driven and led by the product manager.

It's hard

Observed as I have from outside, being an effective product manager feels like a massively challenging task.

It's so easy to go without talking to customers, to get sucked into day-to-day issues and not create a vision, and to allow evangelism to happen ad-hoc.

Then there's the fact you don't live in a vacuum. You may have a boss in product management. Your engineering peers may have competing priorities. You may have a hard time understanding the founders or CEO. In a large company, you may not even have a CEO.

My ideas, your ideas

These are my ideas based on my experience. You may have your own ideas. If mine help you, great! If they don't, great!

January 18, 2023

January 12, 2023

The year in books: 2022

In 2022 I finished 20 books spanning 15,801 pages. 3 more than I read in 2021, but about twice the number of pages. 3 fiction and 17 non-fiction. Another ~30 started but not finished.

I had a hard time reading books while I was trying to start my own company. But I also discovered audiobooks. I would put on a book and listen while I did my chores. Only 5 of the 20 books I finished were physical (or kindle) books. The other 15 were audiobooks.

Non-fiction: 13 to recommend

After I started read Robert Caro's Master of the Senate I got hooked on history and felt less daunted about larger books.

The only non-fiction I read in 2022 was US and UK history.

Here were my favorites:

  • Master of the Senate by Robert Caro: Covering more than just Lyndon B. Johnson but the history of the Senate and the Civil Rights movements in the US. This book is now on my list of best books.
  • The Last Lion: Winston Spencer Churchill: Visions of Glory, 1874-1932 by William Manchester: First in a three-volume series about Churchill. He's an especially interesting guy to read about because he served in UK politics 1901 to his retirement (for the second time) as UK Prime Minister in 1955. He was First Lord of the Admiralty in World War 1 before he, more famously, become Prime Minister during World War 2. This entire series is on my list of best books.
  • The Autobiography of Martin Luther King, Jr.: Sad and revealing. Though it doesn't talk much about his legacy since it only includes his writings.
  • Passage of Power by Robert Caro: Covering LBJ's pathetic failed attempts at the presidency before becoming JFK's Vice President, up to JFK's assassination. Still a very good book. I can't wait for Caro's final book to come out.
  • Truman by David McCullough: I always thought Truman was a lame nerd but he actually had a very interesting life (and as I'd later discover, is far from the lamest president. Wilson hands down takes that place.) And unlike most other famous politicians I read about, he had a great relationship with his wife. He was honest and respectable and was the first US president to normalize relations with Mexico since the Mexican-American War (that U.S. Grant and Robert E. Lee fought in the 1840s).
  • The Last Lion: Winston Spencer Churchill: Alone, 1932-40 by William Manchester: The second book in the series. Pretty depressing because it's a decade of Churchill noticing Nazi German behavior and stressing UK preparedness and the UK ignoring him and Nazi Germany.
  • The Last Lion: Winston Spencer Churchill: Defender of the Realm, 1940-1965 by William Manchester: The final book in the series, covering his Prime Ministership.
  • Eleanor Roosevelt, Volume 1: The Early Years, 1884-1933 by Blanche Wiesen Cook: Her background and many problems, as the daughter of Theodore Roosevelt's brother and later husband of their distant cousin, is pretty hard to relate to. Still it was quite interesting to hear about her life and early activities how she became such an outspoken progressive activist from being quite conservative.
  • Abraham Lincoln: A Life, Volume One by Michael Burlingame
  • Abraham Lincoln: A Life, Volume Two by Michael Burlingame
  • Grant by Ron Chernow: Among famous generals of the Civil War, somehow Robert E. Lee and Stonewall Jackson came to mind to me more readily than Grant. I'm glad I read this book because the popularity of Southern generals today seems like revisionism. This book makes strong arguments that while Lee was a great officer, he could only think in terms of short-term tactics and the Virginia region. Whereas Grant was the first (US, anyway) officer to consider and command (via telegraph) all theaters of war at once, every day. And this book redeems his presidency somewhat. His progressive adoption of freed Black people and work to make them equal citizens is highly commendable. Even with the horror of what happened in the South after the war ended.
  • The Rise of Theodore Roosevelt by Edmund Morris: First in a three-volume series about the 26th President. I read somewhere that it can feel impossible to read a bad biography of Roosevelt because he was such an interesting human. That may be true. This book didn't disappoint. Roosevelt growing up in a townhouse in Manhattan, going to Harvard, buying a farm on Long Island is all hard to relate to. His Puritanical morals and machismo were also difficult to get past. But he was a very interesting guy.
  • Theodore Rex by Edmund Morris: Second in the series, covering the entirety of Roosevelt's presidency. Like the first volume, a great read. I always used to think Roosevelt was a pure war-monger. But he helped avert war with the UK and Germany over Venezuelan debt-default. And he later received the Nobel Peace Prize for mediating peace between Japan and Russia in 1905.

Fiction: 1 to recommend

Of the three I read last year, I really enjoyed one:

  • The Leopard by Giuseppe Tomasi di Lampedusa: A gentle piece of historical fiction set during the 1860s in Sicily during and after the unification of Italy. I learned about this book from a Rick Stein episode in the Mediterranean Escapes series.

January 11, 2023

January 10, 2023

January 05, 2023

Supabase Beta December 2022

This month the Beta Update is a Launch Week 6 Special, where we review the cascade of announcements.

January 04, 2023

Faster MySQL with HTTP/3

In this article we explore how our HTTP/3 API compares to the latency of a traditional MySQL client.