SQLite3 Framework
Entries feed
2010, Tuesday August 24
By A.Bouchez on 2010, Tuesday August 24, 11:16
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...
2010, Thursday August 19
By A.Bouchez on 2010, Thursday August 19, 10:48
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...
2010, Wednesday August 4
By A.Bouchez on 2010, Wednesday August 4, 00:48
The SQLite3 MainDemo source code has just been uploaded to the repository.
This application is just a database tool which stores text content and files
into the database, in both clear and "safe" manner. Safe records are stored
using AES-256/SHA-256 encryption. There is an Audit Trail table for tracking
the changes.
Continue reading...
2010, Thursday July 22
By A.Bouchez on 2010, Thursday July 22, 22:44
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.
Continue reading...
2010, Sunday July 18
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.
Continue reading...
2010, Monday July 12
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.
Continue reading...
2010, Monday May 24
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.
Continue reading...
2010, Sunday March 14
By A.Bouchez on 2010, Sunday March 14, 15:16
Our SQLite3 Framework has been updated into the 1.5 version.
Continue reading...
2010, Monday February 8
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).
Continue reading...
2010, Sunday January 24
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.
Continue reading...
2010, Friday January 22
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.
Continue reading...
2010, Monday January 18
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.
Continue reading...
2010, Thursday January 14
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.
Continue reading...
2010, Tuesday January 5
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
Continue reading...
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;
Continue reading...
2010, Friday January 1
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.
Continue reading...
2009, Sunday December 20
By A.Bouchez on 2009, Sunday December 20, 18:18
How to download and install the source code of this framework.
Continue reading...
By A.Bouchez on 2009, Sunday December 20, 18:03
More details (source code, JSON, REST) about this framework.
Continue reading...
2008, Saturday March 8
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.
Continue reading...