— Each week, console reviews the best tools for developers. Subscribe

Retool Database

retool.com @retool

Managed Postgres database.

Relational database

Our review

What we like

Instant setup with easy schema-definition and predefined or custom field types - full access to all Postgres types. CSV import & export. Spreadsheet-like UI for searching, filtering, editing rows. Get a connection string for remote access. Query via SQL from within a Retool app. Redundancy & backup handled for you.

What we don't like

Designed for small use cases that don’t require high availability or scalability e.g. internal tools where it’s not a good use of time to manage your own database. Initial quota matches this - 5GB storage (can be increased on request).

Reviewed: 2023-06-15

Open source vs commercial (Appsmith & Retool)

with David Mytton & Jean Yang

S01 E06 — 2021-08-12

Highlights

David: One of the nice things about Retool is it allows you to query all the sources with SQL, even if they aren't databases. Appsmith and Retool both expose the UI so that everything is a JavaScript object. If you need more customizability, then you can just get into the code and you can even create your own react components with Retool. The main difference then is the philosophy behind how these are developed, so I thought it'd be interesting to have a discussion about that.

Developer Interview

With Snir Kodesh, Head of Engineering

2021-08-10

What is Retool and why did you build it?

Retool is the fastest way to build internal apps and tools. We all used to work on internal tools ourselves, and we realized that we were building tools that were quite similar. That’s how the idea for Retool came about.

Internal tools are not particularly desirable to write for most software engineers, in the sense that they don't really progress the art form of the business model. At least from my personal experience, they are a bit of a tax when you're building product: you build the internal tool in order to support that product in the wild.

This creates a good opportunity for us to effectively group the common pieces, and ship them as an abstraction. This is what Retool does— it allows people to build internal tools easily, in a highly accelerated way.

Every internal app has some sort of view and a connection to a datastore. Retool is a collection of drag and drop components that allow you to construct that front-end, and hook into your back-end. We also make all of that really simple. You can get what might take the order of weeks in just hours, and be set up with a tool and process that works out of the box. It's also beautiful, elegant, and a lot easier than writing everything from ground up.

Engineering Profile

Retool

https://retool.com

Build internal tools remarkably fast.

Retool’s goal is to build internal tools remarkably fast. Despite software’s massive impact on our lives, software development hasn’t fundamentally changed in the past two decades. At Retool, we’re thinking about what comes after programming languages: coding from scratch isn’t something most companies should be doing in 15 years. We’re starting with internal tools but our ambitions are much larger.

What are some recent examples of interesting development challenges?

Building a real-time app development environment and it’s natural extensions, for starters :) How do we support multiple concurrent users? How do we version control Retool apps and help our customers deploy them across environments? How do we support deep native integration to third party services (data warehouses, datastores, custom APIs, etc)? The surface area that powers Retool today is so vast, and we’re also innovating in adjacent areas!

The thing that’s most exciting about Retool is how much of a platform it is – just permuting components + resources + code + Retool versions by our customer leads to an unbounded set of possibilities. That’s fundamentally what allows our customers to build anything with the product. By extension, supporting it across all the permutations as we deploy at warp speed is a challenging infra/correctness problem.

There’s a lot more here – from building a best-in-class layout and drag-n-drop engine, running untrusted code safely, the tension between product extensibility/power and performance, and making Retool even more accessible and powerful.

About Console

Console is the place developers go to find the best tools. Each week, our weekly newsletter picks out the most interesting tools and new releases. We keep track of everything - dev tools, devops, cloud, and APIs - so you don't have to.