لقد انتهيت من برمجة faimo Database

بسم الله الرحمن الرحيم

اما بعد فالسلام عليكم و رحمة الله و بركاته

لقد انتهيت من برمجة faimo Database و هو نظام و برنامج لانشاء قواعد البيانات او DBMS للمبرمجين ب Borland Delphi / C++Builder and Kylix

فهو سينسيك فالدلفي BDE .

و ال faimo Database له 5 مكونات هي

TFAITable, TFAIQuery, TFAIDatabase, TFAISession, TFAIBatchMove و كلها لها نفس خصائص مكونات قاعدة البيانات لدلفي لكن مع بعض الخصائص الغير متوفرة في Delphi BDE

و ال faimo Database لا تحتاج لاي ملف في تنصيب البرنامج يعني ليس كالدلفي BDE فاهذا الاخير عندما تنهي انشاء قاعدة بيانات فسوف تحتاج لارسال ملفات مع برنامجك او انالجهاز يجب ان يتوفرعلى محرك ال BDE لكي يستطيع برنامجك القراءة و الكتابة لقاعدة البيانات اما مع faimo Database فاانت لاتحتاج لاى ملف BDE و لا DLLs

هذه بعض خصائص faimo Database :

compiles right into executable application file; no BDE, no DLLs requires;
- multi-user concurrent read / write access (both file-server and client/server mode);
- multi-thread access enables to develop thread-safe applications, for example, web application;
- multiple tables in a single-file database;
- SQL & DDL commands support;
- Referential Integrity support (SQL'99 compliance)
- DB-aware controls and tools compatibility;
- IProvider support for TClientDataset compatibility;
- master / detail relationship;
- creating, renaming, emptying, deleting, restructuring and repairing tables;
- creating, editing, deleting, browsing and searching for records;
- creating and deleting multiple indexes;
- calculated and lookup fields;
- fast searching using multiple indexes;
- filtering support;
- default values support;
- record-level constraints;
- Key and Range methods;
- tables and database restructuring and repairing routines;
- progress bar support;
- using BLOB fields with data compression ability;
- Varchar support with optional compression;
- strong database encryption with wide variety of algorithms;
- custom memory manager speed up operation and guarantees low memory usage;
- in-memory mode is also available to speed up the work with small tables;
- shareable in-memory tables;
- transactions support with READ COMMITTED isolation level;
- batch operations with groups of records;
- backup-restore capabilities;
- triggers - database and server events;
- reverse engineering (table or whole database to SQL script export);
- capability of database embedding inside the executable file;
- importing from and exporting to any data source in fast and easy way;
- internationalization / localization and Unicode support. 

Faimo Database is a fully functional database system; it includes visual components, utilities .

The core of Faimo Database TFaiTable, which is a fast and easy TTable replacement, provides all the TTable functions such as master / detail relationship, filtering, searching, sorting, blob fields, key and range methods, as well as some advanced features like table and database encryption, blob fields compression and multiple indexes. 

All the components are fully compatible with standard DB-aware controls as well as with the most of third-parties database tools such as DBGrids, Tries, Report Generators, etc. 

Faimo Database System allows easy migration from the database systems you used and has the widest functionality to help you to save your time of development. It provides an access to databases from different OS and environment to give you the fabulous flexibility. 

Faimo Database System is a complete database solution which can help provide return on investment by capitalizing on new, revenue-generating software with respond to requests from new prospects at low cost, allowing you to extend your reach to new markets. 
--
SQL & DDL commands support. 
Data types:
ftFixedChar, ftString, ftWideString, ftSmallint, ftInteger, ftLargeint, ftWord, ftAutoInc, ftFloat, ftBoolean, ftCurrency, ftDate, ftTime, ftDateTime, ftTimeStamp, ftBytes, ftVarBytes, ftDBaseOle, ftParadoxOle, ftTypedBinary, ftBlob, ftGraphic, ftMemo, ftFmtMemo 
Advanced data types:
aftUnknown, aftChar, aftString, aftWideChar, aftWideString, aftShortint, aftSmallint, aftInteger, aftLargeint, aftByte, aftWord, aftCardinal, aftAutoInc, aftAutoIncShortint, aftAutoIncSmallint, aftAutoIncInteger, aftAutoIncLargeint, aftAutoIncByte, aftAutoIncWord, aftAutoIncCardinal, aftSingle, aftDouble, aftExtended, aftBoolean, aftCurrency, aftDate, aftTime, aftDateTime, aftTimeStamp, aftBytes, aftVarBytes, aftBlob, aftGraphic, aftMemo, aftFormattedMemo, aftWideMemo 
Default page size: 4096 bytes (4 Kb). 
Minimum page size: 128 bytes. 
Maximum page size: 65535 bytes (64 Kb without 1 byte). 
Maximum number of pages per database file: 231 (over 2 billions). 
Maximum record size: 231 bytes (over 2 billions). 
Maximum number of  connections: 100,000,000 . 
Maximum fields per table: 231 (over 2 billions). 
Maximum indexes per table: 231. 
Maximum index fields per index: 231. 
Maximum index entry size: (PageSize - 128) / 2. 
Maximum field name's length: 255 characters. 
Maximum index name's length: 255 characters. 
BLOB fields block size: > 1 byte, default 100 KB. 
BLOB and Varchar compression algorithms: ZLib, BZip, PPM. 
Database encryption: 12 strong encryption algorithms . 
Search operators: <,>,=,<>,<=,>=, like, not like, is null, is not null, and, or, not, (). 
SQL Support :
SELECT [DISTINCT | ALL] 
* | column [AS correlation_name | correlation_name], [column...] 
[INTO destination_table] 
FROM table_reference [AS correlation_name | correlation_name] [Password 'password']
[[[[NATURAL][INNER | [LEFT | RIGHT | FULL] OUTER JOIN] table_reference [AS correlation_name | correlation_name] 
[ON join_condition] | USING (join columns)] 
[WHERE predicates] 
[GROUP BY group_list] 
[HAVING predicates] 
[ORDER BY order_list] 
[UNION [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[EXCEPT | MINUS [ALL] [CORRESPONDING [BY (column_list)]] SELECT...]
[INTERSECT [ALL] [CORRESPONDING [BY (column_list)]] SELECT...] 
CREATE TABLE, DROP TABLE, ALTER TABLE statements 
CREATE INDEX, DROP INDEX statements 
INSERT, UPDATE, DELETE statements 
SQL scripts (multiple commands separated by ';') 
BETWEEN, IN, EXISTS, LIKE, IS NULL operators 
Aggregate functions COUNT,SUM,MIN,MAX,AVG 
Most of all SQL'92 arithmetic, logical, datetime and string expressions, functions and operators 
Data types conversion function CAST 
Parameters in queries 
Uncorrelated subqueries 
START TRANSACTION, COMMIT, ROLLBACK

و خصائص اخرى ...

و لانني انتهيت منها فسوف اطلب من الاخوة الاعزاء :

romanof

DeltaAziz

زاهر سعيد

ORWA

ان يجربوها و يعطوا ارائهم و لهذا ارجوا منهم ان يرسلوا لي كلمات السر التي سوف اضعها في برنامج التنصيب و ابعثه لهم يعني للتنصيبها لابدا من كلمة السر

و السلا عليكم و رحمة الله و بركاته