I’m currently doing some testing to determine the best way to achieve something in Bubble (something which is a very common requirement, and should be very simple but, due to some of the limitations of Bubble’s database query functionality, is way more challenging than it should be), and I’d be inte…

I’m looking forward your benchmark results on contains keyword(s) :slight_smile:

My 10 minute solution for the second problem: [image] adamhholmes: Return ONLY Content Items that contain ALL of the selected Tags [CleanShot 2024-07-30 at 20.47.45@2x] etc up to the max number of tags you want to support. The limitation is editor maintainability, and having a limit on t…

[image] georgecollier: I’ve found this is abysmal on searches with lots of text (e.g blog posts) to the point of not being useable I was just thinking about the tags being a single text field, not running it on the whole blog post.

İs this actually work ? I have tried constructing the selected in every scenario possible but it actually doesn’t work as intended

İs this performant ? I have 73.600 tags in my case

[image] Is this the right way to use "contains keyword(s)"? Need help an example: contains keywords the cat is on the table [image] will match these value in the database (just some example): cat table CAT table the cat is on the yellow table the table is a cat you…

[image] dorilama: I was just thinking about the tags being a single text field, Ah of course, good shout. Hadn’t thought about that as I never read too much into how contains keyword(s) actually works.

I think it doesn’t work any of this type of scenarios

I’m sure you can see how it can be used on one use case once you understand how the operator works [image] dorilama: I was just thinking about the tags being a single text field, not running it on the whole blog post.

[image] georgecollier: etc up to the max number of tags you want to support. The limitation is editor maintainability, and having a limit on the number of tags based on how many constraints you include. If only you could programmatically add constraints… is Data API allowed? :wink:

Bubble DB Challenge - Searching By Tags

Questions

dorilama July 30, 2024, 12:56pm 11

Topic		Replies	Views
List A contains at least 1 of List B Questions	16	3081	September 26, 2023
Optimal Database Design - Advice? Database	23	2141	April 3, 2024
How do I create a tagging system? Need help	30	7036	November 2, 2022
Search 2.0 - Summarizing what I've learned exploring Algolia Idea	64	13001	February 17, 2022
[New Plugin] Quick Find Search & Facet Filtering Plugins	189	15984	March 8, 2025

Bubble DB Challenge - Searching By Tags

Related topics