J.D. Was Here

Rethinking dev.idaho

2015-04-15T07:34:00.000-07:00

I'll never forget the very first discussions about what would eventually become the dev.idaho conference. It was 2010 or 2011, and we were just putting together the ITC software alliance.

Matt Rissell was the president of the software alliance, and I was the chair of the education committee (I didn't work for Matt at the time. I was still at SAP and had a trip to WhiteCloud in my future). Matt kept saying we needed a "big event". I thought it was a terrible idea. We were a group of volunteers giving everything we had to just make a difference with our small community initiatives. Typical short-sighted engineer response on my part, but I felt we were spread thin already and an event would be an absolute waste of time.

I chose to focus on my committee and abstained from all planning and discussions about the event. This was my first experience with Matt's persuasive personality and his ability to get people around him to step up to a challenge. It was also my first experience with Martin Hambalek's project management and planning capabilities. I would learn over the years that both are incredibly capable and this single event was not an anomaly.

I attended the first dev.idaho event, which was paired with Tech Cocktail, and I was blown away. The community showed up, the startup showcase was a blast, the speakers were great with awesome stories to tell, Mark Solon dropped some F-bombs and after the event a number of attendees shut down The Modern. It was an experience to say the least!

Over the years, Martin's team has organized multiple events that fill the gap between a developer conference like Boise CodeCamp, and an entrepreneur or business conference.

This year's agenda is a departure from the format used the last couple of years and promises to entertain, educate and motivate like never before. A fantastic keynote from Hadi Partovi of code.org combined with numerous panel discussions from local software peers and a new networking format should make this a brand new experience even for those who have attended the event in the past.

I encourage everyone to attend the redesigned dev.idaho event, contribute to the discussions, network with your peers, and remember why we loved the first event so much.

I despise Hackfort and dev.idaho, and I will attend EVERY year

2015-03-26T20:29:00.003-07:00

When push comes to shove, I despise attending Hackfort and dev.idaho. But I will go EVERY. SINGLE. YEAR.

I’m a sucker for people who have an idea, a vision, and execute on it. I love people who DO THINGS versus talk about things. I love people passionate about Boise and software, and even if only a small group of them assemble at these events, I want to be around them and talk to them.

I have no affiliation with Hackfort, but nothing but respect for volunteers who can get four to five hundred software engineers to assemble in a single place at a specific time.

Three themes emerged during discussions at Hackfort today that come up every single time Boise developers and entrepreneurs assemble, and they all drive me freaking crazy:

Lack of funding in Boise
Inability to pull software developers from their “day jobs” to work on a startup
How we stay involved as a community and meet more frequently

Topic number one is BS. If you have a great idea, you can find funding anywhere and develop your product from Idaho. Better yet, bootstrap with a few angel investors (even if they aren’t from Boise) and build something cool. The reality is rather than being short on funding, we are short on innovative ideas. It’s hard to stomach and say out loud, but money is easy to find if your idea is sound. It’s too easy to blame a lack of funding when the reality is we are short on awesome ideas and teams that can execute on them.

Topic number two is also BS, but I understand the frustration. If your idea is compelling, and developers think it will work, they will help you build it. The problem is software engineers today are in high demand, often very well compensated, and they are very likely happily employed. When you offer no salary and limited equity in something that is simply an idea, you shouldn’t be frustrated when they are not chomping at the bit to drop everything and join your new venture. Believe it or not, they are people too, and have families to support. They are by definition risk-averse and analytical type-A personalities. I’m sorry your super-popular and personable high school quarterback friend can’t build out the infrastructure for your new product idea, but that’s the way things go. Offer developers an awesome salary and equity, or expect to be shot down. I’m sorry, but that is reality.

Topic number three should be so simple, but even I struggled today with a simple answer to the question of “how do I get involved or connect with the Boise dev community." The reality is, there are a LOT of software user groups, and a lot of entrepreneur groups meeting regularly in Boise. The Idaho Technology Council has a page listing a ton of meet-up groups (http://www.idahotechcouncil.org/local-places-techies-network). Myself and some friends agree there should be an easy to remember URL to find a list of active groups, and next week we will start something up so in the future we as a community can answer this question with a simple URL. Update: We're starting with a easy URL that redirects to the ITC page for now, and we'll build out a better (and more dynamic) site as we can: gemstate.io

What do we need to do to build Boise’s tech startup community? Simple:

1) Build awesome, compelling products and companies

2) Stay in Boise when you exit the business
3) Stay in Boise and keep building your business (never exit)

Build cool products and services, and if you have a liquidity event, please stay in Boise and build something else. That’s it. We should all be striving for this. It isn’t easy and it won't happen overnight, but until we reach critical mass, nothing is going to change and we will continue to attend events where all we do is fantasize about being the next big “tech hub."

Update: Most of the conversation around this post happened when Jess posted it on Facebook. You can read those comments here.

