Which database components do you use?

A reporting tool based on TRichView
Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Which database components do you use?

Post by Sergey Tkachenko » Mon Mar 14, 2016 5:00 pm

Finally, we implemented every feature that we planned for the first release. I still have many ideas, but we need to stop somewhere, otherwise the components will never be released ).
We completed both the source code and the documentation. Before the release, we still need to create demo projects, packages for all versions of Delphi, and installers. And to implement support for different data sources.

We implemented components reading data from FireDAC, ADO, BDE, and some other set of DB components.
In this topic, I want to ask, what DB components do you use? I want to add support for popular DB components in the first release of Report Workshop.

It's very easy to add support for any TDataSet-based set of components, and we gladly will do it. But we also appreciate if you point us to DB components having a different architecture.

(probably, it's too early to ask about it, before attracting interest to the new product; but nevertheless, let's try)

bsanlang
Posts: 80
Joined: Sun Sep 24, 2006 1:03 am

Post by bsanlang » Tue Mar 15, 2016 12:20 am

Pgsql,ms sqlserver,SQLite,MySQL,oracle

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Tue Mar 15, 2016 7:54 am

Thank you, but can you tell me which components you use to work with these database engines?

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Tue Mar 15, 2016 1:49 pm

Probably, I should explain with more details.

Report Workshop is a set of reporting components based on TRichView. It does not implement access to databases directly, but it may use another database components.

Report Workshop includes several "data provider" components.
Data providers receive "data queries" (such as SQL select statements), and create "query processors" to handle them. In the most typical case, query processors are wrappers around TDataSet-based query components.
For example, TRVReportADODataProvider component use TADOQuery for creating query processors.

I want to add data providers for the most popular DB components.

bsanlang
Posts: 80
Joined: Sun Sep 24, 2006 1:03 am

Post by bsanlang » Tue Mar 15, 2016 3:40 pm

Ado,Unidac,qdac,fdac

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Thu Mar 17, 2016 4:10 pm

We completed data providers for:
Image BDE (Borland Database Engine)
Image dbExpress
Image dbGo / ADO (ActiveX Data Objects)
Image Absolute Database

To be continued...
Last edited by Sergey Tkachenko on Sun Mar 20, 2016 3:14 pm, edited 1 time in total.

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Thu Mar 17, 2016 6:19 pm

Image Interbase Express

To be continued...

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Fri Mar 18, 2016 9:33 pm

Image MongoDB via FireDAC (available starting from Delphi 10 Seattle)

This is an interesting one. MongoDB is an open-source document database. It uses JSON for data queries instead of SQL.
ReportWorkshop supports queries like

Code: Select all

[{"$match": {"cuisine": "Italian", "address.zipcode": "10075"}},{"$limit":"3"}]
or only "match" part:

Code: Select all

{"cuisine": "Italian", "address.zipcode": "10075"}
To make a master-detail report, nested queries can simply specify a field of a dataset type. So the query for a detail could be

Code: Select all

field:grades
(where 'field' is a prefix for this kind of queries in Report Workshop, and 'grades' is a field name in results of the master query (must be TDataSetField))

To be continued...
Last edited by Sergey Tkachenko on Sun Mar 20, 2016 3:13 pm, edited 1 time in total.

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Sat Mar 19, 2016 12:47 pm

Image FireDAC

To be continued...

nexusdb
Posts: 1
Joined: Sat Mar 19, 2016 2:00 pm
Location: Brisbane, Australia
Contact:

Re: Which database components do you use?

Post by nexusdb » Sat Mar 19, 2016 2:09 pm

Sergey Tkachenko wrote:It's very easy to add support for any TDataSet-based set of components, and we gladly will do it. But we also appreciate if you point us to DB components having a different architecture.

(probably, it's too early to ask about it, before attracting interest to the new product; but nevertheless, let's try)
NexusDB, which is TDataSet compatible. Please email us at sales at nexusdb dot com and we'll get you started. :)

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Sat Mar 19, 2016 8:04 pm

Image UniDAC

To be continued...
Last edited by Sergey Tkachenko on Sun Mar 20, 2016 3:12 pm, edited 1 time in total.

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Sun Mar 20, 2016 2:53 pm

Image NexusDB

To be continued...

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Mon Mar 21, 2016 8:22 am

Image ElevateDB

Test example:
Image

To be continued...

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Mon Mar 21, 2016 7:44 pm

Image DBISAM

Test example (using a music album base from the DBISAM demo):
Image

To be continued...

Sergey Tkachenko
Site Admin
Posts: 13584
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Post by Sergey Tkachenko » Wed Mar 23, 2016 12:00 pm

Image IBObjects

To be continued (or should I stop here?)...

Post Reply