My Database

My Database is an intuitive app that lets you create and manage personalized databases directly on your Android device or connect to remote servers. Whether you're organizing inventories, tracking collections, storing notes with images, or accessing remote MySQL databases and SSH servers, this app simplifies database management without requiring complex setups. Designed for versatility, it supports customizable local SQLite databases, remote MySQL connections with image handling, SSH terminal access, and secure, offline or online storage options.

Local Database and Table Management (SQLite): Easily create, rename, delete, or password-protect databases. Add custom tables with user-defined text columns, automatic image support, and full column management (add, rename, delete, reorder).

Remote MySQL Database Support: Connect to remote MySQL servers with SSL for secure connections. Browse tables, query data, add/edit/delete records, and manage images uploaded via a server-side API. Features include optional PEM-encoded certificates, API key authentication, and battery optimization reminders to maintain active sessions during long operations.

SSH Terminal Access: Securely connect to remote servers (e.g., Linux) for command-line management. Add and manage connections with credentials, use an interactive terminal with special keys (CTRL, ALT, etc.), and receive battery optimization prompts to prevent disconnections in the background.

Data Entry and Editing: Add rows (posts) to tables in local or remote databases, edit fields, and attach multiple images from your gallery or camera. Images include EXIF rotation, compression, thumbnails, and a full-screen viewer with zoom and swipe navigation.

Advanced Search and Filtering: Perform simple or advanced searches with operators (e.g., equals, contains, greater/less than, between) and full-text keyword search across local and remote databases. Sort results, paginate for large datasets, and export search results as CSV.

SQL Query Tool: Run custom SQL queries directly in the app for both SQLite and MySQL, with syntax highlighting, result pagination, and export to CSV.

Import/Export Options: Share entire databases as ZIP files (including images), export tables to CSV or MySQL-compatible SQL, and import from various formats like pure SQLite DB or CSV. Background processing handles imports/exports with progress indicators for efficiency.

Customization and Security: Toggle between light and dark modes, adjust image quality (high/low compression), scale thumbnails (50%–300%), and set defaults for quick access. Protect sensitive data with passwords, database encryption, SSL for MySQL, and secure local storage for credentials.

Offline and Performance-Focused: Local data is stored securely with WAL journaling for optimal performance. Includes built-in example databases (e.g., Chinook, Animals) to help you get started quickly. The app features robust error handling, permissions management, and battery optimization reminders for seamless remote sessions.

Built with privacy in mind, My Database supports both fully offline local operations and secure remote access, ensuring your data stays protected. It's ideal for hobbyists, small businesses, developers, or anyone needing a lightweight, powerful tool for personal data management, inventory tracking, visual note-taking, or remote server administration.

Recent changes:
Exciting updates: Now supports MySQL server connections with image upload via API, SSH terminal for remote server access, SSL for secure MySQL connections, and battery optimization reminders to keep sessions alive. Also minor bug fixes.