# migrations

dir: embeddings_queue
filename: 00001-embeddings.sqlite.sql
hash: d3755dfd232be8e8301f4d7fcfb3a486
sql:
CREATE TABLE embeddings_queue (
    seq_id INTEGER PRIMARY KEY,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    operation INTEGER NOT NULL,
    topic TEXT NOT NULL,
    id TEXT NOT NULL,
    vector BLOB,
    encoding TEXT,
    metadata TEXT
);


dir: sysdb
filename: 00001-collections.sqlite.sql
hash: 38352d725ad1c16074fac420b22b4633
sql:
CREATE TABLE collections (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    topic TEXT NOT NULL,
    UNIQUE (name)
);

CREATE TABLE collection_metadata (
    collection_id TEXT REFERENCES collections(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (collection_id, key)
);


dir: sysdb
filename: 00002-segments.sqlite.sql
hash: 2913cb6a503055a95f625448037e8912
sql:
CREATE TABLE segments (
    id TEXT PRIMARY KEY,
    type TEXT NOT NULL,
    scope TEXT NOT NULL,
    topic TEXT,
    collection TEXT REFERENCES collection(id)
);

CREATE TABLE segment_metadata (
    segment_id TEXT  REFERENCES segments(id) ON DELETE CASCADE,
    key TEXT NOT NULL,
    str_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (segment_id, key)
);


dir: sysdb
filename: 00004-tenants-databases.sqlite.sql
hash: 048867ce8fcdefe4023c7110e4433591
sql:
CREATE TABLE IF NOT EXISTS tenants (
    id TEXT PRIMARY KEY,
    UNIQUE (id)
);

CREATE TABLE IF NOT EXISTS databases (
    id TEXT PRIMARY KEY, -- unique globally
    name TEXT NOT NULL, -- unique per tenant
    tenant_id TEXT NOT NULL REFERENCES tenants(id) ON DELETE CASCADE,
    UNIQUE (tenant_id, name) -- Ensure that a tenant has only one database with a given name
);

CREATE TABLE IF NOT EXISTS collections_tmp (
    id TEXT PRIMARY KEY, -- unique globally
    name TEXT NOT NULL, -- unique per database
    topic TEXT NOT NULL,
    dimension INTEGER,
    database_id TEXT NOT NULL REFERENCES databases(id) ON DELETE CASCADE,
    UNIQUE (name, database_id)
);

-- Create default tenant and database
INSERT OR REPLACE INTO tenants (id) VALUES ('default_tenant'); -- The default tenant id is 'default_tenant' others are UUIDs
INSERT OR REPLACE INTO databases (id, name, tenant_id) VALUES ('00000000-0000-0000-0000-000000000000', 'default_database', 'default_tenant');

INSERT OR REPLACE INTO collections_tmp (id, name, topic, dimension, database_id)
    SELECT id, name, topic, dimension, '00000000-0000-0000-0000-000000000000' FROM collections;
DROP TABLE collections;
ALTER TABLE collections_tmp RENAME TO collections;


dir: sysdb
filename: 00005-remove-topic.sqlite.sql
hash: b1367c826b8fba5f96f27befdc1d42d2
sql:
-- Remove the topic column from the Collections and Segments tables

ALTER TABLE collections DROP COLUMN topic;
ALTER TABLE segments DROP COLUMN topic;


dir: sysdb
filename: 00006-collection-segment-metadata.sqlite.sql
hash: 4eea7468935bf25d4604a0fed2366116
sql:
-- SQLite does not support adding check with alter table, as a result, adding a check
-- involve creating a new table and copying the data over. It is over kill with adding
-- a boolean type column. The application write to the table needs to ensure the data
-- integrity.
ALTER TABLE collection_metadata ADD COLUMN bool_value INTEGER;
ALTER TABLE segment_metadata ADD COLUMN bool_value INTEGER;


dir: sysdb
filename: 00007-collection-config.sqlite.sql
hash: 1c7e63bba346a42a18b6ab7f1c989bed
sql:
-- Stores collection configuration dictionaries.
ALTER TABLE collections ADD COLUMN config_json_str TEXT;


dir: sysdb
filename: 00008-maintenance-log.sqlite.sql
hash: 0a0e7e93111a01789addf64961c6127c
sql:
-- Records when database maintenance operations are performed.
-- At time of creation, this table is only used to record vacuum operations.
CREATE TABLE maintenance_log (
  id INT PRIMARY KEY,
  timestamp INT NOT NULL,
  operation TEXT NOT NULL
);


dir: sysdb
filename: 00009-segment-collection-not-null.sqlite.sql
hash: 054355aef9e63702bf54ea29e61563f1
sql:
-- This makes segments.collection non-nullable.
CREATE TABLE segments_temp (
    id TEXT PRIMARY KEY,
    type TEXT NOT NULL,
    scope TEXT NOT NULL,
    collection TEXT REFERENCES collection(id) NOT NULL
);

INSERT INTO segments_temp SELECT * FROM segments;
DROP TABLE segments;
ALTER TABLE segments_temp RENAME TO segments;


dir: metadb
filename: 00001-embedding-metadata.sqlite.sql
hash: 2b4cf52c4bb2676e21d6860a4409f856
sql:
CREATE TABLE embeddings (
    id INTEGER PRIMARY KEY,
    segment_id TEXT NOT NULL,
    embedding_id TEXT NOT NULL,
    seq_id BLOB NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE (segment_id, embedding_id)
);

CREATE TABLE embedding_metadata (
    id INTEGER REFERENCES embeddings(id),
    key TEXT NOT NULL,
    string_value TEXT,
    int_value INTEGER,
    float_value REAL,
    PRIMARY KEY (id, key)
);

CREATE TABLE max_seq_id (
    segment_id TEXT PRIMARY KEY,
    seq_id BLOB NOT NULL
);

CREATE VIRTUAL TABLE embedding_fulltext USING fts5(id, string_value);


dir: metadb
filename: 00002-embedding-metadata.sqlite.sql
hash: 12a570f7121b3a8ce750a2a7c36da20f
sql:
-- SQLite does not support adding check with alter table, as a result, adding a check
-- involve creating a new table and copying the data over. It is over kill with adding
-- a boolean type column. The application write to the table needs to ensure the data
-- integrity.
ALTER TABLE embedding_metadata ADD COLUMN bool_value INTEGER


dir: metadb
filename: 00003-full-text-tokenize.sqlite.sql
hash: f97ad6334aeaa8f419f01110b648b97a
sql:
CREATE VIRTUAL TABLE embedding_fulltext_search USING fts5(string_value, tokenize='trigram');
INSERT INTO embedding_fulltext_search (rowid, string_value) SELECT rowid, string_value FROM embedding_metadata;
DROP TABLE embedding_fulltext;


dir: metadb
filename: 00004-metadata-indices.sqlite.sql
hash: fb36603a45ee2cd0254cef3ef86585e8
sql:
CREATE INDEX IF NOT EXISTS embedding_metadata_int_value ON embedding_metadata (key, int_value) WHERE int_value IS NOT NULL;
CREATE INDEX IF NOT EXISTS embedding_metadata_float_value ON embedding_metadata (key, float_value) WHERE float_value IS NOT NULL;
CREATE INDEX IF NOT EXISTS embedding_metadata_string_value ON embedding_metadata (key, string_value) WHERE string_value IS NOT NULL;


# embeddings_queue

created_at: 2025-05-12 07:12:08
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: c3b5b48d-87c6-4e90-8219-5afdbe4e8b70-p2-c0-i
encoding: FLOAT32
metadata:
{"document_uuid": "c3b5b48d-87c6-4e90-8219-5afdbe4e8b70", "page_number": 2, "type": "table", "html": "<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>0</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td></td>\n    </tr>\n  </tbody>\n</table>", "chunk_number": 0, "chroma:document": "The provided HTML snippet contains a table structured with a single column and a single row, apart from the header row. The table features a border and is formatted with a class labeled \"dataframe.\" In the header section, there is one header cell that contains a column identifier labeled \"0.\" The table's body consists of one additional row, which enumerates another header cell marked \"0,\" but the corresponding data cell beneath it is empty.\n\nThe simplicity of this table structure suggests that it may serve as a preliminary framework for data organization or a placeholder for future entries. Given the lack of additional context, such as specific metrics or categories, it implies that either the content is to be filled in later or that it pertains to a very specific aspect of a broader topic not detailed in the provided context. The overall focus, therefore, seems to be on structure rather than substantive data, highlighting either an early stage of data collection or a minimalist representation."}


created_at: 2025-05-12 07:12:09
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: c3b5b48d-87c6-4e90-8219-5afdbe4e8b70-p1-c1-i
encoding: FLOAT32
metadata:
{"document_uuid": "c3b5b48d-87c6-4e90-8219-5afdbe4e8b70", "page_number": 1, "type": "table", "html": "<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>0</th>\n      <th>1</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td></td>\n      <td></td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td></td>\n      <td></td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td></td>\n      <td></td>\n    </tr>\n  </tbody>\n</table>", "chunk_number": 1, "chroma:document": "The context surrounding the table suggests that there are ongoing issues with the navigation features in the Map App, specifically regarding the functionality of route displays based on different modes of transportation. Users have expressed frustration that after selecting the \u201ccar\u201d option, the distance and routing information is visible, but switching to \u201ccycle\u201d or \u201cwalk\u201d modes and then returning to the \u201ccar\u201d mode does not restore this vital information. This indicates a functionality gap in the app's navigational capabilities, which is important for users who rely on accurate and timely information for their routes.\n\nThe table itself appears to be quite minimal, comprising three rows and two columns devoid of any specific data. The first row serves as a header, while the subsequent rows simply contain empty cells. This could imply a lack of relevant information that was perhaps meant to be included, or it may serve as a placeholder for data that needs to be populated later. Given the surrounding context, it seems this table could potentially be intended to display routing details or other pertinent information related to the navigation issues specified, such as distance and route options across different transport modes. However, the absence of actual content makes it clear that there is an incomplete or unresolved aspect concerning the app's navigational data presentation. \n\nThe mention of integrating public transport routes into the application's functionality further highlights the need for comprehensive transport information. The reference to obtaining public transport details via an API from OneMap suggests a broader aim to enhance the app's utility by incorporating multiple transportation modes, thereby addressing the users' demands for a more integrated navigation solution. This context amplifies the significance of the table and signifies the challenges in achieving a cohesive user experience within the navigation features of the Map App."}


created_at: 2025-05-12 07:12:09
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: c3b5b48d-87c6-4e90-8219-5afdbe4e8b70-p0-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "c3b5b48d-87c6-4e90-8219-5afdbe4e8b70", "page_number": 0, "chunk_number": 0, "type": "text", "chroma:document": "1.  The button to be allowed to change at the backend. \u201cDealss\u201d remove one s 2. Sliding banner not auto rotating?  Able to set a duration of each banner at the backend? 3. Font and background to be contrasting. For dark mode: fonts should be white in colour only Applies for pages: Contact us thank you page after enquiry submission, About Us, Privacy Policy, Terms of Use, Guides"}


