DPSQLStudio — Themes, Preferences & Data Tools

Making it yours — themes, preferences, and a flexible Data Tools dialog

This post covers the parts of DPSQLStudio that shape how it feels day to day: a Preferences dialog with eight editor themes and a live light ↔ dark switch, and the general-purpose Data Tools dialog that does sort, filter and group on any result. Screenshots are from the live app (v0.1.0 Beta) on Oracle as ADMIN@dpsqltest_high.

1. Preferences and the eight themes

Tools ▸ Preferences gathers the settings worth having in one place: workspace and Oracle-client folders, date format and decimal places, and a column of editor toggles — highlight SQL keywords, auto-UPPERCASE, autocomplete (Ctrl+Space), the line-number gutter, whitespace dots, show NULL as blank, and roll-back-on-close. The Theme dropdown offers eight looks:

The nice touch: themes apply live. Pick one and the whole app — editor, grid, tree, dialogs — repaints immediately, so you can audition looks without closing the dialog. Cancel restores whatever was active when you opened it.

2. Data Tools — sort, filter, group on any result

Beyond the dedicated tools (VLOOKUP, Pivot, Hierarchy, Compare), the Data menu has a single Data Tools dialog for the everyday reshaping: choose a source sheet or the current result, an Operation (Sort, Filter, or Group → subtotal), the columns to act on, and an aggregate where it applies.

Because every Data tool can write its output back as a new Sheet, you can chain them — VLOOKUP to enrich, Group to subtotal, Sort to rank — without round-tripping through SQL each time.

One more thing

DPSQLStudio is built directly on the Win32 API with no GUI framework dependencies — which is how a full editor, grid, and this whole Data suite fit in a small, fast, free download.

DPSQLStudio v0.1.0 (Beta) — a free Oracle SQL client for Windows. Screenshots are from the live app; demo data is fictional.

Comments (0)