2010, Tuesday August 24
By A.Bouchez on 2010, Tuesday August 24, 11:16 - SQLite3 Framework
The Synopse SQLite3 Database Framework was just released under version
1.9.1:
- internal SQLite3 database engine is updated to version 3.7.2;
- new TSQLRecordFTS3 record, for using FTS3 virtual tables, i.e. implementing
full-text search;
- new SQLite3UIEdit unit, to edit table content with a dialog created from
RTTI;
- new dedicated BLOB methods and JSON array serialization;
- a lot of fixes and speed enhancements (including our HTTP/1.1 RESTful server
now using Thread Pool).
The new 3.7.2 version of the SQLite3 engine, which is mandatory according to
SQLite3's authors, is included.
Continue reading...
no trackback
2010, Thursday August 19
By A.Bouchez on 2010, Thursday August 19, 10:48 - SQLite3 Framework
In software engineering, multi-tier architecture (often referred to as
n-tier architecture) is a client–server architecture in which the presentation,
the application processing, and the data management are logically separate
processes. For example, an application that uses middleware to service data
requests between a user and a database employs multi-tier architecture. The
most widespread use of multi-tier architecture is the three-tier
architecture.
Both ORM and RESTful aspects of our framework makes it easy to develop using
such a three-tier architecture.
Continue reading...
no trackback
2010, Friday July 2
By A.Bouchez on 2010, Friday July 2, 10:11 - Pascal Programing
RESTful JSON is still a buzzing process... there is no standard yet, and
they should not be, since JSON itself has its own RFC, and REST is a powerful
but vague statement.
Continue reading...
no trackback
2010, Monday May 24
By A.Bouchez on 2010, Monday May 24, 10:34 - SQLite3 Framework
Our SQLite3 Framework has been updated into the 1.7 version. For Delphi 7 to
Delphi 2010.
Mostly User-Interface (reporting) enhancements, and some bug fixes.
Continue reading...
no trackback
2010, Sunday March 14
By A.Bouchez on 2010, Sunday March 14, 15:16 - SQLite3 Framework
Our SQLite3 Framework has been updated into the 1.5 version.
Continue reading...
no trackback
2010, Monday February 8
By A.Bouchez on 2010, Monday February 8, 14:29 - SQLite3 Framework
The framework has been updated, and is released now under the LGPL license (public domain
license was found to be confusing).
Continue reading...
no trackback
2010, Sunday January 24
By A.Bouchez on 2010, Sunday January 24, 17:28 - SQLite3 Framework
The SQLite3 Framework has been updated. Three
sample applications are provided, in order to show basic ORM features of the
framework.
Continue reading...
no trackback
2010, Friday January 22
By A.Bouchez on 2010, Friday January 22, 22:11 - SQLite3 Framework
The version 1.3 of the Synopse SQLite3 Framework is just released. It's a
minor release, with bug fixes, especially for Delphi 2009/2010.
Continue reading...
no trackback
2010, Monday January 18
By A.Bouchez on 2010, Monday January 18, 00:16 - SQLite3 Framework
The version 1.2 of the Synopse SQLite3 Framework is just released. Includes
latest SQLite3 engine version 3.6.22. Now tested on Delphi 7, 2007
and 2009, it should work on all Delphi compiler versions from 3 to 2010.
Continue reading...
no trackback
2010, Thursday January 14
By A.Bouchez on 2010, Thursday January 14, 22:43 - SQLite3 Framework
The version 1.1 of the Synopse SQLite3 Framework is just released. Includes
latest SQLite3 engine version 3.6.22. Delphi 3 to Delphi 2007 compatiblity,
first attempt to compile under Delphi 2009/2010 and FPC.
Continue reading...
no trackback
2010, Tuesday January 5
By A.Bouchez on 2010, Tuesday January 5, 17:26 - SQLite3 Framework
Question posted in the embarcadero forum:
Is there a way in your wrapper to know whether the field is NULL (say,
Integer or String field)?
In most databases '' and null are different values.
Thanks,
Michael
Continue reading...
no trackback
2009, Sunday December 20
By A.Bouchez on 2009, Sunday December 20, 18:03 - SQLite3 Framework
More details (source code, JSON, REST) about this framework.
Continue reading...
no trackback
2008, Saturday March 8
By A.Bouchez on 2008, Saturday March 8, 17:32 - SQLite3 Framework
The Synopse SQLite3 database Framework interfaces the SQlite3
database engine into pure Delphi code: database access, User Interface
generation, security, i18n and reporting are handled in a safe and fast
Client/Server AJAX/RESTful model.
Continue reading...
no trackback