Creating a company/decision maker database app.

Problem Description

We are looking to build a company (/decision maker) database app, that would present data from the database, which the user should be able to filter/search. The first version we are looking to build here should have following core features:

For the admin:

• Can create and remove new “workspaces” and add and remove users from the workspace, users use emails as their identifier
  For the user:
• Receiving login details in email after beeing added to a workspace(?)
• Login to the database app
  Following require the user to ve logged in:
• Seeing a list of all the available companies with pagination, display only 100 first companies on the first page, user is able to move between pages(?)
• User can open a company and see all the data available for that company on a separate company page
• Searching for companies by name, and other available fields, fuzzy search
• Filtering companies (practically a search where you can select the key you want to search for e.g city=helsinki or line of business= manufacturing)
• Saving filters as lists
• Exporting list of companies (the limitation should be set to 5000 per export). If more than 5000 in the list, it should just export first 5000 rows. Export will always contain all the available data and should be in csv or excel format.

Priority for the mvp is for it to work, not to look pretty. But obviously it is great if it also looks pretty.

To add to the above the app should fetch data from data from two open apis, we have an sample code for this, that we will share.

This should run on a server or cloud function with a database, preferably postgresql. For initial data, it can be run manually once. And for fetching new companies, it could be run once per day with a cron and a filter that only takes new companies registered since last 24h. Also there should be inplemented a strategy for updating existing companies, since their data could update, there could be a full update every month or so.

Acceptance Criteria

We are looking for a developer who is confident that can build this app. We require you to sign a separate contract so that the IPR from the app moves to us.

Good written English is required from the applicant.

Technical Details

Ideal stack react.js/next.js on front-end and node.js on backend. Ideally you would use Material UI and as an example https://minimals.cc/ for this.

We are looking to most likely host this on Google cloud. The database should be Postgresql.

I will provide you with sample data that you can use in testing.

We also have rough figma designs for this, though they aint scoped down to mvp properly and contain further development steps.

Timelines / Milestones

Ideally this MVP would be done during December. We can split this to multiple milestones, and would like to see considerable progress in the next two weeks.

For further steps, there is multiple things we are looking to do with this:

• Adding “reveal” functionality and monthly quotas for users to “reveal” data.
  o Practically this means that certain fields require credits to be shown and super admin should be able to manage credits
• We want to create an api so that you can move data from lists to different softwares (possibly make/zapier app later)
• Adding payment methods via stripe
• Possibility for the admin to add data to the database manually, without using SQL

The bounty amount here is not final, I am trying Replit for the first time so didnt want to deposit more for first try. But we can negotiate the exact rate.