Searchable database best practice.

Ask the community
, ,
1

Hi, I’m putting together a database that I will be using to create dynamic pages. We have 4 media types - blog posts, pdfs, videos, and audio. I’d like some suggestions on how to make this database searchable by the end user in a normal fashion.

There are some search plugins that can scan the contents of a pdf (and a blog post) and return the results. The problem really arises when it comes to the video and audio. I’ve been thinking that I’ll tag the entries, and have the end user search using those tag terms. The problem is that this doesn’t allow for fuzzy matching.

I hope I’m clear with the problem I’m facing. Any suggestions? TIA.

2

If I understand you correctly, you want to have a fuzzy search on tags that you enter on the DB,
You’ll probably have to implement this yourself. fetch all data on site load, then implement a fuzzy search yourself with JS. there are a lot of examples for this in the web you’ll just need to pick whatever fits your need.

3

Thanks for the response.

After looking over the Wix DB, I realized that it doesn’t support audio or video. That would make it a poor choice, then, as I won’t be able to make my videos or audio searchable, nor would I be able to populate dynamic pages with video or audio.

Am I understanding that correctly? Thanks.