Download the PHP package provydon/laravel-pgsearch without Composer
On this page you can find all versions of the php package provydon/laravel-pgsearch. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download provydon/laravel-pgsearch
More information about provydon/laravel-pgsearch
Files in provydon/laravel-pgsearch
Package laravel-pgsearch
Short Description PostgreSQL-friendly search for Eloquent (ILIKE + normalization; optional FTS/trigram later).
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package laravel-pgsearch
🔍 Laravel PostgreSQL Search
Smart PostgreSQL search for Laravel with text normalization and relationship support.
✨ Why This Package?
- 🎯 Smart matching: Find "Jane Doe" even when stored as "Jane-Doe"
- 📱 Phone numbers: Search "1234567890" matches "(123) 456-7890"
- 🔗 Relationships: Search across related models seamlessly
- ⚡ PostgreSQL optimized: Uses ILIKE and REGEXP_REPLACE for performance
- 🛡️ Safe fallback: Works on non-PostgreSQL databases (no-op)
🚀 Quick Start
Install
Use Immediately
That's it! No configuration needed.
💖 Support
If this package helped you, consider supporting its development:
📖 Usage Examples
Basic Search
Relationship Search
Advanced Options
Ordering and Custom Sort
When order_by_best_match is enabled (default), results are ranked by relevance: exact phrase match (100) > normalized match (50) > word token match (10). This prevents generic words (e.g. "office") from returning the wrong row when multiple rows match.
Custom ordering: Chain your orderBy after pgSearch() so relevance is primary and your column is the tiebreaker:
To disable best-match ordering entirely, pass ['order_by_best_match' => false] or set it in config.
Helper Function
For convenience, you can also use the pg_search() helper function:
🔧 Configuration (Optional)
Publish config to customize behavior:
🧠 How It Works
The package performs intelligent PostgreSQL searches:
| Search Type | SQL Example | Matches |
|---|---|---|
| Direct | name ILIKE '%john doe%' |
"John Doe", "JOHN DOE" |
| Normalized | REGEXP_REPLACE(phone, '[^a-zA-Z0-9]', '', 'g') ILIKE '%1234567890%' |
"(123) 456-7890", "123-456-7890" |
Real-World Examples
📋 Requirements
- Laravel: 10.0+, 11.0+, 12.0+, or 13.0+
- PHP: 8.1+
- Database: PostgreSQL (graceful fallback for others)
⚡ Performance Tips
For frequently searched columns, add expression indexes to speed up normalized searches:
Important: Use the exact same expression as in the search query for optimal performance.
🧪 Testing
📝 License
MIT License - see LICENSE for details.
Made with ❤️ for the Laravel community
All versions of laravel-pgsearch with dependencies
illuminate/support Version ^10.0|^11.0|^12.0|^13.0
illuminate/database Version ^10.0|^11.0|^12.0|^13.0