Upgrade Guide: Moving from MyDbExplorer Free to Personal Edition

Getting Started with MyDbExplorer Personal Edition: A Quick Guide

Overview

MyDbExplorer Personal Edition is a lightweight desktop tool for exploring and managing local databases (SQLite, MySQL, PostgreSQL). It focuses on simple, fast browsing, running queries, and basic schema edits without the complexity of full-scale database IDEs.

Quick setup

1. Download & install: Run the installer for your OS and follow prompts.
2. Create or open a database: Use “Open Database” to load a local file (SQLite) or “New Connection” for server databases.
3. Add connection details: Enter host, port, username, password, and database name for MySQL/PostgreSQL. Save connections for reuse.
4. Configure defaults: Set preferred SQL dialect, results row limit, and theme in Settings.

Main interface

• Connections pane: Saved connections and recent files.
• Schema browser: Expand databases → schemas → tables, views, functions.
• SQL editor: Write and run queries; supports basic syntax highlighting and autocompletion.
• Results grid: Displays query results with export options (CSV, JSON, SQL).
• Table view: Inspect rows, edit cells inline, add/delete rows, and apply filters.

Common tasks

1. Run a query: Open SQL editor, enter SQL, press Run. Results shown in grid.
2. Export results: Click Export and choose CSV/JSON/SQL.
3. Edit data: Double-click a cell in Table view, modify, and click Save.
4. Create a table: Right-click schema → New Table → define columns and types.
5. Backup database: For SQLite, copy the file; for servers, use EXPORT or native tools.

Tips & best practices

• Use row limits to avoid huge result sets.
• Save queries you frequently run.
• Test destructive queries (DELETE/DROP) on a copy first.
• Enable auto-backup if available for local files.
• Secure saved credentials with the app’s encryption option.

Troubleshooting

• Can’t connect: Check host/port, firewall, and credentials; ensure server allows remote connections.
• Slow queries: Add indexes or limit returned rows.
• Corrupt SQLite file: Try PRAGMA integrity_check; restore from backup.

Useful keyboard shortcuts (defaults)

• Run query: Ctrl/Cmd+Enter
• Format SQL: Ctrl/Cmd+Shift+F
• Open connection: Ctrl/Cmd+O

If you want, I can turn this into a printable one-page quickstart or a step-by-step tutorial for a specific database type (SQLite, MySQL, or PostgreSQL).