Icon of program: McCoy_RDBMS

McCoy_RDBMS for Windows

Download now

Used McCoy_RDBMS for Windows?

Editors’ Review

Download.com staff
This application executes SQL queries on ASCII database files. It features a visual connection wizard, ODBC connectivity, and multiple data editors, letting you query data in its original state without requiring an import.

Top Recommended Alternative

Enlarged image for McCoy_RDBMS
McCoy_RDBMS 0/1

  • Pros

    • Operates on data without requiring import
    • Queries any type of ASCII database file
    • Imports from and exports to ODBC data sources
    • SQL editor includes an intellisense popup for code aid
    • Includes extended SQL clauses like suppression joins and splits

  • Cons

    • Functionality is limited to ASCII formatted database files
    • Creates index and query files in the source data folder
    • Requires a graphical user interface for operations
Icon of program: McCoy_RDBMS

McCoy_RDBMS for Windows

Download now

Used McCoy_RDBMS for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
2.1
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 7
  • Windows 10
Additional Requirements
ASCII Database file
POPULARITY
Total Downloads
148
Downloads Last Week
13
Report Software

Program available in other languages

Last Updated

Developer’s Description

By Brad McCoy
Perform SQL on ASCII Database Files.
SQL on a flat file? Yes! You can perform SQL on about any type of ASCII database file. This application lets you include your files using a connection wizard as a visual reference or you can import your data from an ODBC source. You can draw lines between the fields to aid you in writing your SQL Using a grid editor or forms type of editor you can view and edit your database information. Then you can write SQL statements to create queries which are viewed in the grid editor; and some queries can be edited too. You can perform most of the standard SQL known today. Create Tables, Rename Fields, Insert Rows, Join Tables, Sort Tables and Where Clauses... There is an intellisense popup that will also aid you in writing SQL.Plus there are additional SQL clauses that have been added to the language as well. For example a suppression join will drop the rows from the first table that match the rows in the second table. Split By {Expression} will pull out records that return a true result when the expression evaluates. The remaining records will drop down to possible other "Split By {Expression}" clauses. This gives you the ability to split a file into multiple files. As with other SQL you can make a query of a query too. When doing this I usually make the second query a child node of the first query in the tree view portion of the GUI interface. But truthfully... the SQL interpreter doesn't care if the nodes are inside each other or not. Nor does it care if the file is even declared in the GUI either. You can use relative file naming to refer to a file that resides in another workspace (folder) . After you are done working with your databases you can upload them back into an ODBC source. Or you can use them locally. This tool is nice because data does not have to be imported to work on it. The data remains in its original state. However you will notice indexing and query files being added to the same folder that the data resides in.
Download.com
Your review for McCoy_RDBMS