One of things that surprised me in iOS is the lack of an open-source native library to connect to Microsoft SQL Server. When googling the topic the usual comments are “why would you do that?” and “just use a web service wrapper.” Well, there are countless business reasons to access a SQL Server on a LAN: POS, data collection, reporting, etc. Further, it’s not always possible or practical to install a web service layer (REST, SOAP, OData) to act as an intermediary. Granted, it is generally much safer to do so, but it does add a layer of complexity (and latency).
Posted in iOS, SQL
Tags: client, connector, data, isql, lan, library, Microsoft, native, query, sdk, server, sql, stream, tabular, tds
Yesterday evening I had the privilege of hearing tech legend Michael “Monty” Widenius, founder of MySQL, give a presentation on MariaDB at the AppNexus headquarters to an audience of 300+. MySQL is the world’s pre-eminent open source database, and Monty’s contributions still make up 60% of the current source code!
Posted in NoSQL, SQL
Tags: Cassandra, CONNECT, ExtraDB, Galera, InnoDB, MariaDB, MongoDB, MySQL, NoSQL, Oracle, Percona, Sun