created_at: 2025-05-12 07:12:10
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: c3b5b48d-87c6-4e90-8219-5afdbe4e8b70-p2-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "c3b5b48d-87c6-4e90-8219-5afdbe4e8b70", "page_number": 2, "chunk_number": 0, "type": "text", "chroma:document": "Clicking on the bus stops should show the buses and timings as below:  Details to be shown when click \u201cMy Location\u201d and ability to share  Possible to have the map zoomed in more? To be able to see the building and streets in detail"}


created_at: 2025-05-12 07:12:10
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: c3b5b48d-87c6-4e90-8219-5afdbe4e8b70-p1-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "c3b5b48d-87c6-4e90-8219-5afdbe4e8b70", "page_number": 1, "chunk_number": 0, "type": "text", "chroma:document": "4. Navigation: it still doesn\u2019t work on the Map App  Why is it that when click the \u201ccar\u201d is shows the distance and route, however if after clicking \u201ccycle\u201d / \u201cwalk\u201d routes and back to \u201ccar\u201d route the distance and routing does not show up?      5.  To add in public transport routes  Below are from OneMap, please check if can API public transport details from there."}


created_at: 2025-05-14 16:57:31
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 19fc8695-20ba-4711-86f8-2239c29814e6-p1-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "19fc8695-20ba-4711-86f8-2239c29814e6", "page_number": 1, "chunk_number": 0, "type": "text", "chroma:document": "INDUSTRY PROJECTS\nCrazzy Hub\nE-Commerce Website\nThis website, made using React.js, is an e-commerce platform specializing in electronics\nproducts such as mobile phones, laptops, and their accessories, offering an online shopping\nexperience. \nBhaarat ERP\nEnterprise resource planning website\nThis project, built with React.js, serves as a comprehensive management system designed to\nstreamline various aspects of the business, including Inventory Management, Sales\nManagement, Purchase Management, Support Management, CRM and HRM. Bhaarat ERP,\nwe have created a powerful tool to enhance the overall operations and customer experience for\nbusinesses.\nTechnologies Used\nReact JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs\nIntegration. \nTeam Size\n3-5 members\nPERSONAL PROJECTS\nEdu-Villa\nE-Learning Mobile App\nA Flutter-based e-learning app designed to provide convenient access to a diverse range of"}


