Open Database From MemoryStream

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
hmelihkara
Posts: 21
Joined: Fri 09 Nov 2007 23:29

Open Database From MemoryStream

Post by hmelihkara » Fri 18 Oct 2013 15:22

Hi,
Can we load and open database from a memory stream? What we want to achieve is:
- Pack empty database into a resource file and compile it
- Extract database to a memory stream while application running
- Load database from memory stream to vcl component
- Insert data from internet (from some php file, etc.) and query it

We do not need to save any information back to database and save it, so opening empty database every time application runs is expected and normal. Just need this for making some t-sql query because your virtual table still haven't got this feature. We'd use tvirtualtable + txquery to achieve this but txquery component full of bugs and we're getting so many AVs during queries.

So, simply we want to use sqllite db as a t-sql capable virtual table...
Or do you have any plans to add t-sql support (as we voted this many times before) to your virtual table?

Thanks...

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

Re: Open Database From MemoryStream

Post by AlexP » Mon 21 Oct 2013 09:57

Hello,

SQLite doesn't support work with a database from a thread. You can save to a disk the DB file loaded from resources and work with it in LiteDAC.

Post Reply