Slashdb 0.9 Rev.1

We are pleased to announce the first revision of our 0.9 release from two months ago. In addition to improvements to performance and concurrency this revision carries a slew of readily applicable business features.

SlashDB enables data scientists, software engineers and project managers do more with data. The combination of Data Discovery and SQL Pass-thru APIs with data integrity from underlying databases and automated conversion into JSON, XML and CSV formats put our product in a league of its own when it comes to enterprise ready REST API.

Here’s what’s new, presented using our public end points.

Filtering Data Discovery by partial values (similar to SQL’s LIKE)

Example: Invoices with billing address on Elgin Street

https://demo.slashdb.com/db/Chinook/Invoice/BillingAddress/*Elgin*

Sorting by multiple columns

Example: Invoices first sorted by country then by date in reverse order.

http://demo.slashdb.com/db/Chinook/Invoice?sort=BillingCountry,-InvoiceDate&limit=29

Slicing by column for SQL Pass-thru URLs

Example: Parameterized query “customers-in-city” normally returns 5 columns

http://demo.slashdb.com/query/customers-in-city/city/London

Now you can pick only some of the columns in any order:

http://demo.slashdb.com/query/customers-in-city/city/London/LastName,FirstName,Phone

Assign HTTP methods for SQL Pass-thru queries

When defining a query the user now has an option to assign one or more HTTP methods. This way queries, which for example add new records (i.e. INSERT) can be more appropriately associated with the POST method. Previously SQL Pass-through would only work with the GET method.

Screenshot of query definition with HTTP method assignmentAPI key generator on user definition screen

When adding a new user or modifying an existing one there is now a button for adding a randomly generated API key. Previously keys had to be generated by other means and pasted into the user definition form.

Performance improvements

Faster JSON generation and changes to default values for certain concurrency parameters provide for better overall performance in a general a purpose application. As before those and many other parameters can be tweak in slashdb.ini file.

StackOverflow logoSupport on StackOverflow

Our community on StackOverflow is growing. Submit your technical questions with tag “slashdb” for fastest response.

http://stackoverflow.com/tags/slashdb