created_at: 2025-05-14 16:57:33
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 19fc8695-20ba-4711-86f8-2239c29814e6-p1-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "19fc8695-20ba-4711-86f8-2239c29814e6", "page_number": 1, "chunk_number": 1, "type": "text", "chroma:document": "Integration. \nTeam Size\n3-5 members\nPERSONAL PROJECTS\nEdu-Villa\nE-Learning Mobile App\nA Flutter-based e-learning app designed to provide convenient access to a diverse range of\ncourses and educational content. Offering an intuitive interface and interactive features for\nengaging learning experiences across various subjects and levels.\nTechnologies Used\nFlutter, Dart, Material UI 3, Dark & Light Mode setup adopt with system setting and NodeJs for\nREST APIs \nChit Chat\nChat Mobile App\nChit Chat is a basic mobile chat app built with React Native for the interfaces and Node.js for the\nbackend. It demonstrates skills in creating mobile interfaces and implementing server-side\nfunctionalities.\nTechnologies Used\nReact Native, React Native Paper, Nativewind, Dark & Light Mode setup adopt with system setting\nand NodeJs for REST APIs"}


created_at: 2025-05-14 16:57:33
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 19fc8695-20ba-4711-86f8-2239c29814e6-p0-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "19fc8695-20ba-4711-86f8-2239c29814e6", "page_number": 0, "chunk_number": 0, "type": "text", "chroma:document": "MANI KANT\nEXPERIENCE\nEDUCATION\nSKILLS SUMMARY\nLANGUAGE\nSOFT SKILLS\nExperienced software developer\npassionate about creating user-\nfriendly web applications. Skilled\nin building efficient interfaces.\nAbout Me\nmanikants157@gmail.com\n+918737018483\nAara Technologies Pvt. Ltd\nIndira Nagar, Lucknow\nNov 2022 - June 2024\nBachelor of Technology ( CSE )\n2017-2021\nLucknow, Uttar Pradesh, India\nSoftware Development Engineer I (SDE-I)\nEnglish\nHindi\nSoftware Developer\nQuick Learner\nLeadership\nTrainer\nAdaptibility\nBabu Banarasi Das University, Lucknow\nHigh School & Intermediate \n2012-2016\nBalrampur Modern School, Balrampur\nReactJs\nSHARMA\nReact Native\nFlutter\nNodeJs\nSingsys Pte. Ltd.\nOmaxe City, Lucknow\nJune 2024 - Present\nSoftware Development Engineer II (SDE-II)\nTranslate client requirements into technical\nspecifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter, MongoDB, and Firebase."}


created_at: 2025-05-14 16:57:34
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 19fc8695-20ba-4711-86f8-2239c29814e6-p0-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "19fc8695-20ba-4711-86f8-2239c29814e6", "page_number": 0, "chunk_number": 1, "type": "text", "chroma:document": "specifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter, MongoDB, and Firebase.\nEnhanced product functionality and user\nexperience.\nImproved application performance and efficiency.\nContributed to scalable web and mobile\napplication design."}


created_at: 2025-05-14 17:32:59
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9e417847-eef5-401b-b767-62aa7eae36a6-p1-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "9e417847-eef5-401b-b767-62aa7eae36a6", "page_number": 1, "chunk_number": 0, "type": "text", "chroma:document": "INDUSTRY PROJECTS\nCrazzy Hub\nE-Commerce Website\nThis website, made using React.js, is an e-commerce platform specializing in electronics\nproducts such as mobile phones, laptops, and their accessories, offering an online shopping\nexperience. \nBhaarat ERP\nEnterprise resource planning website\nThis project, built with React.js, serves as a comprehensive management system designed to\nstreamline various aspects of the business, including Inventory Management, Sales\nManagement, Purchase Management, Support Management, CRM and HRM. Bhaarat ERP,\nwe have created a powerful tool to enhance the overall operations and customer experience for\nbusinesses.\nTechnologies Used\nReact JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs\nIntegration. \nTeam Size\n3-5 members\nPERSONAL PROJECTS\nEdu-Villa\nE-Learning Mobile App\nA Flutter-based e-learning app designed to provide convenient access to a diverse range of"}


created_at: 2025-05-14 17:32:59
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9e417847-eef5-401b-b767-62aa7eae36a6-p0-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "9e417847-eef5-401b-b767-62aa7eae36a6", "page_number": 0, "chunk_number": 0, "type": "text", "chroma:document": "MANI KANT\nEXPERIENCE\nEDUCATION\nSKILLS SUMMARY\nLANGUAGE\nSOFT SKILLS\nExperienced software developer\npassionate about creating user-\nfriendly web applications. Skilled\nin building efficient interfaces.\nAbout Me\nmanikants157@gmail.com\n+918737018483\nAara Technologies Pvt. Ltd\nIndira Nagar, Lucknow\nNov 2022 - June 2024\nBachelor of Technology ( CSE )\n2017-2021\nLucknow, Uttar Pradesh, India\nSoftware Development Engineer I (SDE-I)\nEnglish\nHindi\nSoftware Developer\nQuick Learner\nLeadership\nTrainer\nAdaptibility\nBabu Banarasi Das University, Lucknow\nHigh School & Intermediate \n2012-2016\nBalrampur Modern School, Balrampur\nReactJs\nSHARMA\nReact Native\nFlutter\nNodeJs\nSingsys Pte. Ltd.\nOmaxe City, Lucknow\nJune 2024 - Present\nSoftware Development Engineer II (SDE-II)\nTranslate client requirements into technical\nspecifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter, MongoDB, and Firebase."}


created_at: 2025-05-14 17:32:59
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9e417847-eef5-401b-b767-62aa7eae36a6-p1-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "9e417847-eef5-401b-b767-62aa7eae36a6", "page_number": 1, "chunk_number": 1, "type": "text", "chroma:document": "Integration. \nTeam Size\n3-5 members\nPERSONAL PROJECTS\nEdu-Villa\nE-Learning Mobile App\nA Flutter-based e-learning app designed to provide convenient access to a diverse range of\ncourses and educational content. Offering an intuitive interface and interactive features for\nengaging learning experiences across various subjects and levels.\nTechnologies Used\nFlutter, Dart, Material UI 3, Dark & Light Mode setup adopt with system setting and NodeJs for\nREST APIs \nChit Chat\nChat Mobile App\nChit Chat is a basic mobile chat app built with React Native for the interfaces and Node.js for the\nbackend. It demonstrates skills in creating mobile interfaces and implementing server-side\nfunctionalities.\nTechnologies Used\nReact Native, React Native Paper, Nativewind, Dark & Light Mode setup adopt with system setting\nand NodeJs for REST APIs"}


