Frequently Asked Questions
What are the advantages of FriendlyData compared to similar products?
FriendlyData API works with any SQL schemas including dynamic schemas where you send the DB structure to the API endpoint along with the query. FriendlyData API also doesn’t require access to the DB, neither does it transfer any data over the network. We simply return you the SQL query that you safely run on your server.
Is there any time limited trial version available to evaluate?
Not yet, but we will be happy to build for your custom demo\POC. Contact us!
Can you offer an on premise setup?
Both (cloud and on-prem) options are available. The main advantage of the cloud integration is faster support and ability to update solution on the fly. We have a very aggressive roadmap and API solution would allow us to deliver updates to you without involving any resources from your side.
Tell me about the integration.
Integration process is really smooth for you - you only need to give us your database schema and make a connection to the REST API endpoint in your application. Usually it takes less than few hours.
What’s the difference between FriendlyData and open source NLP libraries? Can I build an in-house solution for databases using such libraries?
You can use a natural language processing library coupled with a rule driven post-processing module that analyzed the syntactical tree. But such approach has the following drawbacks: the input query has to be a grammatically correct sentence which was not always the case since the users often tend to simplify constructions and use symbols not typical for natural language, i.e. creating a mix of natural grammar and formal query language. Also, NLP parsers are not 100% accurate and the accuracy drops dramatically in longer sentences, e.g. when the query contains a chain of 4 or more conditions. FriendlyData’s query parsing module based on the proprietary formal grammar based technology. The technology features the following advantages that improve the technology learning curve and customer on-boarding time:
- FriendlyData parses both natural language and any structured or semi-structured types of queries
- The technology is based on a simple plain text grammar definition format that can be easily edited and compiled on the fly.
- The grammar format allows for custom solutions that require introduction of new synonyms, data types and operations.
- The parsing module outputs a tree specifically modelled for query analysis purposes which provides full control over the structure and makes the post processing and query object translation easy and transparent.
What databases do you support?
We support a wide list relational DBMS (including PostgreSQL, MySQL, MSSQL, Amazon Redshift, etc) so we are pretty sure that if you have any relational DBMS then we support it.
What languages do you support?
Right now we work with English only but we are planning to extend our language coverage. You can subscribe to our newsletter not to miss any significant updates.
We don’t support any NoSQL solutions right now, but we have very aggressive roadmap which includes implementing FriendlyData for NoSQL databases. Subscribe to our newsletter to be in touch.
Is my data safe?
Yes, your data is absolutely safe - we don’t require you to move your data anywhere and we even can work without any access to your data - we only need to know your database structure and columns names and types.
What about accuracy?
It depends on your particular case, but as we found out from our customers experience, the accuracy is about 90% in average. The accuracy approaches 100% for queries written in grammatically correct English.
Do you provide an autocomplete?
Yes, we can provide the suggestions functionality as an add-on.
Does FriendlyData ‘translate’ into SQL only or are there other options available?
FriendlyData translates into different SQL dialects but we can also respond with structed object which you can use according to your needs or we even can translate into your own DSL.