Can SQLite Access other DevArt DataSet?

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dschuch
Posts: 69
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

Can SQLite Access other DevArt DataSet?

Post by dschuch » Tue 26 Mar 2013 11:06

Hi,

i looked a bit to FireDAC after EMB bought it and this feature is absolutely great:
I can Query DataSets, that are Querie'd from a DataBase. Thats nearly LINQ in Delphi ;)

http://docs.embarcadero.com/products/ra ... l_SQL.html

Is sth like this possible with DevArt? If not i will suggest it on the UserVoice. ;)

Thx.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Can SQLite Access other DevArt DataSet?

Post by AlexP » Tue 26 Mar 2013 15:37

hello,

This feature is already added to our UserVoice and roadmap. However, we cannot tell the exact implementation time frame.

Dunkelmann
Posts: 13
Joined: Fri 05 Apr 2013 08:43

Re: Can SQLite Access other DevArt DataSet?

Post by Dunkelmann » Fri 12 Jul 2013 15:04

I did something by myself that has similiar functionality, using UniDAC

- Open Database of your Choice
- Open Dataset (Query/Table)

- Use MetaData Information/ Table Info to automatically generate a CREATE statement that resembles the Dataset Stucture. TUniScript ist used for creating this Statement.
- Add Create Index Statements if required

- Create In-Memory or File Based SQLite Database using the automatically generated UniScript

- Use BatchMove to transfer Data from Dataset to SQLite Database

Repeat for every Dataset of your choice.

This leaves you with fully SQL queryable SQLite Database derived from your Datasets.

Works fine for me this way!

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Can SQLite Access other DevArt DataSet?

Post by AlexP » Tue 16 Jul 2013 08:30

Hello,

Yes, you can use SQLite as an engine for "in-memory DataSet", however, as we currently support the Direct mode for the Win32 platform only, using this approach in other platforms requires supplying the SQLite library.

We are working on the implementation of this feature, and we'll try to support it as soon as possible.

dschuch
Posts: 69
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

Re: Can SQLite Access other DevArt DataSet?

Post by dschuch » Fri 24 Apr 2015 12:00

if i see it right, this is not yet implemented natively, isnt it?

http://devart.uservoice.com/forums/1046 ... components

http://devart.uservoice.com/forums/1046 ... ql-dataset

thanks,

daniel.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Can SQLite Access other DevArt DataSet?

Post by AlexP » Fri 24 Apr 2015 12:43

We have just supported Direct mode for all platforms in this version. Now we can implement in-memory DataSet. However, we can't tell the exact implementation time frame.

dschuch
Posts: 69
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

Re: Can SQLite Access other DevArt DataSet?

Post by dschuch » Sun 26 Apr 2015 13:49

Thanks, please inform us, if ready, so we can kill FireDAC SQL Lite from our Project. ;)

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Can SQLite Access other DevArt DataSet?

Post by AlexP » Tue 28 Apr 2015 08:25

As soon as we have implement in-memory dataset, we will inform you.

Post Reply