All Projects → manticoresoftware → Manticoresearch

manticoresoftware / Manticoresearch

Licence: gpl-2.0
Database for search

Programming Languages

cpp
1120 projects

Projects that are alternatives of or similar to Manticoresearch

V8 Archive
Directus Database API — Wraps Custom SQL Databases with a REST/GraphQL API
Stars: ✭ 486 (-20.33%)
Mutual labels:  api, sql, database, mysql
Filemasta
A search application to explore, discover and share online files
Stars: ✭ 571 (-6.39%)
Mutual labels:  search, json, search-engine, database
Directus Docker
Directus 6 Docker — Legacy Container [EOL]
Stars: ✭ 68 (-88.85%)
Mutual labels:  api, sql, database, mysql
App
Directus Admin Application — An Intuitive WebApp for Managing Database Content
Stars: ✭ 464 (-23.93%)
Mutual labels:  api, sql, database, mysql
Radon
RadonDB is an open source, cloud-native MySQL database for building global, scalable cloud services
Stars: ✭ 1,584 (+159.67%)
Mutual labels:  json, sql, full-text-search, database
Countries States Cities Database
🌍 World countries, states, regions, provinces, cities, towns in JSON, SQL, XML, PLIST, YAML, and CSV. All Countries, States, Cities with ISO2, ISO3, Country Code, Phone Code, Capital, Native Language, Timezones, Latitude, Longitude, Region, Subregion, Flag Emoji, and Currency. #countries #states #cities
Stars: ✭ 1,130 (+85.25%)
Mutual labels:  api, json, sql, mysql
Stackoverflow Clone
Clone project of a famous Q/A website for developers which is stackoverflow built using MySQL-Express-React-Node 🌐
Stars: ✭ 182 (-70.16%)
Mutual labels:  api, sql, database, mysql
Go Clean Arch
Go (Golang) Clean Architecture based on Reading Uncle Bob's Clean Architecture
Stars: ✭ 5,128 (+740.66%)
Mutual labels:  sql, database, mysql
Go Mysql Server
A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
Stars: ✭ 445 (-27.05%)
Mutual labels:  sql, database, mysql
Sleekdb
Pure PHP NoSQL database with no dependency. Flat file, JSON based document database.
Stars: ✭ 450 (-26.23%)
Mutual labels:  api, json, database
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (-21.8%)
Mutual labels:  sql, database, mysql
Franchise
🍟 a notebook sql client. what you get when have a lot of sequels.
Stars: ✭ 3,823 (+526.72%)
Mutual labels:  sql, database, mysql
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+669.67%)
Mutual labels:  sql, database, mysql
Fess
Fess is very powerful and easily deployable Enterprise Search Server.
Stars: ✭ 561 (-8.03%)
Mutual labels:  search, search-engine, full-text-search
Gnorm
A database-first code generator for any language
Stars: ✭ 415 (-31.97%)
Mutual labels:  sql, database, mysql
Dotmim.sync
A brand new database synchronization framework, multi platform, multi databases, developed on top of .Net Standard 2.0. https://dotmimsync.readthedocs.io/
Stars: ✭ 406 (-33.44%)
Mutual labels:  sql, database, mysql
Trdsql
CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. Can output to various formats.
Stars: ✭ 593 (-2.79%)
Mutual labels:  json, sql, mysql
Qb
The database toolkit for go
Stars: ✭ 524 (-14.1%)
Mutual labels:  sql, database, mysql
World countries
Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP and SQL formats, in multiple languages and with national flags included
Stars: ✭ 598 (-1.97%)
Mutual labels:  json, sql, mysql
Typesense
Fast, typo tolerant, fuzzy search engine for building delightful search experiences ⚡ 🔍 ✨ An Open Source alternative to Algolia and an Easier-to-Use alternative to ElasticSearch.
Stars: ✭ 8,644 (+1317.05%)
Mutual labels:  search, search-engine, full-text-search

Manicore Search Logo

Manticore Search 3.5.4

WebsiteDownloadsDocsCoursesForumChatTwitter

 

Introduction

Manticore Search is a database designed specifically for search, including full-text search. What differs it from other solutions is:

  • Powerful and fast full-text searching which works fine for small and big datasets
  • SQL-first: the native Manticore's syntax is SQL. It speaks SQL over HTTP and MySQL protocol (you can use your preferred mysql client)
  • JSON over HTTP: to provide more programmatic way to manage your data and schemas Manticore provides HTTP JSON protocol. Very similar to the one from Elasticsearch
  • Written fully in C++: starts fast, doesn't take much RAM, low-level optimizations give good performance
  • Real-time inserts: after INSERT is made the document can be read immediately
  • Interactive courses for easier learning
  • Built-in replication and load balancing
  • Can sync from MySQL/PostgreSQL/ODBC/xml/csv out of the box
  • Not fully ACID-compliant, but supports transactions and binlog for safe writes

Craigslist, Socialgist, PubChem and many others use Manticore for efficient searching and stream filtering.

Manticore Search was forked from Sphinx 2.3.2 in 2017.

More features

Installation

Docker

Docker image is available on Docker Hub.

To play with Manticore Search in Docker just run:

docker run --name manticore --rm -d manticoresearch/manticore && docker exec -it manticore mysql -w && docker stop manticore

You can then: create an index, add data and run searches. For example:

create table movies(title text, year int) morphology='stem_en' html_strip='1' stopwords='en';

insert into movies(title, year) values ('The Seven Samurai', 1954), ('Bonnie and Clyde', 1954), ('Reservoir Dogs', 1992), ('Airplane!', 1980), ('Raging Bull', 1980), ('Groundhog Day', 1993), ('<a href="http://google.com/">Jurassic Park</a>', 1993), ('Ferris Bueller\'s Day Off', 1986);

select highlight(), year from movies where match('the dog');

select highlight(), year from movies where match('days') facet year;

select * from movies where match('google');

When you exit from the mysql client it stops and removes the container, so use this way only for testing / sandboxing purposes.

Read the full instruction for the docker image for more details including our recommendations on running it in production.

Packages

Ubuntu, Debian, Centos, Windows and MacOS packages are here.

YUM repo for RHEL/Centos

yum install https://repo.manticoresearch.com/manticore-repo.noarch.rpm
yum install manticore

APT repo for Ubuntu/Debian

wget https://repo.manticoresearch.com/manticore-repo.noarch.deb
dpkg -i manticore-repo.noarch.deb
apt update
apt install manticore

Homebrew on MacOS

brew install manticoresearch

Windows

See instruction here.

MacOS .dmg

See instruction here.

Documentation and community channels

How we can support you

Should your company require any help - we provide full-cycle services in the areas of Sphinx and Manticore Search:

  • Audit
  • Support
  • Consulting
  • Development
  • Training

More details here

❤️ How you can support Manticore Search

Manticore Search is a GPLv2-licensed open source project with development made possible by support from our core team, contributors, and sponsors. Building premium open-source software is not easy. If you would like to make sure Manticore Search stays free here is how you can help the project:

Analytics

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].