v0.8.3

Adding Dolt Integrated Support

[Download Desktop App Here]

Dolt is a version-controlled SQL database, enabling collaboration, branching, and merging of data like Git for databases. Outerbase Studio now support limited functionality for working with Dolt.

• Commit and view commit history
• Staged/unstaged changes
• Switch branch
• Create new branch
• Reset from commit

Dolt.4k.mp4

We will continue to add more support for Dolt. Let us know which feature you want us to implement for Dolt.

v0.8.2

• Adding the row count
• Multiple cell selection
• Improve the EXPLAIN for MySQL and Sqlite
• Add and edit trigger
• Massive improve on export. Support CSV, Excel, Delimited Text, JSON and SQL.
• MySQL Sandbox Playground from your browser

Multiple Cell Selection

Outerbase Studio now support multiple cell selection. This will open door for more flexiblity.

MultipleCellSelection.mp4

Now you can get the aggregate value of the selected cells.

More Export Options

We now support more export option

Full Changelog: v0.8.1...v0.8.2

v0.8.1

What's Changed

Table Size

We now display the disk size of tables for both MySQL and PostgreSQL, enabling users to quickly identify which tables consume the most storage space.

Better Explain Visual for MySQL

We’ve introduced an improved EXPLAIN Visualizer. While it’s still in early development and doesn’t cover all cases yet, it provides a solid starting point.

v0.8.0

We have been gradually releasing new features, but it's been a while since we last published a changelog. Here’s the changelog covering the updates from the 0.7.1 to v0.8.0.

Entity Relationship Diagram (ERD) support

You now can generate a beautiful Entity Relationship Diagram. Currently only work great with Sqlite-based database and MySQL.

Number of Rows and Column

Show the number of rows and columns on the query result tab.

Column Type Suggestion for MySQL

We provide a great support for column type selection when create or edit table column.

Other Changes

• Mass drop table
• Add Starbasedb (yet another Sqlite-based database)
• Add "USE" statement support for MySQL
• Export to Excel file

Adding MySQL Support

We’ve added support for MySQL! You can now connect to MySQL using our desktop app (https://github.com/outerbase/studio-desktop/releases/tag/v0.1.15). Please note that MySQL support is still in its early stages, and it will be our primary focus for future sequential releases.

Adding PostgreSQL

We also support PostgreSQL, though it’s still in its early stages. While functional, it’s not yet fully refined.

v0.7.1

Quality of life improvement

• We will fallback to rowid if there is no primary key
• Generate column cannot be edit
• Add duplicate rows
• Add commit and discard keybinding

v0.7.0

What's Changed

• [Major Feature] Add MySQL support
• Support ATTACH (this can be used via command line)
• Add small gutter highlight on statement user currently on
• LibSQL Studio now provides more customization for embed iframe
  • Override the theme color
  • Option to disable the light/dark more toggle button

Thanks to @rentalhost for various of improving:

• Added support for closing tabs with the middle mouse button
• Added a type mismatch indicator
• Use green color for texts
• Added ellipsis for large numbers, texts, and links
• Prevent visual glitch when entering field edit mode

We also have also redesign LibSQL Studio website.

v0.6.2

What's Changed

Features

• Allow user to view snippet of foreigner key data
• Allow user to hide selected column in table data
• Add support for Cloudflare D1
• Allow save sqlite file directly after open
• Allow reload sqlite file
• Allow user to format SQL
• Allow user to change SQL editor font size using (Cmd + "+", Cmd + "-")
• Add JSON editor and multi-line editor
• Add proper format of EXPLAIN QUERY PLAN

Improvement

• Improve tab dragging animation
• Add back button to go back to connection list
• Prevent navigation back when scrolling horizontally
• Add create script
• Prevent user from creating table with empty name and better error message when there is problem.

v0.6.0

We now support saving queries.

• If you store your connection using local storage, we will use IndexedDB to securely store your saved queries on your computer.
• If you store your connection on our server, we will persistently save it there. This is convenient if you use multiple devices and want to share your saved queries across them.

v0.5.1

What's Changed

• Add function tooltips
• Add sqlite playground. It is based on sql.js. It is good for practice and play around
• Group fts5 indexing table together
• Auto refresh schema if execute any SQL query that alter database schema

v0.5.0

What's Changed

• Add table constraints
• Multiple query result
• Export the whole query result
• Add row read and row written
• Show foreign key information on table column
• Support temporary session