[DUG] BERLIN and DB connectivity

[John Bird]

My most recent serious DB work was using standard IB components to open two embedded Firebird databases and ADO to use MSSQL DB, and using TCLientDataSets to merge data from all of them.     There has always been a reasonable number of good options of what component sets to use – even the old BDE works great, the only real disadvantage is having to install and configure a separate product.   I expect that the FireDac is very capable – for instance I have read (but not tried) that later versions allow one to do SQL joins on different ClientDataSets which would have been most useful in my previous project.

As far as n tiered, I have had dealings with a current substantial Delphi product that is 3 tiered but I am not sure if Datasnap is the technology used, there is a good chance – I understand they have parallel code bases using Delphi for Windows and Free Pascal for Mac, and can point at either Firebird or MSSQL on Windows (Firebird on Mac).  In other limited experience with Datasnap it worked as expected.

Android and iOS, haven’t done more than toy projects yet myself, but so far looks like it should scale.

Note about web browsers, on iOS and Mac TWebBrowser drives Safari, and on Android it drives Chrome.  Means that it has a fairly sparse set of events as its a lowest common denominator, but it certainly works and is the native browser – I knocked up a program for various OS’s with an Embedded web browser in a few minutes, runs nicely on the Nexus and Windows.

I have seen what David did with driving the native Safari browser using the code from the Windows VCL, bypassed Firemonkey altogether to get to the full native Safari.   Works very well, hardest part is getting to grips with Xcode and Cocoa world of delegates and pointers to everything, but certainly Delphi Berlin joined the Windows IDE and XCode together very thoroughly.

From: Tony Blomfield 
Sent: Wednesday, August 17, 2016 7:16 PM
To: NZ Borland Developers Group - Delphi List 
Subject: [DUG] BERLIN and DB connectivity

Some generic questions. I have just started using Berlin.

 

1.       For DB connectivity, query etc. Which is better. Firedac, or TSQL connection ?

2.       TSQL connection does not support SQLServer 2008 R2, 2012, or 2014. This is a pretty serious short coming. What do others think ? No doubt there are many other shortcomings.

3.       Can anyone experienced in the subject suggest a good n Tiered example using Data Snap ?

4.       Is Delphi a realistic platform for Android and iOS ? Friends that have tried it, say it is just a demo toy, and a long way from ready.

 

Thanks very much,

 

Tony  

 

From: delphi-bounces at listserver.123.net.nz [mailto:delphi-bounces at listserver.123.net.nz] On Behalf Of Graham Marsden
Sent: Tuesday, 2 August 2016 4:37 a.m.
To: delphi at listserver.123.net.nz
Subject: [DUG] TChromium

 

Hi All

Does anyone have any experience with TChromium ... as in delphichromiumembedded, DCEF3 ?

Installation in the VCL, distribution (files required), reliability, support etc

 

I am looking for a replacement for the standard TWebBrowser component in order to view PDF files within a Delphi VCL application. TWebBrowser unfortunately relies on the Windows Internet Explorer installation and current settings which can lead to various problems.

Any info very much appreciated on this and the wider topic of extracting images from PDF files generally.

Graham Marsden

 



--------------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20160817/8fce5b41/attachment.html