Category Archives: Back-end

SQL Databases in Node.js

Node.js is one of the best current platforms available for creating back-end applications that expose REST APIs. Often such applications are backed with a database. Nowadays, many NoSQL databases are available that integrate easily with the platform and operate using JSON data format and associated principles – so they’re natural to both a JavaScript platform such as Node.js and the modern REST APIs. These databases usually offer speed, conceptual simplicity, as well as massive horizontal scalability and parallelism – all great when the application, like many modern social media platforms and other services exposed to the end users on the Internet, works with large numbers of users. At the same time, the structural complexity of the data in the context of a single user is usually relatively simple and therefore can be handled perfectly by a NoSQL database.

Continue reading

Kicking the tires: Mulesoft

Mulesoft logoIn the past couple of  years I’ve seen lots of companies and products moving from monolithic applications to microservices world. As large, heavy web services are being replaced, I’ve started looking into products for REST services integration.

Mulesoft seems to be a good place to go for REST services integration and implementation. RAML is racing Swagger to become #1 solution for API design. Their Anypoint platform is making the integration of third party API’s simple and efficient. Using the ability to connect to SAP or ServiceNow platforms makes this solution perfect for wide variety for consumers. Mapping and transforming data capabilities are great bonuses as well.

Continue reading

Yet Another Result Set Parser

Database graph, distortedEfficiently parsing SQL query result sets into the hierarchical data structures with which applications normally operate has been a problem for quite a long time. Numerous attempts have been made over what feels like the ages to solve the problem, the essence of which is that the strictly two-dimensional grid nature of what’s returned by a SQL SELECT query – those rows and columns – map very poorly to the tree. More generally speaking,  they don’t suit the graph-like data structures utilized by modern applications to model the world. Continue reading

Coming Soon: In The Field

In The Field with Field Goods logoBig congratulations to our client Field Goods on their soon-to-be-released Web application In The Field:

In The Field is a web-based application that allows producers to more easily share information, such as crop availability and desired price, and it makes it possible for Field Goods to manage orders and request specific products. By reducing the costs of managing the supply chain and increasing transparency, this new tool lets Field Goods continue to partner with a broad range of local producers even as they scale up the business.

In short, this new application helps Field Goods multiply their impact on the local economy. [Source]

Continue reading

ORM must go!

No ORM!Object Relational Mapping, or ORM, has enjoyed a long run of being accepted as a standard paradigm for middle-tier, server-side software work with a back-end database. It’s wide spread and “no-brainer” status originated, probably, with the popularity of a single, exceptionally successful Java framework called Hibernate. The idea behind ORM is blending the line that separates the middle-tier and the persistence layer and making them practically one piece. So-called persistent objects become something that simultaneously belongs to the persistence layer and the rest of the application that works with them – often even in the presentation layer.

Continue reading

NPM and friends

npm logo[A couple of months ago, the open source community and npm were rocked by an author’s unpublishing of a module called “kik.” This unprecedented action, which brought down scores of projects that were dependent upon the kik module, was the result of a dispute over ownership of the name “kik” itself. Nestor Fedyk has some interesting things to say about this dispute. Read on… — The Editor]

This is a late response to this article about the deletion of the “kik” module from npm. Most people have sided with either Azer Koçulu or npm on in this dispute and it sort of became quite at “the moment .”

Continue reading