Hit Counter
Welcome to the Navvy(tm) home-page - databases made easy.
- Browse your database schema in an intuitive manner.
- Automatically generate SQL queries using your mouse
- Navigate to related data using embedded 'handles'. Only fetch child records
you are interested in - not the whole join.
- Modify your data and save it.
Contact us at
comments@navvy.org
What is Navvy?
Navvy is a new patent-applied for group of concepts in database access.
On-screen elements represent data from all kinds of data source from RDBMS's to
object, hierarchical and semi-structured database.
Navvy enables many queries to be implemented without any coding. Data can be
entered modified and deleted.
Links between records in relational, object, or any other kind of databases
can be followed to browse and modify data interactively.
Each record has a handle. The handle has a series of actions associated with
it. The default action is selected by a left-click. The other actions are
selected by right-clicking. If a record has just been read, the default action
is to 'Close' it which removes it from the screen. If you change the data in
the record, the handle may change to 'Save' (depending on the Navvy
implementation).
Record handles can be embedded within other records. For example a
foreign-key link to another record (or set of records) is represented by an
embedded record handle or list handle respectively. Selecting this embedded
handle fetches the related data and displays it inside the outer record. This
ability enables you to navigate around the data you are interested in, rather
than building complex join queries which bring back rows you aren't interested
in.
Records appear on a Navvy grid. The grid is capable of displaying different
kinds of records together on the same grid.
Apart from the grid, Navvy usually has a traditional hierarchical data tree
with important modifications that allow users to navigate data schemas and
build queries without keyboard input, or with minimal keyboard input.
The on-screen representation of data and schemas need not relate to the
underlying data as Navvy is fully programmable.
What is Navvy1?
Navvy1 is our first offering. It interfaces the Navvy to your ODBC data
sources, enabling you to navigate your schema and generate queries with minimal
keyboard input. Results of initial queries can act as a staging post for
fetching related data via relational foreign keys.
Data can be modified or deleted from the database.
What does Navvy1 look like?
Does Navvy cost
anything?
register You don't need to pay
to register. We suggest you try the tool and register with your comments when
you feel ready.
Download Navvy1 for Windows(R)
Make a $10, £5, 7 euro donation and get
bugfixes and the next major version free You can pay using PayPal
or credit cards.
Download the
manual Navvy1 has a help-file which contains most of the manual.
The manual contains a guided tour as well. You may want to download the manual
to see what Navvy1 can do before downloading it. You may be interested in Navvy
technology but not have a database server yet.
Who should download Navvy1?
Navvy works on Microsoft Windows platforms . Anybody with a database server
such as Oracle(r), or SQL Server(tm) will find Navvy useful. It is less useful
with desktop databases such as Access (tm), as they provide
What can Navvy1 do?
Navvy1's capabilities are limited by the level of ODBC support of your data
source. When pointed at RDBMS servers such as SQL Server® and Oracle®,
you can navigate the schema via foreign-keys and generate complicated queries
using the intuitive data tree control without having to type in SQL. Following
this you can update records on-screen and save them to the database
On
standalone databases such as Paradox and Access, Navvy can browse the data
schema and generate simple queries that don't involve joins, but the data will
be read-only. Our next development effort will be to bring server-like capacity
to these databases. Navvy represents both ends of foreign keys as record
handles, or lists of record handles..
Who is Navvy1 intended for?
The Navvy1 interface is very intuitive, so it is aimed at novice users. If
you haven't got a server-type RDBMS like SQL Server®, MySQL or Oracle
®, then the capabilities are not very inspiring
Navvy uses ODBC.
Set-up of new DSN's is slightly complicated.
Oracle is a trademark of Oracle Corpo...
SQL Server is a rrrr
How safe is installation of Navvy1?
Does Navvy cost anything?
Navvy is shareware/donation ware. We ask for a $10, £5 or 7 euro
contribution. This entitles you to the next version (intended price around
£20GBP) free.. If you use it without a donation, we are still interested
in your comments.