FSSQL Client-Server SQL Database

WELCOME TO FSSQL
CLIENT-SERVER SQL DATABASE

About project

FSSQL is a professional, compact, open source client/server database engine for programmers developing applications with Borland Delphi or C++ Builder. Because of its open architecture and extendibility, FSSQL easily supports large client/server systems and grows with you as your requirements expand. Because of its small size and speed, the FSSQL Server engine can also be embedded in your stand-alone applications. FSSQL is also an excellent alternative to the Borland Database Engine (BDE). Since FSSQL is small and doesn't require any external libraries, it is much easier to deploy than other database systems bogged down with run-time files.

FSSQL is tightly integrated with Borland Delphi and Borland C++Builder, so you can quickly use FSSQL right out of the box. FSSQL data access components are TdataSet descendants, allowing third-party and VCL components such as TDataSource or TDBGrid to seamlessly connect with FSSQL tables.

FSSQL also includes FSSQL Explorer, an application developed using FSSQL Client. It provides database creation, importing, browsing, and maintenance capabilities. With FSSQL Explorer, standard maintenance tasks such as changing the structure of a table can be done at the click of a mouse button. We provide the full source code for FSSQL Explorer so you can use the same techniques in your own client applications. FSSQL gives you the security you need. FSSQL Server can be configured so that all access to data requires the user to log on. For further security, especially across the Internet, data passed between client and server is encrypted. In addition, FSSQL can encrypt physical data on disk. With FSSQL's open architecture and free source code, you can extend or modify the security features as necessary.

FSSQL based on TurboPower FlashFiler 2.13 but not compatible. Support for Delphi 5, 6, 7, 2005, 2006, BCB5, 6

Future (next generation FSSQL 2.xxx):
- views,
- procedures,
- users' right,
- single file,
- full unicode support,
- new object type (field),
- better support for writes of large BLOB,
- support for version of record ( possible the reading the previous versions ),
- script language for queries, manipulation the data etc..,
- version for linux,
- great safety,
- ....

Next generation FSSQL 2.xxx must be completely rewritten for use new properties and function.

Key Features FSSQL 1.xxx

SQL Query Support	Use powerful SQL SELECT statements to find exactly the data you want. Supports parameterized queries, nested queries, and built-in functions too!
Huge Tables	Create and manage huge data stores limited only by your operating system, file system and available drive space. An excellent option for multimedia databases!
Extensible, multi-threaded FSSQL Server	The new multi-threaded FSSQL Server handles multiple requests from many connected clients at once.
Advanced, Component-based Server Architecture	New thread-safe Transport, Command Handler, and Server Engine components can be flexibly mixed and matched to meet your exact needs. You can even use more than one FSSQL Server in an application!
FSSQL Windows Service	Now you can run FSSQL Server as a Windows Service on Microsoft Windows NT or Windows 2000. The new FSSQL Service runs "in the background" without user intervention, and writes server errors or debugging information to the Windows Event Log.
Improved FSSQL Explorer	FSSQL Explorer makes database administration easier with the ability to browse multiple tables at once, built-in SQL query window, search and filtering capabilities, and more.
Faster SingleEXE applications	Simplified communications between your program and the FSSQL Server make applications with embedded FSSQL Servers (SingleEXE mode) faster than ever before. You can even connect with remote servers now from SingleEXE programs too!
Huge BLOB support - up to 2GB	FSSQL stores binary large objects (BLOBs) like pictures, sound, and video. The result is improved performance and significantly less wasted space in your database tables.
True client/server architecture	Create client applications that seamlessly interact with the powerful FSSQL Server. Even embed the Server engine in your own programs for easy distribution.
Concurrent transactions	FSSQL allows multiple transactions to execute in parallel increasing the responsiveness and throughput of your applications.
Server Plug-Ins Architecture	Add your own functionality to the FSSQL Server by writing custom Plug-Ins that can add your own customized functionality.
Server Monitors & Extenders	Tie in to key FSSQL Server events to monitor database activity or actually participate in the Server's functionality. An ideal architecture to designing limits on concurrent access or implementing audit trails of database activity.
Security system	FSSQL offers both login security and support for encrypted tables. In addition, all messages between client applications and the FSSQL Server are encrypted. You can even replace the FSSQL encryption subsystem with your own encryption mechanism.
Timeout handling	Each client-side component now has a Timeout property and FSSQL Server now calculates its timeouts based on the component's settings.
Support undelete	FSSQL support undelete record.
Protect individual record before delete or update	Now possibility protect rows on table.
Triggers and Referential integrity	FSSQL offers triggers mechanism and referential integrity.