html5

SlashDB Helps Aruba Win #1 Spot in Digital Marketing Index

SlashDB Helps Aruba Win #1 Spot in Digital Marketing Index

Together with ConceptFarm, a leading digital marketing agency in New York, we are delighted to share with you the recent success of our client, Aruba.com.

Caribbean & Co. reports that the happy island of Aruba ranks No. 1 out of 35 Caribbean islands for overall “destination marketing index 2015.” Aruba also ranks No. 1 out of 10 Caribbean islands for Instagram reach, boasting an impressive 23,000 followers, double the number of the runner up. The marketing index ranking was derived by a proprietary weighing of various data, including social media followings, website inbound links, 3rd party rankings, and more (…)

Solidifying its position as the most digitally innovative DMMO, the ATA recently launched The Happiness Builder – a content-rich planning experience (…)

Quick Start With SlashDB

SlashDB connects website to databaseWhen the design team at ConceptFarm outlined their ideas for Aruba’s Happiness Builder it quickly became evident that such an innovative site would need to be custom built. Featuring video clips of nearly 100 attractions housed under six categories, the site allows visitors to create and share custom video “itineraries” of their Aruba vacation, complete with personalized messages and a choice of sound tracks.

The honor of programming of the site was awarded to VT Enterprise (the company that created SlashDB) after a highly competitive Request for Proposal process. Victor Olex, founder and CEO commented:

The sheer scope of the project and the need to launch the site in time for the contest was not a job your neighborhood web developer or digital marketing agency could do by themselves. We took the challenge and delivered on every idea the creative team threw at us.

VTE’s team utilized database design methodologies found in professional enterprise information systems and coupled that with API automation from SlashDB. SlashDB provided an instant API gateway to MySQL, which was the database already in use at Aruba.com. This combination formed the bedrock of the solution and the back-end for the web application.

Focus on User Experience

Once an API layer was in place, the development team focused on delivering the rich interactive features and stunning visuals conceptualized by the creative team. HTML5, advanced Cascading Stylesheets (CSS), and the JavaScript library, AngularJS, were key components in the front-end development process. OpenStreetMap combined with styling from Stamen and Leaflet library rounded off the technology stack and allowed for the innovative special effects on the map of the island. Adds Olex:

Every time our back-end team needed to make a change to the database, SlashDB instantly provided our front-end developers with an API ready for use. In the end we found that the entire site required literally ZERO lines of code in the back-end. SlashDB truly surpassed our own expectations.

At VTE, we view the finished product as one our greatest accomplishments in digital marketing production. This project was richly rewarding as it allowed our developers to explore new concepts and deliver a product that is truly remarkable for both its visuals and dynamic use of technology. We are happy to share the finished product on behalf of our client and hope that this new site will help to inspire plans for your next vacation.

Aruba Happiness Builder - Explore by Map

SlashDB ver. 0.8 Debuts on Microsoft Azure

SlashDB ver. 0.8 Debuts on Microsoft Azure

The latest version of SlashDB launches on Microsoft’s cloud — a direct result of a partnership agreement between VT Enterprise and Microsoft. Pricing starts at $0/hr.

SlashDB is an automatic REST API for databases. The product instantly enhances existing web-based systems with a flexible data API for reading and writing in JSON, XML and CSV formats. Using SlashDB, web businesses achieve the shortest time to market for their API initiatives in marketing, e-commerce or data monetization programs. Enterprise clients utilize SlashDB to enable traditional client/server systems to work with modern HTML5 and mobile front-ends.

Indisputable Return on Investment

Microsoft_Azure_CertifiedUp to 90% of API development time can be saved by deploying SlashDB software. With the instant availability and pay-as-you-go per-minute billing for SlashDB on Azure there is no delay to start an API project and no upfront costs for hardware, networking and software development.

SlashDB clients report $30-$40k in savings per annum per developer. Developers can often entirely avoid boiler-plate data access code in Java Enterprise Edition (JEE), Microsoft .NET, PHP, object relational mappers (ORM) or other code-heavy approaches. Repetitive work is avoided due to SlashDB’s unique ability to automatically emerge new API endpoints as new tables are added or changed in the database.

What’s New in Version 0.8

Availability

SlashDB version 0.8 is immediately available from Microsoft Azure Marketplace and for on-premises installation. Version 0.7 is also available on Amazon Web Services with the update coming soon.

UPDATE: AWS Marketplace has the latest version now too.

SlashDB Airzooka Raffle at PyData

SlashDB Airzooka Raffle at PyData

Welcome back, here’s a short blast from the past, a video featuring SlashDB that we just discovered on the web.

In November last year we were proud sponsors of the PyData conference. In this lightning talk we are outlining SlashDB’s main benefits. After the presentation we are using random number generator in Google Spreadsheet to raffle-off an Airzooka gun.

http://vimeo.com/79936618

How Bloomberg Uses REST APIs

How Bloomberg Uses REST APIs

Bloomberg Industry Leaderboard Uses REST API for Financial Data Visualization; Imagine What You Could be Doing with Your Data Assets

