Store text data into sqlite instead of stream.

General TRichView support forum. Please post your questions here
Post Reply
richrich
Posts: 4
Joined: Sun Jul 01, 2018 2:51 pm

Store text data into sqlite instead of stream.

Post by richrich » Sun Jul 01, 2018 2:57 pm

Hi,

I'm considering purchase of your component, does it support sqlite?
I mean simply instead of storing into stream and one file store into SqLite with different tables to easy search and filter data later.

If that is possible - have you got demo ?

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

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko » Sun Jul 01, 2018 5:12 pm

There is no special support for SQLite, but I believe it must not be a problem.
But native format of TRichView documents (RVF) is a binary format, it must be stored as BLOB field. So, if you want to enable searching text in DB, I suggest to save two copy of each document: RVF in BLOB field and plain text version in TEXT field.

Which components do you use for SQLite? I'll try to make an example.

richrich
Posts: 4
Joined: Sun Jul 01, 2018 2:51 pm

Re: Store text data into sqlite instead of stream.

Post by richrich » Sun Jul 01, 2018 5:58 pm

As for your question about component: SynSQLite3 freeware from mORMot
Example RVF document content:

1) Red First line
2) Green Second line
3) etc. etc.

I want to quickly find specified data from db to filter/search and the same have text formatted view using your tdbrichviewedit.
So single viewedit should show data from different tables/cells.

richrich
Posts: 4
Joined: Sun Jul 01, 2018 2:51 pm

Re: Store text data into sqlite instead of stream.

Post by richrich » Mon Jul 02, 2018 11:08 am

Sergey Tkachenko wrote:
Sun Jul 01, 2018 5:12 pm
There is no special support for SQLite, but I believe it must not be a problem.
But native format of TRichView documents (RVF) is a binary format, it must be stored as BLOB field. So, if you want to enable searching text in DB, I suggest to save two copy of each document: RVF in BLOB field and plain text version in TEXT field.

Which components do you use for SQLite? I'll try to make an example.
Is that possible? Have display in one viewedit all doc but at same time data from different sources tables in database?

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

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko » Mon Jul 02, 2018 12:07 pm

I need some time to study SynSQLite3...

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

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko » Mon Jul 02, 2018 2:43 pm

I created a demo viewtopic.php?f=3&t=9178
I hope this is what you asked for.

Post Reply