created_at: 2025-05-14 17:33:00
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9e417847-eef5-401b-b767-62aa7eae36a6-p0-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "9e417847-eef5-401b-b767-62aa7eae36a6", "page_number": 0, "chunk_number": 1, "type": "text", "chroma:document": "specifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter, MongoDB, and Firebase.\nEnhanced product functionality and user\nexperience.\nImproved application performance and efficiency.\nContributed to scalable web and mobile\napplication design."}


created_at: 2025-05-19 12:09:01
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 3f2cbed9-c05a-43ca-94c5-a683fff94db3-p0-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "3f2cbed9-c05a-43ca-94c5-a683fff94db3", "page_number": 0, "chunk_number": 0, "type": "text", "chroma:document": "MANI KANT\nEXPERIENCE\nEDUCATION\nSKILLS SUMMARY\nLANGUAGE\nSOFT SKILLS\nExperienced software developer\npassionate about creating user-\nfriendly web applications. Skilled in\nbuilding efficient interfaces.\nAbout Me\nmanikants157@gmail.com\n+918737018483\nAara Technologies Pvt. Ltd\nIndira Nagar, Lucknow\nNov 2022 - June 2024\nBachelor of Technology ( CSE )\n2017-2021\nLucknow, Uttar Pradesh, India\nSoftware Development Engineer\nEnglish\nHindi\nSoftware Developer\nQuick Learner\nLeadership\nTrainer\nAdaptibility\nBabu Banarasi Das University, Lucknow\nHigh School & Intermediate \n2012-2016\nBalrampur Modern School, Balrampur\nReactJs\nSHARMA\nTailwind\nMaterial UI\nRedux\nSingsys Pte. Ltd.\nOmaxe City, Lucknow\nJune 2024 - Present\nSoftware Development Engineer\nTranslate client requirements into technical\nspecifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter and Firebase."}


created_at: 2025-05-19 12:09:01
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 3f2cbed9-c05a-43ca-94c5-a683fff94db3-p1-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "3f2cbed9-c05a-43ca-94c5-a683fff94db3", "page_number": 1, "chunk_number": 0, "type": "text", "chroma:document": "INDUSTRY PROJECTS\nE-Commerce Website\nThis website, made using React.js, is an e-commerce platform specializing in electronics products\nsuch as mobile phones, laptops, and their accessories, offering an online shopping experience. \nEnterprise resource planning website\nThis project, built with React.js, serves as a comprehensive management system designed to\nstreamline various aspects of the business, including Inventory Management, Sales\nManagement, Purchase Management, Support Management, CRM and HRM. ERP, we have\ncreated a powerful tool to enhance the overall operations and customer experience for\nbusinesses.\nTechnologies Used\nReact JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs\nIntegration. \nTeam Size3-5 members\nOPEN SOURCE CONTRIBUTION\nreact-mkx-toolkit (npm package) - Over 6,200 downloads!\nPublished a React library providing versatile custom hooks such as useKeyboard,"}


created_at: 2025-05-19 12:09:02
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 3f2cbed9-c05a-43ca-94c5-a683fff94db3-p1-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "3f2cbed9-c05a-43ca-94c5-a683fff94db3", "page_number": 1, "chunk_number": 1, "type": "text", "chroma:document": "Integration. \nTeam Size3-5 members\nOPEN SOURCE CONTRIBUTION\nreact-mkx-toolkit (npm package) - Over 6,200 downloads!\nPublished a React library providing versatile custom hooks such as useKeyboard,\nuseRandomArray, useCurrentLocation, useScroll, and useNotification. These hooks are\ndesigned to streamline and enhance development workflows.\nKEY ACHIEVEMENTS AND RESPONSIBILITY HIGHLIGHTS\nFrontend Development\nDesigned responsive and reusable React components using tools like Husky. ESLint, Tailwind\nCSS, MUI, and React Query.\nCreated real time chat using webshocket.\nWhat\u2019s App Business WorkFLow and Chat bot.\nCrowl a Webpage in NextJs and Cheerio Library\nCreated a Glassmorphism Website\nCreated and Setup multiple react project.from Scratch.\nGoogle map Integration in ReactJs.\nLeadership and Mentoring\nLed an 7-person team for a React project at Aara Technologies.\nMentored over 3 batches of trainees in React development."}


created_at: 2025-05-19 12:09:02
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 3f2cbed9-c05a-43ca-94c5-a683fff94db3-p0-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "3f2cbed9-c05a-43ca-94c5-a683fff94db3", "page_number": 0, "chunk_number": 1, "type": "text", "chroma:document": "specifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter and Firebase.\nEnhanced product functionality and user\nexperience.\nImproved application performance and efficiency.\nContributed to scalable web and mobile\napplication design."}


