Data

Database Application Tools for FireDAC that ship with our products - check them out! I received a comment on one of my blog posts from Wilfred Oluoch who was happy to see our renewed focus on development tools. He also said he would like to see a revamped "Database Desktop" style tool that works with InterBase/SQLite and other databases. Thank you Wilfred. We do have several database tools integrated into the IDE and also as standalone applications. Inside of the IDE you can use the Data Explorer to work with your FireDAC and dbExpress based database connections. Outside of...
Using FireDAC Unidirectional property for fast, low memory selection set processing I often do large Oracle database queries using FireDAC to analyze registration data about our products and customers. Most of the time I am only processing through millions of rows to create a report or chart. One of the FDQuery properties that I forget to set True is the TDFQuery's "Unidirectional" sub-property found under the FetchOptions (TFDFetchOptions) property.  By default Unidirectional is set to false as some developers will want to put the data into a grid or other container and u...

Posted by on in Data
Newsgroup Nugget: Row-level locking with FireDAC Here is a recent newsgroup post asking about Row-Level locking using FireDAC to talk to SQL databases. Enjoy! Emery asks: I’m working on a project right now that’s presently using FireDAC to connect to PostgreSql, but we are planning on expanding the possible backends to include MS/SQL, MySQL and Oracle as well (with possibly other, not yet identified, alternatives as well). PostgreSql may or may not be in our long-term plans. One of the single most important requirements that I have is the a...

Posted by on in Data
Coderage 2015 Source Source code for my CodeRage 2015 Presentation is here I will add a link to the video when it is available....

Posted by on in Data
InterBase and Python    This blog post will cover basic usage of InterBase and Python using Eclipse. Install PyDev using the Eclipse IDE Install Python3.4 Configure Eclipse to use Python Download the FDB 1.4.9 driver sources Edit the sources to use the InterBase client library gds32.dll instead of the default FireBird Client library Install the driver to your local Python Environment Write a simple test to connect  

Check out more tips and tricks in this development video: