Record Manager

[FatemaD1577]

I want to incorporate data deduplication using record manager. I have a few queries. Have listed them below. a response to these queries with reference links if possible would be really helpful:

1. Can we use same database as vector database and for record manager?
2. How do we setup SQL/PosgreSQL for record manager? DO we need to create a db separately?
   a. For PosgreSQL I found supabase to create the db. Are there any other providers to create the DB?
   b. For SQL I didn't come across any. How to setup the SQL DB?
3. Which db (SQL/PosgreSQL) is better? (List of pros and cons for comparison would be helpful)
4. I find few examples using Chromadb and elastic search. An example with FAISS would be helpful.
5. In FAISS we have something called docstore and a paramete index_to_docstore_id.
   a. What is the use of docstore? Can that not be used for indexing purpose?
   b. What is the use of index_to_docstore_id parameter?