Smithware Home PageSmithware Product InformationHow to Order Smithware ProductsSmithware Technical SupportSearch the Smithware Web SiteBtrieve Developer's Journal MagazineContact Smithware by E-mailPervasive Software Home Page Smithware Home Page

Scalable SQL

Note: On February 13, 1998, Smithware was acquired by Pervasive Software. This site is an archive of the materials that were on the Smithware site when www.smithware.com was routed to www.pervasive.com. This site is maintained for archival purposes only.

ActiveX Controls for Btrieve
I*net Data Server
Crystal Reports for Btrieve
DDF Builder
DDF Sniffer
VBX Controls for Btrieve
Butility for DOS


Other Products Available Through Smithware's Product Marketing Group:

BSqueeze
Btrieve
ODBC Interface
Scalable SQL

Note: On February 13, 1998, Smithware was acquired by Pervasive Software. This site is an archive of the materials that were on the Smithware site when www.smithware.com was routed to www.pervasive.com. This site is maintained for archival purposes only.



Scalable SQL 4 is the leading SQL database for delivering client/server applications.

Scalable SQL 4, Pervasive Software Inc.'s relational client/server database, is uniquely designed to be bundled in high volume client/server applications. Scalable SQL 4 provides seamless scalability, deployment licensing and packaging, maintenance-free operation, small memory footprint and multiplatform support.

Application Scalability

Scalable SQL 4 allows developers to scale applications from mobile systems to client/server environments without changing the application or the database.

Deployment Licensing and Packaging

Scalable SQL 4 is licensed for high volume deployment of applications ($2 per seat for 1,000-seat Workstation Commercial Deployment Kit). Licensing includes distribution of a fully functional workstation engine.

Maintenance-free Operation

Scalable SQL 4 is simple to install and use. It requires no extensive performance setup or ongoing tuning by a database administrator.

Small Memory Footprint

Scalable SQL 4 has a small footprint, requiring only 4MB of memory.

Multiplatform Support

Scalable SQL 4 provides multiplatform support including Windows, Windows NT, Windows 95 and NetWare.

Feature Highlights
Programming Extensions

Inscribe: Visual Basic Compatible Scripting provides an industry standard language for developing routines that can be executed directly or from within an application.

Stored Procedures improve performance and reduce network traffic by allowing applications to call precompiled subroutines which are processed by the database engine. Supports ANSI standard SQL and Visual Basic compatible stored procedures.

Triggers enforce business rules at the database level by initiating a user defined stored procedure when specified update events occur. Supports ANSI standard SQL and Visual Basic compatible triggers.

Cost-based Optimization

Statistical analysis improves query performance by determining the fastest access plan.

Enhanced fetch algorithms provide efficient data access.

Transaction Processing Enhancements

Nested transactions allow transactions to be composed of small sub-transactions and minimize the time required for rollback operations.

Full transactional logging records all database operations in a single log file, improving transaction durability.

Standards Enhancements

Open Database Connectivity (ODBC) provides an industry standard data access mechanism for Windows applications via Pervasive's high performance ODBC Interface.

Full transactional logging records all database operations in a single log file, improving transaction durability.

Other New Features

Additional Windows utilities improve ease-of-use and include monitor, administration and maintenance tools.

Very large file support increases the maximum database file size from 4 gigabytes to 64 gigabytes.

TIMESTAMP, UNSIGNED and CURRENCY data type variables are compatible with Visual Basic and Access(tm) data types and enable seamless application integration.

Scalable SQL Product Line
Developer Kit

Provides everything required to build and test applications. Includes five-user Scalable SQL 4 for NetWare and NT test server engines, API documentation, Inscribe Developer Kit, ODBC Interface, SupportAbility, Programmer Language Interfaces.

Platforms: DOS, Windows 3.x, Windows NT and Windows 95.

Workstation Engine‚ Single Seat

Allows users to run Scalable SQL 4-based applications on a single system, either in single-user mode or network file-sharing mode. Includes installation and operation documentation and software.

Platforms: Windows 3.x, Windows NT, and Windows 95. Includes Pervasive's ODBC Interface. Call for availability.

Commercial Deployment Kit

Allows the distribution of up to 1,000 seats of the Scalable SQL 4 Workstation Engine with an application. Includes software.

Platforms: Windows 3.x, Windows NT and Windows 95.

Client/Server Database Engine

Licensed on a per server basis with a specific user count. Available counts include: 10, 20, 50, 100, and unlimited. Includes installation and operation documentation and software.

Platforms: NetWare and Windows NT.

Technical Specifications
ANSI SQL and IBM SAA compatible

Maximum table size: Up to 64 gigabytes

Maximum open tables: Only limited by operating system resources

Maximum row size: 32 kilobytes

Maximum rows per table: No limit

Maximum index length: 255 bytes

Maximum indexes per table: 119

Index attributes: duplicable or non-duplicable (a.k.a. unique), linked/repeating duplicable (a.k.a. named), modifiable or non-modifiable, segmented or non-segmented, ascending or descending sorting, case-sensitive or case-insensitive sorting, alternate collating sequence sorting, null all segments or non-null, and auto-increment

16-bit requesters: Windows, Windows 95, Windows NT

32-bit requesters: Windows 95, Windows NT

DOS requesters


 
To Order Call Toll-Free (800) 828-7438 or (615) 386-3100 or

CLICK HERE

for on-line ordering information!

 

Copyright © 1988, 1998 by Smithware, Inc. All rights reserved.
Smithware, Controls for Btrieve, DDF Builder, DDF Sniffer, Btrieve Developer's Journal, and Power Tools for Btrieve are trademarks of Smithware, Inc. Btrieve is a registered trademark of Pervasive Software, Inc. ActiveX, Windows, Windows NT, and Internet Explorer are trademarks of Microsoft Corp. All other product or brand names are trademarks or registered trademarks of their respective owners. Legal Notice.