pawelsalawa/sqlitestudio

Features

• SQLite Databases - Open SQLite database files and provide a graphical interface for viewing, editing, and managing their tables and data.
• Administration Tools - Provides a graphical tool for browsing, editing, and managing SQLite database files.
• SQLite Integration - Directly links against the SQLite C library to execute queries and manage database connections.
• Management Tables - Modify a table's columns, constraints, and indexes through a visual interface without writing SQL.
• Grid View Browsings - Open a table in a grid view to inspect, filter, and edit its rows directly.
• Data Import and Export - Transfers data between SQLite databases and external formats like CSV, JSON, SQL, and XML.
• Table Schemas - Modify a table's columns, types, constraints, and indexes through a visual interface.
• SQL Query Execution - Runs arbitrary SQL statements against the database and displays results in a result set grid.
• Database Object Management - Create, alter, and delete tables, indexes, views, triggers, and other schema elements through a visual editor.
• Database Schema Designers - Ships a visual schema designer for creating and modifying entity-relationship diagrams.
• In-Place Cell Editing - Edits cells directly in the grid with F2 or opens a dedicated editor with F4.
• Inline Data Editing - Provides an editable grid for modifying database records directly with inline cell editing and filtering.
• SQL Query Editors - Provides a full-featured SQL editor with syntax highlighting, auto-completion, and query history.
• SQL Script Execution - Executes SQL statements directly within the application for database operations.
• SQLite Extensions - Loads third-party SQLite extension libraries to add custom functions and virtual tables.
• Integrated Development Environment Plugins - Provides a plugin development framework for extending functionality with custom metadata, actions, and UI components.
• Multi-Format Data Exports - Saves query results and table data to CSV, SQL, HTML, XML, JSON, and other formats.
• Multi-Language Script Runners - Embeds JavaScript, Tcl, and Python interpreters for user-defined functions and scripts within SQL queries.
• Plugin Extensibility - Loads community or third-party plugins to add new functionality to the application.
• Multi-Language Plugin Frameworks - Provides a plugin framework supporting extensions in C/C++, JavaScript, Tcl, and Python.
• Multi-Language Script Execution - Executes scripts written in QtScript, SQL, Tcl, and Python directly within the database manager.
• Plugin Extenders - Extends core functionality by loading shared libraries that register new features through a plugin interface.
• SQL Syntax Highlighting - Provides SQL syntax highlighting with automatic recognition of database objects as you type.
• JSON Exports - Outputs database contents as JSON files for use in web applications.
• SQL Generators - Generates SELECT or UPDATE statements by dragging tables and columns into the SQL editor.
• Entity-Relationship Diagram Editors - Provides an interactive visual editor for creating and modifying entity-relationship diagrams.
• Cross-Table String Searches - Search for a given string across every table in the database and return matching rows.
• CSV Import Managers - Imports data from CSV files into SQLite database tables with configurable options.
• Grid Data Filters - Filters grid rows by text, exact match, regular expression, or SQL expression per column.
• CSV Exports - Exports tables and query results to CSV files from the toolbar or menu.
• Cross-Database Transfers - Transfer tables, views, indexes, and triggers between databases with drag-and-drop, including data if desired.
• File-Based Data Import - Imports data from files into database tables, creating the table if it does not exist.
• Database Population Tools - Fills database tables with constant, random, sequential, scripted, or dictionary-based test data.
• Test Data Generators - Generate and insert sample data into tables for testing or demonstration purposes.
• Row Deletions - Removes rows with Delete key or clears cell values to NULL with Backspace in data grids.
• Custom SQL Functions - Adds user-defined functions written in C/C++ that can be called from SQL queries.
• SQL Export Generators - Writes database contents as SQL statements for backup or transfer.
• Continuous SQL Analyses - Highlights syntax errors and recognizes database objects in the editor as you type for better readability.
• Multi-Database Queryings - References databases by name in a single SQL editor to join and analyze data across multiple databases.
• Multiple Document Interfaces - Organizes database windows in a multiple-document interface for simultaneous editing.
• Embedded Interpreters - Embeds a QtScript interpreter for executing JavaScript-like scripts within the database manager.
• Embedded Interpreters - Embeds a Python interpreter for executing scripts and user-defined functions within the database manager.
• Real-Time SQL Completion - Suggests SQL keywords, table names, and column names as you type, triggered automatically or manually.
• Encrypted Database Managers - Supports opening and creating encrypted databases using multiple cipher formats.
• Collation Rules - Registers user-defined sorting rules for string comparison in SQL queries.
• Keyboard Shortcuts - Ships configurable keyboard shortcuts for most application actions via a settings dialog.
• File-to-Table Importers - Imports data from files into database tables with configurable format, charset, and options.

Star history