#community-help

Defining a Database Collection

TLDR Zachary asked if all fields need to be specified when defining a collection. Kishore Nallan clarified that only fields want to be indexed need to be specified.

14mo

Join the chat

Jul 28, 2022 (14 months ago)

Photo of md5-5f04183984c8ae83c8715a074dd4c473

Zachary

03:45 AM

Hey everyone, I’m trying to set up my first collection. My question is: When I am defining a collection, do I need to specify all fields or only the ones I want to index? eg. I have a number of thumbnails (width, height, url) that I would like to retrieve with the document, but don’t need to index, if they are not indexed will they still be stored

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

03:49 AM

Only fields you want to search needs to be on the schema. Other fields can be present on the document -- they will be stored on disk and retrieved.

Zachary

03:49 AM

Awesome - thank you Kishore!

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Understanding Collection Schema in Database Queries

em1nos needed clarification on the function of schemas in database collections, Jason confirmed that schema is for searching, and filtering purposes, and discussed the usage of include/exclude_fields parameters.

26mo

Updating Collection Schema and Querying Unspecified Fields in Typesense

Stefan asked about updating a collection schema. Kishore Nallan stated it's not currently possible but suggested automatic schema detection in version 0.20. Rishabh sought a workaround and Jason suggested creating a new collection with a new schema and re-indexing the data. Rishabh also asked about defining custom field IDs which Jason confirmed is not possible with Typesense.

29mo

Specific Collection Backfill and Schema Config in Firebase Extension

Loic asked Jason about backfilling specific collections with the Firebase Extension and configuring collection schemas. The latter explained current limitations and gave advices about handling attributes for search/filtering, storage, and return.

17mo