Placing full-text search data in a separate database

[Evgeny Markhasin]

My SQLite Zotero database is more than 90% the full-text tables. Why not placing them in a separate database file?

[Alain Borel]

Is it a problem?

[Evgeny Markhasin]

It is. I have a real-time cloud back-up and a limited bandwidth (I do not use online Zotero library/sync). So it does make a difference whether the database file is 30 MB or 330 MB. If I attach all PDFs and increase indexing limit, the difference will grow further.

[Alain Borel]

I can't comment on the feasibility and priority, but it certainly helps to understand the motivation. Thanks for the explanation!

[Abe Jellinek]

https://www.zotero.org/support/kb/data_directory_in_cloud_storage_folder

--
You received this message because you are subscribed to the Google Groups "zotero-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to zotero-dev+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/zotero-dev/2e8ddcd3-13bb-48ca-bea9-115f21c157d8n%40googlegroups.com.

[Evgeny Markhasin]

The SQLite dev team confirmed that SQLite supports such a design (https://sqlite.org/forum/forumpost/d2f0f5f69e). The idea is that the second database containing full-text search data is attached to the connection having "zotero.sqlite" as  the "main" database. An SQLite's search option  (perhaps, already used by Zotero anyway) can then be used to specify the location of the full-text search tables.

--
You received this message because you are subscribed to a topic in the Google Groups "zotero-dev" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/zotero-dev/VpEPMiwR1is/unsubscribe.
To unsubscribe from this group and all its topics, send an email to zotero-dev+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/zotero-dev/bab83582-ade3-408e-ae39-ee2b99803ebcn%40googlegroups.com.

[Emiliano Heyns]

The ATTACH isn't the issue, but having the zotero database in a cloud-synced directory is very likely going to corrupt the database(s) at some point.