News

Creating and connecting to MSSQL Database on Azure with Delphi / C++Builder

By
January 20, 2020
I have been asked multiple times recently about connecting to a Azure databases with Delphi and C++Builder. So….I decided to make a video! Which even shows how to use the data directly at design time in the RAD Studio IDE. The video follows the the 3 phases. Creating an account Creating a database Connecting to the database from the RAD Studio IDE Creating an Azure Account The first…
Read more
News

Database and FireDAC Enhancements in RAD Studio 10.2.3

By
March 27, 2018
I already blogged about RAD Server changes and RTL fixes in the Delphi, C++ Builder and RAD Studio 10.2.3 update. Another area that has received attention is the database support in general, and FireDAC in particular. Below is a list with some of the most notable…
News

FireDAC and Microsoft Azure SQL Database

By
April 28, 2017
I’ve started to get requests to use FireDAC with Cloud Databases, like SQL Azure. The question whether or not to put your business data in the cloud is getting easier and easier these days and a lot of that is thanks to Microsoft’s investment in Microsoft Azure. Microsoft’sstrategy to create an infrastructure, like Microsoft Azure SQL Database, that can manage…
Read more
News

Making Win10 Calendar controls database-aware

By
January 9, 2017
Author: Dmitry Kovalenko Programming is fun. Sometimes projects and apps are more serious, sometimes less. On my recent Delphi 10.1 Update 2 presentation two times I have been asked about data-aware versions of new VCL Win10 calendar controls. Here is the code. unit…
News

Three Ways To Easily Embed A Database With Your Android And IOS Apps

By
August 23, 2016
There are numerous embedded databases that can be used with Delphi and C++Builder. Embarcadero provides two embedded databases: InterBase ToGo and IBLite. The SQLite Consortium created SQLite, an embedded SQL database engine. Finally, there’s TFDMemTable, which can save and load data from binary, XML, and JSON files, as well as query them via its LocalSQL property. Each embedded database has…
Read more
Delphi

Creating an InterBase database on the fly with FireDAC

By
February 14, 2014
Recently I have been creating a number of applications using InterBase on iOS and Android using FireDAC components to talk to the database. One route to achieving this is by create the database file and table structure either via iSQL or using IBConsole GUI first before…
Delphi

Simple Database and Data access in Delphi XE5 for iOS and Android

By
September 18, 2013
Author: Blaise Þ With the release of Delphi XE5 for iOS and Android developers now have several options for connecting to databases and data both on the devices themselves as well as via our DataSnap multi-tier technology; REST application services, REST, SOAP, and XML (TXMLDocument).  You can directly use SQLite, InterBase IBLite/IBToGo in your iOS and Android applications via the FireDAC…
Read more