created_at: 2025-05-19 12:21:39
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9bf0b1e7-eedb-40ed-bb94-457e848f35d8-p0-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "9bf0b1e7-eedb-40ed-bb94-457e848f35d8", "page_number": 0, "chunk_number": 0, "type": "text", "chroma:document": "MANI KANT\nEXPERIENCE\nEDUCATION\nSKILLS SUMMARY\nLANGUAGE\nSOFT SKILLS\nExperienced software developer\npassionate about creating user-\nfriendly web applications. Skilled in\nbuilding efficient interfaces.\nAbout Me\nmanikants157@gmail.com\n+918737018483\nAara Technologies Pvt. Ltd\nIndira Nagar, Lucknow\nNov 2022 - June 2024\nBachelor of Technology ( CSE )\n2017-2021\nLucknow, Uttar Pradesh, India\nSoftware Development Engineer\nEnglish\nHindi\nSoftware Developer\nQuick Learner\nLeadership\nTrainer\nAdaptibility\nBabu Banarasi Das University, Lucknow\nHigh School & Intermediate \n2012-2016\nBalrampur Modern School, Balrampur\nReactJs\nSHARMA\nTailwind\nMaterial UI\nRedux\nSingsys Pte. Ltd.\nOmaxe City, Lucknow\nJune 2024 - Present\nSoftware Development Engineer\nTranslate client requirements into technical\nspecifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter and Firebase."}


created_at: 2025-05-19 12:21:40
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9bf0b1e7-eedb-40ed-bb94-457e848f35d8-p0-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "9bf0b1e7-eedb-40ed-bb94-457e848f35d8", "page_number": 0, "chunk_number": 1, "type": "text", "chroma:document": "specifications.\nOptimize performance through testing and debugging.\nImprove development processes and team\ncollaboration.\nDeveloped solutions using ReactJs, NextJs,\nFlutter and Firebase.\nEnhanced product functionality and user\nexperience.\nImproved application performance and efficiency.\nContributed to scalable web and mobile\napplication design."}


created_at: 2025-05-19 12:21:40
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9bf0b1e7-eedb-40ed-bb94-457e848f35d8-p1-c0-t
encoding: FLOAT32
metadata:
{"document_uuid": "9bf0b1e7-eedb-40ed-bb94-457e848f35d8", "page_number": 1, "chunk_number": 0, "type": "text", "chroma:document": "INDUSTRY PROJECTS\nE-Commerce Website\nThis website, made using React.js, is an e-commerce platform specializing in electronics products\nsuch as mobile phones, laptops, and their accessories, offering an online shopping experience. \nEnterprise resource planning website\nThis project, built with React.js, serves as a comprehensive management system designed to\nstreamline various aspects of the business, including Inventory Management, Sales\nManagement, Purchase Management, Support Management, CRM and HRM. ERP, we have\ncreated a powerful tool to enhance the overall operations and customer experience for\nbusinesses.\nTechnologies Used\nReact JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs\nIntegration. \nTeam Size3-5 members\nOPEN SOURCE CONTRIBUTION\nreact-mkx-toolkit (npm package) - Over 6,200 downloads!\nPublished a React library providing versatile custom hooks such as useKeyboard,"}


created_at: 2025-05-19 12:21:42
topic: persistent://default/default/e7515d55-b087-433e-8eec-336d52198b0e
id: 9bf0b1e7-eedb-40ed-bb94-457e848f35d8-p1-c1-t
encoding: FLOAT32
metadata:
{"document_uuid": "9bf0b1e7-eedb-40ed-bb94-457e848f35d8", "page_number": 1, "chunk_number": 1, "type": "text", "chroma:document": "Integration. \nTeam Size3-5 members\nOPEN SOURCE CONTRIBUTION\nreact-mkx-toolkit (npm package) - Over 6,200 downloads!\nPublished a React library providing versatile custom hooks such as useKeyboard,\nuseRandomArray, useCurrentLocation, useScroll, and useNotification. These hooks are\ndesigned to streamline and enhance development workflows.\nKEY ACHIEVEMENTS AND RESPONSIBILITY HIGHLIGHTS\nFrontend Development\nDesigned responsive and reusable React components using tools like Husky. ESLint, Tailwind\nCSS, MUI, and React Query.\nCreated real time chat using webshocket.\nWhat\u2019s App Business WorkFLow and Chat bot.\nCrowl a Webpage in NextJs and Cheerio Library\nCreated a Glassmorphism Website\nCreated and Setup multiple react project.from Scratch.\nGoogle map Integration in ReactJs.\nLeadership and Mentoring\nLed an 7-person team for a React project at Aara Technologies.\nMentored over 3 batches of trainees in React development."}


# collections

id: e7515d55-b087-433e-8eec-336d52198b0e
name: AnswerIt
database_id: 00000000-0000-0000-0000-000000000000
config_json_str:
{"hnsw_configuration": {"space": "l2", "ef_construction": 100, "ef_search": 10, "num_threads": 4, "M": 16, "resize_factor": 1.2, "batch_size": 100, "sync_threshold": 1000, "_type": "HNSWConfigurationInternal"}, "_type": "CollectionConfigurationInternal"}


