- SQLite3 database layer updated to version 3.6.23.1
- alter table with newly added fields to a TSQLRecord
SQLite3Commons unit:
- SQLite3 database layer updated
to version 3.6.23.1
- most useful functions are now shared in a separate SynCommons unit
- the framework is now licensed under a MPL/GPL/LGPL tri-license
- obscure JSON parsing bug fixed (when a field content finished with '\')
- alter table with newly added fields to a TSQLRecord (see GetSQLAddField()
methods)
- some compatibility fixes for Delphi 2009/2010
- fixed bug: negative numbers were not updated when calling *.Update()
SQLite3Pages unit:
- new version, using our SynGdiPlus unit: if the GDI+ is available, it will use
it to render the page using its AntiAliased engine
- direct export of the report as PDF, by using our new SynPdf unit
SynPdf unit:
- first public release, corresponding to
SQLite3 Framework 1.7
- can use the Windows Uniscribe API to render Ordering and Shaping of the text
(see USE_UNISCRIBE conditional below)
- issue corrected in TPdfEnum.DrawBitmap() method - occured e.g. when drawing a
bitmap using a VCLCanvas
- rare issue corrected in TPdfWrite.AddUnicodeHexTextUniScribe() method
- added TPdfBox with Width and Height properties
- minor corrections in Uniscribe part of the rendering engine
- added RightToLeftText property in TPdfCanvas (Uniscribe-only)
- handle ETO_RTLREADING option (Uniscribe-only) in VCLCanvas/TMetaFile
SynGdiPlus unit:
- first public release on
http://synopse.info blog
- new TGDIPlusFull with most usefull GDI+ primitives (ancestor TGDIPLus only
handles pictures)
- TGDIPlusFull loads dynamicaly the latest GDI+ version available on the
system, i.e. the 1.1 version bundled with Office 2003/2007 (all the other
pascal GDI+ units use static linking, therefore only link to the OS version,
even if a newer one if available within the Office folder)
- draw an EMF created from GDI commands into a GDI+ Antialiased canvas (this
unit can work without the GDI+ library, e.g. under Windows 98 or 2000, but
won't use new pictures format nor antialiasing)
The full source code from the framework is available to download from
SynopseSQLite3.zip
licensed under a MPL/GPL/LGPL tri-license.
Compatible with Delphi 7 to Delphi 2010.
15 reactions
1 From esmond - 28/05/2010, 17:12
I've got a problem with the GetJSONValues function at line 3799 in SQLite3Commons. It seems to ignore rowFirst and rowLast if you want a range of records.
A solution which worked for me is to change lines 3819-3823 to:
if RowLast=0 then
RowLast := RowCount;
if RowLast > RowCount then
RowLast := RowCount;
if RowFirst<=0 then
RowFirst := 1;
U := @fResults[FieldCount*RowFirst];
Otherwise great work!
2 From blofeld_es - 04/06/2010, 11:11
Is the SQLite RTREE-capability present in either of the obj-files that are provided with the download?
3 From mai62 - 06/06/2010, 08:40
Gimme please any example for working with blob fields.
4 From longge007 - 12/06/2010, 04:00
when i downloaded SynopseSQLite3.zip here, i opened the testSQlite3.dproj in Delphi2007, when compiling, an error occures,
[DCC Error] TestSQL3.dpr(45): E2003 Undeclared identifier: 'SQLite3Http_Test'
anybody can help me? thanks a lot
5 From A.Bouchez - 12/06/2010, 08:57
It's strange, since this procedure is declared and implemented in SQLite3HttpServer.pas
There is no problem with my Delphi2007 compiler.
Didn't you modify the test project source code, or make a mix between this version and an older version or your hard drive? I suspect you open an old version of TestSQLite3... so don't open testSQLite3.dproj by directly the TestSQLite3.dpr file in Delphi 2007. You'll be able to compile.
6 From A.Bouchez - 12/06/2010, 09:24
For Esmond and its first comment on this page:
Yes, you're right, there was a problem with RowFirst.
It's fixed in upcoming version 1.8.
7 From longge007 - 12/06/2010, 10:00
somebody can write some details about how to use it In Delphi2007,including installation ,and setting, for now i am defeated
next are my steps:
1.i downloaded version1.7
2.uncompresed it in one directory,
3.start delphi2007
4.Open testSqlite3,
5.Run
6.datal Error.
8 From longge007 - 12/06/2010, 10:32
To A.Bouchez
i delete old version 1.7, and redownload version1.7, and begin compile.[Open the 01-In memory ORM / project01.dpr]. The Error is
[DCC Error] SampleData.pas(18): E2003 Undeclared identifier: 'RawUTF8'.i don't use ENhancedRTL or LVCL.
the project default search path is "D:\Dev\Lib\LVCL;..\..;E:\Self2007\SynopseSQLite3"
My OS is Vista Chinese.and Delphi2007 is CodeGear™ RAD Studio for Microsoft® Windows™ Version 11.0.2627.5503 .
9 From longge007 - 13/06/2010, 03:59
To esmond
Can you write some some details about installation of Framwork 1.7 in delphi2007. thanks a lot
10 From longge007 - 18/06/2010, 04:47
I want to know whether or not this Framework can work well when there are many clients.thanks a lot
11 From longge007 - 18/06/2010, 05:42
Anybody can test:
if you only copy the directory EXE to other PC,run projec03Server ,perhaps there is an Error,
and test pipe model,
Form1.Database := TSQLRestClientURINamedPipe.Create(Form1.Model,'\127.0.0.1\pipe\Sqlite3_03'); running is right In Local。if want to connect remote PC, it does't work.
can't find file ' \192.168.0.16\pipe\Sqlite3_03'
or somebody can tell me other settings.thanks alot
12 From A. Bouchez - 18/06/2010, 13:55
Named pipes are mostly to be used localy on the same computer.
You can put a server name, following the official MSDN guidelines from http://msdn.microsoft.com/en-us/lib...).aspx
\ServerName\ is supposed to follow the SMB naming, not IP. You have to put the computer name on the windows network, not its IP.
If you want client/server access which could pass through firewalls and identify itself as IP, perhaps you should use the HTTP protocol instead of named pipes. It works well.
The framework could handle a lot of clients at the same time. It should have a very good response time. The main bottleneck here seems to be the windows network layer itself, and, if you've got one, your anti-virus program (for example, I use Nod32 and get 200-300 requests per seconds when it's ON, but more than 2000 when its OFF....)
13 From A.Bouchez - 21/06/2010, 11:16
14 From A.Bouchez - 27/06/2010, 18:14
About installation, I've just posted something on our forum:
http://synopse.info/forum/viewtopic.php?id=33
and you'll discover the new unitary tests introduced with version 1.8.