Sybase iAnywhere SQL AAnywhere Mobile and Embedded Database

Rows and Columns

SQL Anywhere perspective on technology

header image

Entries Tagged as 'Development'

Simple.Data and SQL Anywhere – First Impressions

January 23rd, 2012 · Comments Off

I was recently referred to the Simple.Data library by a SQL Anywhere user Richard Hopton (@richardhopton on twitter) who has created the Simple.Data.SQLAnywhere adaptor for Simple.Data. I’ve written down some of my impressions here after taking a look at it.

[

Tags: Commentary · Development · SQL Anywhere

SVG support in SQL Anywhere

January 16th, 2012 · Comments Off

The support for spatial data in SQL Anywhere 12 includes the ability to generate result sets in the SVG (scalable vector graphics) format. This format is basically an xml representation of spatial data. We leverage this support in DBISQL, to provide visual representations of result sets:

[

Tags: Development · GIS · Spatial · SQL Anywhere

Who Needs a Client Interface?

January 9th, 2012 · 1 Comment

The SQL Anywhere database server has had the ability to accept HTTP (and HTTPS) requests for a while now. It is a very cool feature that allows (among other things) the production and consumption of web services directly from the database server (ie. no web server required). While not designed to actually replace a web [...]

[

Tags: Development · SQL Anywhere

SQL Graph Paper

February 16th, 2011 · Comments Off

You can do all sorts of cool things with the spatial data support in SQL Anywhere 12. One of the engineering team shared this function with me. This function creates a grid, much like a sheet of graph paper, with x and y co-ordinates defined in the function call. DROP FUNCTION IF EXISTS F_GraphPaper; CREATE [...]

[

Tags: Development · Spatial · SQL Anywhere

Formatting a Tag Cloud

April 27th, 2009 · Comments Off

Previously, I talked about creating a tag cloud, aggregating tag information from multiple blogs. In order to create/display the tag cloud on the Sybase blog homepage, we had to determine how to integrate the data and the CSS that was generated to display the tag cloud. After some discussion, we decided to feed the tag [...]

[

Tags: Development · SQL Anywhere · WordPress

GPS – How Does It Work? – Part 3

April 13th, 2009 · Comments Off

In my first post in the series, I covered how one might gain access to a GPS signal and interpret it. Post 2 covered displaying the data and storing it in the database. Now that we have some data collected and stored in the database, we can do some other things to it.

[

Tags: Development · Spatial · SQL Anywhere

GPS – How Does It Work? Part 2

April 6th, 2009 · 1 Comment

In my previous post I explained how to receive and parse a GPS signal from a GPS device.

In order to leverage the parser, I created a (very) simple GUI to parse and display the GPS information. I dropped a multi-line edit on the form, declared some delegate functions to act as callbacks for the parsing process, and then created the parse function (once again from the CodeProject article I mentioned in my previous post)…

[

Tags: Development · GIS · SQL Anywhere

GPS – How does it Work?

March 31st, 2009 · 3 Comments

GPS devices are becoming more and more prevalent. They’ve been sold as separate navigation units by a variety of vendors, been embedded into the dashboards of newer luxury vehicles, and I expect they will soon become a standard part of a cell phone, much like the camera has evolved. This will lead to more and [...]

[

Tags: Development · GIS · Spatial

Automated Database Backups

February 26th, 2009 · Comments Off

Having a backup and recovery process in place is critical if you care about your data. The following is a simple event I created to automate backups for the SQL Anywhere database running on the blog server: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 [...]

[

Tags: Development · SQL Anywhere

The Problem With Object Relational Mappings

January 26th, 2009 · 2 Comments

My co-worker Glenn Paulley has been writing in his blog lately about Object Relational Mappings (ORM) and all of the issues it generates for the application developer and database vendors. I thought I would provide my own view on ORMs, as a former technical support person and bug fixer for the SQL Anywhere code. I [...]

[

Tags: Commentary · Development