# embedding_metadata

key: html
string_value:
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>0</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td></td>
    </tr>
  </tbody>
</table>


key: chroma:document
string_value:
The provided HTML snippet contains a table structured with a single column and a single row, apart from the header row. The table features a border and is formatted with a class labeled "dataframe." In the header section, there is one header cell that contains a column identifier labeled "0." The table's body consists of one additional row, which enumerates another header cell marked "0," but the corresponding data cell beneath it is empty.

The simplicity of this table structure suggests that it may serve as a preliminary framework for data organization or a placeholder for future entries. Given the lack of additional context, such as specific metrics or categories, it implies that either the content is to be filled in later or that it pertains to a very specific aspect of a broader topic not detailed in the provided context. The overall focus, therefore, seems to be on structure rather than substantive data, highlighting either an early stage of data collection or a minimalist representation.


key: html
string_value:
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>0</th>
      <th>1</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td></td>
      <td></td>
    </tr>
    <tr>
      <th>1</th>
      <td></td>
      <td></td>
    </tr>
    <tr>
      <th>2</th>
      <td></td>
      <td></td>
    </tr>
  </tbody>
</table>


key: chroma:document
string_value:
The context surrounding the table suggests that there are ongoing issues with the navigation features in the Map App, specifically regarding the functionality of route displays based on different modes of transportation. Users have expressed frustration that after selecting the “car” option, the distance and routing information is visible, but switching to “cycle” or “walk” modes and then returning to the “car” mode does not restore this vital information. This indicates a functionality gap in the app's navigational capabilities, which is important for users who rely on accurate and timely information for their routes.

The table itself appears to be quite minimal, comprising three rows and two columns devoid of any specific data. The first row serves as a header, while the subsequent rows simply contain empty cells. This could imply a lack of relevant information that was perhaps meant to be included, or it may serve as a placeholder for data that needs to be populated later. Given the surrounding context, it seems this table could potentially be intended to display routing details or other pertinent information related to the navigation issues specified, such as distance and route options across different transport modes. However, the absence of actual content makes it clear that there is an incomplete or unresolved aspect concerning the app's navigational data presentation. 

The mention of integrating public transport routes into the application's functionality further highlights the need for comprehensive transport information. The reference to obtaining public transport details via an API from OneMap suggests a broader aim to enhance the app's utility by incorporating multiple transportation modes, thereby addressing the users' demands for a more integrated navigation solution. This context amplifies the significance of the table and signifies the challenges in achieving a cohesive user experience within the navigation features of the Map App.


key: chroma:document
string_value:
1.  The button to be allowed to change at the backend. “Dealss” remove one s 2. Sliding banner not auto rotating?  Able to set a duration of each banner at the backend? 3. Font and background to be contrasting. For dark mode: fonts should be white in colour only Applies for pages: Contact us thank you page after enquiry submission, About Us, Privacy Policy, Terms of Use, Guides


key: chroma:document
string_value:
Clicking on the bus stops should show the buses and timings as below:  Details to be shown when click “My Location” and ability to share  Possible to have the map zoomed in more? To be able to see the building and streets in detail


key: chroma:document
string_value:
4. Navigation: it still doesn’t work on the Map App  Why is it that when click the “car” is shows the distance and route, however if after clicking “cycle” / “walk” routes and back to “car” route the distance and routing does not show up?      5.  To add in public transport routes  Below are from OneMap, please check if can API public transport details from there.


key: chroma:document
string_value:
INDUSTRY PROJECTS
Crazzy Hub
E-Commerce Website
This website, made using React.js, is an e-commerce platform specializing in electronics
products such as mobile phones, laptops, and their accessories, offering an online shopping
experience. 
Bhaarat ERP
Enterprise resource planning website
This project, built with React.js, serves as a comprehensive management system designed to
streamline various aspects of the business, including Inventory Management, Sales
Management, Purchase Management, Support Management, CRM and HRM. Bhaarat ERP,
we have created a powerful tool to enhance the overall operations and customer experience for
businesses.
Technologies Used
React JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs
Integration. 
Team Size
3-5 members
PERSONAL PROJECTS
Edu-Villa
E-Learning Mobile App
A Flutter-based e-learning app designed to provide convenient access to a diverse range of


key: chroma:document
string_value:
Integration. 
Team Size
3-5 members
PERSONAL PROJECTS
Edu-Villa
E-Learning Mobile App
A Flutter-based e-learning app designed to provide convenient access to a diverse range of
courses and educational content. Offering an intuitive interface and interactive features for
engaging learning experiences across various subjects and levels.
Technologies Used
Flutter, Dart, Material UI 3, Dark & Light Mode setup adopt with system setting and NodeJs for
REST APIs 
Chit Chat
Chat Mobile App
Chit Chat is a basic mobile chat app built with React Native for the interfaces and Node.js for the
backend. It demonstrates skills in creating mobile interfaces and implementing server-side
functionalities.
Technologies Used
React Native, React Native Paper, Nativewind, Dark & Light Mode setup adopt with system setting
and NodeJs for REST APIs


