Subscribe to this list via RSS Blog posts tagged in MySQL
Secrets of FireDAC: Pagination With Grids And LiveBindings If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common pattern when doing web development to give the user 20 results for example and then the ability to move to the next page. If you are implementing a REST API in RAD Server you might also implement this functionality instead of delivering 2 million rows for the query you only deliver the first 20 rows and the next 20 can be requested in the next call. Obviou...

Posted by on in Programming
AWS AuroraにFireDAC接続[JAPAN] 毛利です。   AWS AuroraはMySQL 互換のクラウド(RDS)データベースです。 MySQL互換と言う事なので FireDAC接続を試してみました。
C++Builder FireDAC, TFDBatchMoveを使いデータセットをコピーする方法[JAPAN] FireDACのTFDBatchMoveを使いデータセットから別のテーブルに簡単に書き込む事ができます。 TFDBatchMove用のコンポーネントは下記です。 この中でTFDBatchMoveDataSetReader, TFDBatchMoveDataSetWriterを試してみました。 TFDBatchMoveDataSetReaderはコピー元になるDatasetを設定 TFDBatchMoveDataSetWriterにはコピー先になる空のDatasetを設定しました。
Using Delphi, from Excel to JSON, then FireDAC[JAPAN] First, I will convert Excel data to JSON. After that, we insert that JSON into the DB table with FireDAC.This time DB uses MySQL. They all program with Delphi. Excel is like this. TRect is used to acquire data only for that area.
Embrace the Future of Data Architecture: Make the Switch to ER/Studio Sometimes you need to face the inevitable: the tool selected years ago is not the one you need for the future. Have you been struggling with complicated modeling tasks or outdated tools? Are your data models getting too big to handle? We’ve heard from a lot of customers recently who have been frustrated with their old data modeling tools, for multiple reasons such as: Lack of functionality Lack of support Lack of a future roadmap Embarcadero is committed to enabling our users to adapt to...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...
FireDAC - universal enterprise database connectivity for iOS, Android, Windows and OSX With the release of Delphi XE5 developers now can use the advanced capabilities of FireDAC to build apps that connect with local and remote databases (via DataSnap) that run on iOS, Android, Windows and OSX. C++Builder developers can currently use FireDAC for their Windows and OSX applications (the RAD Studio Roadmap shows C++Builder support for iOS and Android coming later this year). With its powerful universal architecture FireDAC enables direct access from your application from your Android,...
Back from my World and Texas RAD Studio XE2 tours - Webinars Tuesday (tomorrow) I am finally back in my Scotts Valley office today after three weeks on the road visiting with great developers on three continents and on the Internet.  Many thanks to all of you that spent your valuable time with me and all of the other RAD Studio XE2 World Tour evangelists.  Just want to remind you that there are only 4 more days until the end of September.  If there was a special offer at a tour stop, now is the time to use it before it goes away.  There are several ways to buy - all of the ...

Posted by on in Blogs
Want more...Platforms Platform is one the most overloaded terms in computer technology. When someone talks about supporting a platform they might be referring to an operating system platform, hardware platform, mobile platform, database platform, graphics hardware and software platform, service based platform, application based platform, a framework, or an architecture.  Operating system platforms in use today include Windows (desktop, server, and Mobile), Linux, OS X, iOS, Android, Blackberry OS, Unix (and it's vari...

Posted by on in Blogs
InterBase® and MySQL™ - A Technical Comparison Are you considering MySQL as your choice for your SQL database server?    Did you read the Register's recent article, "Oracle kills low-priced MySQL support" by Gavin Clarke.  The recently released InterBase XE is a better technical and cost effective alternative to MySQL. Read the free, technical white paper! Embarcadero Technology InterBase® XE is a powerful, SQL-compliant database that is often considered for embedding in applications and for application-specific uses. Savvy developers and...

Check out more tips and tricks in this development video: