[PR #2133] [CLOSED] Add search function to database layer #5951

New Issue

OVERLORD · 2026-02-05T10:21:09+03:00

OVERLORD commented

2026-02-05 10:21:09 +03:00

📋 Pull Request Information

Original PR: https://github.com/BookStackApp/BookStack/pull/2133
Author: @jeff-ong
Created: 5/22/2020
Status: ❌ Closed

Base: master ← Head: feature/search-MySQL-stored-procedure

📝 Commits (1)

97e2c91 Add search stored-procedure to allow developer to call the search function with a different front-end application

📊 Changes

1 file changed (+43 additions, -0 deletions)

View changed files

➕ database/storedProcedure/search-books.sql (+43 -0)

📄 Description

Add MySQL stored procedure to allow us to call the search function in the database layer. It lets us access the search feature when using the relational database with different frameworks.

Steps to create this SP in database:

First, ensure that search_terms table is a type of either InnoDB or MyISAM
Create a new index on the search_terms table: CREATE FULLTEXT INDEX search_terms_fulltext_index ON search_terms(term)
Create the stored procedure by executing the code inside ./database/storedProcedure/search-books.sql

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/BookStackApp/BookStack/pull/2133 **Author:** [@jeff-ong](https://github.com/jeff-ong) **Created:** 5/22/2020 **Status:** ❌ Closed **Base:** `master` ← **Head:** `feature/search-MySQL-stored-procedure` --- ### 📝 Commits (1) - [`97e2c91`](https://github.com/BookStackApp/BookStack/commit/97e2c91ce92ddd51958c0a3ec44d3c0a5a349b42) Add search stored-procedure to allow developer to call the search function with a different front-end application ### 📊 Changes **1 file changed** (+43 additions, -0 deletions) <details> <summary>View changed files</summary> ➕ `database/storedProcedure/search-books.sql` (+43 -0) </details> ### 📄 Description Add MySQL stored procedure to allow us to call the search function in the database layer. It lets us access the search feature when using the relational database with different frameworks. Steps to create this SP in database: 1. First, ensure that search_terms table is a type of either InnoDB or MyISAM 2. Create a new index on the search_terms table: `CREATE FULLTEXT INDEX search_terms_fulltext_index ON search_terms(term)` 3. Create the stored procedure by executing the code inside ./database/storedProcedure/search-books.sql --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

OVERLORD added the pull-request label 2026-02-05 10:21:09 +03:00

OVERLORD closed this issue

2026-02-05 10:21:12 +03:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#5951