mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Synopse SQLite3 Framework 1.13/1.14

This is a major step for the framework.

Among a lot of new features and bug fixes:
- Dynamic arrays and Record handling, including low-level access and high-level handling for the ORM part of the framework (using TDynArray wrapper);
- Business rules now handled via filtering and validating classes for both our ORM and the Synopse Big Table;
- New full-featured logging classes, with exception handling, stack trace and JSON serialization;
- Custom SQL functions and TSQLRecordRTree to implement R-Tree virtual tables;
- Batch sequences for adding/updating/deleting multiple records;
- Secure RESTful authentication via per-user light sessions, and per-query signature;
- Define custom Virtual Tables (i.e. access any kind of data from SQL) in Delphi code;
- New HTTP server using fast http.sys kernel-mode server and zip / SynLZ compression;
- SynTaskDialog unit native under Vista,Seven with emulation code under XP/2000 ;
- User Interface automated Generation using standard VCL or proprietary TMS components;
- Documentation completed - more than 600 pages by now, including general User Guide and exhaustive Technical Reference;
- Updated SQLite3 database engine to version 3.7.6.3;
- Numerous bug fixes, speed and feature enhancements (including in the PDF and other UI-related units).

Open Source project, for Delphi 6 up to XE, licensed under a MPL/LGPL/GPL tri-license.

edwinsn

Member

Registered: 2010-07-02

Posts: 1,218

Re: Synopse SQLite3 Framework 1.13/1.14

Great job, Arnaud!

Thank you for your effort!

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

harjonolay

Member

Registered: 2011-06-06

Posts: 1

Re: Synopse SQLite3 Framework 1.13/1.14

can sqlite3 framework use firebird database engine firebirdsql.org

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Synopse SQLite3 Framework 1.13/1.14

can sqlite3 framework use firebird database engine firebirdsql.org

Check the forum about this question.
http://synopse.info/forum/viewtopic.php?id=193

Short answer: not yet, and not needed since SQLite is great and faster with our Client-Server architecture.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Synopse SQLite3 Framework 1.13/1.14

Upgraded to revision 1.14.

Mainly a bug fix release.
See  http://blog.synopse.info/post/2011/06/2 … ework-1.14