Reputation: 191
I would like to know as to what has been the experience of using direct data access components like devart's MyDAC which allows a direct connection to the mysql server rather than through the client library or ODBC.
Upvotes: 3
Views: 642
Reputation: 31
Awesome.
Direct Access is wonderful specially when you are developing for mobile apps... You dont need the backend layer... (So... Goodbye FastAPI) You can get data in your mobile phone as simple as a query.
PD. I had used both, MyDAC and DAC for Mysql. Both are a rocket but for some intance i prefer to use MyDAC.
Upvotes: 0
Reputation: 1458
With AnyDAC you can acess almost all popular databases (MySQL, SQL Server, Oracle, Firebird, PostgreSQL, DB2, SQLite, ...). High-speed native direct access, many unique futures, unified API for access to cross-database features, excelent support.
Upvotes: 4
Reputation: 11050
Mydac is the best when you try to connect to MySql, it's fast stable and real powerful components.
Also the same for other components like Sdac and Odac.
and if you would like to use more than database you can use Unidac, which you can use to connect to (oracle, Sql server, Mysql, Interbase, Firebird and ODBC drivers.).
Another great point for Devart components that you don't need client library to be installed on the clients machine (libmysql.dll).
Upvotes: 0
Reputation: 11
I've never used MyDAC before. My experience is with DAC for MySQL from http://www.microolap.com/.
So far so good. Pretty easy to drop onto my Delphi projects, set the values of various properties, and then ready to connect. It has quite a number of useful components that allows you to retrieve data in several ways and you can use it easily with TDataSource.
No issues with deployment as well. All compiled nicely into one EXE.
Hope this helps!
Upvotes: 0