The SQLite3 Framework has been updated. Three sample applications are provided, in order to show basic ORM features of the framework.
January 2010 (10)
2010-01-22
Synopse Enhanced Framework version 1.3
2010-01-22. Open Source › mORMot 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.
2010-01-18
Synopse SQLite3 Framework version 1.2
2010-01-18. Open Source › mORMot Framework
Enhanced System Run Time for Delphi 7 and Delphi 2007
2010-01-18. Open Source › Enhanced Delphi Run Time
I managed to get our RTL work with Delphi 2007. Only System.pas and SysInit.pas are supplied (and needed) for Delphi 2007. Even if some John O'Harrow or Pierre Le Riche modifications were already included in Delphi 2007, some of my tricks are unique and could be useful even on this compiler.
2010-01-14
Synopse SQLite3 Framework version 1.1
2010-01-14. Open Source › mORMot 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.
Updated Enhanced System Run Time patches
2010-01-14. Open Source › Enhanced Delphi Run Time
It did appear that some diverse VCL source code files were provided, with the same official version. So I made some diverse patches, in order that everyone could get our enhancements.
2010-01-05
New Enhanced System Run Time Distribution
2010-01-05. Open Source › Enhanced Delphi Run Time
Tonight, I received an email from Nick Hodges, the Delphi Development Manager, about our distribution of some corrections/enhancements of the Delphi 7 System and VCL source code.
Synopse SQLite3 Framework: NULL handling
2010-01-05. Open Source › mORMot 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
Synopse SQLite3 Framework: why ORM?
2010-01-05. Open Source › mORMot Framework
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-01-01
Synopse SQLite3 Framework installation
2010-01-01. Open Source › mORMot Framework
Some details about the current framework status, and the fact that it does compile only under Delphi 7 by now.