If you have visited Bloomberg’s website lately you may have noticed a new tool called Bloomberg Industry Leaderboard, which is a part of their Visual Data site. The Leaderboard presents fundamental data about 600 leading global corporations in a visually attractive manner. Visualization techniques such as tree map, colored grid and rankings are all dynamically configurable, and results are sorted on the fly.

bloomberg-leaderboard

 

While the concept of presenting fundamental metrics in similar ways is not new, and there are many websites with similar data and visualization, the technical details behind the site are worth examining a bit closer.

Traditionally, data-driven  web pages respond to users input (clicks) by requesting from the web server a fully prepared page, coded in HTML for the browser to render. This typically results with reloading of the entire page upon each interaction or (more recently) with replacing fragments of existing HTML with new ones. In contrast, Bloomberg’s site uses REST/HTTP API to get raw data, which the browser then combines with a shell HTML page using Javascript and Cascading Style Sheets.

For us what is even more interesting is that Bloomberg seems to follow a very similar approach to that of SlashDB. Here’s an example of companies broken down industry and ranked by operating margin and estimated net income growth:

http://www.bloomberg.com/visual-data/industries/rank/margin:est-net (HTML representation)
http://www.bloomberg.com/visual-data/industries/db/rank/margin:est-net.json (underlying data)

By comparison, SlashDB links (to an unrelated data set) look as follows:

http://demo.slashdb.com/db/Chinook/Customer/Country/Brazil.html (HTML representation)
http://demo.slashdb.com/db/Chinook/Customer/Country/Brazil.json (underlying data)

Imagine what you could do by layering SlashDB on top of your data. Use it internally for data federation, database search and self-service reporting, or deliver data to the web and mobile apps, or even offer your data assets for sale. Either way, the time to market is about an order of magnitude shorter than custom developed solutions, as our customers have attested. SlashDB is also more versatile as it allows for reading and writing of data and provides alternative data formats. It just as easily integrates with Excel, R, Matlab and enterprise systems as it does with the web.

As you may know, the idea for SlashDB was conceived out of the issues with access to market data in large investment banks. Had Bloomberg used SlashDB, they could have saved a ton of time and money.

Try /db Risk Free

If you would like to learn more about SlashDB or to discuss REST APIs in finance or in general, please contact us. You can also register here to try our product risk free.

SlashDB Adds Support for 3Scale API Management Service

SlashDB Adds Support for 3Scale API Management Service

powered-by-3scale-croppedWe are pleased to officially announce that we have added support for 3Scale API Management service in SlashDB.

Powerful Technology Combination

With /db‘s capability to generate API on the Fly™ directly from databases this level integration creates the most powerful combo to quickly and reliably launch, manage and safeguard REST/HTTP APIs. API metering, billing and developer portal management are only some of the features that 3Scale’s platform provides. But an API management service cannot build an API for you – that is what SlashDB does.

In the past this kind of integration required manual modifications to proxy configuration files, which although powerful can be cumbersome to do. Now, all that is required is to use 3Scale web-based GUI for proxy configuration to generate required files, which then can be simply uploaded to SlashDB. Of course, manual tweaking of the files is still possible so SlashDB clients get the best of both worlds so to speak.

API Keys

Related to 3Scale integration, added is the support for authentication with API keys. SlashDB has always allowed for stateless authentication using HTTP Basic Authentication but many developers are accustomed to the convention of an API key. SlashDB now supports both a singular API Key (user key) or a pair of Application ID and Application Key. The keys can be associated with SlashDB accounts (users), which in turn govern access to data resources and system features. For making API calls authentication keys can be provided as HTTP headers or in a URL query string.

Immediate Benefits

There is no faster way to an API than from one’s database and SlashDB excels at making the connection, thanks to these key features and benefits:

  • API on the Fly™ with multiple resource representations to suit every purpose
  • Data Discovery and search readiness to visually orient developer or analyst in data resources available
  • SQL Pass-thru to leverage the full power of database querying capabilities in API
  • Authentication, resource authorization and encryption to control who gets to see what
  • Leverages investments already made in databases for seamless integration with HTML5, mobile, NoSQL and Big Data analytics

Enterprises, web businesses, data vendors, data scientists, quantitative analysts, DBAs, mobile enterprise applications developers and other user groups all derive unique benefits from SlashDB.

How can /db upgrade your data infrastructure? Learn about solutions and try it risk-free on your databases.

Mobile App in a few clicks using SlashDB and KendoUI

As a quick experiment this afternoon, we clicked our way through a tutorial to KendoUI and modified it slightly to show data from the SlashDB demo instance. As you can see in the picture a simulated iOS app is displaying data from a SlashDB URL.

Data from SlashDB shown in KendoUI app.

Data from SlashDB shown in KendoUI app.

There are two code parts that make up the app.

1. Declarative HTML5 application layout

<!--Add Mobile App HTML --></pre>
<div data-role="view">
<div data-role="header">
<div data-role="navbar">Northwind Customers</div>
</div>
</div>
<pre>

2. JavaScript initialization and data fetch code

//Mobile App Initialization Code
var ds = new kendo.data.DataSource({
    transport: {
       read: {
            url: "http://demo.slashdb.com/db/Northwind/Customer/CompanyName.json?limit=41",
            dataType: "json"
        }
    },
});

ds.read();
window.ds = ds;
var app = new kendo.mobile.Application(document.body);