Dev Update: Direct Inline Cell Editing

Stop writing manual UPDATE statements for typos

The goal of SQLitePilot has always been to remove the friction of "raw SQL gambling" when managing remote production data. While our visual grid made reading data easy, fixing a simple typo in a single cell still required opening the SQL tab and manually writing an UPDATE statement with a careful WHERE clause.

We’ve just simplified that workflow with Inline Cell Editing.

How it works

You can now modify your remote data directly from the Tables tab without leaving the grid view:

• Edit in place: Clicking any editable cell switches it to input mode.
• Automatic SQL generation: When you press Enter, the app automatically generates the precise UPDATE statement required to modify that specific record.
• Safety first: A confirmation dialog appears showing you the exact SQL that is about to run on your remote database.
• Audit trail: Once confirmed, the statement is executed and automatically logged to your SQL history for future reference.

Precise targeting with PKs and ROWIDs

To ensure your updates are safe, we implemented a strict row-targeting strategy. The frontend builds the WHERE clause using the following priority:

1. Primary Keys: If the table has a primary key, it is used for targeting.
2. ROWID Fallback: If no primary key is available, the app uses the hidden rowid field as a fallback.
3. Read-only Protection: To prevent accidental data corruption, primary keys and internal rowid fields are strictly read-only within the grid.

Quality of Life Improvements

Alongside inline editing, we’ve included a few more updates to make browsing data smoother:

• Performance Caps: Initial table loads and search results are now capped at 100 rows to keep the interface snappy on slower VPS connections.
• Better Alignment: Table headers and cell contents are now center-aligned for better readability.
• Preserved Context: When you save an edit, the table reloads while preserving your current search terms, so you don't lose your place.

This update effectively moves SQLitePilot from a "remote viewer" to a true management tool, allowing you to handle quick data patches without the overhead of manual query writing.