Trusted Windows (PC) download Quick Query 1.1.2. Virus-free and 100% clean download. Get Quick Query alternative downloads. Global Nav Open Menu Global Nav Close Menu; Apple; Shopping Bag +. Querious 2.1.5 Mac OS X 32.12 MB. Querious lets you view, search, edit, import, export, build, configure and monitor their MySQL and MariaDB databases easier than ever data. With Querious, you can even open raw CSV or tab – delimited files and easily split, merge, reorder, add, delete and process columns and rows, and then convert the. Querious 2.1.15 July 30, 2019 Querious allows you to view, search, edit, import, export, build, configure, and monitor your MySQL and MariaDB databases easier than ever before.
Version 3 — Requires macOS 10.12 or later.
A tool you'll love, not fight.
View, search, edit, import, export, build, configure, and monitor your MySQL and compatible databases easier than ever before. Querious is full-featured, fast, and made exclusively for macOS, so it feels and works exactly how a Mac app should.
The Content view is packed full of convenient features, such as a flexible multiple-condition filter, easy multi-row value assignment, row duplication, copying to the clipboard, and jumping to related tables through foreign keys.
Convenient Filtering
Easily build a multi-condition filter to find just the right records you want to look at. You can even copy the resulting
SELECT
statement.JSON, Binary, Checkboxes
Edit values as text, JSON (with full syntax validation and coloring), binary, or even as a simple checkbox for 'boolean' columns, such as
`tinyint(1)`
Foreign Keys
When a table contains foreign keys, click on the arrow next to a foreign key id value to immediately jump to the related records.
Editors for Everything
Fewer queries means greater efficiency.
Other database programs will have a good editor for viewing table contents and querying, but then completely fall short when supporting other object types. Querious goes all the way, providing editors for everything you need.
Avoid Writing Queries
Straightforward and uncluttered editors allow you to quickly see and change the structure make-up of your databases without having to write queries.
Editors for ALL Types
Complete interfaces for defining and editing table columns, indexes, primary and foreign keys, triggers, events, functions, and procedures. Querious doesn't simply stop at table contents.
A MySQL Assistant
The various editors in Querious are a great way to expand your knowledge of MySQL by learning what's available and making it easy to use and change.
Call Functions & Procedures
Setup function and procedure parameters, and even easily call procedures without having to use a query.
Triggers
Set up SQL code to run either before or after any insert/update/delete occurs in a table.
Events
Events are SQL code scheduled to run at either a specific time or on a reoccurring interval.
Import, Export, Duplication
It literally doesn't get any better.
Export Entire Server
Querious 2 1 5 Download Free Online
Export anything from a single table to multiple databases at a time. You can even export the entire server's contents for a complete backup.
Export Presets
Exporting the same set of tables/databases/etc often? Save your export settings as a preset and easily reuse them over and over to save time.
Import Defaults
When importing CSV or Tab, specify default values to use for unmapped or empty columns.
Multiple Formats
Import or Export SQL, CSV, and Tab files, with fine-tuned adjustments to adapt to any slight format differences between programs.
Compressed Files
Big data? Small files. Querious can directly export to and import from compressed .gz files for maximum space savings.
Create Tables on Import
When importing a CSV or Tab file, you can create a new table directly from the imported data, specifying field names and types.
Not only can Querious do speedy imports and exports, but it can also 'duplicate' views, triggers, functions, procedures, events, and even tables including their data content, within the same database, between databases on the same server, or between completely different servers! What's even more impressive is Querious can duplicate an entire database, even between servers.
Outstanding Performance
We hate waiting, and we know you do too. That's why we obsessed over shaving off every last microsecond wherever we could.
For example, when it comes to importing and exporting data, nothing is faster than Querious. The only reason to use anything besides Querious is if you actually like waiting for super-long exports.
(With performance this good, it's hard not to brag.)
Advanced custom querying is richly supported when you need to perform custom joins, subselects, run
alter
statements manually, or any other kind of query.Syntax Highlighting
Fast syntax highlighting of SQL keywords, values, and identifiers.
Fast Autocomplete
Autocomplete of MySQL keywords, database names, table/view/function/etc names, and even column names.
Multiple Code Editors
Open as many independent query tabs (code editors) as you want, each with independent results.
Organize Saved Queries
Convenient 'Favorites' bar for often-used queries, and a highly organizable sidebar for big collections of queries.
Query Reformatting
Keep your code clean, with re-indented and case-corrected reformatting. You can even minify your SQL to embed in code.
Table Reference
Use the handy sidebar for referencing column names and types in tables.
Querious goes beyond just helping you manage the data in your tables by enabling you to quickly see the status of the server, such as bandwidth used, number of connections, and see the queries/processes running on the server. You can also setup and administer user permissions, the event scheduler, server variables, and when file system access is authorized (via SSH for remote hosts), Querious can even display the errors and slow queries logged on the server.
Query TranscriptSee each query that Querious executes.
Server StatusGlance at a general overview of info.
ProcessesSee how many and which queries are running on the server.
EventsSee a complete list of all scheduled SQL events.
Server VariablesQuerious 2 1 5 download free. full
Inspect and change session- and server-level variables.
Error LogAccess a log of any errors MySQL reports.
Slow Query LogFind out which queries are taking too long.
InnoDB Status
Advanced users have quick access to engine status.
A full-featured super-easy-to-user Users view makes adding and removing users, and changing their global, database-level, or even field-level privileges a cinch.
Get a high level overview of how your tables are related to each other, and the keys which establish those relationships. See how tables connect to each other from foreign key to primary key.
Artificial Keys
Soulver 2 6 5. Only in Querious can you specify artificial keys which relate two tables, mimicking PK/FK relationships, without modifying the database.
Export as PDF
The Relationships graph view can even be exported as a PDF for you to include in documentation.
Zoom, Fields & Types
Zoom in and out, show and hide field names and types. You can even hide tables with no connections.
Database Structure Comparison
Find and synchronize the differences.
When working with evolving database structure, sometimes the development and production environments can drift apart. With database structure comparison in Querious, you can compare two databases, find all of the differences between them, and even adopt the changes needed to make them the same.
Step One
After selecting which databases on which servers to compare, choose which types of schema objects to compare, and which aspects to ignore.
Step Two
Querious will compare the structure and show you the results. Select which differences to ignore.
Step Three
Finally, the synchronization script will be shown and can be executed to make the chosen changes applied to the source database.
Data File Editor
Edit CSV and Tab files easier than ever.
Querious has a powerful built-in editor for directly editing CSV and Tab files like a spreadsheet. If a client gives you a CSV file with wacky columns or malformed data, you can easily clean it up Querious.
Need to apply a regular expression replacement to all or just one column? You can! Need to join multiple columns together? Not a problem! Need to split a single column into multiple columns? That's no problem either!
Not only can you easily manipulate the add, filter, and massage the data in the files, but converting between CSV/Tab format varitions is a cinch.