WINDEV: Client/Server, Network, Local, Pocket PC


HyperFileSQL, free, unlimited database

WinDev comes standard with a secure database, HyperFileSQL, which is very powerful, very fast and very reliable. HyperFileSQL is already being used by millions of sites. HyperFileSQL works with Windows and Linux and with networks of any size and any type, and automatically manages hundreds of concurrent accesses.

You can freely distribute the HyperFileSQL engine with your WINDEV applications.



MAXIMUM CAPACITY
- Items per file
- Keys per file
- Key size
- Records per file
- File size
- Record size
- Item size
65,535
65,535
65,535 bytes
329 quadrillions
4 millions of tera
2 Gb
65,535 bytes



   MANAGER

      HyperFileSQL is one of WINDEV main benefit. Its
      reliability, its capacity, its speed and its free
      deployment make it indispensable

  NEW

      Linux and Windows client/server engine

   AAF TECHNOLOGY

      Automatic concurrent access management
      Automatic reindex after hardware failure

   MAIN POINTS

      Free
      Speed
      Windows and Linux
      Automatic administration
      Automatic update management



Easily manage replication, transactions,
log files and more.




Power and ease-of-use

A single source code accesses all the databases and all the environments.
Note that you can of course access HyperFileSQL client/server from a Pocket PC.





A proven engine comes with the product: HyperFileSQL

The "HyperFileSQL" database engine comes standard with WinDev. It is a reliable, robust engine, already in use in millions of sites.


High speed

HyperFileSQL is extremely fast.


329 millions of billions of records...

HyperFileSQL lets you work with large volume of data (up to 329 quadrillion records).


Total integration

The engine is totally integrated with the development environment.

At any time, in any editor, you have access to the references and to the data dictionary. The interaction between the user interface and the database management system allows for easier and faster programming.


Simple yet powerful programming

The power and the simplicity with which the W-Language 5GL manages databases are amazing. For example, seeking a record, and all the associated routines (opening the file, assigning data, etc.) is done in one simple line of code:

HReadSeek(CUSTOMER,NAME,"DOE")

The source programs are clear, easy to write and especially easy to maintain; this reduces the chance for errors, and makes the applications you develop more reliable, and faster.
Plain English commands make it easier to use; the code is self-commented! The HReadSeek command can be understood by any developer, even the brand new ones!

You can also program in French: the command becomes hLitRecherche

Of course, you can also program a traditional SQL query for this purpose:

 SELECT * from CUSTOMER where NAME= ‘DOE’



And the code is generated!

This very simple, very fast and very reliable routine is generated on demand by the RAD tool or by one of the numerous wizards when you create your windows!

 

Open to other applications

The ODBC driver, which you can freely distribute with your WINDEV applications, lets WinDev data be accessed from third-party applications.


Automatic installation, "zero administration"

HyperFileSQL installs immediately, without requiring any other software. For example, if following a physical problem with the database it should be reindexed, it is done automatically. Database administration is automatic: no need to involve human resources!


Toolbox included

A toolbox including a set of useful tools comes with the product: import
data, check database, view data, performance optimizer, and more.


Import/export data

The WDCONVER module, provided with WinDev, lets you import data in various format: Access, dBase, Text, Oracle, etc.

HyperFileSQL, which is included with WINDEV, is an undeniable asset;
reliable, fast, secure, free.


Concurrent accesses: automatic

HyperFileSQL 9 automatically manages concurrent access to a record, without requiring any programming. In case of access conflicts, a (customizable) window automatically comes up. You can also handle concurrent access in your program for special cases.

Here, 2 users are trying to modify the same record at the same time! A (customizable) window automatically comes up and asks for the correct value.
No programming is required.


 


All data types are supported

HyperFileSQL supports all the file data types:

• binary and character strings (phonetic find is available)
• numeric (integer, real, currency, etc.)
• date, time, duration
• text and binary memo (image, sound, video, etc.)
• the "NULL" value is also supported

All key types are supported: automatic identifier, text, numeric, date, time, composite key.

FEATURES
- 128 bit encryption
- Referential integrity
- Log files
- Replication
- Transactions
- Triggers
- Import Export
- On the fly Compression/
  Decompression of memos

TECHNOLOGIES
- Automatic maintenance
- Concurrent access management
- Zero administration
- Resume automatically after incident
- Automatic deployment