Algolia in San Francisco, California offers enterprise search as a service.
$0
per month 10,000 search requests + 1 Million records
PostgreSQL
Score 8.6 out of 10
N/A
PostgreSQL (alternately Postgres) is a free and open source object-relational database system boasting over 30 years of active development, reliability, feature robustness, and performance. It supports SQL and is designed to support various workloads flexibly.
N/A
Pricing
Algolia
PostgreSQL
Editions & Modules
Build
$0
per month Up to 10,000 search requests + 1 Million records
Grow
$0.50
per month per 1,000 search requests
Algolia Recommend
$0.60
per month per 1,000 Recommend requests
Premium
Custom
per month Customized pricing
No answers on this topic
Offerings
Pricing Offerings
Algolia
PostgreSQL
Free Trial
No
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
Pay as you go, scale instantly, or upgrade anytime for advanced features and capabilities.
Algolia was by far and away the easiest of the three to implement. PostgreSQL has many search modules that can be used on top of your usual database, however, none are particularly efficient and can quickly become overwhelmed at scale. Equally, they do not handle business …
Algolia offers a wide range of capabilities that can benefit any business by addressing their specific requirements. Integrating with this platform is seamless, and their extensive knowledgebase and training resources are highly valuable for both developers and UI users. We have already witnessed the advantages of this product and are eagerly anticipating future enhancements as we continue to expand our platform, with Algolia as our primary tool for enhancing our search experience.
PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.
The stability it offers, its speed of response and its resource management is excellent even in complex database environments and with low-resource machines.
The large amount of resources it has in addition to the many own and third-party tools that are compatible that make productivity greatly increase.
The adaptability in various environments, whether distributed or not, [is a] complete set of configuration options which allows to greatly customize the work configuration according to the needs that are required.
The excellent handling of referential and transactional integrity, its internal security scheme, the ease with which we can create backups are some of the strengths that can be mentioned.
Recent pricing model changes made Algolia considerably more expensive. I understand that companies change their models all the time, but my plan almost doubled in price overnight. They let me keep my legacy plan for as long as I wanted, but I had already outgrown it, so a small increase in demand caused big price spikes. It's still cheap for what it is though.
The documentation is generally good, but sometimes hard to navigate. I was trying to find examples of how to combine geo-queries with normal ones, and I couldn't find an example, but it wasn't actually hard to figure out.
Some of the advanced features can be hard to understand at first. This isn't really a con, as it just means Algolia is loaded with features, but I was a bit overwhelmed the first time I tried to customize an index.
The query syntax for JSON fields is unwieldy when you start getting into complex queries with many joins.
I wish there was a distinction (a flag) you could set for automated scripts vs working in the psql CLI, which would provide an 'Are you sure you want to do X?' type prompt if your query is likely to affect more than a certain number of rows. Especially on updates/deletes. Setting the flag in the headless(scripted) flow would disable the prompt.
Better documentation around JSON and Array aggregation, with more examples of how the data is transformed.
Algolia is a great tool, we didn't have to build a custom search platform (using Elasticsearch for example) for a while. It has great flexibility and the set of libraries and SDKs make using it really easy. However, there are two major blockers for our future: - Their pricing it's still a bit hard to predict (when you are used to other kind of metrics for usage) so I really recommend to take a look at it first. - Integrating it within a CI/CD pipeline is difficult to replicate staging/development environments based on Production.
Algolia has a good interface and they have done some improvements. However, some non technical users have a challenging time in the use for the first days of learning. But once the main aspects are learned is a straight forward operation
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Performance is always a major concern when integrating services with our client's websites. Our tests and real-world experience show that Algolia is highly performant. We have more extremely satisfied with the speed of both the search service APIs and the backend administrative and analytic interface.
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
It’s non existent. No tech support and no customer service… my application was blocked and is currently inactive causing huge business disruption, and I’m still waiting days later for a response to an issue which could be resolved very very quickly if only they would respond. Very poor from a company of that size
There are several companies that you can contract for technical support, like EnterpriseDB or Percona, both first level in expertise and commitment to the software.
But we do not have contracts with them, we have done all the way from googling to forums, and never have a problem that we cannot resolve or pass around. And for dozens of projects and more than 15 years now.
The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
While AWS's offering is a typically cheaper solution, it requires a lot of work to gain any of the core features of Algolia. The cost of dev time and long-term maintenance would be more than the costs incurred with Algolia, which is why it made the most sense financially. On the engineering side, we could give our stakeholders access to Algolia to adjust the indices themselves, which would allow us to focus on other work.
Postgres stacks up just [fine] along the other big players in the RDBMS world. It's very popular for a reason. It's very close to MySQL in terms of cost and features - I'd pick either solution and be just as happy. Compared to Oracle it is a MUCH cheaper solution that is just as usable.
Overall is a scalable tool as the environment and the backend functions are the same and many things are done directly on the tool so without the need of further specific developments. However some things could be improved such as documentation for integration that could help in doing whitelabel solutions
Users who had abandoned our product (attributing slow search speeds as the reason) returned to us thanks to Algolia
We used Algolia as our product's backbone to relaunch it, making it the center of all search on our platform which paid off massively.
Considering we relaunched our product, with Aloglia functioning as its engine, we got a lot of press coverage for our highly improved search speeds.
One negative would be how important it is to read the fine print when it comes to the technical documentation. As pricing is done on the basis of records and indexes, it is not made apparent that there is a size limit for your records or how quickly these numbers can increase for any particular use case. Be very wary of these as they can quite easily exceed your allotted budget for the product.
The user-role system has saved us tons of time and thus money. As I mentioned in the "Use Case" section, Postgres is not only used by engineering but also finance to measure how much to charge customers and customer support to debug customer issues. Sure, it's not easy for non-technical employees to psql in and view raw tables, but it has saved engineering hundreds of man-hours that would have had to be spent on building equivalent tools to serve finance or customer support.
It provides incredibly trustworthy storage for wherever customer data dumped in. In our 6 years of Postgres existence, we have not lost a byte of customer data due to Postgres messing up a transaction or during the multiple times the hard-drives failed (thanks to ACID compliance!).
This is less significant, but Postgres is also quite easy to manage (unless you are going above and beyond to squeeze out every last bit of performance). There's not much to configure, and the out of the box settings are quite sane. That has saved us engineers lots of time that would have gone into Postgres administration.
