The Synopse SQLite3 Database Framework was just released under Version 1.8.
SQLite3 just officially reached version 3.7.0, so it's time to commit our changes from our source code repository to the main "stable" zip.
SQLite3 Framework
2010, Sunday July 18
DataSnap-like Client-Server JSON RESTful Services in Delphi 7-2010
By A.Bouchez on 2010, Sunday July 18, 17:44
You certainly knows about the new DataSnap Client-Server features, based on
JSON, introduced in Delphi 2010.
http://docwiki.embarcadero.com/RADStudi
… plications
We added such communication in our SQLite3 Framework, in a KISS (i.e. simple) way: no expert, no new unit or new class. Just add a published method Server-side, then use easy functions about JSON or URL-parameters to get the request encoded and decoded as expected, on Client-side.
2010, Monday July 12
Draft Documentation of the Synopse SQLite3 Framework
By A.Bouchez on 2010, Monday July 12, 14:55
As a tutorial about SynProject, the documentation for the SQLite3 framework itself has been generated for the first time.
2010, Monday May 24
SQLite3 Framework version 1.7
By A.Bouchez on 2010, Monday May 24, 10:34
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.
2010, Sunday March 14
SQLite3 Framework version 1.5
By A.Bouchez on 2010, Sunday March 14, 15:16
Our SQLite3 Framework has been updated into the 1.5 version.
2010, Monday February 8
SQLite3 Framework version 1.4
By A.Bouchez on 2010, Monday February 8, 14:29
The framework has been updated, and is released now under the LGPL license (public domain license was found to be confusing).
2010, Sunday January 24
SQLite3 Framework updates and Samples
By A.Bouchez on 2010, Sunday January 24, 17:28
The SQLite3 Framework has been updated. Three sample applications are provided, in order to show basic ORM features of the framework.
2010, Friday January 22
Synopse Enhanced Framework version 1.3
By A.Bouchez on 2010, Friday January 22, 22:11
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.
2010, Monday January 18
Synopse SQLite3 Framework version 1.2
By A.Bouchez on 2010, Monday January 18, 00:16
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.
2010, Thursday January 14
Synopse SQLite3 Framework version 1.1
By A.Bouchez on 2010, Thursday January 14, 22:43
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.
2010, Tuesday January 5
Synopse SQLite3 Framework: NULL handling
By A.Bouchez on 2010, Tuesday January 5, 17:26
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
Synopse SQLite3 Framework: why ORM?
By A.Bouchez on 2010, Tuesday January 5, 17:20
In the codegear forum, I posted this example code, to illustrate the Object-relational mapping (ORM) aspect of the framework :
People := TSQLPeople.Create;
try
People.Name := 'Smith';
People.Address := 'New York City';
People.BirthDate := Now;
ID := Client.Add(People);
finally
People.Free;
end;
Albert Drent posted this question:
What's the advantage above the usage of SQL?
with MyQuery do begin
sql.text := 'insert into people values ("Smith","New York City","2008-01-01")';
execSQL;
end;
2010, Friday January 1
Synopse SQLite3 Framework installation
By A.Bouchez on 2010, Friday January 1, 15:39
Some details about the current framework status, and the fact that it does compile only under Delphi 7 by now.
2009, Sunday December 20
Synopse SQLite3 database Framework download
By A.Bouchez on 2009, Sunday December 20, 18:18
How to download and install the source code of this framework.
SQLite3 Framework
By A.Bouchez on 2009, Sunday December 20, 18:03
More details (source code, JSON, REST) about this framework.
2008, Saturday March 8
SQLite3 Framework
By A.Bouchez on 2008, Saturday March 8, 17:32
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.