key: chroma:document
string_value:
MANI KANT
EXPERIENCE
EDUCATION
SKILLS SUMMARY
LANGUAGE
SOFT SKILLS
Experienced software developer
passionate about creating user-
friendly web applications. Skilled
in building efficient interfaces.
About Me
manikants157@gmail.com
+918737018483
Aara Technologies Pvt. Ltd
Indira Nagar, Lucknow
Nov 2022 - June 2024
Bachelor of Technology ( CSE )
2017-2021
Lucknow, Uttar Pradesh, India
Software Development Engineer I (SDE-I)
English
Hindi
Software Developer
Quick Learner
Leadership
Trainer
Adaptibility
Babu Banarasi Das University, Lucknow
High School & Intermediate 
2012-2016
Balrampur Modern School, Balrampur
ReactJs
SHARMA
React Native
Flutter
NodeJs
Singsys Pte. Ltd.
Omaxe City, Lucknow
June 2024 - Present
Software Development Engineer II (SDE-II)
Translate client requirements into technical
specifications.
Optimize performance through testing and debugging.
Improve development processes and team
collaboration.
Developed solutions using ReactJs, NextJs,
Flutter, MongoDB, and Firebase.


key: chroma:document
string_value:
specifications.
Optimize performance through testing and debugging.
Improve development processes and team
collaboration.
Developed solutions using ReactJs, NextJs,
Flutter, MongoDB, and Firebase.
Enhanced product functionality and user
experience.
Improved application performance and efficiency.
Contributed to scalable web and mobile
application design.


key: chroma:document
string_value:
MANI KANT
EXPERIENCE
EDUCATION
SKILLS SUMMARY
LANGUAGE
SOFT SKILLS
Experienced software developer
passionate about creating user-
friendly web applications. Skilled in
building efficient interfaces.
About Me
manikants157@gmail.com
+918737018483
Aara Technologies Pvt. Ltd
Indira Nagar, Lucknow
Nov 2022 - June 2024
Bachelor of Technology ( CSE )
2017-2021
Lucknow, Uttar Pradesh, India
Software Development Engineer
English
Hindi
Software Developer
Quick Learner
Leadership
Trainer
Adaptibility
Babu Banarasi Das University, Lucknow
High School & Intermediate 
2012-2016
Balrampur Modern School, Balrampur
ReactJs
SHARMA
Tailwind
Material UI
Redux
Singsys Pte. Ltd.
Omaxe City, Lucknow
June 2024 - Present
Software Development Engineer
Translate client requirements into technical
specifications.
Optimize performance through testing and debugging.
Improve development processes and team
collaboration.
Developed solutions using ReactJs, NextJs,
Flutter and Firebase.


key: chroma:document
string_value:
INDUSTRY PROJECTS
E-Commerce Website
This website, made using React.js, is an e-commerce platform specializing in electronics products
such as mobile phones, laptops, and their accessories, offering an online shopping experience. 
Enterprise resource planning website
This project, built with React.js, serves as a comprehensive management system designed to
streamline various aspects of the business, including Inventory Management, Sales
Management, Purchase Management, Support Management, CRM and HRM. ERP, we have
created a powerful tool to enhance the overall operations and customer experience for
businesses.
Technologies Used
React JS, Redux, Tailwind, HTML, CSS, Bootstrap, Material UI, Material Joy UI, Ant design, Rest APIs
Integration. 
Team Size3-5 members
OPEN SOURCE CONTRIBUTION
react-mkx-toolkit (npm package) - Over 6,200 downloads!
Published a React library providing versatile custom hooks such as useKeyboard,


key: chroma:document
string_value:
Integration. 
Team Size3-5 members
OPEN SOURCE CONTRIBUTION
react-mkx-toolkit (npm package) - Over 6,200 downloads!
Published a React library providing versatile custom hooks such as useKeyboard,
useRandomArray, useCurrentLocation, useScroll, and useNotification. These hooks are
designed to streamline and enhance development workflows.
KEY ACHIEVEMENTS AND RESPONSIBILITY HIGHLIGHTS
Frontend Development
Designed responsive and reusable React components using tools like Husky. ESLint, Tailwind
CSS, MUI, and React Query.
Created real time chat using webshocket.
What’s App Business WorkFLow and Chat bot.
Crowl a Webpage in NextJs and Cheerio Library
Created a Glassmorphism Website
Created and Setup multiple react project.from Scratch.
Google map Integration in ReactJs.
Leadership and Mentoring
Led an 7-person team for a React project at Aara Technologies.
Mentored over 3 batches of trainees in React development.


key: chroma:document
string_value:
specifications.
Optimize performance through testing and debugging.
Improve development processes and team
collaboration.
Developed solutions using ReactJs, NextJs,
Flutter and Firebase.
Enhanced product functionality and user
experience.
Improved application performance and efficiency.
Contributed to scalable web and mobile
application design.


