Store text data into sqlite instead of stream.

[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]

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]

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]

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]

I need some time to study SynSQLite3...

[Sergey Tkachenko]

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