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.
Entries Tagged as 'Development'
January 23rd, 2012 · Comments Off
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:
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 [...]
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 [...]
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 [...]
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.
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)…
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 [...]
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 [...]
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 [...]