How to prevent duplicate data in DB?

• fuzzysort

  7 3,490 0.0 JavaScript

  Fast SublimeText-like fuzzy search for JavaScript.

Use something like fuzzysort, to compare user input to what currently exists in the DB. If there are no good match scores, when comparing user input for "job title" to what exists in the DB, you can proceed with creating an entry. However, if there is a match, you can respond to the front-end with the best match, and use it to autofill the form (or provide some kind of feedback for the end user). Your web server should perform match score verification before adding a new job title to the DB.

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

Suggest a related project