Page 1 of 1
Store text data into sqlite instead of stream.
Posted: Sun Jul 01, 2018 2:57 pm
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 ?
Re: Store text data into sqlite instead of stream.
Posted: Sun Jul 01, 2018 5:12 pm
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.
Re: Store text data into sqlite instead of stream.
Posted: Sun Jul 01, 2018 5:58 pm
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.
Re: Store text data into sqlite instead of stream.
Posted: Mon Jul 02, 2018 11:08 am
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?
Re: Store text data into sqlite instead of stream.
Posted: Mon Jul 02, 2018 12:07 pm
by Sergey Tkachenko
I need some time to study SynSQLite3...
Re: Store text data into sqlite instead of stream.
Posted: Mon Jul 02, 2018 2:43 pm
by Sergey Tkachenko