Repository navigation
TablePro for Linux 0.1.0-beta.4
Pre-release
Pre-release
·
5 commits
to main
since this release
Immutable
release. Only release title and notes can be modified.
Added
- Open SQLite files from the file manager's Open With, or with
tablepro file.sqlite3. (#3413) - Saved connections with groups, colours and TLS options, and passwords kept in the system keyring. (#3464)
- Keyboard navigation of the grid, and names and states for screen readers. (#3464)
- Table grid with filters, sorting and paging, editing in place, new and deleted rows, and undo until you save. (#3464)
- SSH tunnels through the system OpenSSH client, with your agent,
~/.ssh/config, jump hosts and host key checks. (#3464) - Desktop notification when a query, save or export finishes in a tab you are not looking at. (#3464)
- Query history with full-text search, and saved queries. (#3464)
- SQL Server sign-in with Kerberos, using the ticket from
kinit. (#3464) - Structure tab to change columns, indexes and foreign keys, with the SQL shown before it runs. (#3464)
- Troubleshooting in About TablePro, with the versions to paste into a bug report. (#3464)
- Open connections and their table, structure and SQL editor tabs reopen at the next launch. (#3464)
- Export to CSV, JSON, SQL, Excel, Markdown, HTML and XML, and import CSV. (#3464)
- SQL editor with completion, formatting, find and replace, a result per statement, and Stop. (#3464)
- Widen and narrow a grid column with Shift+Alt+Right and Shift+Alt+Left. (#3566)
- Commit and Roll Back beside an editor tab's open transaction, and a banner on the other tabs that names it. (#3697)
- Safe Mode per connection: Off, Confirm Writes or Read-Only. (#3706)
- TablePro is available in Vietnamese. (#3727)
- Open Referenced Row (Ctrl+J) and Show Referencing Rows in the cell menu open the rows a foreign key leads to. (#3797)
- Filters compare a binary column to a 0x hex value. (#3797)
- The SQL editor has Vim keybindings, turned on in Preferences, and :w, :e, :q and :wq act on the tab. (#3804)
- An MCP server lets AI clients on this computer use your saved connections, each with an External Clients level. (#3805)
- DuckDB files open from the connect dialog or a terminal, with tables to browse, edit and export. (#3806)
- Connect to Redis directly or through SSH, browse its keys by type and run its commands. (#3810)
- Connections take several named tags and an icon, and the connection list has a search that also matches tags. (#3811)
- Paste rows into a table with Ctrl+V or Paste in the cell menu, copied from a TablePro grid or a spreadsheet. (#3815)
- ER diagram of a schema's tables and foreign keys, with pan, zoom, movable tables and PNG and SVG export. (#3817)
- Connect to Apache Cassandra and ScyllaDB: browse keyspaces, page through tables and edit rows by their key. (#3818)
- Snippets in the SQL editor: built-in statements per engine and your own from a folder, with Tab between stops. (#3819)
- Connect to MongoDB directly, through SSH or by DNS seed list, browse collections in a grid and run shell statements. (#3820)
- Multiple cursors in the SQL editor, added with Ctrl+D, Ctrl+Shift+L, Shift+Alt+Up and Down, or Ctrl+click. (#3821)
- An AI assistant on Anthropic, OpenAI or Ollama that answers, explains, reviews and fixes SQL, and suggests as you type. (#3822)
- Find text in SQL results and key tabs with Ctrl+F. (#3836)
- Each table keeps its column order, hidden columns and widths, set from the header or the Columns dialog. (#3836)
- Filter a table by a cell's value, or exclude it, from the cell's menu. (#3836)
- Several connections open in one window, listed in a sidebar tree of groups, connections, schemas and tables. (#3856)
- Copy rows as a text table, JSON Lines, one row of SQL values, or INSERT statements without generated keys. (#3862)
- The data grid's row number header has a menu to select every row or choose the columns. (#3864)
- On MySQL and MariaDB, Structure sets the character set and collation of a table or column, and the next AUTO_INCREMENT. (#3866)
- Selecting rows shows the sum, average and count of the focused column, with every figure ready to copy. (#3877)
- The first launch after an update says so, with a What’s New button that opens About and its release notes. (#3878)
- Enum and set cells pick from a menu of the column's labels, in the grid and in Row Details. (#3880)
- Row Details sets a time, or a timestamp's time, from a clock beside the calendar. (#3881)
- Row Details shows a binary value as a hex dump, and an image as a picture above it. (#3882)
- Ctrl+E goes back to the tab shown before; hold Ctrl and press E again to go further back. (#3883)
- Importing connections first lists each one with its host, and nothing is saved until you choose Import. (#3892)
- An editor tab names its database, and its database menu moves the tab to another of the server's databases. (#3904)
- Open Database… on a PostgreSQL or SQL Server connection opens another of its databases beside it, with its own tabs. (#3905)
- Ctrl+Shift+O opens an overview of the window's tabs, where typing searches them and the menu closes them all. (#3930)
- Every other row of a data grid is shaded, with a switch in Preferences to turn it off. (#3932)
- Show or copy the CREATE INDEX statement for one index from the Indexes page of the structure tab. (#3964)
- The sidebar lists functions, procedures, sequences and triggers, and opening one shows its definition. (#3969)
- Move a grid column left or right from the keyboard with Alt+Left and Alt+Right, or from the cell and header menus. (#3974)
- A connection can set its own query timeout for the SQL editor in the connect dialog, in place of the one in Preferences. (#3977)
- A date, time or timestamp cell can be set to the database's current date or time, such as
NOW(). (#3982) - Favourite connections and the 5 opened last lead the connection list, and favourites can be reordered. (#4011)
- Connection groups nest up to 3 levels and can be renamed, deleted, and moved by drag and drop or from their menus. (#4011)
- SQL Server connections can use strict encryption (TDS 8.0), which servers set to Force Strict Encryption require. (#4012)
- Import connections and saved queries from another database app, after a review of what each one brings. (#4015)
- Ubuntu 22.04 and 24.04 and other distributions install TablePro and its updates from a signed Flatpak repository. (#4046)
- Betas install from their own PPA and COPR project, and each GitHub release carries the .deb, .rpm and a Flatpak bundle. (#4046)
- Searching the app grid or a software centre for MariaDB, Postgres or MSSQL finds TablePro. (#4046)
- Connect to PostgreSQL, MySQL and MariaDB on this computer through the server's Unix socket, with peer and socket logins. (#4048)
- Connect to a MongoDB replica set from its hosts and name, as a connection URL lists them. (#4048)
- Paste a connection URL at the top of a new connection to fill in its engine, server, login, database and TLS settings. (#4048)
- A .sql file opened from Files or the command line loads into an editor tab without running. (#4049)
- Before an update changes the format of saved connections, query history or tabs, the old file is kept beside it. (#4049)
- Truncate a table, and create or drop a database or schema, from the sidebar. (#4050)
- Export a whole database or schema to a .sql or .sql.gz file, and import a .sql or .sql.gz file, from the main menu. (#4052)
- TablePro shares usage data with its developers, as on macOS; Preferences > General > Privacy turns it off. (#4053)
- After 30 days of use without a license, a message asks whether you would buy one. (#4053)
- Sign in to a TablePro account in Preferences > Account to see your plan, devices and teams, as on macOS. (#4053)
- Rows of a query result that reads one table with its whole primary key can be edited and saved from the SQL editor. (#4055)
- Ctrl+Shift+E exports the results or rows shown in the tab in front. (#4066)
- Switch between Data and Structure from a table tab’s bottom bar while keeping unsaved changes in each view. (#4108)
- A table tab's Structure view shares the tab's bottom bar instead of stacking a second one. (#4111)
- Row Details marks a primary key field with a key, and a field holding an unsaved edit with a pencil. (#4112)
- Search Row Details by field name or value, or show only fields with unsaved edits. (#4113)
- The sidebar has a Favorites scope listing the saved queries of the connection in front. (#4114)
- A favorite is renamed or deleted from the Favorites list, with a right click, F2 or Delete. (#4115)
- The sidebar toggle stays in the header while the sidebar shows, so it collapses from there. (#4117)
- The bottom bar has a Columns button that opens the column chooser. (#4118)
- A table tab's paginator says how long the page took to read. (#4119)
- Open Quickly (Ctrl+Shift+O) finds tables and views across the connection’s schemas. (#4121)
- A table tab's bottom bar has a JSON view of the rows on screen. (#4122)
- The header has a lock that shows the connection's Safe Mode level and changes it. (#4124)
- Refresh the current table, key or diagram from the header. (#4125)
- The header has Save Changes for table edits, table structure and editable query results. (#4126)
- Highlight Rules in the bottom bar colour the rows or cells that meet a condition. (#4127)
- The data grid draws in the colours of the editor's style scheme. (#4128)
- Highlight Rules are kept for each table across restarts, including database files and other databases. (#4129)
- Organize saved queries in folders in the Favorites sidebar. (#4130)
- Row Details marks foreign key fields and announces their key roles to screen readers. (#4131)
- Open Quickly finds saved queries by name and opens them in a new editor tab. (#4133)
- Data grid preferences set whether rows are numbered, how tall a row is and what a NULL shows. (#4134)
- The data grid has its own cell font setting in Preferences under Data Grid. (#4135)
- Preferences can set the format Copy writes when several rows are selected, as TSV, JSON, CSV or Markdown. (#4137)
- Preferences can open the row details pane whenever a row is selected. (#4138)
- Session Menu puts database commands beside the workspace, with app commands in Main Menu. (#4139)
- Preferences can sort a table by its primary key or first column when it opens, ascending or descending. (#4140)
- Cells and value fields mark zero-width, control and special space characters, which Preferences can turn off. (#4141)
- Preferences can show dates and timestamps in cells as ISO, US or EU dates, with or without the time. (#4142)
- Open Quickly finds successful past queries by their SQL and opens them in a new editor tab. (#4144)
- A tablepro command runs queries, lists and describes tables, exports them and prints shell completions. (#4145)
- Database links such as postgresql:// open in TablePro once you confirm them. (#4145)
- The sidebar has an Add button below the tree for a new table, schema or database in the connection in front. (#4146)
- Import from Another App reads the connections and saved SQL of DBX; its passwords stay in the system keyring. (#4147)
- The sidebar's Schemas button chooses which schemas it lists, and remembers the choice for each connection. (#4150)
- The sidebar can be widened by dragging its edge or with the arrow keys, and every window keeps that width. (#4155)
- Each field in the row details has a button that copies its whole value. (#4156)
- Each field in the row details has its own menu to set it to NULL, DEFAULT or empty, or copy it. (#4158)
- Set to Default on a saved MongoDB row removes the field. (#4208)
- Preferences > MCP lists AI clients, shows whether each one reaches TablePro, and sets it up or copies its setup. (#4211)
- Share Result masks the columns that look sensitive before a link is made, with Keep, Mask or Remove for each column. (#4253)
- Share a query or a result as a public link, and open shared links in TablePro. (#4253)
- Import SQL File loads PostgreSQL COPY blocks in CSV or with options, and large blocks load faster. (#4258)
Changed
- Saved queries keep their folder, keyword, and order when replaced. (#4116)
- Set to Empty, NULL, DEFAULT or an expression changes every selected row in one undo step. (#4136)
- The software center listing says TablePro works without an account or a license, and when it asks you to buy one. (#4152)
- Row details edit a field in its own row instead of in an editor under the list. (#4157)
- The sidebar lists a schema's views, sequences, routines and triggers in a row for each kind, above its tables. (#4159)
- A query run stops keeping rows once they pass 256 MB, and the banner over a result says when that cut it short. (#4201)
- SQL editor queries on PostgreSQL and table pages wait on the server fewer times, which shows on slow links. (#4224)
Fixed
- Preferences > Account called the Pro plan Starter. (#4082)
- The device limit dialog says TablePro keeps working here if you remove no device. (#4082)
- The app icon was a placeholder grid instead of TablePro's logo. (#4085)
- Connecting with a saved password in the Flatpak no longer hangs when the keyring is locked or missing. (#4091)
- Remember Password failed silently when the keyring could not save the password, as with no default keyring. (#4105)
- Picked editor schemes could differ from their previews and make code blocks and value placeholders hard to read. (#4109)
- Row numbers scrolled out of view when columns were scrolled sideways. (#4110)
- Dragging the results up no longer hides the query: the editor keeps a few lines. (#4120)
- The sidebar could select the wrong database after a query tab changed databases. (#4132)
- Opening a database link showed its password on a page saying the file was not on this computer. (#4145)
- tablepro --new-window with files dropped the files when TablePro was already running. (#4145)
- A long right-click menu, such as a table's in the sidebar, was cut short with a scrollbar in the middle of the screen. (#4149)
- Software centers showed no screenshots for TablePro from the TablePro Flatpak repository. (#4152)
- A change to connections.json made outside TablePro while it ran was undone on the next connect. (#4176)
- A ClickHouse login whose profile sets readonly=1 could not connect. (#4176)
- Exporting a MySQL or MariaDB editor query that matched no rows wrote a file without its header. (#4180)
- A MySQL or MariaDB query that matched no rows showed as a command, without its column headers. (#4180)
- Connecting to a host whose first address did not answer timed out instead of trying its next address. (#4180)
- An MCP client that gave up on a row count or a table lookup left it running and holding the connection. (#4180)
- On MySQL and MariaDB, SELECT ... INTO OUTFILE in the editor wrote only as many rows as the editor's row limit. (#4180)
- An MCP client reading rows with very large values could make TablePro use gigabytes of memory. (#4180)
- CSV export put a single quote before values starting with =, +, - or @ by default, which then stayed in imports. (#4185)
- Editing a number in a MongoDB collection could change its stored type, such as saving an int as a long. (#4201)
- The banner over a PostgreSQL result cut at the row limit said the statement ran no further than the rows shown. (#4201)
- Editing a MongoDB field that holds more than one number type changed the edited value's type. (#4202)
- Exporting a MongoDB collection left out fields that none of its first 1,000 documents held. (#4202)
- A MongoDB DNS seed list logged in to
admininstead of the database its TXT record names. (#4202) - MongoDB UUID fields opened as JSON instead of UUID columns. (#4202)
- A read-only MongoDB connection let
validatewithrepairthrough. (#4202) - New MongoDB documents got an explicit
nullfor every field left empty, which sparse and partial indexes count. (#4202) - With Safe Mode off, MongoDB index, user and role drops,
$outand other collection replacements ran without asking. (#4202) - After a reconnect, MongoDB fields of mixed types showed as plain values and an edit could change their type. (#4202)
- Stopping a MongoDB statement on an Atlas free or Flex cluster did not stop it. (#4202)
- MongoDB statements from Copy As or an export stored values such as
NumberLongas nested documents in mongosh. (#4208) - Duplicating, pasting or importing MongoDB rows wrote
nullfor fields the source documents did not have. (#4208) - With Safe Mode off, a MongoDB
$mergeinto the collection it reads ran without asking. (#4208) - The MCP page copied the access token without its Bearer scheme, and offered no Regenerate while the server was off. (#4211)
- Scrolling a table with highlight rules was slow when its rows had many columns. (#4224)
- Deleting thousands of pasted rows at once froze the table tab. (#4224)
- Locked-keyring errors omitted the steps to create a default keyring. (#4234)
- The keys pointing at a table could miss a table while another program changed the SQLite file's schema. (#4291)
Security
- tablepro export printed control codes stored in the database to the terminal, where they could run. (#4145)
- While a connection was reconnecting, Safe Mode read SQL by PostgreSQL's rules and could miss a write to ask about. (#4176)
- The MCP server answers only programs running as your user, so a leaked access token does not work from another account. (#4211)
- An MCP client could read or write any file through a DuckDB connection. (#4219)
- Safe Mode missed a DuckDB statement hidden after a non-breaking or zero-width space. (#4239)
- Safe Mode missed a PostgreSQL statement hidden after a routine named
beginor one that names abegincolumn. (#4254) - At Read-Only, a function a query called could make a MySQL or MariaDB connection writable for the next query. (#4264)
- Reading a table's keys or structure in a crafted SQLite or DuckDB file could take gigabytes of memory. (#4287)
- A crafted SQLite file could make reading its structure take gigabytes of memory or minutes of CPU. (#4291)
- Opening or browsing a DuckDB file with deeply nested constraints, defaults or views could crash the app. (#4293)