![]() ![]() You can also write and manage queries for Microsoft SQL Server (T-SQL), OLEDB queries, Facebook Query Language (FQL) and you can even analyze big data in the cloud using Google BigQuery services. In addition, we have added input filters for custom RegEx and log4net input log formats and also Android logs (with support for console input and regular expressions). Because the command-line interface is not very intuitive, we have created Log Parser Lizard, a free GUI tool for managing queries and exporting results to Excel, charts, dashboards and even design your own report. Log Parser is a very powerful and versatile query software tool that provides universal query access (using SQL) to text-based data, such as log files, XML files, and TSV/CSV text files, as well as key data sources on the Microsoft Windows operating system, such as the Windows Event Log, IIS log, the registry, the File System, the Active Directory services and much more. Log Parser Lizard is a GUI for Microsoft Log Parser. * Open source and free - Released under GPLv2 licence. Binary distribution is just the single, ready to use file. * Single executable file - no need to install or uninstall. Mac OS X support is partially done, but dont expect to run SQLiteStudio on it yet - support for this system is planned, * Localizations, currently translated to: o English, o Polish, o Spanish, o German, * Exporting to various formats (SQL statements, CSV, HTML, XML), * Pretty fast handling of tables with lots of data (tables data preview and SQL queries results are split and displayed in smaller pieces), * Numerous small additions, like formatting code (uppercase keywords), fast navigation between windows and tabs in notebooks by shortcuts, history of queries executed in editor windows and more, * UTF-8 support, * skinnable (interface can look native for Windows 9x/XP, KDE, GTK, Mac OS X, or draw widgets to fit for other environments, WindowMaker, etc), * Configurable colors, fonts and shortcuts. Open the Find dialog (future version 3.SQLiteStudio is a SQLite database manager with the following features: * Intuitive interface, * All SQLite3 and SQLite2 features wrapped witin simple GUI, * Some features implemented on top of basic SQLite3/SQLite2 SQL statements, like editing all existing objects, or Foreign Keys transparent emulation, * Cross-platform - runs on Windows 9x/2k/XP/2003/Vista/7, Linux, Solaris, FreeBSD and should work on other Unixes (not tested yet). Move to first visible character in document lineĮxtend selection to first visible character in document lineĮxtend rectangular selection to first visible character in document lineĮxtend rectangular selection to end of document lineĮxtend rectangular selection down one page Ctrl + H Opens the Find/Replace dialog (future version 3.12).Įxtend rectangular selection down one lineĮxtend rectangular selection left one characterĮxtend rectangular selection right one character.Ctrl + F Opens the Find dialog (future version 3.12).Insert toggles overwrite mode in both text editor and hex editor.Shift + F5 executes the SQL commands on the current line only.Ctrl + R and F5 execute the SQL commands.Ctrl + Return executes the SQL commands.Ctrl + R and F5 refresh the pragma list.When being on the last cell, a new row is inserted automatically. Tab moves to the next cell when the table browser is focused.Alt + Delete and Alt + Backspace delete the content of the current cell(s), setting them to NULL.Delete and Backspace delete the content of the current cell(s), setting it to an empty string.Ctrl + PageUp and Ctrl + PageDown switch the currently browsed table to the previous or the next table.Ctrl + ‘ copies the data from the cell above the current (future version 3.11).Ctrl + “ duplicates the currently selected record.Ctrl + R and F5 refresh the currently browsed table.Ctrl + R and F5 refresh the database structure.Alt + 4 switches to the Execute SQL tab.Alt + 3 switches to the Edit Pragmas tab.Alt + 2 switches to the Browse Data tab.Alt + 1 switches to the Database Structure tab.Mac users have to press ⌘ instead of Ctrl Main window Alt + E for clicking the button with the underlined E), and that aren’t typical for all GUI application (e.g. Ctrl + N for a new database), that aren’t simply Alt accelerators (e.g. By this I mean those shortcuts that aren’t obviously visible in the menus (e.g. This Wiki page aims at listing the more ‘hidden’ keyboard shortcuts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |