On 6 August 2018 at 22:20, R Smith wrote:
> Think of paragraphs in English as large records delimited by 2 or more
> Line-break characters (#10+#13 or perhaps only #10 if on a *nix platform)
> between texts.
>
> Each paragraph record could be comprised of one or more sentences (in
> English) as
On 2018/08/06 4:49 PM, Hick Gunter wrote:
Good luck with quoted speech that contains more than one sentence. E.g.
William Faulkner said, “Never be afraid to raise your voice for honesty and
truth and compassion against injustice and lying and greed. If people all over
the world...would do
.”
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von R Smith
Gesendet: Montag, 06. August 2018 16:20
An: sqlite-users@mailinglists.sqlite.org
Betreff: Re: [sqlite] [EXTERNAL] Save text file content in db: lines or whole
file?
On 2018/08/06
On 2018/08/06 12:00 PM, R Smith wrote:
I need to save text files (let say between 1 KB to 20 MB) in a SQLite
DB.
Why not do both?
If it was me, I would write some code to split the text into sentences
(not lines - which is rather easy in English, but might be harder in
some other
I need to save text files (let say between 1 KB to 20 MB) in a SQLite DB.
I see two possibilities:
1) save all the content in a single column:
create table content(id integer not null primary key,
text blob not null);
2) split the content in lines:
create table
separately, you can always group_concat() them together
on retrieval.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Abramo Bagnara
Gesendet: Freitag, 03. August 2018 21:04
An: SQLite mailing list
Betreff: [EXTERNAL] [sq
6 matches
Mail list logo