Store text data into sqlite instead of stream.

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

Store text data into sqlite instead of stream.

Post by richrich »

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: 17236
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko »

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: 5
Joined: Sun Jul 01, 2018 2:51 pm

Re: Store text data into sqlite instead of stream.

Post by richrich »

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: 5
Joined: Sun Jul 01, 2018 2:51 pm

Re: Store text data into sqlite instead of stream.

Post by richrich »

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: 17236
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko »

I need some time to study SynSQLite3...
Sergey Tkachenko
Site Admin
Posts: 17236
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Store text data into sqlite instead of stream.

Post by Sergey Tkachenko »

I created a demo https://www.trichview.com/forums/viewto ... f=3&t=9178
I hope this is what you asked for.
Post Reply