Two "Must Use" Chrome Dev Tools Shortcuts

2012-05-18T12:35:00.004-07:00

I switched from Firebug to the Chrome Dev Tools about 4 months ago and couldn't be happier. Until this week (May 14th, 2012), navigating to specific script files and functions was tedious. I'm happy to see some of the Chrome beta tools make their way to production this week.

Brand New

In scripts tab, cmd-O now brings up a dialog to open a specific script file. No more mousing over to the scripts drop-down.
Even better, cmd-shift-O brings up a dialog to navigate to a specific function in the current script. The only thing that would make this better is if it worked across ALL loaded scripts, vs just the current script. If this feature alone doesn't excite you I question your geek standing... seriously.
In options (the gear icon at the bottom-right of the dev tools screen), select "dock to right" to dock the dev tools with your existing browser window. Awesome option when you have a good monitor (24" or wider). I wish it could dock left, but this is better than nothing.
In options, "enable source maps". Cool way to map source files from compiled js to the actual source files. I REALLY hope this turns into a more advanced feature where you can map a server source file to a local host version, and then persist your in-browser changes to disk.
Speaking of in-browser changes, you can modify js source files in the dev tools and their changes are respected until you do an explicit browser refresh.
Tree view of loaded scripts. I'm not fond of this, and I hide it since I can cmd-O to find them anyway, but still a nice addition.

Not New, But Useful

cmd-shift-F, search for a string across ALL loaded scripts

would be even cooler if could get cursor into the results automatically (can set up keyboard maestro command to get there, though)

cmd-shift-C, activate the "select element to inspect" functionality
cmd-option-I, start debugging session

Side Effects

2011-11-04T13:46:00.001-07:00

Last month we hosted a CS Extras event at Keynetics, inviting all CS students, but focusing on freshman and sophomore students. The Keynetics team put on a great presentation. They focused on describing what kinds of things students can expect in the workplace, what a typical work day/week/month is like, why they love their jobs and the industry, what tools they use, etc.

The November presentation itself was a success, but I wanted to focus on how small events like this can indirectly result in long lasting returns.

To someone on the outside an event like this might seem like a waste of time or a futile effort. "How will talking to 20-60 students for 2 hours increase the number and quality of software professionals in Idaho?". This is a great question, and one I constantly ask myself as it can often feel like we are fighting an uphill battle.

This presentation, and the events following it helped solidify my motivation and confidence in our program.

At the BBQ after the presentation, two students told me they had been considering switching to an Electrical Engineering degree, but now they were motivated to stick with Computer Science and excited about the opportunities. That provided a warm fuzzy feeling and I was more than happy to take that as ample justification for the event. But that isn't why I'm writing this.

It wasn't until two weeks later that I realized the full impact of the event. This is a circumstance of one small act of giving turning into something much bigger than itself.

Amit, a professor at BSU, told me that the students came back to class and asked him about automated testing (which was mentioned in the presentation). As Amit uses tests to verify the students programming assignments, he was able to expose an interface the students could use to run his tests against their programs before submitting them.

If you work in the software industry, you understand the significance of that last paragraph. We now have first year CS students that understand the value of automated testing and how it can be applied to almost any program. This is a fundamental career skill that will not only help them with programming tasks in college, but that they will take with them into the work force.

We have a situation where one event, that was easy to coordinate, and took only a few hours of each volunteers time, instilled a process that will likely stick with these students (and possibly the curriculum) for years and years to come. In addition, the benefit of the presentation has now filtered to all students in that class, not just those who attended CS Extras.

Perhaps I'm being too optimistic, but these are the kinds of positive side effects that you just can't plan for but that can make the entire endeavor worthwhile.

To keep up with CS Extras events; like our Facebook page, subscribe to my blog, or watch the ITC website for event updates. To volunteer, post on the ITC LinkedIn discussion group and I will contact you.

Update: Be sure to check out the comments on this post, more good side effects.

Hello Tomorrow

2011-08-02T12:31:00.001-07:00

I started at Extended Systems in the fall of 1995 during my second year of college. I was immediately placed on a team with incredibly smart people working on fun products. That trend has continued for the past 16 years and I have had a wonderful time. Great coworkers, cool customers and constantly changing technologies have kept things interesting for a very long time.

I’m also excited to take on some new challenges and with that in mind I have accepted a position at a local startup and will be saying goodbye to my friends at ESI/Sybase soon.

While the last few years I have been the public face of Advantage via blog posts and screencasts, this product is much bigger than one person and is in great hands. The development team is strong and works with an equally experienced sales, support and marketing team. I know Advantage will continue to thrive.

I still plan to continue writing, however the content will likely shift a bit towards different software technologies. I look forward to continuing our conversations and friendships.

iPhone oData Client, Part 3

2011-06-22T07:23:00.001-07:00

In Part 2 of this series we moved our service query to a background thread and added “pull to refresh” functionality. In Part 3 we take a quick look at insert, update and delete functionality.

You can view (or right-click and download) the screencast here.

Resources

The Example Application Source Code
Paul Crawford’s PCCustomSwitch
Part 2 of this series

iPhone oData Client, Part 2

2011-05-26T12:23:00.001-07:00

In Part 1 of this series we set up an XCode project to use the Objective-C oData client and pulled some rows into a grid. In Part 2 we will move our service query into a background thread to keep our UI responsive. In addition, we will add some visual feedback and “pull to refresh” functionality.

You can view the screencast here (or right-click and download) (61MB).

Resources

Getting Started with iOS Development and Advantage

2011-05-17T14:04:00.001-07:00

The Advantage Web API makes it easy to expose your Advantage databases via the oData protocol. The oData protocol includes a variety of clients, including an Objective-C client for iOS devices (iPhone, iPod Touch, iPad, etc.).

I’ve posted an introduction to using the Objective-C oData client with Advantage. This 20 minute video shows how to download the client, configure a new XCode project, and display the contents of a table. You can stream the presentation (or right-click and download) here.

While this presentation is targeted towards Advantage developers getting started with iOS development, aside from the first 3 minutes the rest of the presentation is provider agnostic and applies to all oData services, not just those provided by the Advantage Database Server.

Update: If you’d like to use SSL, I’ve submitted a patch to the oData client you can download and use (as opposed to disabling SSL in the web api conf file). The patch provides a new switch for odatagen (/trustServer=1) and a new trustServer parameter when initializing your WindowsCredential object:

     WindowsCredential *cred = 

      [[WindowsCredential alloc] initWithUserName:@"adssys" password:@"" trustServer:true];

See http://odataobjc.codeplex.com/SourceControl/list/patches

Resources

CS Extras #1 and #2

2011-03-21T06:49:00.000-07:00

CS Extras kicked off in February with its first presentation. Seven industry volunteers collaborated to teach an introduction to web development fundamentals. Over sixty students from area universities participated in the inaugural event.

The second CS Extras presentation will be held Wednesday March 23rd from 6pm to 8pm in the BSU Micron Engineering Center, room MEC106. In this session, Patrick Lee from Bodybuilding.com will be focusing on web form creation fundamentals and persisting and retrieving data once a form is submitted. In addition, I can't hold out until April to give away these Apple TV's, so we will be giving away one of the three Apple TV's at the end of the night! If you attended the first session, and you are at the second session, you will be eligible to win. We've made a couple of tweaks to the "hands on" portion based on feedback from the first event as well, and pizza will be provided again. Hope to see everyone there!

Event map and other details can be found on our Facebook page as well at http://tinyurl.com/csextras

Delphi Starter Edition Database Support

2011-02-02T09:48:00.001-08:00

The Delphi Starter Edition was released February 1, 2011 as a low cost entry-level version of Delphi. The starter edition is a great addition to the Delphi product line, but only includes database support for IBExpress and the deprecated Borland Database Engine (BDE). It does not include a simple in-process database or support for client/server databases like SQL Server, MySQL, Oracle, etc.

Unlike these other database offerings, the Advantage Database Server components for Delphi are fully compatible with the Delphi Starter Edition, and you can start using them today for free. The majority of database support was removed from the Delphi Starter edition by eliminating support for the dbExpress database layer, but Advantage does not use this extra database layer, and therefore works very well with the Delphi Starter Edition.

BDE issues

Many Delphi developers and enthusiasts have been pointing out that beginners should not be learning to use Delphi with a deprecated database engine. Michael Rozlog mentions the BDE hasn’t been developed for 10 years and there is not a 64-bit migration path. This is untrue if you use the Advantage Database Server (ADS). In addition to being a fully functional client/server database and a great in-process local database, replacing the BDE with Advantage provides a clear and sustainable 64-bit migration path. Advantage already has 64-bit servers, supports a variety of 64-bit clients (ADO.NET, PHP, OLE DB, ODBC, etc.) and is ready to provide 64-bit Delphi support as soon as the Delphi compiler is available.

Free Local Engine

The Advantage Local Server is also included with the Advantage Components for Delphi, and is a free in-process database library that fits perfectly with the starter edition concept. The local server is not limited to local drive access and can operate on and serve data via network shares just like the BDE (only without lock file and concurrency headaches). The Advantage Local Server is free to use and distribute, and as your product grows and puts more demand on the database, the full ADS version is available with no code changes (simply change a server type property on the connection).

Starter Edition Installation

The Delphi Starter edition does not allow the use of the Delphi command-line compiler, which the Advantage installer generally needs. With this limitation the Advantage design-time components will work fine in the Delphi IDE, but when an application is built the compiler will fail to find adsdata.dcu. A future update to the installer will address this issue, but for now this is easily resolved by opening the Delphi Tools->Options menu, clicking on the Delphi Library item in the tree view (shown below), and updating the Advantage Library Path from “…\DelphiXE\win32” to “…\DelphiXE\win32\source”.

NOTE: With this path change, if you are utilizing user access control in Windows, you may need to run Delphi as the administrator the first time you compile an Advantage enabled application.

Copy/Paste Rows in Advantage Data Architect

2010-12-21T09:21:00.001-08:00

This is a guest post by Will Foster, our R&D intern this year, on a feature he implemented in ARC version 10.1

@WilliamGFoster

Overview

The Advantage Data Architect (ARC) now supports copy and pasting directly from the table browser! This functionality has been added in order to allow copy and pasting into and out of ARC. This means when you select one or more records in a table view (SQL Utility in next v10.1 public update) you will now be able to right click and “Copy Records” which will place all your data, including memo and blob field types, onto the system-wide clipboard. The data is placed onto the clipboard in CSV, HTML Table, and Tab delimited formats. This means you will be able to Paste directly into Microsoft Office products with some default formatting, and directly into an HTML formatted e-mail message. This framework also allows you to select data in Microsoft Excel or other spreadsheet software and paste directly into ARC, making adding data to a table as easy as a copy and a paste. You can also copy rows from a table and paste back into that same table (to duplicate rows, then tweak individual fields, for example).

Copying data directly from a table browser

Pasting directly to Microsoft Excel

Pasting directly into email client

Binary/BLOB Data

It should be noted that blob field types will be 64 bit encoded prior to being placed onto the clipboard. This means that if copying large quantities of blob data, this encoding may take a while, and will remain 64-bit encoded if pasted anywhere other than ARC. However, you can feel free to copy and paste blob data within ARC, retaining all the original integrity of the field.

Field Mapping

You can also copy and paste from two entirely different tables. This is accomplished via a mapping dialog. This allows you to modify the orientation of fields from the source table so that they match the destination table. If any conflicts occur you will be notified and allowed to retry with all the data still remaining on the clipboard. This dialog will also let you choose if you have a header row or not (useful when copying partial bits of data from Excel or the Web. This dialog also attempts to match based on field names, so if you have fields in a different order on the source table it will be no problem at all!

Field Mapping Dialog

Conclusion

Overall, the copy/paste functionality is a great addition to ARC and we believe it will make your data manipulation tasks even easier than before!

ITC Software Alliance: Industry-Led Education

2010-10-06T10:08:00.001-07:00

CS Extras

Our goal is to increase the number and quality of software professionals in Idaho.

Idaho’s software industry is vibrant and expanding. Yet, many are not aware of its growing importance. Today there are many silos of professionals and user groups in Idaho exposing high school students to software, teaching guest lectures at universities, and training their own employees valuable skills. These efforts are inspirational, but can often fade when volunteers don’t feel like they are making the impact originally envisioned. We would like to pool these existing resources, strengthen them with renewed interest from Industry partners in the Idaho Technology Council, and create a community that not only engages high school and university students, but its own members as well.

By helping to build a more vibrant software community through industry led training, we can help retain existing professionals, build a solid pipeline of excellent local talent coming from our Idaho schools and universities, and avoid recruiting from out of state.

The Format

Our format simply pairs Idaho software experts with those seeking enhanced skills and information about software. The format will be flexible – presentations, interactive coding sessions, round table discussions and other discussion and training methods.

Idaho’s software industry employees and leaders are encouraged to volunteer in one of these areas:

Encourage teens to consider and pursue a software degree
Increase college student’s awareness of a variety of programming skills and knowledge, and showcase exciting career opportunities.
Expand existing professional skills with industry-specific presentations, skills and training

Starting early 2011, we’d like to host an event every other month, with focus areas of your interest. Scheduling will be dependent on areas of interest and the best time of year for the target audience. The target audience will vary throughout the year between high school students, university students, and industry peers.

What We Ask of Volunteers

Volunteers will be asked to present (or help present with one or more additional volunteers) one time each year or two. Topics and formats can vary based on the subject matter and the target audience. Volunteers can expect support from the Software Alliance for organizing, scheduling and communicating the sessions and discussions. The Software Alliance will lay the ground work for the volunteers to effectively share their expertise.

Example topics may include:

Basics (source code control, debugging techniques)
Technologies (languages, frameworks, mobile development, content mgmt)
Hands on demonstrations
Tips and best practices

We Need Your Help

Interested? Motivated? E-mail me to volunteer or ask questions.

You can also check out Facebook page for the most up to date information.

Still not convinced?

Still reading? The content above was the “short version”, and will be the base message we market in the future and post on our web site. I’m including some of the rational behind the plan below for those interested in more context:

A Successful Partnership

Industry led software education benefits all parties involved, making it a very powerful mechanism.

Benefits to Employers

Develop reputations and company name recognition with potential student hires. When students are attending job fairs or looking for internship employment they will recognize companies who have invested time training them in the past. They will also likely know the instructors, and if they enjoyed those instructors they will be more likely to interview and entertain job offers with their company.
Help the local community build a bigger job force to hire from, and a job force that has additional skills beyond those taught as part of the student’s course work. This will reduce ramp-up time when educating out-of-college new hires.
Students will learn about the active tech community in Boise and many companies that employ software professionals here that they didn’t know existed, resulting in more graduates staying in Idaho and a larger talent pool for all companies to hire from.
As the program grows, and is promoted by ITC, employers will be helping draw out of state students to Idaho universities. This in turn can result in a larger pool of students willing to consider Idaho companies for their full time employment.

Benefits to Students

ITC Software Alliance seminars will provide free training above and beyond their standard course-work. This will create students with additional “real world” training and make them more marketable when they are interviewing for internships and full time positions.
Develop relationships with local companies, many of which will be looking to hire interns and full time employees.
Develop a relationship with ITC and have access to its full list of relevant companies when looking for employment.
Eventually we would like to have ITC scholarships we can offer students who have engaged us in these training events.

Benefits to Universities

Student retention in engineering programs as industry guest speakers motivate students and provide glimpse into what their “real world” working environment and tasks may entail.
If successful, this program will differentiate Idaho universities and make them more valuable and attractive to out of state students.
Industry training will allow universities to focus on core competencies of the curriculum, while industry volunteers help educate students on specialty, cutting edge topics that the industry needs new students to understand (Python, .NET, Ruby on Rails, etc) for immediate employment (whether as interns or full time employees).

Too Many Web Frameworks

2010-09-27T14:18:00.001-07:00

This list of web frameworks is not complete (read all of the additional frameworks listed in the comments), but serves as a reminder why many traditional desktop application developers encounter analysis paralysis when moving to web development.

Advantage Web API

2010-09-08T15:45:00.001-07:00

Currently, data stored in the Advantage Database Server can only be accessed via an Advantage client interface of some sort (Delphi components, .NET Data Provider, PHP driver, etc.). All of these interfaces are built on top of the Advantage Client Engine (ACE), and ACE only supports two platforms; Windows and Linux.

The easiest way to consume your data from other platforms is to expose that data via a web service. Depending on your experience and familiarity with web services, this can be a trivial task, or a pain point. There are many choices to be made at a high level (IIS, Apache, Ruby, Python, ASP.NET, PHP, etc.) and once those decisions are made there are even more at lower levels (framework decisions, REST vs RPC, etc.).

Once implemented, these technologies work well with Advantage, but have introduced a variety of moving parts that your team must now understand and maintain. In addition, the requirement for these technologies as a foundation has increased both your development time and the scope of your project. For many teams this is a manageable solution, but for others this entry barrier prevents projects from ever getting off the ground.

A Built-In Solution

We want Advantage users to have a turnkey option to retrieve their data via a web service. You can still obviously build your own, but for teams that would like a jump start, or would like to investigate web interfaces without the overhead or commitment, we will be distributing a pre-built web server and web service that provides access to your existing Advantage data.

The Technology

The web service is implemented as an Apache module that will be loaded by a stand-alone instance of Apache. This web service can also be installed into an existing Apache installation, but by default will install it’s own minimal copy of Apache.

The web service is a RESTful API that returns data using a format very similar to the oData specification. The initial implementation will return JSON data. XML is a possibility for future implementations, but will not be part of the initial beta.

Every modern development environment I know of provides the ability to make an HTTP call and consume a web service. This means you will have access to your Advantage data from literally any programming language and on any device platform.

Configuration will be VERY simple. Add the path to the database you want to expose to a configuration file, and that’s it. You will immediately be able to securely (via HTTPS) request and update data from your Advantage server via web URI’s.

Consumption Examples

I’ve included a few examples below of this web service retrieving a set of records. These examples are by no means complete, but provide a quick glimpse at the consumption of this API on a variety of platforms and devices.

Web Browser

The easiest way to test the service is to simply enter a URI into your browser.

For example, entering the following URI into your browser after installing the server:

https://myserver:6282/adsweb/v1/test_db/tables/orders

would return:

.NET

Consumption from the .NET framework is accomplished using the built in WebClient class in combination with the JSON.NET library for JSON serialization and de-serialization:

        1: WebClient w = new WebClient();

       2:  

       3: w.Headers.Add( "Authorization", "Basic " + 

       4:    Convert.ToBase64String( Encoding.ASCII.GetBytes( "adssys:" ) ) );

       5: w.Encoding = Encoding.UTF8;

       6: string result = w.DownloadString( 

       7:    "https://myserver:6282/adsweb/v1/test_db/tables/orders" );

       8:  

       9: sr = new StringReader( result );

      10: olist = (oDataResults<Orders>)serializer.Deserialize( new JsonTextReader( sr ), 

      11:                                                       typeof( oDataResults<Orders> ) );

      12:  

      13: // Results are now ready to use in an object list

      14: if ( olist.d.results.Count > 0 )

      15:    MessageBox.Show( string.Format( "First order ID is {0}", 

      16:                     olist.d.results[0].id.ToString() ) );

iPhone/iPad (Objective-C)

Consumption in Objective-C is accomplished using the URLWithString constructor and the TouchJSON library:

       1: NSString *jsonString = [NSString stringWithContentsOfURL:

       2:    [NSURL URLWithString: @"https://myserver:6268/adsweb/v1/test_db/tables/orders"]

       3:           encoding: NSUTF8StringEncoding error:&error];

       4:     

       5: // deserialize

       6: NSData *jsonData = [jsonString dataUsingEncoding:NSUTF32BigEndianStringEncoding];

       7: NSDictionary *dictionary = 

       8:    [[CJSONDeserializer deserializer] deserializeAsDictionary:jsonData error:&error];

       9:     

      10: // save reference to the rows

      11: _rows = [[NSMutableArray alloc] initWithArray:[dictionary objectForKey:@"d"]];

      12: [_rows retain];

Android (Java)

Consumption in Java is accomplished using the WebClient class and the Gson library:

       1: WebClient ordersClient = 

       2:    new WebClient( "https://myserver:6282/adsweb/v1/test_db/tables/orders" );

       3:  

       4: String jsonOrders = ordersClient.GetData( "total>50000" )

       5:  

       6: Gson gson = new Gson();

       7:  

       8: OrdersListWrapper ordersList = gson.fromJson( jsonOrders, OrdersListWrapper.class );

       9:  

      10: // The deserialized Results are now contained in the "d" object array.

      11: if ( ordersList.d.Count > 0 ) {

      12:    TextView tvResults = (TextView)mainView.findViewById( R.id.txtResults );

      13:    tvResults.setText( "The First Order ID is " + 

      14:                       (new Integer( ordersList.d[0].id ).toString() ));

      15:    }

JavaScript

The following example consumes the API using Javascript in a browser, and uses the JQuery framework to quickly manipulate the JSON data and present a table:

       1: <script language="javascript">

       2:  

       3:   $.getJSON('https://myserver:6282/adsweb/v1/test_db/tables/orders',

       4:   function(data, status){

       5:     $.each( data.d, function(i, item) {

       6:      $('#res').append( '<li>Order ' + item.OrderNo + ' : $' + item.AmountPaid + '</li>' );

       7:     } );

       8:  

       9:  });

      10: </script>

      11:  

      12: <ul>

      13:   <div id=res>

      14:   </div>

      15: </ul>

PHP

The following example consumes the API using PHP, and uses the CURL extension and built in json_decode function:

       1: $session = 

       2:   curl_init("https://localhost:6282/adsweb/pupdir/v1/query/select%20*%20from%20test1");

       3:  

       4: // configure CURL to trust our server with self-signed cert

       5: curl_setopt($session, CURLOPT_SSL_VERIFYPEER, false);

       6: // set db password

       7: curl_setopt($session, CURLOPT_USERPWD, "adssys:");

       8: // setup curl_exec to return the data instead of printing it

       9: curl_setopt($session, CURLOPT_RETURNTRANSFER, true);

      10: // set headers

      11: curl_setopt($session, CURLOPT_HTTPHEADER, 

      12:   array ( "Accept: application/json; charset=utf-8" ) );

      13:  

      14: // get the data

      15: $response = curl_exec($session);

      16: curl_close($session);

      17:  

      18: // decode the json into an object

      19: if ( ! $dataset = json_decode( $response ) )

      20:   trigger_error( json_last_error() );

      21:  

      22: // spit out a simple table (normally would use a view, but not in small example)

      23: print( "<table><tr><hr><th>Lastname</th><th>Firstname</th></tr>" );

      24: foreach ( $dataset->d->results as $row )

      25:   print( "<tr><td>$row->LASTNAME</td><td>$row->FIRSTNAME</td></tr>" );

      26: print( "</table>" );

Beta Testing and Discussion

The beta program is underway and we are ready for testers to try the new web API. If you would like to be included in the beta process, please register here and we will email you download and documentation links.

In addition, you can visit the Advantage.webapi newsgroup for Advantage Web API discussions and updates. If you can not access NNTP newsgroups, feel free to email me (Jeremy.Mullin at Sybase.com) with any feedback you may have.

Advantage Version 10 Tips

2010-07-08T11:30:00.001-07:00

If you didn’t catch Chris’ series of tips on utilizing the new functionality in Advantage version 10, he has created a post with links to all 25 tips. Great material in bite-sized chunks, and much better than sitting down and reading a help file. :)

Boise Software Mentoring

2010-04-22T12:54:00.001-07:00

Last night David Cohen from TechStars presented at a local TechBoise event. He explained how TechStars helped to generate a software startup community and ecosystem in Boulder Colorado that feeds itself. Entrepreneurs, investors and mentors generating more entrepreneurs, more investors, and more mentors. It was motivational, to say the least. It was also hard to see why this couldn’t work in Boise. In fact, Nebula Shift was announced a few months ago and plans to use a similar approach.

I don’t plan on leaving my corporate job any time soon, but I’m fascinated with the software startup story. David’s presentation helped me realize my position in the community might be as a mentor. I want to contribute, and mentoring seems like the most immediate way to get involved.

At the end of this post I offer up a little information about myself, not in the context of “look at me”, but rather as a quick overview of things I’m interested in, past endeavors, and areas I might be able to contribute. Some of these things I know in depth, some I’ve only played with for a week or two, some I’d be interested in learning more about and could only provide direction to resources and research. The list is certainly not complete, but hopefully provides a quick overview.

I’m not a TechStars caliber mentor:

I can’t provide business advice (at least nothing credible).
I’ve never started a company.
I’ve never made millions.

I do love writing software, talking about software, and using software.

I can provide architecture and framework suggestions, beta feedback, and general “have you heard of”, or “have you considered” types of conversations. I can help you locate and evaluate contractors. I can review and test the code contractors deliver as well as give you an independent assessment of the reality of their schedules. I can even write a few modules for you on a weekend every now and then.

My day job working on developer tools exposes me to an outrageous number of technologies. My communication skills make it easy for me to effectively discuss these technologies with people of varying technical backgrounds. Some of the most helpful mentoring I have done so far has been helping those with little to no technical background get a handle on what is necessary, and what to expect, when implementing their business ideas.

I hope a few colleagues will join me, and perhaps we can start a mentors directory on the TechBoise web site. Until a directory like that exists, feel free to email me directly.

J.D. Mullin, jeremy.d.mullin@gmail.com, @jdmullin

What I Currently Do

Software developer and R&D manager for an embedded database server and its client APIs and drivers
Develop and write server and desktop client software using a variety of platforms and languages
Understand of a wide variety of database technologies, development environments and programming frameworks
Manage feature prioritization and roadmap
Handle scheduling and dev team (they are awesome and low maintenance, though, so this job is easy)
Train and interact with other software developers (we mostly sell to ISV’s)
Constantly evaluating development environments and frameworks is part of my job. Provides a breadth of knowledge, but not always much depth
Ship a successful software product that was conceived and is still currently developed here in Boise
Read way too many software blogs

General Interests

RESTful services
Scalability
Concurrent programming
Web APIs
Post-mortem debugging
Mobile device development (synchronization, data access, etc.)
Social graphs
Big dogs, beer, camping, motorcycles

Past

My resume is probably the best list of past work

Advantage v10 Delphi SQL Property Editor

2010-02-25T10:29:00.001-08:00

One of my favorite new features in Advantage version 10 (beta at the end of March) is the new TAdsQuery.SQL property editor in Delphi/C++Builder. No longer will users be greeted with the default Delphi string list editor:

Instead, you will see the familiar SQL Utility from the Advantage Data Architect:

What does this mean? Now, without leaving your work flow in Delphi/C++Builder, you will have:

syntax highlighting
code templates
access to the query plan
ability to create indexes to help optimize the query
ability to export the query results
find and replace functionality
ability to run and preview query results
ability to verify query syntax
ability to debug SQL scripts

Write your query, preview it, and debug it. Then just click OK and the query is saved to your TAdsQuery instance. It’s all ball bearings these days.

Another cool feature is this is the exact same interface you use inside the Advantage Data Architect (ARC), no need to learn any new functionality, it will all be familiar.

To preview some of the other upcoming features in Advantage version 10 be sure to register for Chris’s upcoming webinars.

Object-Relational Mapping (ORM) Technology

2010-01-20T07:33:00.001-08:00

Sharing an interesting post by Shawn Wildermuth, Are ORM’s Solving Anything. Be sure to read the comments as well for more insight from his readers.

I’m also fond of our colleague Glenn Paulley’s recent presentation, “ORMs: Friend or Foe?”, which can be found and downloaded from his presentations page.

I’ve written my own “poor man’s ORM” solutions in the past to facilitate object generation from a database result set, but have yet to fully embrace the latest generation of ORM technology. Like many developers, I’m a control freak and I love my database. Putting a middle man and smoke and mirrors between us is not fun for me. However, reducing the need to crank out endless lines of redundant data access code certainly is appealing. For writing simple applications, I really like the idea of using an ORM to just “get the job done”.

I wish the Advantage team had the resources to support all of the ORM’s currently available, but that just isn’t possible. I could name at least 7 off the top of my head, and I bet with 5 minutes of web searching I could easily find another 10.

I’m also concerned about the long term maintenance requirements. Supporting ORMs is not as basic as providing an interface to our database. We then have to deal with optimizing overly complex queries generated by the ORM (see Glenn’s presentation), record locking and visibility issues, transaction issues, etc.

For now we support the .NET Entity Framework. Hibernate and NHibernate are on our radar, but no decisions have been made yet to move forward with solutions for those frameworks. There are feature requests for both on our feedback page. I’d encourage you to vote for those or submit your own requests. Also please feel free to comment on this post to share your insights or thoughts.

Ken Levy “Advantage with VFP” Screencast

2009-12-16T07:52:00.001-08:00

Ken has recorded a cool screencast that covers the following topics:

Advantage Database Server (ADS) Components
ADS Overview
ADS Scenarios with Visual FoxPro
Demo: ADS for VFP and .NET
Resources

The screencast can be found here: http://video.sybase.com/products/advantage/Sybase_ADS_VFP.wmv

Delphi Help System WITHOUT Microsoft SDK

2009-12-10T12:30:00.001-08:00

The help system in newer versions of Delphi and C++Builder is a pain to navigate. This blog post describes a way you can remove the Microsoft SDK from the help system. This significantly increases the odds you will find the Delphi methods/properties/etc you are looking for instead of Microsoft SDK info you likely don’t care about and can already search for on MSDN.

http://blogs.embarcadero.com/deeelling/2009/12/07/38310

In addition, if you would like to see the SDK documentation removed by default in the future, leave Dee a comment.

Advantage Delphi Components

2009-10-15T09:42:00.001-07:00

I’m currently in Delphi modifying and improving some of the Advantage property editors (the dialogs that help you read and set property values in the Object Inspector).

If you have ideas for improvements, or if there are things that drive you crazy, post a comment to this post and I’ll see what I can do.

Advantage Delphi Components for RAD Studio 2010 Posted

2009-09-21T14:04:00.001-07:00

Advantage support for Delphi/RAD Studio 2010 was released today.

Advantage CHM Help File

2009-09-15T12:15:00.001-07:00

The next Advantage 9.1 service update will include a CHM help file to replace the WinHelp files we are currently shipping. If you would like to try it out early, you can download a copy from http://devzone.advantagedatabase.com/jeremym/advantage_chm.zip

In the past we only installed the help files for the client kits and products you where using. While this kept the installations smaller, it would often hide the fact that other clients existed and had functionality you might be interested in. This new help file is an “all-in-one” help file that contains ALL Advantage documentation, and is still a relatively small help file (roughly 7MB).

This CHM help file will work in Windows Vista and Windows 7 without the buggy WinHelp plugin that was required in the past. Note if you want to view a CHM file stored on a network drive you will need to download and run this utility from EC Software.

Our new help file is built using Help & Manual from EC Software. So far it has been a great tool. I really like having access to the raw XML files the help is built from. In the event I need to manipulate the content and H&M doesn’t have the functionality I need, I can quickly write a Ruby or Perl script to zip through the help files and make my changes.

If you encounter any problems with the help file or notice any formatting errors please use the feedback email button to send us bug reports.

Advantage Delphi 2010 Support

2009-08-31T10:21:00.001-07:00

As many of you have heard, Delphi 2010 (or “RAD Studio 2010”) has shipped. We will be updating the Advantage Delphi Components and releasing 8.1 and 9.1 updates in the next few weeks.

Our first update will include basic changes in the Advantage Delphi Components to support Delphi 2010. This update will let you use our components in Delphi 2010 just as you do in Delphi 2009 and older versions today. A subsequent release will include updates that expand on some of the new functionality in Delphi (verb hints in the Object Inspector, JSON serialization, etc.).

I’m Not Dead Yet

2009-07-28T17:38:00.001-07:00

Couldn’t resist the Monty Python reference…

It’s been a long time since I’ve posted to my blog. I’ve been caught up in Twitter land which appeals to my lazy programmer side (140 characters is much easier to conjure up than a blog post is). I’ve also been spending most of my free time (when I normally write these blog entries) playing with .NET, Visual Studio, Ruby, Ruby in Steel, and ASP.NET MVC. Add to that some C and Delphi stuff at work, and my brain has been mush for the last few months.

I’m skipping Southwest Fox this year, but I’ll be in Washington D.C. at the end of August for our next Advantage Technical Summit. I believe we will be hosting a Visual FoxPro user group meeting while we are in town as well.

As for technical blog content, I hope to post some more soon. I’ve recently had the need to slurp up a specific portion of the ads_err log and post it to a remote exception logger. I hope to publish and post a .NET version of that code when I’m finished. Unless of course some of you have already done that, in which case it would be cool if you could e-mail me the code… ;)